Database Member 0 -- Database DB6 -- Active -- Up 0 days 19:36:54 -- Date 2014-02-28-06.22.37.726113 Dynamic Cache: Current Memory Used 3198271 Total Heap Size 13699317 Cache Overflow Flag 0 Number of References 257309 Number of Statement Inserts 1415 Number of Statement Deletes 1313 Number of Variation Inserts 360 Number of Statements 102 Dynamic SQL Statements: Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text 0x00007F313E31E020 4 1 1 1 2 1 CREATE TABLE SYSTOOLS.HMON_COLLECTION (HI_ID BIGINT NOT NULL,OBJ_NAME1 VARCHAR(128) NOT NULL,OBJ_NAME2 VARCHAR(128) DEFAULT NOT NULL,OBJ_NAME3 VARCHAR(128) DEFAULT NOT NULL,OBJ_DETAIL VARCHAR(512),OBJ_STATE INT NOT NULL,OBJ_REFRESH_TIME TIMESTAMP NOT NULL,NOTIFY CHAR(1) DEFAULT 'N' NOT NULL,HISTORY VARCHAR(200) FOR BIT DATA,CONSTRAINT HI_OBJ_UNIQ UNIQUE (HI_ID, OBJ_NAME1, OBJ_NAME2, OBJ_NAME3))IN SYSTOOLSPACE 0x00007F313D47E8C0 11 1 1 1 170 458 delete from CQ_CRX_x002e_DEFAULT_BUNDLE where NODE_ID = ? 0x00007F313D47EB80 29 1 1 1 2 1 create unique index CQ_CRX_x002e_DEFAULT_REFS_IDX on CQ_CRX_x002e_DEFAULT_REFS (NODE_ID) 0x00007F313D4CD9C0 43 1 1 1 15726 8018 INSERT INTO DS_DATASTORE VALUES(?, 0, ?, NULL) 0x00007F313D3AB700 48 1 1 1 2 1 create table JOURNAL_GLOBAL_REVISION (REVISION_ID BIGINT NOT NULL) 0x00007F313D388400 69 1 1 1 1 1 CALL SYSPROC.SYSINSTALLOBJECTS('POLICY','C','','') 0x00007F313D49E400 100 1 0 0 3818 3818 select REVISION_ID from JOURNAL_GLOBAL_REVISION 0x00007F313E30CF40 110 1 1 1 1 1 DROP TABLE SYSTOOLS.HMON_ATM_INFO 0x00007F313D3BD900 111 2 1 1 9 9 SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableRunstatsDecision' AND NAME='TableRunstatsPolicy' 0x00007F313D49DAC0 115 1 0 0 3818 3818 update JOURNAL_GLOBAL_REVISION set REVISION_ID = REVISION_ID + 1 0x00007F313D31FE80 116 1 1 1 1 1 SELECT TABNAME, TABSCHEMA, TYPE, CREATE_TIME FROM SYSCAT.TABLES WHERE TABSCHEMA = USER ORDER BY TABSCHEMA, TABNAME 0x00007F313E29F1C0 118 1 1 1 1 1 CALL SYSPROC.POLICY_INSTALL ('I','DB2DatabaseRecoveryMED','DBBackupDecision','DBBackupPolicy',?) 0x00007F313D48F800 130 1 1 1 3081 4347 update CQ_CRX_x002e_DEFAULT_BUNDLE set BUNDLE_DATA = ? where NODE_ID = ? 0x00007F313D47E540 147 2 1 1 9 9 UPDATE SYSTOOLS.HMON_ATM_INFO AS ATM SET REORG_FLAG = 'N' WHERE (ATM.SCHEMA, ATM.NAME) IN (SELECT IBM.CREATOR, IBM.NAME FROM SYSIBM.SYSTABLES AS IBM WHERE IBM.TYPE = 'N' OR IBM.TYPE = 'V' ) WITH UR 0x00007F313D31E4E0 164 8 1 1 269 269 SELECT COLNAME, TYPENAME FROM SYSCAT.COLUMNS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS' 0x00007F313D38EF60 167 2 1 1 9 9 SELECT IBM.TID, IBM.FID FROM SYSIBM.SYSTABLES AS IBM, SYSTOOLS.HMON_ATM_INFO AS ATM WHERE ATM.STATS_FLAG <> 'Y' AND IBM.TYPE IN ( 'S', 'T' ) AND ATM.CREATE_TIME = IBM.CTIME AND ATM.SCHEMA = IBM.CREATOR AND ATM.NAME = IBM.NAME ORDER BY IBM.FID, IBM.TID WITH UR 0x00007F313D4D8C40 184 1 1 1 14755 7504 UPDATE DS_DATASTORE SET ID=?, LENGTH=?, LAST_MODIFIED=? WHERE ID=? AND LAST_MODIFIED=? 0x00007F313E28FEE0 191 1 1 1 1 1 CALL SYSPROC.POLICY_INSTALL ('I','DB2CommonMED','NOP','CommonPolicy',?) 0x00007F313D40A5C0 208 1 1 1 2 1 create unique index VERSION_REFS_IDX on VERSION_REFS (NODE_ID) 0x00007F313D48BCC0 215 2 1 1 9 9 UPDATE SYSTOOLS.HMON_ATM_INFO SET STATS_LOCK = 'N' WHERE STATS_LOCK <> 'N' 0x00007F313D4C7EA0 238 2 1 1 9 9 UPDATE SYSTOOLS.HMON_ATM_INFO SET SIGNAL = 'N' WHERE STATS_FLAG = 'Y' AND STATS_LOCK <> 'Y' AND REORG_LOCK <> 'Y' 0x00007F313D46F160 240 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_BINVAL;' ORDER BY COLNO 0x00007F313D44E3A0 244 1 1 1 2 1 create unique index CQ_CRX_x002e_DEFAULT_BUNDLE_IDX on CQ_CRX_x002e_DEFAULT_BUNDLE (NODE_ID) 0x00007F313E28AF40 283 1 1 1 2 1 CREATE TRIGGER SYSTOOLS.POLICY_UV NO CASCADE BEFORE UPDATE ON SYSTOOLS.POLICY REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL SECURED BEGIN ATOMIC VALUES (SYSPROC.POLICY_VALIDATE(N.MED,N.POLICY)); END 0x00007F313D3CF660 307 1 1 1 2 1 create unique index VERSION_BUNDLE_IDX on VERSION_BUNDLE (NODE_ID) 0x00007F313E277580 307 3 1 1 1431 1431 SELECT STATS_TIME, INDEXTYPE FROM SYSIBM.SYSINDEXES WHERE TBCREATOR = ? AND TBNAME = ? WITH UR 0x00007F313D48F980 310 1 1 1 81 27 SELECT STATS_FLAG FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? WITH UR 0x00007F313D3DFD80 317 1 1 1 20880 20880 select BUNDLE_DATA from VERSION_BUNDLE where NODE_ID = ? 0x00007F313E308100 334 1 1 1 1 1 CALL SYSINSTALLOBJECTS( 'DB2AC', 'D', NULL, NULL ) 0x00007F313D46F6A0 340 2 1 1 9 9 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME='HMON_ATM_INFO' AND TABSCHEMA='SYSTOOLS' 0x00007F313D3B28C0 352 1 2 2 1539 1539 select REFS_DATA from CQ_CRX_x002e_DEFAULT_REFS where NODE_ID = ? 0x00007F313D46F280 365 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_BUNDLE;' ORDER BY COLNO 0x00007F313E27FE40 390 2 1 1 9 9 UPDATE SYSTOOLS.HMON_ATM_INFO SET TO_WAIT = TO_WAIT - 1 WHERE STATS_FLAG = 'Y' AND STATS_LOCK = 'N' AND REORG_LOCK = 'N' 0x00007F313D3AF940 399 1 1 1 2 1 create unique index JOURNAL_GLOBAL_REVISION_IDX on JOURNAL_GLOBAL_REVISION (REVISION_ID) 0x00007F313D3CDD60 410 1 1 1 2 1 create table VERSION_BUNDLE (NODE_ID CHAR(16) FOR BIT DATA not null, BUNDLE_DATA blob(100M) not null) 0x00007F313E2BF9A0 417 1 1 1 1 1 CALL SYSPROC.POLICY_INSTALL ('I','DB2TableMaintenanceMED','TableRunstatsDecision','TableRunstatsPolicy',?) 0x00007F313D31A4A0 418 1 1 1 2 1 CREATE TABLE DS_DATASTORE(ID VARCHAR(255) PRIMARY KEY NOT NULL, LENGTH BIGINT, LAST_MODIFIED BIGINT, DATA BLOB(1000M)) 0x00007F313D4FFC00 422 1 1 1 2 1 CREATE TABLE SYSTOOLS.POLICY (MED VARCHAR(128) NOT NULL, DECISION VARCHAR(128) NOT NULL, NAME VARCHAR(128) NOT NULL, UPDATE_TIME TIMESTAMP NOT NULL, POLICY BLOB (2M), CONSTRAINT POLICY_UNQ UNIQUE (MED, DECISION, NAME)) IN SYSTOOLSPACE 0x00007F313D455AC0 427 1 1 1 2 1 create table CQ_CRX_x002e_DEFAULT_BINVAL (BINVAL_ID varchar(64) not null, BINVAL_DATA blob(1000M) not null) 0x00007F313D4695E0 450 4 1 1 301 301 SELECT TRIGNAME FROM SYSCAT.TRIGGERS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS' 0x00007F313E27E780 453 1 1 1 40 20 LOCK TABLE SYSTOOLS.HMON_ATM_INFO IN SHARE MODE 0x00007F313D489E40 461 1 0 0 5439 5439 select REVISION_ID, JOURNAL_ID, PRODUCER_ID, REVISION_DATA from JOURNAL_JOURNAL where REVISION_ID > ? order by REVISION_ID 0x00007F313D3D29E0 462 2 1 1 1431 1431 SELECT CREATE_TIME FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? FOR UPDATE 0x00007F313D38D100 493 1 1 1 2 2 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'JOURNAL_JOURNAL;' ORDER BY COLNO 0x00007F313D46A5A0 502 1 2 2 53212 53212 select BUNDLE_DATA from CQ_CRX_x002e_DEFAULT_BUNDLE where NODE_ID = ? 0x00007F313D37F920 512 1 1 1 2 1 create table JOURNAL_JOURNAL (REVISION_ID BIGINT NOT NULL, JOURNAL_ID varchar(255), PRODUCER_ID varchar(255), REVISION_DATA blob(100M)) 0x00007F313D382340 536 1 2 2 1028 1028 DELETE FROM DS_DATASTORE WHERE ID=? 0x00007F313D46FCE0 542 1 1 1 1154 150812 insert into CQ_CRX_x002e_DEFAULT_BUNDLE (BUNDLE_DATA, NODE_ID) values (?, ?) 0x00007F313D3EE580 542 2 1 1 5 5 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'JOURNAL_JOURNAL' ORDER BY COLNO 0x00007F313D463740 548 1 1 1 2 1 create table CQ_CRX_x002e_DEFAULT_NAMES (ID INTEGER GENERATED ALWAYS AS IDENTITY, NAME varchar(255) not null) 0x00007F313D359DA0 548 2 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_BUNDLE' ORDER BY COLNO 0x00007F313D389360 566 1 1 1 2 1 create table JOURNAL_LOCAL_REVISIONS (JOURNAL_ID varchar(255) NOT NULL, REVISION_ID BIGINT NOT NULL) 0x00007F313D49F6A0 574 2 1 1 10 10 SELECT COUNT( * ) FROM SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_NOTIFY = 'Y' 0x00007F313D4559A0 580 1 1 1 428 428 CALL SYSPROC.SYSINSTALLOBJECTS('POLICY','V','','') 0x00007F313D40FDE0 594 1 1 1 2 1 create unique index VERSION_BINVAL_IDX on VERSION_BINVAL (BINVAL_ID) 0x00007F313D31FD00 600 1 1 1 12235 12235 SELECT ID, DATA FROM DS_DATASTORE WHERE ID=? 0x00007F313D43EA60 627 1 1 1 81 27 SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE TBSPACEID = ? AND TABLEID = ? AND CREATE_TIME = ? AND TYPE <> 'H'WITH UR 0x00007F313E3BBB80 637 1 1 1 761 761 UPDATE SYSTOOLS.HMON_ATM_INFO SET STATS_LOCK = 'Y' WHERE CURRENT OF SQL_CURSH100C4 0x00007F313D37F460 639 3 1 1 9 9 DELETE FROM SYSTOOLS.HMON_ATM_INFO AS ATM WHERE NOT EXISTS ( SELECT * FROM SYSIBM.SYSTABLES AS IBM WHERE ATM.NAME = IBM.NAME AND ATM.SCHEMA = IBM.CREATOR AND ATM.CREATE_TIME = IBM.CTIME ) WITH UR 0x00007F313E2BBA00 650 1 1 1 1 1 CALL SYSPROC.POLICY_INSTALL ('I','DB2TableMaintenanceMED','TableReorgDecision','TableReorgPolicy',?) 0x00007F313D3B26A0 655 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_NAMES' ORDER BY COLNO 0x00007F313E27EA20 667 1 1 1 2 1 CREATE TRIGGER SYSTOOLS.POLICY_IV NO CASCADE BEFORE INSERT ON SYSTOOLS.POLICY REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL SECURED BEGIN ATOMIC VALUES (SYSPROC.POLICY_VALIDATE(N.MED,N.POLICY)); END 0x00007F313D4C7FC0 668 1 2 2 79866 79866 SELECT LENGTH, LAST_MODIFIED FROM DS_DATASTORE WHERE ID=? 0x00007F313D43F740 672 1 1 1 2 1 create table CQ_CRX_x002e_DEFAULT_BUNDLE (NODE_ID CHAR(16) FOR BIT DATA not null, BUNDLE_DATA blob(100M) not null) 0x00007F313D45C880 689 1 1 1 2 1 create unique index CQ_CRX_x002e_DEFAULT_BINVAL_IDX on CQ_CRX_x002e_DEFAULT_BINVAL (BINVAL_ID) 0x00007F313D3D8060 693 2 0 0 0 0 db2pd -db db6 -locks wait showlocks 0x00007F313E30FB80 703 1 1 1 2 1 CREATE TABLE SYSTOOLS.HMON_ATM_INFO (SCHEMA VARCHAR(128) NOT NULL,NAME VARCHAR(128) NOT NULL,CREATE_TIME TIMESTAMP NOT NULL,STATS_FLAG CHAR(1) DEFAULT 'N' NOT NULL,STATS_LOCK CHAR(1) DEFAULT'N' NOT NULL,STATS_OPTS INTEGER DEFAULT 0 NOT NULL,LAST_WAIT INTEGER DEFAULT 4 NOT NULL,TO_WAIT INTEGER DEFAULT 1 NOT NULL,SIGNAL CHAR(1) DEFAULT 'N' NOT NULL,LEO_TAB CHAR(1) DEFAULT 'N' NOT NULL,EXEC_COUNT BIGINT DEFAULT 0 NOT NULL,STATS_STATE SMALLINT DEFAULT 0 NOT NULL,STATS_NOTIFY CHAR(1) DEFAULT 'N' NOT NULL,STATS_DETAIL VARCHAR(200),STATS_HISTORY VARCHAR(200) FOR BIT DATA,STATS_TIME TIMESTAMP,REORG_FLAG CHAR(1) DEFAULT 'N' NOT NULL,REORG_LOCK CHAR(1) DEFAULT 'N' NOT NULL,REORG_STATE SMALLINT DEFAULT 0 NOT NULL,REORG_TIME TIMESTAMP,REORG_NOTIFY CHAR(1) DEFAULT 'N' NOT NULL,REORG_DETAIL VARCHAR(200),REORG_HISTORY VARCHAR(200) FOR BIT DATA,REORG_AVG_RUNTIME INTEGER,REORG_INDEX_SCHEMA VARCHAR(128),REORG_INDEX_NAME VARCHAR(128),REORG_INDEX_ONLINE CHAR(1),CONSTRAINT ATM_UNIQ UNIQUE (SCHEMA, NAME)) IN SYSTOOLSPACE 0x00007F313D35FC80 714 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_REFS;' ORDER BY COLNO 0x00007F313D48E940 734 2 1 1 9 9 UPDATE SYSTOOLS.HMON_ATM_INFO AS ATM SET ATM.STATS_FLAG = 'Y' 0x00007F313E2DFE20 735 1 1 1 12 12 CALL SYSINSTALLOBJECTS( 'DB2AC', 'V', NULL, NULL ) 0x00007F313E35F6A0 742 2 1 1 2109 703 SELECT STATS_LOCK, REORG_LOCK FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? FOR UPDATE 0x00007F313E30E000 755 1 1 1 1 1 DROP TABLE SYSTOOLS.HMON_COLLECTION 0x00007F313D3595C0 757 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'JOURNAL_GLOBAL_REVISION' ORDER BY COLNO 0x00007F313D3EB160 766 2 1 1 9 9 SELECT CREATOR, NAME, CTIME FROM SYSIBM.SYSTABLES WHERE TYPE='T' OR TYPE='S' OR TYPE='N' WITH UR 0x00007F313D4D2B20 786 1 1 1 15731 8018 UPDATE DS_DATASTORE SET DATA=? WHERE ID=? 0x00007F313E30F0C0 790 1 1 1 1 1 CALL SYSINSTALLOBJECTS( 'DB2AC', 'C', NULL, NULL ) 0x00007F313D3BCE80 794 3 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_REFS' ORDER BY COLNO 0x00007F313E36FBC0 794 2 1 1 3066 1533 UPDATE SYSTOOLS.HMON_ATM_INFO SET TO_WAIT = ?, LAST_WAIT = ?, STATS_LOCK = 'N', STATS_STATE = ?, STATS_NOTIFY = ?, STATS_DETAIL = ?, STATS_HISTORY = ?, STATS_OPTS = ?, STATS_TIME = CURRENT TIMESTAMP, SIGNAL = (CASE SIGNAL WHEN 'N' THEN ? ELSE 'Y' END)WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? 0x00007F313E2EFEA0 809 1 2 2 833 833 SET CURRENT LOCK TIMEOUT 5 0x00007F313D3FFDA0 819 1 1 1 2 1 create table VERSION_REFS (NODE_ID CHAR(16) FOR BIT DATA not null, REFS_DATA blob(100M) not null) 0x00007F313D310B20 821 1 1 1 5 5 CALL SYSIBM.SQLTABLES (?,?,?,?,?) 0x00007F313D3820C0 824 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_NAMES;' ORDER BY COLNO 0x00007F313D40E920 841 1 1 1 2 1 create table VERSION_BINVAL (BINVAL_ID varchar(64) not null, BINVAL_DATA blob(1000M) not null) 0x00007F313D3DF120 841 2 1 1 2 1 create table VERSION_NAMES (ID INTEGER GENERATED ALWAYS AS IDENTITY, NAME varchar(255) not null) 0x00007F313E28F3C0 864 1 1 1 2 1 CREATE TRIGGER SYSTOOLS.POLICY_DR NO CASCADE BEFORE DELETE ON SYSTOOLS.POLICY REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL SECURED BEGIN ATOMIC IF ( ( SELECT COUNT(*) FROM SYSTOOLS.POLICY WHERE OLD_ROW.MED = MED AND OLD_ROW.DECISION = DECISION ) = 1 ) THEN SIGNAL SQLSTATE '85101' ('At least one policy is required.'); END IF; END 0x00007F313D507860 871 2 1 1 9 9 SELECT ATM.SCHEMA, ATM.NAME, ATM.CREATE_TIME, ATM.LAST_WAIT, ATM.TO_WAIT, ATM.SIGNAL, ATM.LEO_TAB, ATM.EXEC_COUNT, ATM.STATS_STATE, ATM.STATS_HISTORY, ATM.STATS_TIME, ATM.STATS_OPTS, IBM.TID, IBM.FID, IBM.CARD, IBM.TYPE, IBM.VOLATILE, IBM.STATS_TIME, CAST( (CASE WHEN IBM.STATISTICS_PROFILE IS NOT NULL THEN 1 ELSE 0 END) AS INT ), SUBSTR(IBM.PROPERTY,1,32), ATM.REORG_TIME, IBM.PARTITION_MODE FROM SYSTOOLS.HMON_ATM_INFO AS ATM, SYSIBM.SYSTABLES AS IBM WHERE ATM.SCHEMA = IBM.CREATOR AND ATM.NAME = IBM.NAME AND ATM.CREATE_TIME = IBM.CTIME AND ( IBM.TYPE IN ( 'S', 'T', 'N' )) AND SUBSTR(IBM.PROPERTY, 21, 1) <> 'Y' AND IBM.VOLATILE = ' ' AND ATM.STATS_FLAG = 'Y' AND ATM.STATS_LOCK <> 'Y' AND ATM.REORG_LOCK <> 'Y' WITH UR 0x00007F313D37F7E0 886 2 1 1 9 9 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME='HMON_COLLECTION' AND TABSCHEMA='SYSTOOLS' 0x00007F313D50FE40 887 1 1 1 2 1 CREATE TRIGGER SYSTOOLS.POLICY_IR NO CASCADE BEFORE INSERT ON SYSTOOLS.POLICY REFERENCING NEW AS NEW_ROW FOR EACH ROW MODE DB2SQL SECURED BEGIN ATOMIC IF ( ( SELECT COUNT(*) FROM SYSTOOLS.POLICY WHERE NEW_ROW.MED = MED AND NEW_ROW.DECISION = DECISION ) = 1 ) THEN SIGNAL SQLSTATE '85101' ('Only one policy is allowed.'); END IF; END 0x00007F313D3EFB20 902 1 1 1 27 27 values(1) 0x00007F313D3D8180 923 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'CQ_CRX_X002E_DEFAULT_BINVAL' ORDER BY COLNO 0x00007F313D318F60 930 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'JOURNAL_LOCAL_REVISIONS' ORDER BY COLNO 0x00007F313D40FC40 939 1 0 0 2797 2797 select REFS_DATA from VERSION_REFS where NODE_ID = ? 0x00007F313D31F220 941 1 1 1 1 1 SELECT COLNAME, TYPESCHEMA, TYPENAME, LENGTH, SCALE, NULLS FROM SYSCAT.COLUMNS WHERE TABSCHEMA = CURRENT SCHEMA AND TABNAME = 'VERSION_BINVAL' ORDER BY COLNO 0x00007F313D49F7E0 949 2 0 0 3809 3809 insert into JOURNAL_JOURNAL (REVISION_ID, JOURNAL_ID, PRODUCER_ID, REVISION_DATA) values (?,?,?,?) 0x00007F313D4A2B20 953 1 1 1 10 10 SELECT COUNT( * ) FROM SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_STATE > 1 0x00007F313E2CFE60 958 1 1 1 1 1 CALL SYSPROC.POLICY_INSTALL ('I','DB2TableMaintenanceMED','StatsProfileDecision','StatsProfilePolicy',?) 0x00007F313D35F2E0 996 1 1 1 2 1 create unique index JOURNAL_JOURNAL_IDX on JOURNAL_JOURNAL (REVISION_ID) 0x00007F313D44FC80 996 2 1 1 2 1 create table CQ_CRX_x002e_DEFAULT_REFS (NODE_ID CHAR(16) FOR BIT DATA not null, REFS_DATA blob(100M) not null) 0x00007F313D49FD40 1003 1 1 1 3988 3846 update JOURNAL_LOCAL_REVISIONS set REVISION_ID = ? where JOURNAL_ID = ? 0x00007F313D469FE0 1005 1 1 1 2 1 CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4 0x00007F313E2AFE60 1014 2 1 1 304 304 SELECT POLICY FROM SYSTOOLS.POLICY WHERE MED='DB2CommonMED' AND DECISION='NOP' AND NAME='CommonPolicy' 0x00007F313E3AF880 1015 1 1 1 1 1 SELECT CURRENT QUERY OPTIMIZATION FROM SYSIBM.SYSDUMMY1 Dynamic SQL Environments: Address AnchID StmtUID EnvID Iso QOpt Blk 0x00007F313E31E300 4 1 1 CS 5 B 0x00007F313D3EE2A0 11 1 5 CS 5 B 0x00007F313D47ED20 29 1 1 CS 5 B 0x00007F313D49E080 43 1 5 CS 5 B 0x00007F313D3AB820 48 1 1 CS 5 B 0x00007F313D388580 69 1 1 CS 5 B 0x00007F313E30D0A0 110 1 1 CS 5 B 0x00007F313D38D5E0 111 2 1 CS 5 B 0x00007F313D31F960 116 1 1 CS 5 B 0x00007F313E29F360 118 1 1 CS 5 B 0x00007F313D4AEFA0 130 1 5 CS 5 B 0x00007F313D38EBE0 147 2 1 UR 5 B 0x00007F313D319580 164 8 1 CS 5 B 0x00007F313D4A72C0 167 2 1 UR 5 B 0x00007F313D4A8A80 184 1 5 CS 5 B 0x00007F313E299040 191 1 1 CS 5 B 0x00007F313D40A740 208 1 1 CS 5 B 0x00007F313D48BDE0 215 2 1 UR 5 B 0x00007F313D4CD1A0 238 2 1 UR 5 B 0x00007F313D44F900 240 1 1 CS 5 B 0x00007F313D44E540 244 1 1 CS 5 B 0x00007F313E28B160 283 1 1 CS 5 B 0x00007F313D3CF780 307 1 1 CS 5 B 0x00007F313D4D8880 307 3 1 UR 5 B 0x00007F313D48FB20 310 1 1 UR 5 B 0x00007F313D48B3C0 317 1 5 CS 5 B 0x00007F313E308280 334 1 1 UR 5 B 0x00007F313D3DE920 340 2 1 CS 5 B 0x00007F313D46F3E0 352 1 4 CS 5 B 0x00007F313D3BD140 352 1 3 CS 5 B 0x00007F313D47E1A0 365 1 1 CS 5 B 0x00007F313D50FB80 390 2 1 UR 5 B 0x00007F313D3AFAE0 399 1 1 CS 5 B 0x00007F313D3CDF00 410 1 1 CS 5 B 0x00007F313E2BFB60 417 1 1 CS 5 B 0x00007F313D31A660 418 1 1 CS 5 B 0x00007F313D50EBE0 422 1 1 CS 5 B 0x00007F313D455BE0 427 1 1 CS 5 B 0x00007F313D45FC80 450 4 1 CS 5 B 0x00007F313E284E40 453 1 1 UR 5 B 0x00007F313D3EF4E0 462 2 1 UR 5 B 0x00007F313D38D2E0 493 1 1 CS 5 B 0x00007F313D40A240 502 1 6 CS 5 B 0x00007F313D4AF800 502 1 5 CS 5 B 0x00007F313D37FAE0 512 1 1 CS 5 B 0x00007F313D48ACC0 536 1 5 CS 5 B 0x00007F313D4A8220 536 1 6 CS 5 B 0x00007F313D4A7A00 542 1 5 CS 5 B 0x00007F313D403720 542 2 1 CS 5 B 0x00007F313D463900 548 1 1 CS 5 B 0x00007F313D38F2A0 548 2 1 CS 5 B 0x00007F313D389480 566 1 1 CS 5 B 0x00007F313D4AE760 574 2 1 UR 5 B 0x00007F313D3FC920 580 1 1 CS 5 B 0x00007F313D3D84A0 594 1 1 CS 5 B 0x00007F313D47D640 600 1 5 CS 5 B 0x00007F313D43EC20 627 1 1 UR 5 B 0x00007F313E35FC00 637 1 2 UR 5 B 0x00007F313D3EF7C0 639 3 1 UR 5 B 0x00007F313E2BBBA0 650 1 1 CS 5 B 0x00007F313D3BD420 655 1 1 CS 5 B 0x00007F313E27EC40 667 1 1 CS 5 B 0x00007F313D44A560 668 1 6 CS 5 B 0x00007F313D4AFBE0 668 1 5 CS 5 B 0x00007F313D43F900 672 1 1 CS 5 B 0x00007F313D45CA20 689 1 1 CS 5 B 0x00007F313E30FCA0 703 1 1 CS 5 B 0x00007F313D38E3E0 714 1 1 CS 5 B 0x00007F313D38DCE0 734 2 1 UR 5 B 0x00007F313E2FD680 735 1 1 UR 5 B 0x00007F313E35F860 742 2 1 UR 5 B 0x00007F313E30E160 755 1 1 CS 5 B 0x00007F313D3597A0 757 1 1 CS 5 B 0x00007F313D3EEDE0 766 2 1 UR 5 B 0x00007F313D49E9C0 786 1 5 CS 5 B 0x00007F313E30F240 790 1 1 UR 5 B 0x00007F313D3AF180 794 3 1 CS 5 B 0x00007F313E35C4A0 794 2 1 UR 5 B 0x00007F313E3BEFC0 809 1 2 CS 5 B 0x00007F313E2DF660 809 1 1 UR 5 B 0x00007F313D4039E0 819 1 1 CS 5 B 0x00007F313D310C80 821 1 1 UR 5 U 0x00007F313D37ED00 824 1 1 CS 5 B 0x00007F313D40EAC0 841 1 1 CS 5 B 0x00007F313D3DF240 841 2 1 CS 5 B 0x00007F313E28F660 864 1 1 CS 5 B 0x00007F313E2772C0 871 2 1 UR 5 B 0x00007F313D3EE6E0 886 2 1 CS 5 B 0x00007F313E27D1C0 887 1 1 CS 5 B 0x00007F313D3EFC80 902 1 1 CS 5 B 0x00007F313D3DE4E0 923 1 1 CS 5 B 0x00007F313D319140 930 1 1 CS 5 B 0x00007F313D358C00 941 1 1 CS 5 B 0x00007F313D49F3E0 953 1 1 UR 5 B 0x00007F313E2DE060 958 1 1 CS 5 B 0x00007F313D35F400 996 1 1 CS 5 B 0x00007F313D478060 996 2 1 CS 5 B 0x00007F313D388EC0 1003 1 5 CS 5 B 0x00007F313D46A180 1005 1 1 CS 5 B 0x00007F313D3BDAE0 1014 2 1 CS 5 B 0x00007F313E3AF9A0 1015 1 1 UR 5 B Dynamic SQL Variations: Address AnchID StmtUID EnvID VarID NumRef Typ Lockname Val Insert Time Sect Size Num Copies 0x00007F313E31E680 4 1 1 1 1 1 010000000100000001008000D6 Y 2014-02-27-10.47.07.216058 2288 0 0x00007F313D4032E0 11 1 5 1 5 4 010000000500000001006001D6 Y 2014-02-27-13.02.39.307890 7408 0 0x00007F313D47F0A0 29 1 1 1 1 1 01000000010000000100A003D6 Y 2014-02-27-10.45.47.601789 1960 0 0x00007F313D48A440 43 1 5 1 5 4 010000000500000001006005D6 Y 2014-02-27-13.02.37.018537 6528 0 0x00007F313D3ABAE0 48 1 1 1 1 1 010000000100000001000006D6 Y 2014-02-27-10.45.45.177518 1936 0 0x00007F313D388900 69 1 1 1 1 13 01000000010000000100A008D6 Y 2014-02-27-10.47.05.774268 6280 0 0x00007F313E30D420 110 1 1 1 1 1 01000000010000000100C00DD6 Y 2014-02-27-10.47.07.166775 1904 0 0x00007F313D38D8A0 111 2 1 1 9 6 02000000010000000100E00DD6 Y 2014-02-27-13.02.05.667918 7072 0 0x00007F313D31E0A0 116 1 1 1 1 6 01000000010000000100800ED6 Y 2014-02-28-06.03.35.325333 16816 0 0x00007F313E29F6E0 118 1 1 1 1 13 01000000010000000100C00ED6 Y 2014-02-27-10.47.07.034212 7056 0 0x00007F313D4AF340 130 1 5 1 66 4 010000000500000001004010D6 Y 2014-02-27-13.02.37.255498 9752 0 0x00007F313E27CC00 147 2 1 1 9 4 020000000100000001006012D6 Y 2014-02-27-13.02.05.723288 12472 0 0x00007F313D31E7E0 164 8 1 1 269 6 080000000100000001008014D6 Y 2014-02-27-10.59.21.765187 12848 1 0x00007F313D49E580 167 2 1 1 9 6 02000000010000000100E014D6 Y 2014-02-27-13.02.05.729973 16448 0 0x00007F313D4A8E20 184 1 5 1 3 4 010000000500000001000017D6 Y 2014-02-27-13.02.38.794224 11920 0 0x00007F313E2993C0 191 1 1 1 1 13 01000000010000000100E017D6 Y 2014-02-27-10.47.07.018961 7056 0 0x00007F313D40AAC0 208 1 1 1 1 1 01000000010000000100001AD6 Y 2014-02-27-10.45.46.761451 1936 0 0x00007F313D48C160 215 2 1 1 9 4 02000000010000000100E01AD6 Y 2014-02-27-13.02.05.734354 8048 0 0x00007F313D4E2A60 238 2 1 1 9 4 02000000010000000100C01DD6 Y 2014-02-27-13.02.05.790763 8896 0 0x00007F313D444D40 240 1 1 1 1 6 01000000010000000100001ED6 Y 2014-02-27-13.51.38.467264 18384 0 0x00007F313D44E8C0 244 1 1 1 1 1 01000000010000000100801ED6 Y 2014-02-27-10.45.47.238735 1960 0 0x00007F313E28B4E0 283 1 1 1 1 1 010000000100000001006023D6 Y 2014-02-27-10.47.07.000670 2080 0 0x00007F313D3CFB00 307 1 1 1 1 1 010000000100000001006026D6 Y 2014-02-27-10.45.46.650304 1936 0 0x00007F313D4C77A0 307 3 1 1 1431 6 030000000100000001006026D6 Y 2014-02-27-13.02.05.759834 8408 0 0x00007F313D48EBC0 310 1 1 1 81 6 01000000010000000100C026D6 Y 2014-02-27-11.02.05.511080 8392 0 0x00007F313D48B6A0 317 1 5 1 32 6 01000000050000000100A027D6 Y 2014-02-27-13.02.37.062571 6904 0 0x00007F313E308600 334 1 1 1 1 13 01000000010000000100C029D6 Y 2014-02-27-10.47.07.166167 6296 0 0x00007F313D3DEBE0 340 2 1 1 9 6 02000000010000000100802AD6 Y 2014-02-27-13.02.05.359182 7728 0 0x00007F313D3CEEA0 352 1 4 1 2 6 01000000040000000100002CD6 Y 2014-02-27-11.05.01.236397 6880 0 0x00007F313D44DF60 352 1 3 1 1109 6 01000000030000000100002CD6 Y 2014-02-27-10.58.58.767601 6880 0 0x00007F313D445180 365 1 1 1 1 6 01000000010000000100A02DD6 Y 2014-02-27-13.51.52.629029 18384 0 0x00007F313E27E260 390 2 1 1 9 4 02000000010000000100C030D6 Y 2014-02-27-13.02.05.736443 9216 0 0x00007F313D382B20 399 1 1 1 1 1 01000000010000000100E031D6 Y 2014-02-27-10.45.45.213102 1960 0 0x00007F313D3CE280 410 1 1 1 1 1 010000000100000001004033D6 Y 2014-02-27-10.45.46.597814 1976 0 0x00007F313E2CD280 417 1 1 1 1 13 010000000100000001002034D6 Y 2014-02-27-10.47.07.052645 7056 0 0x00007F313D31A9E0 418 1 1 1 1 1 010000000100000001004034D6 Y 2014-02-27-10.45.44.715583 1992 0 0x00007F313D50EEA0 422 1 1 1 1 1 01000000010000000100C034D6 Y 2014-02-27-10.47.06.782660 2168 0 0x00007F313D455F60 427 1 1 1 1 1 010000000100000001006035D6 Y 2014-02-27-10.45.47.678997 1976 0 0x00007F313D40E160 450 4 1 1 301 6 040000000100000001004038D6 Y 2014-02-27-10.59.16.176034 13104 1 0x00007F313E285100 453 1 1 1 20 7 01000000010000000100A038D6 Y 2014-02-27-10.57.05.533443 1920 0 0x00007F313E29FB20 462 2 1 1 1431 3 02000000010000000100C039D6 Y 2014-02-27-13.02.05.538426 8000 0 0x00007F313D38F8A0 493 1 1 1 2 6 01000000010000000100A03DD6 Y 2014-02-27-13.52.11.388973 18384 0 0x00007F313D44F4C0 502 1 6 1 177 6 01000000060000000100C03ED6 Y 2014-02-27-13.17.22.725912 6960 0 0x00007F313D4A7580 502 1 5 1 144 6 01000000050000000100C03ED6 Y 2014-02-27-13.02.37.293153 6960 0 0x00007F313D31F480 512 1 1 1 1 1 010000000100000001000040D6 Y 2014-02-27-10.45.45.012882 2008 0 0x00007F313D48AF80 536 1 5 1 2 4 010000000500000001000043D6 Y 2014-02-27-13.02.37.028978 7328 0 0x00007F313D4A85C0 536 1 6 1 2 4 010000000600000001000043D6 Y 2014-02-27-13.02.37.933350 7328 0 0x00007F313D4A7DA0 542 1 5 1 35 4 01000000050000000100C043D6 Y 2014-02-27-13.02.37.739305 5944 0 0x00007F313D409E00 542 2 1 1 5 6 02000000010000000100C043D6 Y 2014-02-27-13.06.48.249912 18384 1 0x00007F313D463C80 548 1 1 1 1 1 010000000100000001008044D6 Y 2014-02-27-10.45.47.910893 1984 0 0x00007F313D3AAF20 548 2 1 1 1 6 020000000100000001008044D6 Y 2014-02-28-06.09.40.309717 18384 1 0x00007F313D389800 566 1 1 1 1 1 01000000010000000100C046D6 Y 2014-02-27-10.45.45.287498 1968 0 0x00007F313D4AEAE0 574 2 1 1 10 6 02000000010000000100C047D6 Y 2014-02-27-10.59.22.105646 9016 0 0x00007F313D3FCBE0 580 1 1 1 428 13 010000000100000001008048D6 Y 2014-02-27-10.47.05.576216 6280 1 0x00007F313D3D8820 594 1 1 1 1 1 01000000010000000100404AD6 Y 2014-02-27-10.45.46.899565 1936 0 0x00007F313D47D920 600 1 5 1 24 6 01000000050000000100004BD6 Y 2014-02-27-13.02.37.126072 7048 0 0x00007F313D43EFC0 627 1 1 1 81 6 01000000010000000100604ED6 Y 2014-02-27-11.02.05.509186 9408 0 0x00007F313D3FC4E0 637 1 2 1 703 4 01000000020000000100A04FD6 Y 2014-02-27-10.59.15.608256 7184 0 0x00007F313D45C0C0 639 3 1 1 9 4 03000000010000000100E04FD6 Y 2014-02-27-13.02.05.660160 15440 0 0x00007F313E2BBF20 650 1 1 1 1 13 010000000100000001004051D6 Y 2014-02-27-10.47.07.043762 7056 0 0x00007F313D3B8040 655 1 1 1 1 6 01000000010000000100E051D6 Y 2014-02-28-06.09.56.611203 18384 0 0x00007F313E27EFC0 667 1 1 1 1 1 010000000100000001006053D6 Y 2014-02-27-10.47.06.969006 2080 0 0x00007F313D47DD60 668 1 6 1 10 6 010000000600000001008053D6 Y 2014-02-27-13.26.12.606827 7760 0 0x00007F313D49EFA0 668 1 5 1 198 6 010000000500000001008053D6 Y 2014-02-27-13.02.36.989773 7760 0 0x00007F313D44A8A0 672 1 1 1 1 1 010000000100000001000054D6 Y 2014-02-27-10.45.47.164997 1984 0 0x00007F313D45CDA0 689 1 1 1 1 1 010000000100000001002056D6 Y 2014-02-27-10.45.47.844737 1968 0 0x00007F313E319E20 703 1 1 1 1 1 01000000010000000100E057D6 Y 2014-02-27-10.47.07.173263 2888 0 0x00007F313D38E6A0 714 1 1 1 1 6 010000000100000001004059D6 Y 2014-02-27-13.52.05.378540 18384 0 0x00007F313D38DFA0 734 2 1 1 9 4 02000000010000000100C05BD6 Y 2014-02-27-13.02.05.718342 7336 0 0x00007F313E2FDA00 735 1 1 1 12 13 01000000010000000100E05BD6 Y 2014-02-27-10.47.07.135355 6296 0 0x00007F313D4691A0 742 2 1 1 2109 3 02000000010000000100C05CD6 Y 2014-02-27-10.59.15.606850 8712 0 0x00007F313E30E4E0 755 1 1 1 1 1 01000000010000000100605ED6 Y 2014-02-27-10.47.07.170375 1904 0 0x00007F313D37F000 757 1 1 1 1 6 01000000010000000100A05ED6 Y 2014-02-28-06.09.19.500234 18400 0 0x00007F313D3EF0A0 766 2 1 1 9 6 02000000010000000100C05FD6 Y 2014-02-27-13.02.05.494302 8040 0 0x00007F313D48A880 786 1 5 1 6 4 010000000500000001004062D6 Y 2014-02-27-13.02.37.024735 9656 0 0x00007F313E30F5C0 790 1 1 1 1 13 01000000010000000100C062D6 Y 2014-02-27-10.47.07.171875 6296 0 0x00007F313D3AF440 794 3 1 1 1 6 030000000100000001004063D6 Y 2014-02-28-06.10.14.269467 18384 1 0x00007F313E35C7C0 794 2 1 1 3066 4 020000000100000001004063D6 Y 2014-02-27-10.59.15.562603 12016 0 0x00007F313E3BF340 809 1 2 1 85 9 010000000200000001002065D6 Y 2014-02-27-10.57.05.979488 2208 0 0x00007F313E2DF9E0 809 1 1 1 748 9 010000000100000001002065D6 Y 2014-02-27-10.47.07.134293 2208 1 0x00007F313D403CA0 819 1 1 1 1 1 010000000100000001006066D6 Y 2014-02-27-10.45.46.700224 1968 0 0x00007F313D311000 821 1 1 1 5 13 01000000010000000100A066D6 Y 2014-02-27-10.45.44.594104 6904 0 0x00007F313D382460 824 1 1 1 1 6 010000000100000001000067D6 Y 2014-02-27-13.51.59.253977 18384 0 0x00007F313D40EE40 841 1 1 1 1 1 010000000100000001002069D6 Y 2014-02-27-10.45.46.828093 1968 0 0x00007F313D3DF5C0 841 2 1 1 1 1 020000000100000001002069D6 Y 2014-02-27-10.45.46.952024 1968 0 0x00007F313E28F9E0 864 1 1 1 1 1 01000000010000000100006CD6 Y 2014-02-27-10.47.07.004820 2232 0 0x00007F313D4D8440 871 2 1 1 9 6 02000000010000000100E06CD6 Y 2014-02-27-13.02.05.744434 18224 0 0x00007F313D3EE9A0 886 2 1 1 9 6 02000000010000000100C06ED6 Y 2014-02-27-13.02.05.490556 7736 0 0x00007F313E27D540 887 1 1 1 1 1 01000000010000000100E06ED6 Y 2014-02-27-10.47.06.877009 2224 0 0x00007F313D43A900 902 1 1 1 27 6 01000000010000000100C070D6 Y 2014-02-27-10.45.47.124883 4488 0 0x00007F313D3CD320 923 1 1 1 1 6 010000000100000001006073D6 Y 2014-02-28-06.12.32.723825 18408 1 0x00007F313D31EC20 930 1 1 1 1 6 010000000100000001004074D6 Y 2014-02-28-06.08.45.936320 18400 0 0x00007F313D358F80 941 1 1 1 1 6 01000000010000000100A075D6 Y 2014-02-28-06.08.56.678172 18384 0 0x00007F313D4AE2A0 953 1 1 1 10 6 010000000100000001002077D6 Y 2014-02-27-10.59.22.104022 9016 0 0x00007F313E2DE3E0 958 1 1 1 1 13 01000000010000000100C077D6 Y 2014-02-27-10.47.07.061290 7056 0 0x00007F313D35F780 996 1 1 1 1 1 01000000010000000100807CD6 Y 2014-02-27-10.45.45.098010 1944 0 0x00007F313D478320 996 2 1 1 1 1 02000000010000000100807CD6 Y 2014-02-27-10.45.47.385489 1984 0 0x00007F313D3AAAE0 1003 1 5 1 481 4 01000000050000000100607DD6 N 2014-02-27-13.02.06.246257 8920 2 0x00007F313D4FEC80 1005 1 1 1 1 1 01000000010000000100A07DD6 Y 2014-02-27-10.47.05.789820 1960 0 0x00007F313D3BDE60 1014 2 1 1 304 6 02000000010000000100C07ED6 Y 2014-02-27-10.58.44.846792 7000 1 0x00007F313E28A5E0 1015 1 1 1 1 6 01000000010000000100E07ED6 Y 2014-02-27-10.57.05.855758 4664 0