You can obtain detailed information about :
user ID
IP direcction
and which program is using the user to connect to DB2
executing : "db2 list application show detail "
Auth Id Application Name Appl. Application
Id Seq# Number of Coordinating Coordinat
or Status Status Change Time DB Name
DB Path
Handle
Agents Node Number pid/threa
d
------------------------------ -------------------- ---------- ------------
------------------ ---- ---------- ------------ ---------
------ ------------------------------ -------------------------- -------- -
-------------------
DB2ADMIN db2bp 65695
*LOCAL.db2admin.010521075755 0001 1 1 4081
UOW Waiting Not Collected BDDWH
/db2/kernel/bddirdef/db2admin/NODE0001/SQL00002/
DEEM25 WINSQL.EXE 65698
0A190668.041F.010521084149 0001 10 1 5973
UOW Waiting Not Collected BDDWH
/db2/kernel/bddirdef/db2admin/NODE0001/SQL00002/
You can see that we have a user ID (DEEM25), connecting to DB2 with the
Windows Application "WinSQL" from the
IP direcction 0A190668 (in hexadecimal).
Regards
Beatriz Cerezo.
Spain.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
