List of users connected to DB2 UDB database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

satish mullapudi - 29 Jul 2006 17:52 GMT

Hi everybody,
How to get the list of all users/clients who are connected to my DB2
UDB database v 8.2 server in RHEL?
Please help me out...

Reply to this Message

Mark A - 29 Jul 2006 18:31 GMT

> Hi everybody,
> How to get the list of all users/clients who are connected to my DB2
> UDB database v 8.2 server in RHEL?
> Please help me out...

db2 list applications show detail

This will show the logon id. Included in one of the strings is IP address of
the remote clients in hex. Each hex pair is one of the four IP numbers. If
the first letter of hex string is greater than F, convert as follows:

G=0
H-1
I=2
J=3
etc

Reply to this Message