IBM 5695-DF1 ユーザーズマニュアル
© 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