SQL 活動報告的範例
本主題顯示「SQL 活動」報告的範例。
依陳述式類型彙總 的 依陳述式號碼彙總 顯示「SQL 活動」報告的摘錄,全部彙總。 每一個可能的摘要層次的報告版面都類似。 依預設,訂單是主要授權 ID 內的計劃名稱。
依陳述式號碼彙總
此摘要層次呈現屬於所選 OMEGAMON for DB2® Performance Expert ID 組合的每個陳述式號碼總計。 事件由套件名稱來限定。
依預設,套件名稱按字母順序排序,套件內的陳述式號碼按遞增順序按數字順序排序。
附註: 並非每個陳述式都可以依陳述式號碼彙總。 例如, DDL 沒有陳述式號碼。 從最接近的摘要層級中選擇事件名稱,在此範例中是陳述式類型 LOCK。
下列指令會產生依陳述式號碼彙總的「SQL 活動」報告:
⋮
SQLACTIVITY
REPORT
SUMMARIZEBY (STMTNO)
⋮
這是依陳述式號碼彙總的「SQL 活動」報告範例。
LOCATION: SYS1DSN2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: DSN2 SQL ACTIVITY - REPORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SE11 TO: NOT SPECIFIED
SUBSYSTEM: SE11 ORDER: PRIMAUTH-PLANNAME ACTUAL FROM: 01/30/15 06:55:37.58
DB2 VERSION: V10 TO: 01/30/15 07:05:37.61
SUMMARIZED BY STMTNO
PRIMAUTH: WRL PLANNAME: PARALCPU THREAD TOTAL: 11 START AET: 0.053771 STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- -----------------------------------------------------------------------------
PACKAGE SYS1DSN2.PARAL.PARALC01.X'158A622D10FD8B50'
DB2OMPETEST
ACQUIRE(USE) REOPT(N) RELEASE(COMMIT) ISO(CS) DYNAMICRULES(RUN)
PREPARE(NODEFER) KEEPDYNAMIC(NO) PROTOCOL(DRDA) OPTHINT(N/P)
IMMEDWRITE(PH1)
# 120 1 7:10.524819 47.134431 OPEN CURSOR: CRS1 ISO(CS) REOPT(NO) KEEP UPD LOCKS: NO
7:10.524819 47.134431
# 137 12888 36.562407 8.188774 FETCH CURSOR: CRS1
0.002837 0.000635
依游標彙總
此摘要層次顯示屬於所選 OMEGAMON for Db2 Performance Expert ID (依套件名稱限定) 之每一個游標名稱的總計。 依預設,套件名稱及每一個套件內的事件會按字母順序排序。
這是依游標彙總之「SQL 活動」報告的範例。
LOCATION: STLEC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P SQL ACTIVITY - REPORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: VA1A ORDER: ENDUSER-PRIMAUTH-ORIGAUTH ACTUAL FROM: 01/22/15 21:00:05.88
DB2 VERSION: V10 TO: 01/22/15 21:00:37.11
SUMMARIZED BY CURSOR
ENDUSER : SYSADM PRIMAUTH: SYSADM ORIGAUTH: SYSADM
THREAD TOTAL: 1 START AET: N/P STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
----------- ------------ ----------- --------- ----------------------------------------------------------------------------
PACKAGE STLEC1.BARTCOB.PGSPNL1.X'1959EE260805DDDE'
TESTE-CURSOR SORTS : 0
GET PAGES : 92 PARALLEL GRP CREATES: 0
SYNC BUFF READS : 0 BUFFER WRITES : 0
INDEX SCANS : 91 TABLESPACE SCANS : 0
ROWS EXAMINED : 0 ROWS PROCESSED : 5203
RID-LIMIT EXC. : 0 RID-NO STORAGE : 0
IN-DB2 ELAPSED : 0.028019 IN-DB2 CPU : 0.018367
GLOBAL LOCK : 0.000000 DRAIN LOCK : 0.000000
LOCK/LATCH : 0.000000 LATCH : 0.000000
PAGE LATCH : 0.000000 CLAIM COUNT : 0.000000
SYNCHRON. I/O : 0.000000 UNIT SWITCH : 0.000000
READ-OTH. THREAD: 0.000000 WRITE-OTH. THREAD : 0.000000
LOG WRITER : 0.000000
1 0.000842 0.000058 STMTTYPE COUNT AET/OCCUR TCB/OCCUR
0.000842 0.000058 CLOSE 1 0.000014 0.000011
OPEN 1 0.000828 0.000047
SQL ACTIVITY REPORT COMPLETE
依程式彙總
此摘要層次呈現屬於所選 OMEGAMON for Db2 Performance Expert ID 組合之所有程式的總計。 套件名稱內嵌在摘要詳細資料中。這是依程式彙總之「SQL 活動」報告的範例。
LOCATION: SYS1DSN2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: DSN2 SQL ACTIVITY - REPORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SE11 TO: NOT SPECIFIED
SUBSYSTEM: SE11 ORDER: PRIMAUTH-PLANNAME ACTUAL FROM: 01/30/15 06:55:37.58
DB2 VERSION: V10 TO: 01/30/15 07:05:37.61
SUMMARIZED BY PROGRAM
PRIMAUTH: WRL PLANNAME: PARALCPU THREAD TOTAL: 11 START AET: 0.053771 STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- -----------------------------------------------------------------------------
PARALC01 1 7:47.087226 55.323204 PACKAGE: SYS1DSN2.PARAL.PARALC01.X'158A622D10FD8B50'
7:47.087226 55.323204 DB2OMPETEST
ACQUIRE(USE) REOPT(N) RELEASE(COMMIT) ISO(CS) DYNAMICRULES(RUN)
PREPARE(NODEFER) KEEPDYNAMIC(NO) PROTOCOL(DRDA) OPTHINT(N/P)
IMMEDWRITE(NO)
STMTTYPE COUNT AET/OCCUR TCB/OCCUR
FETCH 12888 0.002837 0.000635
OPEN 1 7:10.524819 47.134431
N/P 1 6.823537 0.025761 STMTTYPE COUNT AET/OCCUR TCB/OCCUR
6.823537 0.025761 CREATE 1 6.823537 0.025761
依陳述式 ID 彙總
此摘要層次依 ID 將陳述式分組。下列指令會產生依 ID 彙總的「SQL 活動」報告:
⋮
SQLACTIVITY
REPORT
SUMMARIZEBY (STMTID)
⋮
這是依 ID 彙總之「SQL 活動」報告的範例。
LOCATION: SYSDBZE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: DBZE SQL ACTIVITY - REPORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZE1 TO: NOT SPECIFIED
SUBSYSTEM: SZE1 ORDER: PRIMAUTH-PLANNAME ACTUAL FROM: 05/01/15 07:57:15.39
DB2 VERSION: V10 TO: 05/01/15 07:59:12.18
SUMMARIZED BY STMTID
PRIMAUTH: BBE PLANNAME: DISTSERV THREAD TOTAL: 2 START AET: N/P STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- -----------------------------------------------------------------------------
PACKAGE PMODA11GANZLANGE.DSNADM.DSNADMCD.X'0E4D2F6F07F6F0F7'
UK67607
ACQUIRE(USE) REOPT(N) RELEASE(COMMIT) ISO(CS) DYNAMICRULES(RUN)
PREPARE(NODEFER) KEEPDYNAMIC(NO) PROTOCOL(DRDA) OPTHINT(N/P)
304747 2 0.000012 CLOSE
0.000006
STMT ID : 304747 STMT TYPE : STATIC
SORTS : 2
GET PAGES : 4 PARALLEL GRP CREATES: 0
SYNC BUFF READS : 0 BUFFER WRITES : 0
INDEX SCANS : 0 TABLESPACE SCANS : 4
ROWS EXAMINED : 0 ROWS PROCESSED : 78
RID-LIMIT EXC. : 0 RID-NO STORAGE : 0
IN-DB2 ELAPSED : 0.000299 IN-DB2 CPU : 0.000296
GLOBAL LOCK : 0.000000 DRAIN LOCK : 0.000000
LOCK/LATCH : 0.000000 LATCH : 0.000000
PAGE LATCH : 0.000000 CLAIM COUNT : 0.000000
SYNCHRON. I/O : 0.000000 UNIT SWITCH : 0.000000
READ-OTH. THREAD: 0.000000 WRITE-OTH. THREAD : 0.000000
LOG WRITER : 0.000000
304764 7 0.000133 DELETE
0.000019
STMT ID : 304764 STMT TYPE : STATIC
SORTS : 0
GET PAGES : 0 PARALLEL GRP CREATES: 0
SYNC BUFF READS : 0 BUFFER WRITES : 0
INDEX SCANS : 0 TABLESPACE SCANS : 0
ROWS EXAMINED : 0 ROWS PROCESSED : 0
RID-LIMIT EXC. : 0 RID-NO STORAGE : 0
IN-DB2 ELAPSED : 0.000103 IN-DB2 CPU : 0.000100
GLOBAL LOCK : 0.000000 DRAIN LOCK : 0.000000
LOCK/LATCH : 0.000000 LATCH : 0.000000
PAGE LATCH : 0.000000 CLAIM COUNT : 0.000000
SYNCHRON. I/O : 0.000000 UNIT SWITCH : 0.000000
READ-OTH. THREAD: 0.000000 WRITE-OTH. THREAD : 0.000000
LOG WRITER : 0.000000
SQL ACTIVITY REPORT COMPLETE
依陳述式類型彙總
此摘要層次顯示屬於所選 OMEGAMON for Db2 Performance Expert ID (依套件名稱限定) 之每一個游標名稱的總計。 依預設,套件名稱及每一個套件內的事件會按字母順序排序。這是依陳述式類型彙總之「SQL 活動」報告的範例。
LOCATION: SYS1DSN2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: DSN2 SQL ACTIVITY - REPORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SE11 TO: NOT SPECIFIED
SUBSYSTEM: SE11 ORDER: PRIMAUTH-PLANNAME ACTUAL FROM: 01/30/15 06:55:37.58
DB2 VERSION: V10 TO: 01/30/15 07:05:37.61
SUMMARIZED BY STMTTYPE
PRIMAUTH: WRL PLANNAME: PARALCPU THREAD TOTAL: 11 START AET: 0.053771 STOP AET: N/P
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- -----------------------------------------------------------------------------
FETCH 12888 36.562407 8.188774
0.002837 0.000635
OPEN 1 7:10.524819 47.134431
7:10.524819 47.134431
依執行緒彙總
此摘要層次呈現此 OMEGAMON for Db2 Performance Expert ID 組合所執行之每一個陳述式類型的總計。 依預設,事件會按字母順序排序。 在此層次沒有進一步的資格。
這是依執行緒彙總之「SQL 活動」報告的範例。
LOCATION: OMPDB2L OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: DB2L SQL ACTIVITY - TRACE REQUESTED FROM: NOT SPECIFIED
MEMBER: SDL2 TO: NOT SPECIFIED
SUBSYSTEM: SDL2 ACTUAL FROM: 01/30/15 11:36:56.45
DB2 VERSION: V10
SUMMARIZED BY THREAD
PRIMAUTH: N/P CONNECT : N/P CORRNAME: N/P CONNTYPE: 'BLANK'
ORIGAUTH: N/P PLANNAME: N/P CORRNMBR: THRDTYPE: ALLIED
ENDUSER : N/P WSNAME : N/P TRANSACT: N/P
TRACE # 1.1 DB2 LUWID: DEIBMIPS.IPUAWDL2.X'C4B7EAC08924' ACE ADDRESS: X'1AC558F8'
START TIME: 01/30/15 11:36:56.45 START ELAPSED: N/A START REASON: IN PROGRESS
STOP TIME : 01/30/15 11:37:03.28 STOP ELAPSED : N/A STOP REASON : END OF FILE
EVENT COUNT TOT.ELAPS TOTAL TCB DETAIL
AET/EVENT TCB/EVENT
-------------------- ----------- ----------- --------- ----------------------------------------------------------------------
X'C4B7EAC08924' 1 6.823537 0.025761 STMTTYPE COUNT AET/OCCUR TCB/OCCUR
6.823537 0.025761 CREATE 1 6.823537 0.025761