2种办法快速找到占用临时表空间的app

字数 8144阅读 2736评论 11赞 0

2种办法快速找到占用临时表空间的app
1) db2pd -tcbstat -d xxx >tcbstat.log
search "TEMP", schemaname is the app handle.
查找 TEMP 相应的table schema Name 就是我们的app handle .
TCB Table Stats:
Address            TableName          SchemaNm Scans      UDI        RTSUDI               PgReorgs   NoChgUpdts Reads      FscrUpdates Inserts    Updates    Deletes    OvFlRead
s OvFlCrtes RowsComp   RowsUncomp CCLogReads StoreBytes BytesSaved
0x070000006F34F858 RUNINFO            EOD      15         2          2                    1          0          116        42          97         0          101        0
   0          0          0          0          -          -
0x070000007374D358 TEMP (00004,00003) <58558>< 1          236524     236524               0          0          74750033   0           236524     0          0          0
   0          0          0          0          16625870   0
0x070000006B3EA358 HMON_ATM_INFO      SYSTOOLS 739        13720      13720                2          109225     592613     3           1          154384     0          62585
   1          0          0          0          -          -
0x07000000674DF1D8 PBTUSAG            EOD      3          198        198                  0          0          3080634    18          1138       0          0          0
   0          0          0          0          -          -
0x070000006A042958 SECTMVPL           EOD      91         0          0                    18         0          40578      78          2363       0          2364       0
   0          0          0          0          -          -

2) snapshot

0) Turn On Session level monitor. db2 update monitor switches using BUFFERPOOL on lock on sort on statement on table on timestamp on uow on
1) Get the snapshot for tables.       db2 get snapshot for tables on $DB >tab.snap.log
2) vi tab.snap.log , search "TEMP", table schema is the Application handle

eg.
Table Schema        = <58558><BRIOADM >
Table Name          = TEMP (00004,00003)
Table Type          = Temporary
Data Object Pages   = 4524
Rows Read           = 1084585
Rows Written        = 0
Overflows           = 0
Page Reorgs         = 0

3) db2 get snapshot for applications on $DB >app.snap.log
Vi app.snap.log Search App Handle "58558", you will got the executing sql.

eg.
Application handle                         = 58558
Application status                         = UOW Executing
Status change time                         = 09/11/2012 06:12:05.138363
Application code page                      = 1208
Application country/region code            = 0
DUOW correlation token                     = 9.57.167.17.43830.120911061206
Application name                           = db2jcc_application
Application ID                             = 9.57.167.17.43830.120911061206
Buffer pool temporary data logical reads   = 2763644
Dynamic SQL statement text:
delete from eod.ctrl_rsmyrpts where rpt_type_cd=12 and (cwa_id,RPT_ACCESS_ID) not in (select cwa_id,RPT_ACCESS_ID from eod.ctusrrpt)

都是一些简单的英文单词. 应该都看的懂哈.

临时表空间 handle

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！