互联网服务数据库
db2中有都少方法可以看到正在执行的SQL语句？
就是currently executed SQL statements
我先开个头
最"古老"的办法是 get snapshot for application
后来可以query snapshot table了收起
我先开个头
最"古老"的办法是 get snapshot for application
后来可以query snapshot table了收起
查看其它 12 个回答wangzhonnew的回答
db2pd -app for C-AnchID/C-StmtUID, and map to db2pd -dynamic for AnchID/StmtUID
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:23:55 -- Date 07/20/2011 13:12:30
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID CollectActData CollectActPartition CollectSectionActuals
0x0780000000BD7FE0 13 [000-00013] 1 6684 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164841 0 0 N C N
0x0780000000C60080 19 [000-00019] 1 8226 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164847 0 0 N C N
0x0780000000BD0080 12 [000-00012] 1 6427 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164840 0 0 N C N
0x0780000000C37FE0 18 [000-00018] 1 7969 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164846 0 0 N C N
0x0780000000BA7FE0 11 [000-00011] 1 6170 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164839 0 0 N C N
0x0780000000C30080 17 [000-00017] 1 7712 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164845 0 0 N C N
0x0780000000BA0080 10 [000-00010] 1 5913 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164838 0 0 N C N
0x0780000000C17FE0 16 [000-00016] 1 7455 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164844 0 0 N C N
0x0780000000B77FE0 9 [000-00009] 1 5656 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164837 0 0 N C N
0x0780000000D00080 48 [000-00048] 1 8741 UOW-Executing 786 1 374 1 *LOCAL.taoewang.110720170409 1 2 N C N
0x0780000000C10080 15 [000-00015] 1 7198 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164843 0 0 N C N
0x0780000000B70080 8 [000-00008] 1 5399 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164836 0 0 N C N
0x0780000000BF0900 14 [000-00014] 1 6941 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164842 0 0 N C N
0x0780000000B00080 7 [000-00007] 1 1544 UOW-Waiting 0 0 0 0 *LOCAL.taoewang.110720164835 1 1 N C N
0x0780000000C67FE0 20 [000-00020] 1 8483 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164848 0 0 N C N
....
(taoewang@db2debug) /home/taoewang $ db2pd -dynamic -db sample
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:24:32 -- Date 07/20/2011 13:13:07
Dynamic Cache:
Current Memory Used 398903
Total Heap Size 127139
Cache Overflow Flag 1
Number of References 222
Number of Statement Inserts 472
Number of Statement Deletes 469
Number of Variation Inserts 66
Number of Statements 2
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x0700000033FB03E0 182 1 0 0 2 2 select * from employee
0x0700000033FB0260 786 1 1 1 1 1 select count(*) from
employee, employee, employee, employee, employee
Dynamic SQL Environments:
Address AnchID StmtUID EnvID Iso QOpt Blk
0x070000003406E5E0 786 1 1 CS 5 B
Dynamic SQL Variations:
Address AnchID StmtUID EnvID VarID NumRef Typ Lockname Val Insert Time Sect Size
0x0700000033FB07A0 786 1 1 1 1 6 00000001000000010001624056 Y 2011-07-20-13.12.27.048420 15088
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:23:55 -- Date 07/20/2011 13:12:30
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID CollectActData CollectActPartition CollectSectionActuals
0x0780000000BD7FE0 13 [000-00013] 1 6684 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164841 0 0 N C N
0x0780000000C60080 19 [000-00019] 1 8226 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164847 0 0 N C N
0x0780000000BD0080 12 [000-00012] 1 6427 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164840 0 0 N C N
0x0780000000C37FE0 18 [000-00018] 1 7969 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164846 0 0 N C N
0x0780000000BA7FE0 11 [000-00011] 1 6170 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164839 0 0 N C N
0x0780000000C30080 17 [000-00017] 1 7712 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164845 0 0 N C N
0x0780000000BA0080 10 [000-00010] 1 5913 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164838 0 0 N C N
0x0780000000C17FE0 16 [000-00016] 1 7455 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164844 0 0 N C N
0x0780000000B77FE0 9 [000-00009] 1 5656 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164837 0 0 N C N
0x0780000000D00080 48 [000-00048] 1 8741 UOW-Executing 786 1 374 1 *LOCAL.taoewang.110720170409 1 2 N C N
0x0780000000C10080 15 [000-00015] 1 7198 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164843 0 0 N C N
0x0780000000B70080 8 [000-00008] 1 5399 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164836 0 0 N C N
0x0780000000BF0900 14 [000-00014] 1 6941 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164842 0 0 N C N
0x0780000000B00080 7 [000-00007] 1 1544 UOW-Waiting 0 0 0 0 *LOCAL.taoewang.110720164835 1 1 N C N
0x0780000000C67FE0 20 [000-00020] 1 8483 ConnectCompleted 0 0 0 0 *LOCAL.DB2.110720164848 0 0 N C N
....
(taoewang@db2debug) /home/taoewang $ db2pd -dynamic -db sample
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:24:32 -- Date 07/20/2011 13:13:07
Dynamic Cache:
Current Memory Used 398903
Total Heap Size 127139
Cache Overflow Flag 1
Number of References 222
Number of Statement Inserts 472
Number of Statement Deletes 469
Number of Variation Inserts 66
Number of Statements 2
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x0700000033FB03E0 182 1 0 0 2 2 select * from employee
0x0700000033FB0260 786 1 1 1 1 1 select count(*) from
employee, employee, employee, employee, employee
Dynamic SQL Environments:
Address AnchID StmtUID EnvID Iso QOpt Blk
0x070000003406E5E0 786 1 1 CS 5 B
Dynamic SQL Variations:
Address AnchID StmtUID EnvID VarID NumRef Typ Lockname Val Insert Time Sect Size
0x0700000033FB07A0 786 1 1 1 1 6 00000001000000010001624056 Y 2011-07-20-13.12.27.048420 15088