Filter
Top Products
© Copyright IBM Corp. 1999 201
Appendix C. DB2 PM Accounting Trace Report
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 1-1
GROUP: BOAG ACCOUNTING TRACE - LONG REQUESTED FROM: 02/12/99 15:06:03.00
MEMBER: NB22 TO: 02/12/99 15:43:47.00
SUBSYSTEM: NB22 ACTUAL FROM: 02/12/99 15:43:45.28
DB2 VERSION: V5
---- IDENTIFICATION --------------------------------------------------------------------------------------------------------------
ACCT TSTAMP: 02/12/99 15:43:45.28 PLANNAME: POCDRIVE WLM SCL: 'BLANK' CICS NET: N/A
BEGIN TIME : 02/12/99 15:06:04.28 PROD ID : N/P CICS LUN: N/A
END TIME : 02/12/99 15:43:45.28 PROD VER: N/P LUW NET: BOAG CICS INS: N/A
REQUESTER : USIBMT6BOAPLX CORRNAME: RBQ05A LUW LUN: T6E3BOA
MAINPACK : POCDRIVE CORRNMBR: 'BLANK' LUW INS: B1CBC859371E END USER: 'BLANK'
PRIMAUTH : HPQUSER CONNTYPE: TSO LUW SEQ: 1 TRANSACT: 'BLANK'
ORIGAUTH : HPQUSER CONNECT : BATCH WS NAME : 'BLANK'
MVS ACCOUNTING DATA : RBQ05A
RRSAF ACCOUNTING TOKEN: N/A
ELAPSED TIME DISTRIBUTION CLASS 2 TIME DISTRIBUTION
---------------------------------------------------------------- ----------------------------------------------------------------
APPL » CPU »==================> 37%
DB2 »=============================================> 90% NOTACC »==========================> 53%
SUSP »=====> 10% SUSP »=====> 10%
TIMES/EVENTS APPL (CLASS 1) DB2 (CLASS 2) IFI (CLASS 5) CLASS 3 SUSP. ELAPSED TIME EVENTS HIGHLIGHTS
------------ -------------- -------------- -------------- -------------- ------------ -------- --------------------------
ELAPSED TIME 37:41.001054 37:40.386069 N/P LOCK/LATCH 0.060799 2760 THREAD TYPE : ALLIED
CPU TIME 1:06:21.580844 1:06:21.549125 N/P SYNCHRON. I/O 56.770913 19559 TERM.CONDITION: NORMAL
TCB 14:02.087183 14:02.055513 N/P OTHER READ I/O 29:59.155952 143669 INVOKE REASON : DEALLOC
TCB-STPROC 0.000000 0.000000 N/A OTHER WRTE I/O 0.000000 0 COMMITS : 2
PAR.TASKS 52:19.493661 52:19.493612 N/A SER.TASK SWTCH 0.002627 2 ROLLBACK : 0
SUSPEND TIME N/A 30:55.990291 N/A ARC.LOG(QUIES) 0.000000 0 INCREM.BINDS : 0
TCB N/A 3:48.273531 N/A ARC.LOG READ 0.000000 0 UPDATE/COMMIT : 0.00
PAR.TASKS N/A 27:07.716760 N/A DRAIN LOCK 0.000000 0 SYNCH I/O AVG.: 0.002903
NOT ACCOUNT. N/A 19:50.057025 N/P CLAIM RELEASE 0.000000 0 PROGRAMS : 0
DB2 ENT/EXIT N/A 217 N/A PAGE LATCH 0.000000 0 PARALLELISM : CP
EN/EX-STPROC N/A 0 N/A STORED PROC. 0.000000 0
DCAPT.DESCR. N/A N/A N/P NOTIFY MSGS 0.000000 0
LOG EXTRACT. N/A N/A N/P GLOBAL CONT. 0.000000 0
TOTAL CLASS 3 30:55.990291 165990
SQL DML TOTAL SQL DCL TOTAL SQL DDL CREATE DROP ALTER LOCKING TOTAL DATA SHARING TOTAL
-------- -------- ---------- -------- ---------- ------ ------ ------ ------------ -------- ------------ --------
SELECT 0 LOCK TABLE 0 TABLE 0 0 0 TIMEOUTS 0 GLB CONT (%) 0
INSERT 0 GRANT 0 TEMP TABLE 0 N/A N/A DEADLOCKS 0 FLS CONT (%) 0
UPDATE 0 REVOKE 0 INDEX 0 0 0 ESCAL.(SHAR) 0 LOCK REQUEST 0
DELETE 0 SET SQLID 0 TABLESPACE 0 0 0 ESCAL.(EXCL) 0 UNLOCK REQST 0
SET H.VAR. 0 DATABASE 0 0 0 MAX.LCK HELD 25 CHANGE REQST 0
DESCRIBE 0 SET DEGREE 1 STOGROUP 0 0 0 LOCK REQUEST 103 LOCK - XES 18
DESC.TBL 0 SET RULES 0 SYNONYM 0 0 N/A UNLOCK REQST 18 UNLOCK-XES 1
PREPARE 1 CONNECT 1 0 VIEW 0 0 N/A QUERY REQST 0 CHANGE-XES 0
OPEN 1 CONNECT 2 1 ALIAS 0 0 N/A CHANGE REQST 1 SUSP - IRLM 0
FETCH 101 SET CONNEC 0 PACKAGE N/A 0 N/A OTHER REQST 0 SUSP - XES 0
CLOSE 1 RELEASE 0 LOCK SUSP. 0 SUSP - FALSE 0
CALL 0 TOTAL 0 0 0 LATCH SUSP. 0 INCOMP.LOCK 0
ASSOC LOC. 0 RENAME TBL 0 OTHER SUSP. 1 NOTIFY SENT 1
DML-ALL 104 ALLOC CUR. 0 COMMENT ON 0 TOTAL SUSP. 1
DCL-ALL 2 LABEL ON 0