Hi,
In a UDB AIX/Websphere environment, how do we go about tracking a specific
user or applications down. In DB2, a "list applications" shows a list such
as the one below. In the example below, I am interested in 'Auth ID ABCDEFG'
which is the application. Is there any way to tell quickly who is using
that connection.
Websphere maintains its connection pool to DB2 and that means a connection
can be used by different users.
Auth Id Application Appl. Application Id DB #
of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------ --------
-----
DBPROD db2bp 786481 *LOCAL.DBPROD.010524005645 TESTDB 2
DBPROD db2bp 786491 *LOCAL.DBPROD.010524010345 TESTDB 3
L1765 db2ccs.exe 50 0A621A14.06AF.010524010523 TESTDB 1
ABCDEFG java 786684 0A0C1E17.A85B.010524031003 TESTDB 4
ABCDEFG java 786685 0A0C1E17.A85C.010524031004 TESTDB 4
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
