View the currently executing SQL statement » History » Revision 3

« Previous | Revision 3/4 (diff) | Next »
chin-yeh, 11/02/2011 09:47 AM

View the currently executing SQL statement¶

The db2pd utility can be used to troubleshoot the db2 active instance.

Steps:

First, identify the list of applications:

db2pd -db <<database alias name>> -applications

Based on the application command's output, filter out those applications with the Status, UOW-WAITING and UOW-EXECUTING
Based on the filter-ed data, you can then identify the statement using the combination L-AchID and L-StmtUID columns.

After obtained the value from L-AchID and L-StmtUID, execute the following command:

Usage:

db2pd -db store -applications -dyn | egrep '(<<L-AchID|>>|<<L-StmtUID>>)'

Example:

db2pd -db store -applications -dyn | egrep '(123|4563)'

For more information about db2pd utility, see:

Files (0)