DDF SQL Activity View

DDF SQL Activity View shows the distribution by Package of CPU and elapsed time used by SQL statements within a Package that ran in the DDF address space. The list of data view fields and definitions includes the following:

PROFILE_NAME

The name of the profile.

JOB_MEASUREMENT_TS

The timestamp when the Strobe measurement was started.

PACKAGE_NAME

Package name specifies the Package for which SQL Analysis produces SQL access path information.

CPU_STMT_CNT

Shows the number of SQL statement executions.

ELAPSED_AVG_TM_SEC

Shows the total elapsed time in seconds for all Packages divided by the total SQL statement count for all Packages.

ELAPSED_MAX_TM_SEC

Shows the greatest amount of elapsed time in seconds used by any one of the SQL statements in all of the Packages.

ELAPSED_TOTAL_TM_SEC

Shows total elapsed time in seconds for all Packages multiplied by the total SQL statement count for all Packages.

CPU_AVG_TM_SEC

Shows the total CPU time in seconds for all Packages divided by the total SQL statement count for all Packages.

CPU_MAX_TM_SEC

Shows the greatest amount of CPU time in seconds used by any one of the SQL statements in all of the Packages.

CPU_TOTAL_TM_SEC

Shows total CPU time in seconds for all Packages multiplied by the total SQL statement count for all Packages.

PARALLEL_SP_CPU

Shows the CPU time in seconds executed on a specialty processor such as a zIIP while in parallel processing for the SQL statement.

PARALLEL_TOTAL_CPU

Shows the CPU time in seconds executed in parallel processing on all processors for the SQL statement.