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 : a. If the report is for a Package, the date and time the Package was created. b. If the query was executed once, the date and time that the query was executed. c. If the report is for a SPUFI file, the date and time that the SPUFI file was executed. d. If the procedure was executed once, the date and time that the procedure was executed.
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.
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.