Counting connections per user using sql

[Nick Lomax]

Hi,

I am using DB2 UDB v 7.2 Fixpak 7. For a given user I need to find
the number of current connections using sql. Is this possible?
I can find out using "db2 list applications" from the AIX command
line, however I need to know within a client application.

Many thanks,

Nick

Nick Lomax

[Amit]

Re: Counting connections per user using sql

Hi Nick:
It is not possible to do this via sql in DB2 v7. You can use the
Snapshot Monitor API functions( db2GetSnapshot etc - its in the Admin
Api Reference) from the client application.
In DB2 v8 it is possible to do this via SQL using the
SNAPSHOT_APPL_I NFO table function - but only if you are doing this
locally on the server.

Thanks
Amit
email: singleton at canada.com

nick_lomax@uk.i bm.com (Nick Lomax) wrote in message news:<33951daa. 0401150740.5bdb 5c6f@posting.go ogle.com>...[color=blue]
> Hi,
>
> I am using DB2 UDB v 7.2 Fixpak 7. For a given user I need to find
> the number of current connections using sql. Is this possible?
> I can find out using "db2 list applications" from the AIX command
> line, however I need to know within a client application.
>
> Many thanks,
>
> Nick
>
> Nick Lomax[/color]