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]

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_INFO table function - but only if you are doing this
locally on the server.

Thanks
Amit
email: singleton at canada.com

ni********@uk.ibm.com (Nick Lomax) wrote in message news:<33**************************@posting.google. com>...

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