470,614 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Statement monitor output as db2 table

Hi,

I've created a statement monitor with the table option on a
partitioned database. I have the table going to a partition group that
includes all partitions on the database. When I look at the monitor
results table there isn't any stmt_text output. Has anyone encountered
this problem? The monitor definition and table definition as defined
by db2 follows:

create event monitor stmts for statements write to table
stmt(table db2prod.stmt_monitor, in ibmdefaultgroup);

CREATE TABLE "DB2PROD "."STMT_MONITOR" (
"PARTITION_KEY" INTEGER NOT NULL ,
"AGENT_ID" BIGINT NOT NULL ,
"AGENTS_TOP" BIGINT NOT NULL ,
"APPL_ID" CHAR(32) NOT NULL ,
"BLOCKING_CURSOR" SMALLINT NOT NULL ,
"CONSISTENCY_TOKEN" CHAR(8) NOT NULL ,
"CREATOR" VARCHAR(30) NOT NULL ,
"CURSOR_NAME" VARCHAR(18) NOT NULL ,
"EVMON_FLUSHES" BIGINT NOT NULL ,
"FETCH_COUNT" BIGINT NOT NULL ,
"INT_ROWS_DELETED" BIGINT NOT NULL ,
"INT_ROWS_INSERTED" BIGINT NOT NULL ,
"INT_ROWS_UPDATED" BIGINT NOT NULL ,
"PACKAGE_NAME" CHAR(8) NOT NULL ,
"PACKAGE_VERSION_ID" VARCHAR(64) NOT NULL ,
"PARTIAL_RECORD" SMALLINT NOT NULL ,
"PARTITION_NUMBER" SMALLINT NOT NULL ,
"POOL_DATA_L_READS" BIGINT NOT NULL ,
"POOL_DATA_P_READS" BIGINT NOT NULL ,
"POOL_INDEX_L_READS" BIGINT NOT NULL ,
"POOL_INDEX_P_READS" BIGINT NOT NULL ,
"POOL_TEMP_DATA_L_READS" BIGINT NOT NULL ,
"POOL_TEMP_DATA_P_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDEX_L_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDEX_P_READS" BIGINT NOT NULL ,
"ROWS_READ" BIGINT NOT NULL ,
"ROWS_WRITTEN" BIGINT NOT NULL ,
"SECTION_NUMBER" BIGINT NOT NULL ,
"SEQUENCE_NO" CHAR(4) NOT NULL ,
"SORT_OVERFLOWS" BIGINT NOT NULL ,
"SQL_REQ_ID" BIGINT NOT NULL ,
"SQLCABC" INTEGER NOT NULL ,
"SQLCAID" CHAR(8) NOT NULL ,
"SQLCODE" INTEGER NOT NULL ,
"SQLERRD1" INTEGER NOT NULL ,
"SQLERRD2" INTEGER NOT NULL ,
"SQLERRD3" INTEGER NOT NULL ,
"SQLERRD4" INTEGER NOT NULL ,
"SQLERRD5" INTEGER NOT NULL ,
"SQLERRD6" INTEGER NOT NULL ,
"SQLERRM" VARCHAR(72) NOT NULL ,
"SQLERRP" CHAR(8) NOT NULL ,
"SQLSTATE" CHAR(5) NOT NULL ,
"SQLWARN" CHAR(11) NOT NULL ,
"START_TIME" TIMESTAMP NOT NULL ,
"STMT_OPERATION" BIGINT NOT NULL ,
"STMT_TYPE" BIGINT NOT NULL ,
"STOP_TIME" TIMESTAMP NOT NULL ,
"SYSTEM_CPU_TIME" BIGINT NOT NULL ,
"TOTAL_SORT_TIME" BIGINT NOT NULL ,
"TOTAL_SORTS" BIGINT NOT NULL ,
"USER_CPU_TIME" BIGINT NOT NULL ,
"STMT_TEXT" CLOB(2097152) LOGGED NOT COMPACT )
PARTITIONING KEY ("PARTITION_KEY") USING HASHING
IN "IBMDEFAULTGROUP" ;
Lew

Nov 9 '06 #1
0 1531

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by David | last post: by
1 post views Thread by jbaker | last post: by
2 posts views Thread by nekiv90 | last post: by
4 posts views Thread by Michel Esber | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.