DB2 记帐报告
DB2 性能监视器 (DB2PM) 程序产品提供从 DB2 记帐记录获取的记帐报告。
图 1 和 图 2 显示了 CICS 事务访问 DB2 资源的长记帐报告和短记帐报告的示例。
LOCATION: DSN710P2 DB2 PERFORMANCE MONITOR (V7) PAGE: 1-1
GROUP: DSN710P2 ACCOUNTING REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: DF2D TO: NOT SPECIFIED
SUBSYSTEM: DF2D ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 11/05/01 10:42:31.25
DB2 VERSION: V7 SCOPE: MEMBER TO: 11/05/01 10:51:03.70
PRIMAUTH: JTILLI1 PLANNAME: DSNJDBC
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL |=================================================> 98% CPU |=> 3%
DB2 | NOTACC |=> 2%
SUSP |=> 2% SUSP |===============================================> 95%
AVERAGE APPL(CL.1) DB2 (CL.2) IFI (CL.5) CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT HIGHLIGHTS
------------ ---------- ---------- ---------- -------------------- ------------ -------- --------------------------
ELAPSED TIME 25.435644 0.504442 N/P LOCK/LATCH(DB2+IRLM) 0.000000 0.00 #OCCURRENCES : 2
NONNESTED 25.435644 0.504442 N/A SYNCHRON. I/O 0.085908 6.50 #ALLIEDS : 2
STORED PROC 0.000000 0.000000 N/A DATABASE I/O 0.085908 6.50 #ALLIEDS DISTRIB: 0
UDF 0.000000 0.000000 N/A LOG WRITE I/O 0.000000 0.00 #DBATS : 0
TRIGGER 0.000000 0.000000 N/A OTHER READ I/O 0.042337 1.00 #DBATS DISTRIB. : 0
OTHER WRTE I/O 0.000000 0.00 #NO PROGRAM DATA: 2
CPU TIME 0.016663 0.015404 N/P SER.TASK SWTCH 0.352902 4.00 #NORMAL TERMINAT: 2
AGENT 0.016663 0.015404 N/A UPDATE COMMIT 0.000000 0.00 #ABNORMAL TERMIN: 0
NONNESTED 0.016663 0.015404 N/P OPEN/CLOSE 0.206822 1.50 #CP/X PARALLEL. : 0
STORED PRC 0.000000 0.000000 N/A SYSLGRNG REC 0.024259 1.00 #IO PARALLELISM : 0
UDF 0.000000 0.000000 N/A EXT/DEL/DEF 0.121821 1.50 #INCREMENT. BIND: 0
TRIGGER 0.000000 0.000000 N/A OTHER SERVICE 0.000000 0.00 #COMMITS : 3
PAR.TASKS 0.000000 0.000000 N/A ARC.LOG(QUIES) 0.000000 0.00 #ROLLBACKS : 0
ARC.LOG READ 0.000000 0.00 #SVPT REQUESTS : 0
SUSPEND TIME N/A 0.481147 N/A STOR.PRC SCHED 0.000000 0.00 #SVPT RELEASE : 0
AGENT N/A 0.481147 N/A UDF SCHEDULE 0.000000 0.00 #SVPT ROLLBACK : 0
PAR.TASKS N/A 0.000000 N/A DRAIN LOCK 0.000000 0.00 MAX SQL CASC LVL: 0
CLAIM RELEASE 0.000000 0.00 UPDATE/COMMIT : 0.00
NOT ACCOUNT. N/A 0.007891 N/A PAGE LATCH 0.000000 0.00 SYNCH I/O AVG. : 0.013217
DB2 ENT/EXIT N/A 35.00 N/A NOTIFY MSGS 0.000000 0.00
EN/EX-STPROC N/A 0.00 N/A GLOBAL CONT. 0.000000 0.00
EN/EX-UDF N/A 0.00 N/A FORCE-AT-COMMIT 0.000000 0.00
DCAPT.DESCR. N/A N/A N/P ASYNCH IXL REQUESTS 0.000000 0.00
LOG EXTRACT. N/A N/A N/P TOTAL CLASS 3 0.481147 11.50
LOCATION: DSN710P2 DB2 PERFORMANCE MONITOR (V7) PAGE: 1-1
GROUP: DSN710P2 ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: DF2D TO: NOT SPECIFIED
SUBSYSTEM: DF2D ORDER: PLANNAME INTERVAL FROM: 11/05/01 10:42:31.25
DB2 VERSION: V7 SCOPE: MEMBER TO: 11/05/01 10:50:14.53
#OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
--------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
DSNJDBC 1 0 0.00 0.00 0.00 0.00 1.706541 1.003194 249.00 13.00 0.00
0 2 4.00 2.00 2.00 2.00 0.027471 0.025984 0.00 5.00 0
TESTP05 2 0 0.00 0.50 0.00 0.00 33.283119 0.215656 7.00 0.00 0.00
0 2 1.50 0.50 0.00 0.00 0.001908 0.001389 1.00 0.00 0
*** GRAND TOTAL ***
3 0 0.00 0.33 0.00 0.00 22.757593 0.478169 87.67 4.33 0.00
0 4 2.33 1.00 0.67 0.67 0.010429 0.009587 0.67 1.67 0