Spotlight on DB2 6.9.3 - User Guide

Statement Details

Value

Agents

The number of concurrent agents currently executing a statement.

Agents Top

The maximum number of agents that have been used so far during execution of a statement. The number provides a measure of how well intra-query parallelism is being implemented.

Application Creator

The authorization ID of the user who pre-compiled the application that is running a statement.

Blocking Cursors

This value indicates whether a statement uses cursor blocking for data transfer. Blocking can reduce overhead and improve performance by retrieving a block of rows in a single operation. One of the following can be shown:

• UNAMBIG is shown when only unambiguous cursors are blocked.

• ALL is shown when both ambiguous and unambiguous cursors are blocked.      

• NO is shown when cursors are not blocked.

Consistency Token

The consistency token for the package that contains a statement. Like statement package version, this helps to identify the version of the package. It is useful in situations where there are multiple versions for a certain combination of package name and creator.

Cursor Name

The name of the cursor opened for a statement. If the statement does not use a cursor, no value is shown.

Degree of Parallelism

The degree of parallelism requested when a statement was bound. Check the value in the Agents Top column to see if the statement reached the maximum level of parallelism.

Estimated Cost (timerons)

The estimated execution cost for a statement. Cost is shown in timerons. The estimate is made by the SQL compiler.

Estimated Rows

The estimated number of rows a statement will return. The estimate is made by the SQL compiler.

Statement Type

The type of SQL for a statement. Either STATIC or DYNAMIC is shown.

Statement Operation

The operation that is currently being processed or was most recently processed for a statement. The operation can be any of the following:

• CALL

• CLOSE

• COMPILE

• DESCRIBE

• EXECUTE

• EXECUTE IMMEDIATE

• FETCH

• FREE LOCATOR

• OPEN

• PREPARE

• PREP_COMMIT

• PREP_EXEC

• PREP_EXEC

• SELECT

• STATIC COMMIT

• STATIC ROLLBACK

Statement Node

The number of the database partition where a statement is being executed.  

Statement Package Name

For static SQL, this is the name of the package that contains a statement. For dynamic SQL, this is the location identifier for a statement in the package cache.

Statement Package Version

The version identifier for the package that contains a statement. Like the consistency token, this helps to identify the version of the package. It is useful in situations where the version of a package was determined at precompile time for an embedded SQL program with the VERSION keyword. If a version was not specified at precompile time, a value is not shown.

Statement Section Number

The internal section number in the package that contains a statement.

Statement Start Time

The time statement execution started. The timestamp includes year, month, date, and hour, in that order.

Statement Stop Time

The time statement execution stopped. The timestamp includes year, month, date, and hour, in that order.