Statement monitor output as db2 table

[sethwai]

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_mo nitor, 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_CURSO R" SMALLINT NOT NULL ,
"CONSISTENCY_TO KEN" CHAR(8) NOT NULL ,
"CREATOR" VARCHAR(30) NOT NULL ,
"CURSOR_NAM E" VARCHAR(18) NOT NULL ,
"EVMON_FLUS HES" BIGINT NOT NULL ,
"FETCH_COUN T" BIGINT NOT NULL ,
"INT_ROWS_DELET ED" BIGINT NOT NULL ,
"INT_ROWS_INSER TED" BIGINT NOT NULL ,
"INT_ROWS_UPDAT ED" BIGINT NOT NULL ,
"PACKAGE_NA ME" CHAR(8) NOT NULL ,
"PACKAGE_VERSIO N_ID" VARCHAR(64) NOT NULL ,
"PARTIAL_RECORD " SMALLINT NOT NULL ,
"PARTITION_NUMB ER" SMALLINT NOT NULL ,
"POOL_DATA_L_RE ADS" BIGINT NOT NULL ,
"POOL_DATA_P_RE ADS" BIGINT NOT NULL ,
"POOL_INDEX_L_R EADS" BIGINT NOT NULL ,
"POOL_INDEX_P_R EADS" BIGINT NOT NULL ,
"POOL_TEMP_DATA _L_READS" BIGINT NOT NULL ,
"POOL_TEMP_DATA _P_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDE X_L_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDE X_P_READS" BIGINT NOT NULL ,
"ROWS_READ" BIGINT NOT NULL ,
"ROWS_WRITT EN" BIGINT NOT NULL ,
"SECTION_NUMBER " BIGINT NOT NULL ,
"SEQUENCE_N O" 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_TIM E" BIGINT NOT NULL ,
"TOTAL_SORT_TIM E" BIGINT NOT NULL ,
"TOTAL_SORT S" BIGINT NOT NULL ,
"USER_CPU_T IME" BIGINT NOT NULL ,
"STMT_TEXT" CLOB(2097152) LOGGED NOT COMPACT )
PARTITIONING KEY ("PARTITION_KEY ") USING HASHING
IN "IBMDEFAULTGROU P" ;
Lew