DB2 SQL Statement Count View

PROFILE_NAME

The name of the profile.

JOB_MEASUREMENT_TS

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.