DB2 SQL Activity View
Db2 SQL Activity View - shows the distribution of CPU activity and wait among the queries, procedures, and Packages that invoked Db2 system services. 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. |
OWNER | The user ID or job name that initiated the request. |
PROFILE_PATH | The full path where the profile is located. |
RUN_DATE | Date when the reporter processed the sample data set output from the measurement session to create the performance profile. |
RUN_TIME | The time when the reporter processed the sample data set output from the measurement session to create the performance profile. |
RUN_TS | The timestamp when the reporter processed the sample data set output from the measurement session to create the performance profile. |
FOLDER_NAME | The name of the folder where the profile file is located. |
ASID | The address space identifier of the active job. |
CONDITION_CODE | Condition code is code generated when the target program terminated normally while it was being measured. |
DB2_SYSID DB2 | The subsystem ID. |
REGION | The name of the job under which the target program or subsystem was executed. |
JOB_NUMBER | The Job Entry Subsystem (JES) number of the target job. |
LPAR | The name of the logical partition in which the target job executed. |
MEAS_RELEASE | The release of the components of Strobe that gather performance data about the measurement application. |
PROGRAM_NAME | The name of the program or subsystem that was the target of the measurement session. |
SESSION_DATE | The calendar date on which Strobe began measurement. |
SESSION_TIME | The time of day at which Strobe began measurement. |
STEP | The name of the job step, or of the procedure step and job step, in which the program or subsystem was executed. |
SYSTEM_ID | The MVS system on which the measurement session was performed. |
SESSION_TERM | Contains the error code when measurement session gets terminated prematurely due to some exception. |
SQL_QUERY_NAME | The name of the SQL Query. |
QUERY_TYPE | The type of SQL query. |
SQL_QUERY_DTM | This shows :
|
AVG_TM | Shows the average time the statement took to execute during the measurement session. |
ACCUM_AVG_TM | Shows the total CPU time in seconds used by the SQL statement divided by the SQL statement count. |
SOLO_CPU_PERCENT | Shows the percentage of CPU activity without any concurrent I/O activity for the transaction. |
TOTAL_CPU_PERCENT | Shows the percentage of CPU activity with or without any concurrent I/O activity for the transaction. |
INDB2_CPU_PERCENT | Shows the percentage of in_DB2 CPU time used by an SQL statement. |
PAGE_WAIT_PERCENT | Shows the percentage of wait time incurred by the query without concurrent wait or other I/O activity. |
TOTAL_WAIT_PERCENT | Shows the percentage of wait time associated with the query as a percentage of all wait time associated with the measured job step. |
PARALLEL_TOTAL_CPU | Shows the CPU time in seconds executed in parallel processing on all processors for the SQL statement. |
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. |
OVERALL_TOTAL_ELAPSED_TM | Shows the accumulated seconds taken to execute the SQL statement. |
OVERALL_TOTAL_CPU_TM | Shows the accumulated CPU seconds taken to execute the SQL statement on all processors for parallel and non-parallel processing. |
STMT_TYPE | Identifies the SQL statement type. |
EXEC_STMT_DTM | Shows the date and time of the statement executed. |
CMD_STATUS | The status of Db2 command. |
STMT_CNT | Identifies the count of this SQL statement over the entire measurement. |
STMT_NUM | Identifies the SQL statement number. |
STMT_TXT | Shows the text of the executing statement. |
INVOKING_STMT_NUM | Shows the number of the invoking statement. |
INVOKING_STMT_TXT | Shows the text of the invoking statement. |