Db2 Resource Usage View

Db2 Resource Usage View shows the usage data for the Db2 Analytics Accelerator.

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 path where the profile is located.
RUN_DATE	The 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.
ENTRY_ID	The ID of the Db2 entry.
END_USER_ID	The end user's ID.
END_USER_TRANS	The end user's transaction name.
END_USER_WORKSTATION	The end user's workstation name.
CORRELATION_ID	The correlation ID of the requester executing the SQL.
TRAN_CODE	The transaction code.
AUTH_ID	The authorization ID.
WLM_NAME	The name of the WLM class under which the workload ran if it was assigned.
TOTAL_CP_CPU_TIME	Shows the amount of CP CPU time used for all environments.
IN_DB2_CP_CPU_TIME	Shows the accumulated CP CPU time that is spent in Db2.
STORED_PROC_CP_CPU_TIME	Shows the CP CPU time accumulated in Db2 for processing SQL statements in stored procedures.
TRIGGER_CP_CPU_TIME	Shows the CP CPU time consumed executing trigger SQL statements on a nested task.
UDF_CP_CPU_TIME	Shows the CP CPU time consumed executing user defined functions (UDFs) (for version 10 only).
TOTAL_SP_CPU_TIME	Shows the amount of SP CPU time used for all environments.
IN_DB2_SP_CPU_TIME	Shows the SP CPU time consumed that is spent in Db2.
STORED_PROC_SP_CPU_TIME	Shows the SP CPU time accumulated in Db2 for processing SQL statements in stored procedures.
TRIGGER_SP_CPU_TIME	Shows the SP CPU time consumed executing triggers SQL statements on a nested task.
UDF_SP_CPU_TIME	Shows the SP CPU time consumed executing user-defined functions (UDFs) on an IBM specially engine (for version 10 only).
IN_DB2_ELAPSED_TIME	Shows the elapsed time for non-nested activity accumulated in Db2 for the allied agent work request originating in another address space connected to Db2.
STORED_PROC_ELAPSED_TIME	Shows the elapsed time that the allied agent spent executing Stored Procedure SQL statements.
TRIGGER_ELAPSED_TIME	Shows the elapsed time expended executing trigger SQL statements.
UDF_ELAPSED_TIME	Shows the elapsed time that the allied agent spent executing UDF SQL statements - V10 only.
ACCEL_CPU_TIME	Shows accelerator services CPU utilization.
ACCEL_ELAPSED_TIME	Shows accelerator services elapsed time.
ACCEL_TCP_IP_CPU_TIME	Shows accelerator services TCP/IP CPU utilization.
ACCEL_TCP_IP_ELAPSED_TIME	Shows accelerator services TCP/IP elapsed time.