Applications: Statement Text (DB2 UDB for
UNIX and Windows) 
To display information on the current SQL statements for your selected application(s), call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ® Applications.
The Application Snapshot screen appears.
2.
To display
more detailed information, select one or more applications and choose
Details.
A detail Application Snapshot screen appears.
3. Choose Statement Text..
If you have selected more than one application, you can use the page buttons on the screen to navigate between them.
|
Field |
Description |
|
Statement |
|
|
Type |
Type of statement processed. Possible types are: · Static SQL statement · Dynamic SQL statement · An operation other than an SQL statement, for example a bind or precompile operation. |
|
Operation |
Operation currently being processed or most recently processed (if none is currently running). Possible operations are: · SELECT · PREPARE · EXECUTE · EXECUTE IMMEDIATE · OPEN · FETCH · CLOSE · DESCRIBE · STATIC COMMIT · STATIC ROLLBACK · FREE LOCATOR · PREP_COMMIT · CALL · PREP_OPEN · PREP_EXEC · COMPILE |
|
Blocking Cursor |
Indicates if the statement that is executed is using a blocking cursor (YES) or not (NO). If data is transferred in blocks and not row by row, the performance of the corresponding query will be improved. |
|
Statement |
Text of dynamic SQL statement that was being processed when the snapshot was taken. It can also be the text of the statement that was most recently processed, if no statement was being processed at the time when the snapshot was taken. |
If a
statement is displayed, you can choose 
EXPLAIN to list the access plan for the statement
execution. This function provides a detailed analysis of expensive SQL
statements.
RFC-monitored systems only:
To
display the ABAP source program where the statement was defined, choose
Source. An editor screen appears, which contains the
related source.
See also:
· IBM documentation: Administration Guide: Chapter 26, SQL Explain Facility