Finding the Application ID

[Former Member]

Hi,

If we have the PID of a particular process at SAP level, how to see the details of that transaction at DB level.

Basically if we want to use " db2 get snapshot of the application ", we need application ID.

Hence how to find the application ID from the PID of SAP.

Please advise.

Thanks & Regards,

DVRK

[Frank-Martin]

Hi DVRK,

there are different options to do this.

1.)

search for "Process ID of client application" in the output of

db2 get snapshot for applications on DBNAME

This will give you the application IDs for your PID. For most processes this will be a one to one relationship since most ABAP work processes will only open one connection.

2.)

if connect ist still possible

db2 " select AGENT_ID from TABLE ( SNAP_GET_APPL_INFO('', -2) ) AS X WHERE CLIENT_PID = #### "

3.)

if you know the WP number look for the following sections in dev_w#

Section showing the PID:

M Thu Mar 17 13:29:58 2011

M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 9004) [thxxhead.c 1201]

M calling db_connect ...

Section showing the application handle for a given connection. Note that one PID may open multiple connections.

C Thu Mar 17 13:30:08 2011

C DB2 client driver version '09.07.0002'

C Connected to DB server type 'DB2/LINUXX8664'

C Connected to DB server version '09.07.0002'

C Connected to 'F64' as 'SAPF64' schema 'SAPF64' o.k.

C Connected: con_hdl=0 ; appl_hdl=20; appl_id="*LOCAL.db2f64.110317123008"

Regards

Frank

C Application code page is ok.

[Former Member]

Hi,

Thanks a lot. Query is resolved.

Best Regards,

DVRK