Applications: Statements (DB2 UDB for UNIX and Windows) (SAP Library

Applications: Statements (DB2 UDB for UNIX and Windows)

To display information on SQL statements for your selected application(s), call transaction ST04.

In the navigation frame, choose Performance ® Applications.

The Application Snapshot screen appears.

To display more detailed information, select one or more application and choose Details.

A detail Application Snapshot screen appears.

Choose Statements.

If you have selected more than one application, you can use the page buttons on the screen to navigate between them.

Field	Description
Application
Application Handle	Application handle
DMS
Rows Read	Number of DMS rows read
Rows Written	Number of DMS rows written
Statement
Type	Typ of statement processed. Possible types are: - Static SQL statement - Dynamic SQL statement - An operation other than an SQL statement, for example a bind or pre-compile 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
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 This graphic is explained in the accompanying text Explain to list the access plan for the statement execution. This function provides a detailed analysis of expensive SQL statements.

To display the ABAP source program where the statement was defined, choose Source. An editor screen appears, which contains the related source.

See also

The EXPLAIN Function

IBM documentation: Administration Guide: Chapter 26, SQL Explain Facility.