如何抓锁？
db2pd -d dbps -locks
Database Partition 0 -- Database HWDB -- Active -- Up 1 days 05:03:56
Locks:
Address TranHdl Lockname Type Mode Sts Owner Dur HoldCount Att ReleaseFlg
0x00007FD125E17DC0 7 53514C4445464C5428DD630641 Internal P ..S G 7 1 0 0x00 0x40000000
0x00007FD125E184C0 7 53514C4332473133B7F3CE3241 Internal P ..S G 7 1 0 0x00 0x40000000
0x00007FD125E15A00 7 00000500078A110000EFBE2743 CatCache ..S G 7 1 0 0x00 0x40000000
0x00007FD125E15700 7 05000500000000000000000054 Table ..X G 7 255 0 0x00 0x40000000
发现有一个表被锁，有没有办法用SQL看出是哪个SESSION把哪个表给锁住呢？
Database Partition 0 -- Database HWDB -- Active -- Up 1 days 05:03:56
Locks:
Address TranHdl Lockname Type Mode Sts Owner Dur HoldCount Att ReleaseFlg
0x00007FD125E17DC0 7 53514C4445464C5428DD630641 Internal P ..S G 7 1 0 0x00 0x40000000
0x00007FD125E184C0 7 53514C4332473133B7F3CE3241 Internal P ..S G 7 1 0 0x00 0x40000000
0x00007FD125E15A00 7 00000500078A110000EFBE2743 CatCache ..S G 7 1 0 0x00 0x40000000
0x00007FD125E15700 7 05000500000000000000000054 Table ..X G 7 255 0 0x00 0x40000000
发现有一个表被锁，有没有办法用SQL看出是哪个SESSION把哪个表给锁住呢？
2同行回答
db2inst1@db2975:~> db2pd -db test -wlocks -applications
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:12:36 -- Date 06/20/2013 08:18:21
Locks being waited on :
AppHandl [nod-index] TranHdl Lockname Type Mode Conv Sts CoorEDU AppName AuthID AppID
104 [000-00104] 2 02000400040000000000000052 Row ..X G 19 db2bp DB2INST1 *LOCAL.db2inst1.130620090545
122 [000-00122] 9 02000400040000000000000052 Row ..U W 49 db2bp DB2INST1 *LOCAL.db2inst1.130620091038
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:12:36 -- Date 06/20/2013 08:18:21
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID CollectActData CollectActPartition CollectSectionActuals
0x0000000201010080 105 [000-00105] 1 35 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090546 0 0 N C N
0x0000000200FF0080 104 [000-00104] 1 19 UOW-Waiting 0 0 692 1 *LOCAL.db2inst1.130620090545 1 1 N C N
0x0000000200F40080 110 [000-00110] 1 47 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090551 0 0 N C N
0x0000000200F10080 109 [000-00109] 1 46 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090550 0 0 N C N
0x0000000200FB0080 359 [000-00359] 1 51 UOW-Waiting 0 0 397 1 *LOCAL.db2inst1.130620111308 1 3 N C N
0x0000000200F50080 122 [000-00122] 1 49 Lock-wait 155 1 434 1 *LOCAL.db2inst1.130620091038 1 2 N C N
0x0000000200F00080 108 [000-00108] 1 45 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090549 0 0 N C N
0x0000000201030080 107 [000-00107] 1 44 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090548 0 0 N C N
0x0000000201020080 106 [000-00106] 1 34 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090547 0 0 N C N
External Connection Attributes
Address AppHandl [nod-index] ClientIPAddress EncryptionLvl SystemAuthID
0x0000000201010080 105 [000-00105] n/a None DB2INST1
0x0000000200FF0080 104 [000-00104] n/a None DB2INST1
0x0000000200F40080 110 [000-00110] n/a None DB2INST1
0x0000000200F10080 109 [000-00109] n/a None DB2INST1
0x0000000200FB0080 359 [000-00359] n/a None DB2INST1
0x0000000200F50080 122 [000-00122] n/a None DB2INST1
0x0000000200F00080 108 [000-00108] n/a None DB2INST1
0x0000000201030080 107 [000-00107] n/a None DB2INST1
0x0000000201020080 106 [000-00106] n/a None DB2INST1
Trusted Connection Attributes
Address AppHandl [nod-index] TrustedContext ConnTrustType RoleInherited
0x0000000201010080 105 [000-00105] n/a non trusted n/a
0x0000000200FF0080 104 [000-00104] n/a non trusted n/a
0x0000000200F40080 110 [000-00110] n/a non trusted n/a
0x0000000200F10080 109 [000-00109] n/a non trusted n/a
0x0000000200FB0080 359 [000-00359] n/a non trusted n/a
0x0000000200F50080 122 [000-00122] n/a non trusted n/a
0x0000000200F00080 108 [000-00108] n/a non trusted n/a
0x0000000201030080 107 [000-00107] n/a non trusted n/a
0x0000000201020080 106 [000-00106] n/a non trusted n/a
Autonomous Routine Connections
Address AppHandl [nod-index] Status Autonomous Routine Handl [nod-index] Status
db2inst1@db2975:~>db2pd -db test -dynamic
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:16:59 -- Date 06/20/2013 08:22:44
Dynamic Cache:
Current Memory Used 1609720
Total Heap Size 13699317
Cache Overflow Flag 0
Number of References 1750
Number of Statement Inserts 444
Number of Statement Deletes 393
Number of Variation Inserts 104
Number of Statements 51
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x00007FFFABAC6EC0 98 1 2 2 2 1 CREATE USER TEMPORARY
TABLESPACE SYSTOOLSTMPSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4
0x00007FFFABBBE220 134 2 1 1 1 1 SELECT COUNT(*) FROM
SYSTOOLS.HMON_ATM_INFO WHERE REORG_FLAG = 'Y' AND REORG_NOTIFY = 'Y'
0x00007FFFABB17160 155 1 1 1 1 1 update tab1 set name = 'abc5'
where name='abc3'
0x00007FFFABAC7A00 164 7 1 1 25 25 SELECT COLNAME, TYPENAME FROM
SYSCAT.COLUMNS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS'
0x00007FFFAB9E5BC0 181 1 1 1 1 1 SELECT indschema, indname
from SYSCAT.INDEXES a, SYSCAT.TABLES b where a.tabschema = ? AND a.tabname = ? AND (a.tabname = b.tabname AND a.tabschema =
b.tabschema AND (b.clustered is null or b.clustered != 'Y' )) AND (INDEXTYPE = 'CLUS' OR UNIQUERULE IN ('P','U')) ORDER BY
INDEXTYPE, UNIQUERULE with ur
0x00007FFFAB9D83C0 184 1 2 2 2 1 create table tab1 (name
char(10))
0x00007FFFABB21800 220 2 1 1 1 1 SELECT a.schema, a.name,
a.reorg_state, a.reorg_history, a.reorg_index_schema, a.reorg_index_name, a.reorg_index_online FROM SYSTOOLS.HMON_ATM_INFO a,
SYSCAT.TABLES b WHERE a.schema = b.tabschema AND a.name = b.tabname AND a.stats_lock != 'Y' AND a.reorg_flag = 'Y' AND
(b.stats_time > a.reorg_time OR a.reorg_state > 4 OR (b.stats_time is not null AND a.reorg_time is null)) with ur
0x00007FFFABB948A0 247 1 1 1 2 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT I.CREATOR, I.NAME, I.TBCREATOR, I.TBNAME, '%-s' AS COLNAMES, I.COLCOUNT, I.NLEAF, I.NLEVELS,
I.CLUSTERRATIO, I.FULLKEYCARD, I.CLUSTERFACTOR, I.INDEXTYPE, I.NUMRIDS_DELETED, I.NUM_EMPTY_LEAFS, I.UNIQUE_COLCOUNT,
I.AVGLEAFKEYSIZE, I.AVGNLEAFKEYSIZE FROM SYSIBM.SYSTABLES T, SYSIBM.SYSINDEXES I, JTAB WHERE (T.NAME = I.TBNAME) AND
(T.CREATOR = I.TBCREATOR) AND ( TBCREATOR = JTAB.JSCHEMA) AND (TBNAME = JTAB.JNAME) AND ((T.TYPE='T') OR (T.TYPE = 'S') OR
(T.TYPE = 'U')) ORDER BY I.TBCREATOR, I.TBNAME, I.CREATOR, I.NAME
0x00007FFFABAC72E0 270 1 1 1 3 3 update tab1 set name='abc3'
where name='abc2'
0x00007FFFABA97E60 299 1 2 2 2 1 GRANT USE OF TABLESPACE
--More--
SYSTOOLSTMPSPACE TO PUBLIC
0x00007FFFABA27EE0 302 1 1 1 1 1 SELECT TYPE FROM
SYSIBM.SYSTABLES WHERE TYPE='L' AND SYSIBM.SYSTABLES.CREATOR=CAST(? AS varchar(128)) AND SYSIBM.SYSTABLES.NAME=CAST(? AS
varchar(128))
0x00007FFFABBB5920 325 1 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
SET REORG_DETAIL = ?, REORG_STATE = ?, REORG_TIME = CURRENT TIMESTAMP, REORG_NOTIFY = ?, REORG_HISTORY = ?, REORG_INDEX_SCHEMA
= ?, REORG_INDEX_NAME = ? WHERE SCHEMA = ? AND NAME = ?
0x00007FFFABB20D20 332 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
AS ATM SET STATS_FLAG = 'N', REORG_FLAG = 'N' WHERE (ATM.SCHEMA, ATM.NAME) IN (SELECT IBM.CREATOR, IBM.NAME
FROM SYSIBM.SYSTABLES AS IBM WHERE IBM.TYPE = 'N' )
0x00007FFFABB175A0 340 2 1 1 1 1 SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABNAME='HMON_ATM_INFO' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABB67A00 354 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT AVGROWSIZE FROM SYSIBM.SYSTABLES, JTAB WHERE (CREATOR = JTAB.JSCHEMA) AND (NAME = JTAB.JNAME)
0x00007FFFABB26720 382 1 1 1 43 43 UPDATE SYSTOOLS.HMON_ATM_INFO
SET STATS_LOCK = 'Y' WHERE CURRENT OF SQL_CURSH200C4
0x00007FFFABAED520 397 1 1 1 4 4 SELECT * from
SYSIBMADM.LOCKWAITS
0x00007FFFAB9E6480 430 1 1 1 1 1 CALL REORGCHK_IX_STATS ('T',
'"DB2INST1"."TAB1"')
0x00007FFFAB9E32A0 434 1 1 1 21 21 select * from tab1
0x00007FFFABB07280 437 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
AS ATM SET ATM.REORG_FLAG = 'Y' WHERE (ATM.SCHEMA, ATM.NAME, ATM.CREATE_TIME) IN (SELECT IBM.TABSCHEMA, IBM.TABNAME,
IBM.CREATE_TIME FROM SYSCAT.TABLES AS IBM WHERE TABSCHEMA NOT LIKE 'SYS%' ) WITH UR
0x00007FFFABAC5B00 448 3 2 2 3 2 DECLARE GLOBAL TEMPORARY
TABLE TB_STATS ( TABLE_SCHEMA VARCHAR(128), TABLE_NAME VARCHAR(128), DATAPARTITIONNAME
VARCHAR(128), CARD BIGINT, OVERFLOW BIGINT, NPAGES BIGINT,
FPAGES BIGINT, ACTIVE_BLOCKS BIGINT, TSIZE BIGINT,
F1 INT, F2 INT, F3 INT,
REORG CHAR(3) ) ON COMMIT PRESERVE ROWS NOT LOGGED WITH REPLACE IN
SYSTOOLSTMPSPACE
0x00007FFFABAF1A20 450 3 1 1 59 59 SELECT TRIGNAME FROM
SYSCAT.TRIGGERS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABB076C0 453 1 2 3 4 2 LOCK TABLE
SYSTOOLS.HMON_ATM_INFO IN SHARE MODE
0x00007FFFABB06200 462 2 1 1 134 134 SELECT CREATE_TIME FROM
SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? FOR UPDATE
0x00007FFFABB21320 492 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
SET REORG_NOTIFY = 'N'
0x00007FFFABBB7B00 503 2 1 1 1 1 SELECT COUNT(*) FROM
SYSTOOLS.HMON_ATM_INFO WHERE REORG_FLAG = 'Y' AND ((REORG_STATE = 2) OR (REORG_STATE = 6))
0x00007FFFABB21FA0 504 1 1 1 1 1 CALL REORGCHK_TB_STATS ('T',
--More--
'"DB2INST1"."TAB1"')
0x00007FFFABAF17E0 574 1 1 1 1 1 SELECT COUNT( * ) FROM
SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_NOTIFY = 'Y'
0x00007FFFAB9E7A60 580 1 1 1 126 126 CALL
SYSPROC.SYSINSTALLOBJECTS('POLICY','V','','')
0x00007FFFABB06740 639 2 1 1 1 1 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
0x00007FFFABB06CE0 651 1 1 1 1 1 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableReorgDecision' AND NAME='TableReorgPolicy' AND
UPDATE_TIME > '2013-06-20-06.20.36.000000'
0x00007FFFABB15100 692 1 1 1 1 1 update tab1 set name='abc2'
where name='abc3'
0x00007FFFABA704A0 697 1 1 1 2 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT CREATOR, NAME, CARD, OVERFLOW, NPAGES, FPAGES, ACTIVE_BLOCKS, CLUSTERED, AVGCOMPRESSEDROWSIZE, PCTFREE
FROM SYSIBM.SYSTABLES, JTAB WHERE ((TYPE='T') OR (TYPE = 'S') OR (TYPE = 'U')) AND (CREATOR=JTAB.JSCHEMA) AND
(NAME=JTAB.JNAME) ORDER BY CREATOR,NAME
0x00007FFFABA95780 730 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))), DBPGNAMES AS (SELECT DISTINCT(S.DBPGNAME)DBPGNAME FROM SYSCAT.TABLESPACES S,
SYSCAT.DATAPARTITIONS D, JTAB WHERE (D.TABNAME = JTAB.JNAME) AND ( D.TABSCHEMA = JTAB.JSCHEMA) AND D.TBSPACEID IS NOT NULL
AND S.TBSPACEID = D.TBSPACEID ORDER BY DBPGNAME), NODELIST AS (SELECT DISTINCT(D.DBPARTITIONNUM) FROM DBPGNAMES P,
SYSCAT.DBPARTITIONGROUPDEF D WHERE P.DBPGNAME = D.DBPGNAME AND D.IN_USE = 'Y' GROUP BY D.DBPARTITIONNUM) SELECT COUNT(*)
NUM_NODES FROM NODELIST
0x00007FFFABA73380 735 1 1 1 5 6 CALL SYSINSTALLOBJECTS(
'DB2AC', 'V', NULL, NULL )
0x00007FFFABAF7C00 742 2 1 1 8 8 SELECT STATS_LOCK, REORG_LOCK
FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? FOR UPDATE
0x00007FFFABB77D00 742 3 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT COUNT(*) FROM SYSIBM.SYSDATAPARTITIONS, JTAB WHERE (TABSCHEMA = JTAB.JSCHEMA) AND (TABNAME =
JTAB.JNAME) AND LENGTH(STATUS)=0
0x00007FFFABA76F80 753 1 1 1 1 1 WITH VTYPED (NAME, SCHEMA) AS
(VALUES(TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT TYPE FROM SYSIBM.SYSTABLES, VTYPED WHERE TYPE = 'H' AND SYSIBM.SYSTABLES.NAME = VTYPED.NAME AND
SYSIBM.SYSTABLES.CREATOR = VTYPED.SCHEMA
0x00007FFFABB26580 766 2 1 1 1 1 SELECT CREATOR, NAME, CTIME
FROM SYSIBM.SYSTABLES WHERE TYPE='T' OR TYPE='S' OR TYPE='N' WITH UR
0x00007FFFABAFB640 794 2 1 1 100 100 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 = ?
--More--
0x00007FFFABA70C00 809 1 1 1 96 96 SET CURRENT LOCK TIMEOUT 5
0x00007FFFABB27E20 863 2 1 1 1 1 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2DatabaseRecoveryMED' AND DECISION='DBBackupDecision' AND NAME='DBBackupPolicy'
0x00007FFFABBC1F80 877 2 1 1 1 1 SELECT MAX(REORG_AVG_RUNTIME)
FROM SYSTOOLS.HMON_ATM_INFO
0x00007FFFABB25F40 886 2 1 1 1 1 SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABNAME='HMON_COLLECTION' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABAC6A20 923 1 1 1 1 1 SELECT COUNT(*) FROM
SYSCAT.TABLESPACES WHERE TBSPACE='SYSTOOLSTMPSPACE'
0x00007FFFAB9E5280 930 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT D.TABSCHEMA,D.TABNAME, D.CARD, D.OVERFLOW, D.NPAGES, D.FPAGES, D.ACTIVE_BLOCKS, T.CLUSTERED,
D.AVGCOMPRESSEDROWSIZE, T.PCTFREE, D.DATAPARTITIONNAME FROM SYSIBM.SYSDATAPARTITIONS D, SYSIBM.SYSTABLES T, JTAB WHERE
(D.TABSCHEMA=JTAB.JSCHEMA) AND (D.TABNAME=JTAB.JNAME) AND (D.TABSCHEMA=T.CREATOR) AND (D.TABNAME=T.NAME) AND
(D.PARTITIONOBJECTID <> T.FID) AND (D.TBSPACEID <> T.TID) AND (D.STATUS = '') ORDER BY D.TABSCHEMA,D.TABNAME
0x00007FFFABAC7DE0 953 1 1 1 1 1 SELECT COUNT( * ) FROM
SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_STATE > 1
0x00007FFFABB774A0 960 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT SYSIBM.SYSTABLESPACES.PAGESIZE, SYSIBM.SYSTABLESPACES.EXTENTSIZE, SYSIBM.SYSTABLESPACES.DATATYPE FROM
SYSIBM.SYSTABLESPACES, SYSIBM.SYSTABLES, JTAB, SYSIBM.SYSDATAPARTITIONS WHERE (SYSIBM.SYSTABLES.CREATOR = JTAB.JSCHEMA) AND
(SYSIBM.SYSTABLES.NAME = JTAB.JNAME) AND (SYSIBM.SYSTABLES.NAME = SYSIBM.SYSDATAPARTITIONS.TABNAME) AND
(SYSIBM.SYSTABLES.CREATOR = SYSIBM.SYSDATAPARTITIONS.TABSCHEMA) AND (SYSIBM.SYSDATAPARTITIONS.SEQNO=0) AND
(SYSIBM.SYSDATAPARTITIONS.TBSPACEID = SYSIBM.SYSTABLESPACES.TBSPACEID)
0x00007FFFABA76E80 965 1 1 1 2 2 WITH VTYPED (NAME, SCHEMA) AS
(VALUES(TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT TYPE FROM SYSIBM.SYSTABLES, VTYPED WHERE TYPE = 'U' AND SYSIBM.SYSTABLES.NAME = VTYPED.NAME AND
SYSIBM.SYSTABLES.CREATOR = VTYPED.SCHEMA
0x00007FFFABB96CE0 1011 1 2 2 2 1 DECLARE GLOBAL TEMPORARY
TABLE IX_STATS (TABLE_SCHEMA VARCHAR(128), TABLE_NAME VARCHAR(128), INDEX_SCHEMA VARCHAR(128), INDEX_NAME VARCHAR(128),
DATAPARTITIONNAME VARCHAR(128), INDCARD BIGINT, NLEAF BIGINT, NUM_EMPTY_LEAFS BIGINT, NLEVELS INT, NUMRIDS_DELETED BIGINT,
FULLKEYCARD BIGINT, LEAF_RECSIZE BIGINT, NONLEAF_RECSIZE BIGINT, LEAF_PAGE_OVERHEAD BIGINT, NONLEAF_PAGE_OVERHEAD BIGINT,
PCT_PAGES_SAVED SMALLINT, F4 INT, F5 INT, F6 INT, F7 INT, F8 INT, REORG CHAR(5)) ON COMMIT PRESERVE ROWS NOT LOGGED WITH
REPLACE IN SYSTOOLSTMPSPACE
0x00007FFFABA97260 1014 2 1 1 107 107 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2CommonMED' AND DECISION='NOP' AND NAME='CommonPolicy'
Dynamic SQL Environments:
Address AnchID StmtUID EnvID Iso QOpt Blk
0x00007FFFABA97B20 98 1 2 CS 5 B
0x00007FFFABAC6FC0 98 1 1 CS 5 B
0x00007FFFABBBE3A0 134 2 1 CS 5 B
0x00007FFFABB17260 155 1 1 CS 5 B
--More--
0x00007FFFABAED220 164 7 1 CS 5 B
0x00007FFFAB9E5E20 181 1 1 CS 5 B
0x00007FFFAB9D8500 184 1 1 CS 5 B
0x00007FFFAB9DAA20 184 1 2 CS 5 B
0x00007FFFABB21AA0 220 2 1 CS 5 B
0x00007FFFABB94C80 247 1 1 CS 5 B
0x00007FFFABB14E80 270 1 2 CS 5 B
0x00007FFFABA96D40 299 1 1 CS 5 B
0x00007FFFABA95280 299 1 2 CS 5 B
0x00007FFFABA70160 302 1 1 CS 5 B
0x00007FFFABBB5B20 325 1 1 CS 5 B
0x00007FFFABB20F20 332 2 1 CS 5 B
0x00007FFFABB17720 340 2 1 CS 5 B
0x00007FFFABB67C20 354 1 1 CS 5 B
0x00007FFFABAECFA0 382 1 2 CS 5 B
0x00007FFFABAED660 397 1 1 CS 5 B
0x00007FFFAB9E65E0 430 1 1 CS 5 B
0x00007FFFABB14C00 434 1 2 CS 5 B
0x00007FFFABB208C0 437 2 1 CS 5 B
0x00007FFFABA95500 448 3 2 CS 5 B
0x00007FFFABAC5EC0 448 3 1 CS 5 B
0x00007FFFABAF74A0 450 3 1 CS 5 B
0x00007FFFABB07820 453 1 1 CS 5 B
0x00007FFFABB07B60 453 1 2 CS 5 B
0x00007FFFABB06380 462 2 1 CS 5 B
0x00007FFFABB21480 492 2 1 CS 5 B
0x00007FFFABBB7CA0 503 2 1 CS 5 B
0x00007FFFABA76C00 504 1 1 CS 5 B
0x00007FFFABAC7780 574 1 1 CS 5 B
0x00007FFFAB9E7BC0 580 1 1 CS 5 B
0x00007FFFABB06920 639 2 1 CS 5 B
0x00007FFFABB06EC0 651 1 1 CS 5 B
0x00007FFFABB15200 692 1 1 CS 5 B
0x00007FFFABA77940 697 1 1 CS 5 B
0x00007FFFABA95B20 730 1 1 CS 5 B
0x00007FFFABA734E0 735 1 1 CS 5 B
0x00007FFFABAF3980 742 2 1 CS 5 B
0x00007FFFAB9E5000 742 3 1 CS 5 B
0x00007FFFAB9E73A0 753 1 1 CS 5 B
0x00007FFFABB17A60 766 2 1 CS 5 B
0x00007FFFABAF7880 794 2 1 CS 5 B
0x00007FFFABA70D40 809 1 1 CS 5 B
0x00007FFFABB25A40 863 2 1 CS 5 B
--More--
0x00007FFFABBC20E0 877 2 1 CS 5 B
0x00007FFFABB260C0 886 2 1 CS 5 B
0x00007FFFABAC6B80 923 1 1 CS 5 B
0x00007FFFAB9E5600 930 1 1 CS 5 B
0x00007FFFABAC7440 953 1 1 CS 5 B
0x00007FFFABB77860 960 1 1 CS 5 B
0x00007FFFABA1B620 965 1 1 CS 5 B
0x00007FFFABB97B00 1011 1 2 CS 5 B
0x00007FFFABB97020 1011 1 1 CS 5 B
0x00007FFFABA973E0 1014 2 1 CS 5 B
Dynamic SQL Variations:
Address AnchID StmtUID EnvID VarID NumRef Typ Lockname Val Insert Time Sect Size
0x00007FFFABB60300 98 1 2 1 1 1 01000000020000000100400C56 N 2013-06-20-08.14.01.856351 0
0x00007FFFABB5E6E0 98 1 1 1 1 1 01000000010000000100400C56 Y 2013-06-20-08.14.01.690522 1496
0x00007FFFABBBE6E0 134 2 1 1 1 6 02000000010000000100C01056 Y 2013-06-20-08.14.02.067136 6544
0x00007FFFABB00C60 155 1 1 1 1 4 01000000010000000100601356 Y 2013-06-20-07.12.28.972570 5744
0x00007FFFABB09CC0 164 7 1 1 25 6 07000000010000000100801456 Y 2013-06-20-06.29.00.939842 6024
0x00007FFFABB8BAE0 181 1 1 1 1 6 01000000010000000100A01656 Y 2013-06-20-08.14.02.010903 14256
0x00007FFFAB9D8840 184 1 1 1 1 1 01000000010000000100001756 Y 2013-06-20-05.06.25.278924 1424
0x00007FFFAB9DAD60 184 1 2 1 1 1 01000000020000000100001756 N 2013-06-20-05.06.25.546711 0
0x00007FFFABA8E420 220 2 1 1 1 6 02000000010000000100801B56 Y 2013-06-20-08.14.01.228549 10472
0x00007FFFABB94FC0 247 1 1 1 2 6 01000000010000000100E01E56 Y 2013-06-20-08.14.02.026671 20128
0x00007FFFABB1ECA0 270 1 2 1 2 4 01000000020000000100C02156 Y 2013-06-20-07.08.22.281832 5744
0x00007FFFABB61F20 299 1 1 1 1 5 01000000010000000100602556 Y 2013-06-20-08.14.01.857486 1440
0x00007FFFABB63B40 299 1 2 1 1 1 01000000020000000100602556 N 2013-06-20-08.14.01.859269 0
0x00007FFFABAC0480 302 1 1 1 1 6 01000000010000000100C02556 Y 2013-06-20-08.14.01.637006 6624
0x00007FFFABBB5E60 325 1 1 1 1 4 01000000010000000100A02856 Y 2013-06-20-08.14.02.037600 8128
0x00007FFFABA88080 332 2 1 1 1 4 02000000010000000100802956 Y 2013-06-20-08.14.01.213600 9056
0x00007FFFABB044E0 340 2 1 1 1 6 02000000010000000100802A56 Y 2013-06-20-08.14.01.096857 5640
0x00007FFFABB6B9A0 354 1 1 1 1 6 01000000010000000100402C56 Y 2013-06-20-08.14.01.880889 8160
0x00007FFFABB220E0 382 1 2 1 8 4 01000000020000000100C02F56 Y 2013-06-20-06.25.03.900091 5912
0x00007FFFABB0B8E0 397 1 1 1 4 6 01000000010000000100A03156 Y 2013-06-20-07.07.49.499221 17976
0x00007FFFABB91560 430 1 1 1 1 13 01000000010000000100C03556 Y 2013-06-20-08.14.02.013715 5112
0x00007FFFABB1D080 434 1 2 1 6 6 01000000020000000100403656 Y 2013-06-20-07.08.10.510589 4792
0x00007FFFABAAB860 437 2 1 1 1 4 02000000010000000100A03656 Y 2013-06-20-08.14.01.208091 10144
0x00007FFFABB65760 448 3 2 1 1 1 03000000020000000100003856 N 2013-06-20-08.14.01.868743 0
0x00007FFFABB5AEA0 448 3 1 1 2 11 03000000010000000100003856 Y 2013-06-20-08.14.01.642026 2048
0x00007FFFABAF8080 450 3 1 1 59 6 03000000010000000100403856 Y 2013-06-20-06.24.33.258012 5728
0x00007FFFABB0D5A0 453 1 1 1 2 7 01000000010000000100A03856 Y 2013-06-20-06.24.00.833433 1440
0x00007FFFABB15480 453 1 2 2 1 1 01000000020000000200A03856 N 2013-06-20-06.24.00.838379 0
0x00007FFFABB0F780 453 1 2 1 1 1 01000000020000000100A03856 N 2013-06-20-06.24.00.833999 0
0x00007FFFABA6E540 462 2 1 1 134 3 02000000010000000100C03956 Y 2013-06-20-08.14.01.137231 6456
--More--
0x00007FFFABA88080 332 2 1 1 1 4 02000000010000000100802956 Y 2013-06-20-08.14.01.213600 9056
0x00007FFFABB044E0 340 2 1 1 1 6 02000000010000000100802A56 Y 2013-06-20-08.14.01.096857 5640
0x00007FFFABB6B9A0 354 1 1 1 1 6 01000000010000000100402C56 Y 2013-06-20-08.14.01.880889 8160
0x00007FFFABB220E0 382 1 2 1 8 4 01000000020000000100C02F56 Y 2013-06-20-06.25.03.900091 5912
0x00007FFFABB0B8E0 397 1 1 1 4 6 01000000010000000100A03156 Y 2013-06-20-07.07.49.499221 17976
0x00007FFFABB91560 430 1 1 1 1 13 01000000010000000100C03556 Y 2013-06-20-08.14.02.013715 5112
0x00007FFFABB1D080 434 1 2 1 6 6 01000000020000000100403656 Y 2013-06-20-07.08.10.510589 4792
0x00007FFFABAAB860 437 2 1 1 1 4 02000000010000000100A03656 Y 2013-06-20-08.14.01.208091 10144
0x00007FFFABB65760 448 3 2 1 1 1 03000000020000000100003856 N 2013-06-20-08.14.01.868743 0
0x00007FFFABB5AEA0 448 3 1 1 2 11 03000000010000000100003856 Y 2013-06-20-08.14.01.642026 2048
0x00007FFFABAF8080 450 3 1 1 59 6 03000000010000000100403856 Y 2013-06-20-06.24.33.258012 5728
0x00007FFFABB0D5A0 453 1 1 1 2 7 01000000010000000100A03856 Y 2013-06-20-06.24.00.833433 1440
0x00007FFFABB15480 453 1 2 2 1 1 01000000020000000200A03856 N 2013-06-20-06.24.00.838379 0
0x00007FFFABB0F780 453 1 2 1 1 1 01000000020000000100A03856 N 2013-06-20-06.24.00.833999 0
0x00007FFFABA6E540 462 2 1 1 134 3 02000000010000000100C03956 Y 2013-06-20-08.14.01.137231 6456
0x00007FFFABA8C800 492 2 1 1 1 4 02000000010000000100803D56 Y 2013-06-20-08.14.01.216404 5096
0x00007FFFABBBA800 503 2 1 1 1 6 02000000010000000100E03E56 Y 2013-06-20-08.14.02.064526 6912
0x00007FFFABA930A0 504 1 1 1 1 13 01000000010000000100003F56 Y 2013-06-20-08.14.01.242219 5112
0x00007FFFABB12FE0 574 1 1 1 1 6 01000000010000000100C04756 Y 2013-06-20-06.25.07.240580 6544
0x00007FFFABA24780 580 1 1 1 126 13 01000000010000000100804856 Y 2013-06-20-05.09.00.558886 5608
0x00007FFFABA69DC0 639 2 1 1 1 4 02000000010000000100E04F56 Y 2013-06-20-08.14.01.187294 10200
0x00007FFFABAA8080 651 1 1 1 1 6 01000000010000000100605156 Y 2013-06-20-08.14.01.195517 6352
0x00007FFFABAFD3E0 692 1 1 1 1 4 01000000010000000100805656 Y 2013-06-20-07.10.34.512235 5744
0x00007FFFABAC3E60 697 1 1 1 2 6 01000000010000000100205756 Y 2013-06-20-08.14.01.641327 9976
0x00007FFFABB6F9C0 730 1 1 1 1 6 01000000010000000100405B56 Y 2013-06-20-08.14.01.929690 21512
0x00007FFFABA73820 735 1 1 1 5 13 01000000010000000100E05B56 Y 2013-06-20-05.09.00.806131 5624
0x00007FFFABAF3C00 742 2 1 1 8 3 02000000010000000100C05C56 Y 2013-06-20-06.25.03.895931 7080
0x00007FFFABB7DEA0 742 3 1 1 1 6 03000000010000000100C05C56 Y 2013-06-20-08.14.01.960338 8992
0x00007FFFABABC280 753 1 1 1 1 6 01000000010000000100205E56 Y 2013-06-20-08.14.01.634936 8640
0x00007FFFABA19A00 766 2 1 1 1 6 02000000010000000100C05F56 Y 2013-06-20-08.14.01.130798 5896
0x00007FFFABAF1D60 794 2 1 1 100 4 02000000010000000100406356 Y 2013-06-20-06.25.03.890273 9976
0x00007FFFABA71080 809 1 1 1 96 9 01000000010000000100206556 Y 2013-06-20-05.09.00.805387 1728
0x00007FFFAB9DC980 863 2 1 1 1 6 02000000010000000100E06B56 Y 2013-06-20-08.14.01.048513 5824
0x00007FFFABBC2420 877 2 1 1 1 6 02000000010000000100A06D56 Y 2013-06-20-08.14.02.069922 6144
0x00007FFFAB9E33E0 886 2 1 1 1 6 02000000010000000100C06E56 Y 2013-06-20-08.14.01.123805 5640
0x00007FFFABB5CAC0 923 1 1 1 1 6 01000000010000000100607356 Y 2013-06-20-08.14.01.687359 6176
0x00007FFFABB821C0 930 1 1 1 1 6 01000000010000000100407456 Y 2013-06-20-08.14.01.980898 13464
0x00007FFFABAEFBC0 953 1 1 1 1 6 01000000010000000100207756 Y 2013-06-20-06.25.07.238922 6536
0x00007FFFABB78080 960 1 1 1 1 6 01000000010000000100007856 Y 2013-06-20-08.14.01.948920 14664
0x00007FFFABAB8080 965 1 1 1 2 6 01000000010000000100A07856 Y 2013-06-20-08.14.01.631844 8640
0x00007FFFABBAF640 1011 1 2 1 1 1 01000000020000000100607E56 N 2013-06-20-08.14.02.031463 0
0x00007FFFABBADA20 1011 1 1 1 1 11 01000000010000000100607E56 Y 2013-06-20-08.14.02.027657 1928
0x00007FFFABAEDFA0 1014 2 1 1 107 6 02000000010000000100C07E56 Y 2013-06-20-06.24.01.507888 5784
db2inst1@db2975:~>
顺着上面红色和绿色就能找到对应的SQL语句。收起
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:12:36 -- Date 06/20/2013 08:18:21
Locks being waited on :
AppHandl [nod-index] TranHdl Lockname Type Mode Conv Sts CoorEDU AppName AuthID AppID
104 [000-00104] 2 02000400040000000000000052 Row ..X G 19 db2bp DB2INST1 *LOCAL.db2inst1.130620090545
122 [000-00122] 9 02000400040000000000000052 Row ..U W 49 db2bp DB2INST1 *LOCAL.db2inst1.130620091038
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:12:36 -- Date 06/20/2013 08:18:21
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID CollectActData CollectActPartition CollectSectionActuals
0x0000000201010080 105 [000-00105] 1 35 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090546 0 0 N C N
0x0000000200FF0080 104 [000-00104] 1 19 UOW-Waiting 0 0 692 1 *LOCAL.db2inst1.130620090545 1 1 N C N
0x0000000200F40080 110 [000-00110] 1 47 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090551 0 0 N C N
0x0000000200F10080 109 [000-00109] 1 46 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090550 0 0 N C N
0x0000000200FB0080 359 [000-00359] 1 51 UOW-Waiting 0 0 397 1 *LOCAL.db2inst1.130620111308 1 3 N C N
0x0000000200F50080 122 [000-00122] 1 49 Lock-wait 155 1 434 1 *LOCAL.db2inst1.130620091038 1 2 N C N
0x0000000200F00080 108 [000-00108] 1 45 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090549 0 0 N C N
0x0000000201030080 107 [000-00107] 1 44 ConnectCompleted 0 0 0 0 *LOCAL.DB2.130620090548 0 0 N C N
0x0000000201020080 106 [000-00106] 1 34 UOW-Waiting 0 0 0 0 *LOCAL.DB2.130620090547 0 0 N C N
External Connection Attributes
Address AppHandl [nod-index] ClientIPAddress EncryptionLvl SystemAuthID
0x0000000201010080 105 [000-00105] n/a None DB2INST1
0x0000000200FF0080 104 [000-00104] n/a None DB2INST1
0x0000000200F40080 110 [000-00110] n/a None DB2INST1
0x0000000200F10080 109 [000-00109] n/a None DB2INST1
0x0000000200FB0080 359 [000-00359] n/a None DB2INST1
0x0000000200F50080 122 [000-00122] n/a None DB2INST1
0x0000000200F00080 108 [000-00108] n/a None DB2INST1
0x0000000201030080 107 [000-00107] n/a None DB2INST1
0x0000000201020080 106 [000-00106] n/a None DB2INST1
Trusted Connection Attributes
Address AppHandl [nod-index] TrustedContext ConnTrustType RoleInherited
0x0000000201010080 105 [000-00105] n/a non trusted n/a
0x0000000200FF0080 104 [000-00104] n/a non trusted n/a
0x0000000200F40080 110 [000-00110] n/a non trusted n/a
0x0000000200F10080 109 [000-00109] n/a non trusted n/a
0x0000000200FB0080 359 [000-00359] n/a non trusted n/a
0x0000000200F50080 122 [000-00122] n/a non trusted n/a
0x0000000200F00080 108 [000-00108] n/a non trusted n/a
0x0000000201030080 107 [000-00107] n/a non trusted n/a
0x0000000201020080 106 [000-00106] n/a non trusted n/a
Autonomous Routine Connections
Address AppHandl [nod-index] Status Autonomous Routine Handl [nod-index] Status
db2inst1@db2975:~>db2pd -db test -dynamic
Database Partition 0 -- Database TEST -- Active -- Up 0 days 03:16:59 -- Date 06/20/2013 08:22:44
Dynamic Cache:
Current Memory Used 1609720
Total Heap Size 13699317
Cache Overflow Flag 0
Number of References 1750
Number of Statement Inserts 444
Number of Statement Deletes 393
Number of Variation Inserts 104
Number of Statements 51
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x00007FFFABAC6EC0 98 1 2 2 2 1 CREATE USER TEMPORARY
TABLESPACE SYSTOOLSTMPSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4
0x00007FFFABBBE220 134 2 1 1 1 1 SELECT COUNT(*) FROM
SYSTOOLS.HMON_ATM_INFO WHERE REORG_FLAG = 'Y' AND REORG_NOTIFY = 'Y'
0x00007FFFABB17160 155 1 1 1 1 1 update tab1 set name = 'abc5'
where name='abc3'
0x00007FFFABAC7A00 164 7 1 1 25 25 SELECT COLNAME, TYPENAME FROM
SYSCAT.COLUMNS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS'
0x00007FFFAB9E5BC0 181 1 1 1 1 1 SELECT indschema, indname
from SYSCAT.INDEXES a, SYSCAT.TABLES b where a.tabschema = ? AND a.tabname = ? AND (a.tabname = b.tabname AND a.tabschema =
b.tabschema AND (b.clustered is null or b.clustered != 'Y' )) AND (INDEXTYPE = 'CLUS' OR UNIQUERULE IN ('P','U')) ORDER BY
INDEXTYPE, UNIQUERULE with ur
0x00007FFFAB9D83C0 184 1 2 2 2 1 create table tab1 (name
char(10))
0x00007FFFABB21800 220 2 1 1 1 1 SELECT a.schema, a.name,
a.reorg_state, a.reorg_history, a.reorg_index_schema, a.reorg_index_name, a.reorg_index_online FROM SYSTOOLS.HMON_ATM_INFO a,
SYSCAT.TABLES b WHERE a.schema = b.tabschema AND a.name = b.tabname AND a.stats_lock != 'Y' AND a.reorg_flag = 'Y' AND
(b.stats_time > a.reorg_time OR a.reorg_state > 4 OR (b.stats_time is not null AND a.reorg_time is null)) with ur
0x00007FFFABB948A0 247 1 1 1 2 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT I.CREATOR, I.NAME, I.TBCREATOR, I.TBNAME, '%-s' AS COLNAMES, I.COLCOUNT, I.NLEAF, I.NLEVELS,
I.CLUSTERRATIO, I.FULLKEYCARD, I.CLUSTERFACTOR, I.INDEXTYPE, I.NUMRIDS_DELETED, I.NUM_EMPTY_LEAFS, I.UNIQUE_COLCOUNT,
I.AVGLEAFKEYSIZE, I.AVGNLEAFKEYSIZE FROM SYSIBM.SYSTABLES T, SYSIBM.SYSINDEXES I, JTAB WHERE (T.NAME = I.TBNAME) AND
(T.CREATOR = I.TBCREATOR) AND ( TBCREATOR = JTAB.JSCHEMA) AND (TBNAME = JTAB.JNAME) AND ((T.TYPE='T') OR (T.TYPE = 'S') OR
(T.TYPE = 'U')) ORDER BY I.TBCREATOR, I.TBNAME, I.CREATOR, I.NAME
0x00007FFFABAC72E0 270 1 1 1 3 3 update tab1 set name='abc3'
where name='abc2'
0x00007FFFABA97E60 299 1 2 2 2 1 GRANT USE OF TABLESPACE
--More--
SYSTOOLSTMPSPACE TO PUBLIC
0x00007FFFABA27EE0 302 1 1 1 1 1 SELECT TYPE FROM
SYSIBM.SYSTABLES WHERE TYPE='L' AND SYSIBM.SYSTABLES.CREATOR=CAST(? AS varchar(128)) AND SYSIBM.SYSTABLES.NAME=CAST(? AS
varchar(128))
0x00007FFFABBB5920 325 1 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
SET REORG_DETAIL = ?, REORG_STATE = ?, REORG_TIME = CURRENT TIMESTAMP, REORG_NOTIFY = ?, REORG_HISTORY = ?, REORG_INDEX_SCHEMA
= ?, REORG_INDEX_NAME = ? WHERE SCHEMA = ? AND NAME = ?
0x00007FFFABB20D20 332 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
AS ATM SET STATS_FLAG = 'N', REORG_FLAG = 'N' WHERE (ATM.SCHEMA, ATM.NAME) IN (SELECT IBM.CREATOR, IBM.NAME
FROM SYSIBM.SYSTABLES AS IBM WHERE IBM.TYPE = 'N' )
0x00007FFFABB175A0 340 2 1 1 1 1 SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABNAME='HMON_ATM_INFO' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABB67A00 354 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT AVGROWSIZE FROM SYSIBM.SYSTABLES, JTAB WHERE (CREATOR = JTAB.JSCHEMA) AND (NAME = JTAB.JNAME)
0x00007FFFABB26720 382 1 1 1 43 43 UPDATE SYSTOOLS.HMON_ATM_INFO
SET STATS_LOCK = 'Y' WHERE CURRENT OF SQL_CURSH200C4
0x00007FFFABAED520 397 1 1 1 4 4 SELECT * from
SYSIBMADM.LOCKWAITS
0x00007FFFAB9E6480 430 1 1 1 1 1 CALL REORGCHK_IX_STATS ('T',
'"DB2INST1"."TAB1"')
0x00007FFFAB9E32A0 434 1 1 1 21 21 select * from tab1
0x00007FFFABB07280 437 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
AS ATM SET ATM.REORG_FLAG = 'Y' WHERE (ATM.SCHEMA, ATM.NAME, ATM.CREATE_TIME) IN (SELECT IBM.TABSCHEMA, IBM.TABNAME,
IBM.CREATE_TIME FROM SYSCAT.TABLES AS IBM WHERE TABSCHEMA NOT LIKE 'SYS%' ) WITH UR
0x00007FFFABAC5B00 448 3 2 2 3 2 DECLARE GLOBAL TEMPORARY
TABLE TB_STATS ( TABLE_SCHEMA VARCHAR(128), TABLE_NAME VARCHAR(128), DATAPARTITIONNAME
VARCHAR(128), CARD BIGINT, OVERFLOW BIGINT, NPAGES BIGINT,
FPAGES BIGINT, ACTIVE_BLOCKS BIGINT, TSIZE BIGINT,
F1 INT, F2 INT, F3 INT,
REORG CHAR(3) ) ON COMMIT PRESERVE ROWS NOT LOGGED WITH REPLACE IN
SYSTOOLSTMPSPACE
0x00007FFFABAF1A20 450 3 1 1 59 59 SELECT TRIGNAME FROM
SYSCAT.TRIGGERS WHERE TABNAME='POLICY' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABB076C0 453 1 2 3 4 2 LOCK TABLE
SYSTOOLS.HMON_ATM_INFO IN SHARE MODE
0x00007FFFABB06200 462 2 1 1 134 134 SELECT CREATE_TIME FROM
SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? FOR UPDATE
0x00007FFFABB21320 492 2 1 1 1 1 UPDATE SYSTOOLS.HMON_ATM_INFO
SET REORG_NOTIFY = 'N'
0x00007FFFABBB7B00 503 2 1 1 1 1 SELECT COUNT(*) FROM
SYSTOOLS.HMON_ATM_INFO WHERE REORG_FLAG = 'Y' AND ((REORG_STATE = 2) OR (REORG_STATE = 6))
0x00007FFFABB21FA0 504 1 1 1 1 1 CALL REORGCHK_TB_STATS ('T',
--More--
'"DB2INST1"."TAB1"')
0x00007FFFABAF17E0 574 1 1 1 1 1 SELECT COUNT( * ) FROM
SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_NOTIFY = 'Y'
0x00007FFFAB9E7A60 580 1 1 1 126 126 CALL
SYSPROC.SYSINSTALLOBJECTS('POLICY','V','','')
0x00007FFFABB06740 639 2 1 1 1 1 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
0x00007FFFABB06CE0 651 1 1 1 1 1 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2TableMaintenanceMED' AND DECISION='TableReorgDecision' AND NAME='TableReorgPolicy' AND
UPDATE_TIME > '2013-06-20-06.20.36.000000'
0x00007FFFABB15100 692 1 1 1 1 1 update tab1 set name='abc2'
where name='abc3'
0x00007FFFABA704A0 697 1 1 1 2 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT CREATOR, NAME, CARD, OVERFLOW, NPAGES, FPAGES, ACTIVE_BLOCKS, CLUSTERED, AVGCOMPRESSEDROWSIZE, PCTFREE
FROM SYSIBM.SYSTABLES, JTAB WHERE ((TYPE='T') OR (TYPE = 'S') OR (TYPE = 'U')) AND (CREATOR=JTAB.JSCHEMA) AND
(NAME=JTAB.JNAME) ORDER BY CREATOR,NAME
0x00007FFFABA95780 730 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))), DBPGNAMES AS (SELECT DISTINCT(S.DBPGNAME)DBPGNAME FROM SYSCAT.TABLESPACES S,
SYSCAT.DATAPARTITIONS D, JTAB WHERE (D.TABNAME = JTAB.JNAME) AND ( D.TABSCHEMA = JTAB.JSCHEMA) AND D.TBSPACEID IS NOT NULL
AND S.TBSPACEID = D.TBSPACEID ORDER BY DBPGNAME), NODELIST AS (SELECT DISTINCT(D.DBPARTITIONNUM) FROM DBPGNAMES P,
SYSCAT.DBPARTITIONGROUPDEF D WHERE P.DBPGNAME = D.DBPGNAME AND D.IN_USE = 'Y' GROUP BY D.DBPARTITIONNUM) SELECT COUNT(*)
NUM_NODES FROM NODELIST
0x00007FFFABA73380 735 1 1 1 5 6 CALL SYSINSTALLOBJECTS(
'DB2AC', 'V', NULL, NULL )
0x00007FFFABAF7C00 742 2 1 1 8 8 SELECT STATS_LOCK, REORG_LOCK
FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? AND CREATE_TIME = ? FOR UPDATE
0x00007FFFABB77D00 742 3 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT COUNT(*) FROM SYSIBM.SYSDATAPARTITIONS, JTAB WHERE (TABSCHEMA = JTAB.JSCHEMA) AND (TABNAME =
JTAB.JNAME) AND LENGTH(STATUS)=0
0x00007FFFABA76F80 753 1 1 1 1 1 WITH VTYPED (NAME, SCHEMA) AS
(VALUES(TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT TYPE FROM SYSIBM.SYSTABLES, VTYPED WHERE TYPE = 'H' AND SYSIBM.SYSTABLES.NAME = VTYPED.NAME AND
SYSIBM.SYSTABLES.CREATOR = VTYPED.SCHEMA
0x00007FFFABB26580 766 2 1 1 1 1 SELECT CREATOR, NAME, CTIME
FROM SYSIBM.SYSTABLES WHERE TYPE='T' OR TYPE='S' OR TYPE='N' WITH UR
0x00007FFFABAFB640 794 2 1 1 100 100 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 = ?
--More--
0x00007FFFABA70C00 809 1 1 1 96 96 SET CURRENT LOCK TIMEOUT 5
0x00007FFFABB27E20 863 2 1 1 1 1 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2DatabaseRecoveryMED' AND DECISION='DBBackupDecision' AND NAME='DBBackupPolicy'
0x00007FFFABBC1F80 877 2 1 1 1 1 SELECT MAX(REORG_AVG_RUNTIME)
FROM SYSTOOLS.HMON_ATM_INFO
0x00007FFFABB25F40 886 2 1 1 1 1 SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABNAME='HMON_COLLECTION' AND TABSCHEMA='SYSTOOLS'
0x00007FFFABAC6A20 923 1 1 1 1 1 SELECT COUNT(*) FROM
SYSCAT.TABLESPACES WHERE TBSPACE='SYSTOOLSTMPSPACE'
0x00007FFFAB9E5280 930 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT D.TABSCHEMA,D.TABNAME, D.CARD, D.OVERFLOW, D.NPAGES, D.FPAGES, D.ACTIVE_BLOCKS, T.CLUSTERED,
D.AVGCOMPRESSEDROWSIZE, T.PCTFREE, D.DATAPARTITIONNAME FROM SYSIBM.SYSDATAPARTITIONS D, SYSIBM.SYSTABLES T, JTAB WHERE
(D.TABSCHEMA=JTAB.JSCHEMA) AND (D.TABNAME=JTAB.JNAME) AND (D.TABSCHEMA=T.CREATOR) AND (D.TABNAME=T.NAME) AND
(D.PARTITIONOBJECTID <> T.FID) AND (D.TBSPACEID <> T.TID) AND (D.STATUS = '') ORDER BY D.TABSCHEMA,D.TABNAME
0x00007FFFABAC7DE0 953 1 1 1 1 1 SELECT COUNT( * ) FROM
SYSTOOLS.HMON_ATM_INFO WHERE STATS_FLAG = 'Y' AND STATS_STATE > 1
0x00007FFFABB774A0 960 1 1 1 1 1 WITH JTAB(JSCHEMA,JNAME) AS
(VALUES(TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT SYSIBM.SYSTABLESPACES.PAGESIZE, SYSIBM.SYSTABLESPACES.EXTENTSIZE, SYSIBM.SYSTABLESPACES.DATATYPE FROM
SYSIBM.SYSTABLESPACES, SYSIBM.SYSTABLES, JTAB, SYSIBM.SYSDATAPARTITIONS WHERE (SYSIBM.SYSTABLES.CREATOR = JTAB.JSCHEMA) AND
(SYSIBM.SYSTABLES.NAME = JTAB.JNAME) AND (SYSIBM.SYSTABLES.NAME = SYSIBM.SYSDATAPARTITIONS.TABNAME) AND
(SYSIBM.SYSTABLES.CREATOR = SYSIBM.SYSDATAPARTITIONS.TABSCHEMA) AND (SYSIBM.SYSDATAPARTITIONS.SEQNO=0) AND
(SYSIBM.SYSDATAPARTITIONS.TBSPACEID = SYSIBM.SYSTABLESPACES.TBSPACEID)
0x00007FFFABA76E80 965 1 1 1 2 2 WITH VTYPED (NAME, SCHEMA) AS
(VALUES(TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS varchar(128))), TABLE_SCHEMA(CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT TYPE FROM SYSIBM.SYSTABLES, VTYPED WHERE TYPE = 'U' AND SYSIBM.SYSTABLES.NAME = VTYPED.NAME AND
SYSIBM.SYSTABLES.CREATOR = VTYPED.SCHEMA
0x00007FFFABB96CE0 1011 1 2 2 2 1 DECLARE GLOBAL TEMPORARY
TABLE IX_STATS (TABLE_SCHEMA VARCHAR(128), TABLE_NAME VARCHAR(128), INDEX_SCHEMA VARCHAR(128), INDEX_NAME VARCHAR(128),
DATAPARTITIONNAME VARCHAR(128), INDCARD BIGINT, NLEAF BIGINT, NUM_EMPTY_LEAFS BIGINT, NLEVELS INT, NUMRIDS_DELETED BIGINT,
FULLKEYCARD BIGINT, LEAF_RECSIZE BIGINT, NONLEAF_RECSIZE BIGINT, LEAF_PAGE_OVERHEAD BIGINT, NONLEAF_PAGE_OVERHEAD BIGINT,
PCT_PAGES_SAVED SMALLINT, F4 INT, F5 INT, F6 INT, F7 INT, F8 INT, REORG CHAR(5)) ON COMMIT PRESERVE ROWS NOT LOGGED WITH
REPLACE IN SYSTOOLSTMPSPACE
0x00007FFFABA97260 1014 2 1 1 107 107 SELECT POLICY FROM
SYSTOOLS.POLICY WHERE MED='DB2CommonMED' AND DECISION='NOP' AND NAME='CommonPolicy'
Dynamic SQL Environments:
Address AnchID StmtUID EnvID Iso QOpt Blk
0x00007FFFABA97B20 98 1 2 CS 5 B
0x00007FFFABAC6FC0 98 1 1 CS 5 B
0x00007FFFABBBE3A0 134 2 1 CS 5 B
0x00007FFFABB17260 155 1 1 CS 5 B
--More--
0x00007FFFABAED220 164 7 1 CS 5 B
0x00007FFFAB9E5E20 181 1 1 CS 5 B
0x00007FFFAB9D8500 184 1 1 CS 5 B
0x00007FFFAB9DAA20 184 1 2 CS 5 B
0x00007FFFABB21AA0 220 2 1 CS 5 B
0x00007FFFABB94C80 247 1 1 CS 5 B
0x00007FFFABB14E80 270 1 2 CS 5 B
0x00007FFFABA96D40 299 1 1 CS 5 B
0x00007FFFABA95280 299 1 2 CS 5 B
0x00007FFFABA70160 302 1 1 CS 5 B
0x00007FFFABBB5B20 325 1 1 CS 5 B
0x00007FFFABB20F20 332 2 1 CS 5 B
0x00007FFFABB17720 340 2 1 CS 5 B
0x00007FFFABB67C20 354 1 1 CS 5 B
0x00007FFFABAECFA0 382 1 2 CS 5 B
0x00007FFFABAED660 397 1 1 CS 5 B
0x00007FFFAB9E65E0 430 1 1 CS 5 B
0x00007FFFABB14C00 434 1 2 CS 5 B
0x00007FFFABB208C0 437 2 1 CS 5 B
0x00007FFFABA95500 448 3 2 CS 5 B
0x00007FFFABAC5EC0 448 3 1 CS 5 B
0x00007FFFABAF74A0 450 3 1 CS 5 B
0x00007FFFABB07820 453 1 1 CS 5 B
0x00007FFFABB07B60 453 1 2 CS 5 B
0x00007FFFABB06380 462 2 1 CS 5 B
0x00007FFFABB21480 492 2 1 CS 5 B
0x00007FFFABBB7CA0 503 2 1 CS 5 B
0x00007FFFABA76C00 504 1 1 CS 5 B
0x00007FFFABAC7780 574 1 1 CS 5 B
0x00007FFFAB9E7BC0 580 1 1 CS 5 B
0x00007FFFABB06920 639 2 1 CS 5 B
0x00007FFFABB06EC0 651 1 1 CS 5 B
0x00007FFFABB15200 692 1 1 CS 5 B
0x00007FFFABA77940 697 1 1 CS 5 B
0x00007FFFABA95B20 730 1 1 CS 5 B
0x00007FFFABA734E0 735 1 1 CS 5 B
0x00007FFFABAF3980 742 2 1 CS 5 B
0x00007FFFAB9E5000 742 3 1 CS 5 B
0x00007FFFAB9E73A0 753 1 1 CS 5 B
0x00007FFFABB17A60 766 2 1 CS 5 B
0x00007FFFABAF7880 794 2 1 CS 5 B
0x00007FFFABA70D40 809 1 1 CS 5 B
0x00007FFFABB25A40 863 2 1 CS 5 B
--More--
0x00007FFFABBC20E0 877 2 1 CS 5 B
0x00007FFFABB260C0 886 2 1 CS 5 B
0x00007FFFABAC6B80 923 1 1 CS 5 B
0x00007FFFAB9E5600 930 1 1 CS 5 B
0x00007FFFABAC7440 953 1 1 CS 5 B
0x00007FFFABB77860 960 1 1 CS 5 B
0x00007FFFABA1B620 965 1 1 CS 5 B
0x00007FFFABB97B00 1011 1 2 CS 5 B
0x00007FFFABB97020 1011 1 1 CS 5 B
0x00007FFFABA973E0 1014 2 1 CS 5 B
Dynamic SQL Variations:
Address AnchID StmtUID EnvID VarID NumRef Typ Lockname Val Insert Time Sect Size
0x00007FFFABB60300 98 1 2 1 1 1 01000000020000000100400C56 N 2013-06-20-08.14.01.856351 0
0x00007FFFABB5E6E0 98 1 1 1 1 1 01000000010000000100400C56 Y 2013-06-20-08.14.01.690522 1496
0x00007FFFABBBE6E0 134 2 1 1 1 6 02000000010000000100C01056 Y 2013-06-20-08.14.02.067136 6544
0x00007FFFABB00C60 155 1 1 1 1 4 01000000010000000100601356 Y 2013-06-20-07.12.28.972570 5744
0x00007FFFABB09CC0 164 7 1 1 25 6 07000000010000000100801456 Y 2013-06-20-06.29.00.939842 6024
0x00007FFFABB8BAE0 181 1 1 1 1 6 01000000010000000100A01656 Y 2013-06-20-08.14.02.010903 14256
0x00007FFFAB9D8840 184 1 1 1 1 1 01000000010000000100001756 Y 2013-06-20-05.06.25.278924 1424
0x00007FFFAB9DAD60 184 1 2 1 1 1 01000000020000000100001756 N 2013-06-20-05.06.25.546711 0
0x00007FFFABA8E420 220 2 1 1 1 6 02000000010000000100801B56 Y 2013-06-20-08.14.01.228549 10472
0x00007FFFABB94FC0 247 1 1 1 2 6 01000000010000000100E01E56 Y 2013-06-20-08.14.02.026671 20128
0x00007FFFABB1ECA0 270 1 2 1 2 4 01000000020000000100C02156 Y 2013-06-20-07.08.22.281832 5744
0x00007FFFABB61F20 299 1 1 1 1 5 01000000010000000100602556 Y 2013-06-20-08.14.01.857486 1440
0x00007FFFABB63B40 299 1 2 1 1 1 01000000020000000100602556 N 2013-06-20-08.14.01.859269 0
0x00007FFFABAC0480 302 1 1 1 1 6 01000000010000000100C02556 Y 2013-06-20-08.14.01.637006 6624
0x00007FFFABBB5E60 325 1 1 1 1 4 01000000010000000100A02856 Y 2013-06-20-08.14.02.037600 8128
0x00007FFFABA88080 332 2 1 1 1 4 02000000010000000100802956 Y 2013-06-20-08.14.01.213600 9056
0x00007FFFABB044E0 340 2 1 1 1 6 02000000010000000100802A56 Y 2013-06-20-08.14.01.096857 5640
0x00007FFFABB6B9A0 354 1 1 1 1 6 01000000010000000100402C56 Y 2013-06-20-08.14.01.880889 8160
0x00007FFFABB220E0 382 1 2 1 8 4 01000000020000000100C02F56 Y 2013-06-20-06.25.03.900091 5912
0x00007FFFABB0B8E0 397 1 1 1 4 6 01000000010000000100A03156 Y 2013-06-20-07.07.49.499221 17976
0x00007FFFABB91560 430 1 1 1 1 13 01000000010000000100C03556 Y 2013-06-20-08.14.02.013715 5112
0x00007FFFABB1D080 434 1 2 1 6 6 01000000020000000100403656 Y 2013-06-20-07.08.10.510589 4792
0x00007FFFABAAB860 437 2 1 1 1 4 02000000010000000100A03656 Y 2013-06-20-08.14.01.208091 10144
0x00007FFFABB65760 448 3 2 1 1 1 03000000020000000100003856 N 2013-06-20-08.14.01.868743 0
0x00007FFFABB5AEA0 448 3 1 1 2 11 03000000010000000100003856 Y 2013-06-20-08.14.01.642026 2048
0x00007FFFABAF8080 450 3 1 1 59 6 03000000010000000100403856 Y 2013-06-20-06.24.33.258012 5728
0x00007FFFABB0D5A0 453 1 1 1 2 7 01000000010000000100A03856 Y 2013-06-20-06.24.00.833433 1440
0x00007FFFABB15480 453 1 2 2 1 1 01000000020000000200A03856 N 2013-06-20-06.24.00.838379 0
0x00007FFFABB0F780 453 1 2 1 1 1 01000000020000000100A03856 N 2013-06-20-06.24.00.833999 0
0x00007FFFABA6E540 462 2 1 1 134 3 02000000010000000100C03956 Y 2013-06-20-08.14.01.137231 6456
--More--
0x00007FFFABA88080 332 2 1 1 1 4 02000000010000000100802956 Y 2013-06-20-08.14.01.213600 9056
0x00007FFFABB044E0 340 2 1 1 1 6 02000000010000000100802A56 Y 2013-06-20-08.14.01.096857 5640
0x00007FFFABB6B9A0 354 1 1 1 1 6 01000000010000000100402C56 Y 2013-06-20-08.14.01.880889 8160
0x00007FFFABB220E0 382 1 2 1 8 4 01000000020000000100C02F56 Y 2013-06-20-06.25.03.900091 5912
0x00007FFFABB0B8E0 397 1 1 1 4 6 01000000010000000100A03156 Y 2013-06-20-07.07.49.499221 17976
0x00007FFFABB91560 430 1 1 1 1 13 01000000010000000100C03556 Y 2013-06-20-08.14.02.013715 5112
0x00007FFFABB1D080 434 1 2 1 6 6 01000000020000000100403656 Y 2013-06-20-07.08.10.510589 4792
0x00007FFFABAAB860 437 2 1 1 1 4 02000000010000000100A03656 Y 2013-06-20-08.14.01.208091 10144
0x00007FFFABB65760 448 3 2 1 1 1 03000000020000000100003856 N 2013-06-20-08.14.01.868743 0
0x00007FFFABB5AEA0 448 3 1 1 2 11 03000000010000000100003856 Y 2013-06-20-08.14.01.642026 2048
0x00007FFFABAF8080 450 3 1 1 59 6 03000000010000000100403856 Y 2013-06-20-06.24.33.258012 5728
0x00007FFFABB0D5A0 453 1 1 1 2 7 01000000010000000100A03856 Y 2013-06-20-06.24.00.833433 1440
0x00007FFFABB15480 453 1 2 2 1 1 01000000020000000200A03856 N 2013-06-20-06.24.00.838379 0
0x00007FFFABB0F780 453 1 2 1 1 1 01000000020000000100A03856 N 2013-06-20-06.24.00.833999 0
0x00007FFFABA6E540 462 2 1 1 134 3 02000000010000000100C03956 Y 2013-06-20-08.14.01.137231 6456
0x00007FFFABA8C800 492 2 1 1 1 4 02000000010000000100803D56 Y 2013-06-20-08.14.01.216404 5096
0x00007FFFABBBA800 503 2 1 1 1 6 02000000010000000100E03E56 Y 2013-06-20-08.14.02.064526 6912
0x00007FFFABA930A0 504 1 1 1 1 13 01000000010000000100003F56 Y 2013-06-20-08.14.01.242219 5112
0x00007FFFABB12FE0 574 1 1 1 1 6 01000000010000000100C04756 Y 2013-06-20-06.25.07.240580 6544
0x00007FFFABA24780 580 1 1 1 126 13 01000000010000000100804856 Y 2013-06-20-05.09.00.558886 5608
0x00007FFFABA69DC0 639 2 1 1 1 4 02000000010000000100E04F56 Y 2013-06-20-08.14.01.187294 10200
0x00007FFFABAA8080 651 1 1 1 1 6 01000000010000000100605156 Y 2013-06-20-08.14.01.195517 6352
0x00007FFFABAFD3E0 692 1 1 1 1 4 01000000010000000100805656 Y 2013-06-20-07.10.34.512235 5744
0x00007FFFABAC3E60 697 1 1 1 2 6 01000000010000000100205756 Y 2013-06-20-08.14.01.641327 9976
0x00007FFFABB6F9C0 730 1 1 1 1 6 01000000010000000100405B56 Y 2013-06-20-08.14.01.929690 21512
0x00007FFFABA73820 735 1 1 1 5 13 01000000010000000100E05B56 Y 2013-06-20-05.09.00.806131 5624
0x00007FFFABAF3C00 742 2 1 1 8 3 02000000010000000100C05C56 Y 2013-06-20-06.25.03.895931 7080
0x00007FFFABB7DEA0 742 3 1 1 1 6 03000000010000000100C05C56 Y 2013-06-20-08.14.01.960338 8992
0x00007FFFABABC280 753 1 1 1 1 6 01000000010000000100205E56 Y 2013-06-20-08.14.01.634936 8640
0x00007FFFABA19A00 766 2 1 1 1 6 02000000010000000100C05F56 Y 2013-06-20-08.14.01.130798 5896
0x00007FFFABAF1D60 794 2 1 1 100 4 02000000010000000100406356 Y 2013-06-20-06.25.03.890273 9976
0x00007FFFABA71080 809 1 1 1 96 9 01000000010000000100206556 Y 2013-06-20-05.09.00.805387 1728
0x00007FFFAB9DC980 863 2 1 1 1 6 02000000010000000100E06B56 Y 2013-06-20-08.14.01.048513 5824
0x00007FFFABBC2420 877 2 1 1 1 6 02000000010000000100A06D56 Y 2013-06-20-08.14.02.069922 6144
0x00007FFFAB9E33E0 886 2 1 1 1 6 02000000010000000100C06E56 Y 2013-06-20-08.14.01.123805 5640
0x00007FFFABB5CAC0 923 1 1 1 1 6 01000000010000000100607356 Y 2013-06-20-08.14.01.687359 6176
0x00007FFFABB821C0 930 1 1 1 1 6 01000000010000000100407456 Y 2013-06-20-08.14.01.980898 13464
0x00007FFFABAEFBC0 953 1 1 1 1 6 01000000010000000100207756 Y 2013-06-20-06.25.07.238922 6536
0x00007FFFABB78080 960 1 1 1 1 6 01000000010000000100007856 Y 2013-06-20-08.14.01.948920 14664
0x00007FFFABAB8080 965 1 1 1 2 6 01000000010000000100A07856 Y 2013-06-20-08.14.01.631844 8640
0x00007FFFABBAF640 1011 1 2 1 1 1 01000000020000000100607E56 N 2013-06-20-08.14.02.031463 0
0x00007FFFABBADA20 1011 1 1 1 1 11 01000000010000000100607E56 Y 2013-06-20-08.14.02.027657 1928
0x00007FFFABAEDFA0 1014 2 1 1 107 6 02000000010000000100C07E56 Y 2013-06-20-06.24.01.507888 5784
db2inst1@db2975:~>
顺着上面红色和绿色就能找到对应的SQL语句。收起