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.

EXEC_STMT_NUM

The number of the SQL statement generated and executed on behalf of the target statement.

EXEC_STMT_TEXT

The text of the SQL statement generated and executed on behalf of the target statement.

TARGET_STMT_NUM

The statement number of the user's SQL statement as generated by Strobe for Db2 DDF.

TARGET_STMT_TEXT

The SQL text of the user's SQL statement.

TARGET_STMT_TYPE

This shows the category to which the target statement belongs:

Static - non-cursor

Static - cursor

Dynamic - non-cursor

Dynamic - cursor

CPU_STMT_CNT

Shows the number of SQL statement executions.

ELAPSED_AVG_TM_SEC

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

ELAPSED_MAX_TM_SEC

Shows the most amount of elapsed time in seconds used by any one SQL statement.

ELAPSED_TOTAL_TM_SEC

Shows the total amount of elapsed time used, which is the Avg Elapsed time multiplied by the total SQL count for this Package.

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.

CPU_AVG_TM_SEC

Shows the total in_DB2 SQL CPU time in seconds for the Package divided by the total SQL statement count for the Package.

CPU_MAX_TM_SEC

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

CPU_TOTAL_TM_SEC

The in_DB2 SQL CPU time in seconds used by this Package during the measurement. This includes the in_DB2 SQL CPU time from all parallel execution on both central and special processors.