Db2 SQL Statement Count View

Db2 SQL Statement Count View shows the SQL count 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 is 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.
SELECT_COUNT	The number of SQL SELECT statements executed.
INSERT_CNT	The number of INSERT statements executed.
DELETE_COUNT	The number of DELETE statements executed.
UPDATE_COUNT	The number of UPDATE statements executed.
DESCRIBE_COUNT	The number of DESCRIBE statements executed.
PREPARE_COUNT	The number of SQL PREPARE statements executed.
OPEN_COUNT	The number of OPEN statements executed.
CLOSE_COUNT	The number of CLOSE statements executed.
MERGE_COUNT	The number of MERGE statements executed.
TRUNCATE_TABLE_COUNT	The number of TRUNCATE TABLE statements issued.
CALL_COUNT	The number of CALL statements issued.
FETCH_COUNT	The number of FETCH statements executed.
CREATE_DATABASE_COUNT	The number of CREATE DATABASE statements executed.
CREATE_STOGROUP_COUNT	The number of CREATE STOGROUP statements executed.
CREATE_SYNONYM_COUNT	The number of CREATE SYNONYM statements executed.
CREATE_VIEW_COUNT	The number of CREATE VIEW statements executed.
CREATE_ALIAS_COUNT	The number of CREATE ALIAS statements executed.
CREATE_GLOBAL_TEMP_TABLE_COUNT	The number of CREATE GLOBAL TEMPORARY TABLE statements executed.
CREATE_TRIGGER_COUNT	The number of CREATE TRIGGER statements executed.
CREATE_FUNCTION_COUNT	The number of CREATE FUNCTION statements executed.
CREATE_PROCEDURE_COUNT	The number of CREATE PROCEDURE statements executed.
CREATE_AUX_TABLE_COUNT	The number of CREATE AUXILIARY TABLE statements executed.
CREATE_SEQ_COUNT	The number of CREATE SEQ statements executed.
CREATE_TABLE_COUNT	The number of CREATE TABLE statements executed.
CREATE_INDEX_COUNT	The number of CREATE INDEX statements executed.
CREATE_ROLE_COUNT	The number of CREATE ROLE statements executed.
CREATE_TRUST_CONTEXT_COUNT	The number of CREATE TRUSTED CONTEXT statements issued.
DROP_INDEX_COUNT	The number of DROP INDEX statements executed.
DROP_TABLE_COUNT	The number of DROP TABLE statements executed.
DROP_TABLESPACE_COUNT	The number of DROP TABLESPACE statements executed.
DROP_DATABASE_COUNT	The number of DROP DATABASE statements executed.
DROP_SYNONYM_COUNT	The number of DROP SYNONYM statements executed.
DROP_STOGROUP_COUNT	The number of DROP STOGROUP statements executed.
DROP_VIEW_COUNT	The number of DROP VIEW statements executed.
DROP_ALIAS_COUNT	The number of DROP ALIAS statements executed.
DROP_PACKAGE_COUNT	The number of DROP PACKAGE statements executed.
DROP_TRIGGER_COUNT	The number of DROP TRIGGER statements executed.
DROP_FUNCTION_COUNT	The number of DROP FUNCTION statements executed.
DROP_PROCEDURE_COUNT	The number of DROP PROCEDURE statements executed.
DROP_DISTINCT_TYPE_COUNT	The number of DROP DISTINCT TYPE statements executed.
DROP_SEQ_COUNT	The number of DROP SEQUENCE statements executed.
DROP_ROLE_COUNT	The number of DROP ROLE statements executed.
DROP_TRUST_CONTEXT_COUNT	The number of DROP TRUSTED CONTEXT statements issued.
ALTER_STOGROUP_COUNT	The number of ALTER STOGROUP statements executed.
ALTER_TABLESPACE_COUNT	The number of ALTER TABLESPACE statements executed.
ALTER_TABLE_COUNT	The number of ALTER TABLE statements executed.
ALTER_INDEX_COUNT	The number of ALTER INDEX statements executed.
ALTER_DATABASE_COUNT	The number of ALTER DATABASE statements executed.
ALTER_FUNCTION_COUNT	The number of ALTER FUNCTION statements executed.
ALTER_PROCEDURE_COUNT	The number of ALTER PROCEDURE statements executed.
ALTER_SEQ_COUNT	The number of ALTER SEQUENCE statements executed.
ALTER_VIEW_COUNT	The number of ALTER VIEW statements executed.
ALTER_TRUST_CONTEXT_COUNT	The number of ALTER TRUSTED CONTEXT statements issued.
COMMENT_ON_COUNT	The number of COMMENT ON statements executed.
LOCK_TABLE_COUNT	The number of LOCK TABLE statements executed.
GRANT_COUNT	The number of GRANT statements executed.
REVOKE_COUNT	The number of REVOKE statements executed.
LABEL_ON_COUNT	The number of LABEL ON statements executed.
SET_CUR_SQL_ID_COUNT	The number of SET CURRENT SQLID statements executed.
DESCRIBE_TABLE_COUNT	The number of DESCRIBE TABLE statements executed.
RELEASE_COUNT	The number of RELEASE statements executed.
SET_CUR_CONN_COUNT	The number of SET CURRENT CONNECTION statements executed.
SET_CUR_DEGREE_COUNT	The number of SET CURRENT DEGREE statements executed.
SET_CUR_RULE_COUNT	The number of SET CURRENT RULES statements executed.
ALLOCATE_CURSOR_COUNT	The number of SQL ALLOCATE CURSOR statements executed.
ASSOCIATE_LOCATOR_COUNT	The number of SQL ASSOCIATE LOCATORS statements executed.
RENAME_TABLE_COUNT	The number of RENAME TABLE statements issued.
SET_CUR_PATH_COUNT	The number of SET CURRENT PATH statements executed.
HOLD_LOCATOR_COUNT	The number of SQL HOLD LOCATOR statements executed.
FREE_LOCATOR_COUNT	The number of SQL FREE LOCATOR statements executed.
SET_CUR_PRECISION_COUNT	The number of SET CURRENT PRECISION statements executed.
DECLARE_GLOBAL_TMP_TABLE_COUNT	The number of DECLARE GLOBAL TEMPORARY TABLE statements executed.
RENAME_INDEX_COUNT	The number of RENAME INDEX statements issued.