DDF SQL Activity Target View
DDF SQL Activity Target View shows the distribution by Package of CPU and elapsed time used by SQL statements for a target within a Package that ran in the DDF address space.
PACKAGE_NAME | Package name specifies the Package for which SQL Analysis produces SQL access path information. |
STMT_NUM | The statement number of the user's SQL statement as generated by Strobe for Db2 DDF. |
STMT_TXT | The SQL text of the user's SQL statement. |
STMT_TYPE | This shows the category to which the target statement belongs:
|
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 CPU time in seconds divided by the total SQL statement count. |
CPU_MAX_TM_SEC | Shows the most amount of CPU time in seconds used by any one SQL statement. |
CPU_TOTAL_TM_SEC | Shows the total amount of CPU time used, which is the Avg CPU time multiplied by the total SQL count for this Package. |
PROFILE_NAME | The name of the profile. |
JOB_MEASUREMENT_TS | The timestamp when the Strobe measurement was started. |
PROFILE_PATH | The path where the profile is located. |
FOLDER_NAME | The name of the folder where profile is located. |