Session Run Statistics

The initial RunStats screen shows all packages executed in the current DB2 session, with their execution cost. The list is ordered by descending cost.

Requesting Detail for the package under the cursor, shows all package sections by descending SQL cost.

Requesting Detail for the package section under the cursor, shows the latest statistics collected for the package section in the "Statement Statistics" table. Consequently, the statement text and access path are available for both dynamic and compiled applications.