202 Storage Management with DB2 for OS/390
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 1-2
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'
RID LIST TOTAL QUERY PARALLEL. TOTAL STORED PROC. TOTAL DRAIN/CLAIM TOTAL DATA CAPTURE TOTAL
--------------- -------- --------------- -------- ------------ -------- ------------ -------- ------------ --------
USED 0 MAXIMUM MEMBERS N/P CALL STMTS 0 DRAIN REQST 0 IFI CALLS N/P
FAIL-NO STORAGE 0 MAXIMUM DEGREE 5 PROC. ABENDS 0 DRAIN FAILED 0 REC.CAPTURED N/P
FAIL-LIMIT EXC. 0 GROUPS EXECUTED 1 CALL TIMEOUT 0 CLAIM REQST 88 LOG REC.READ N/P
RAN AS PLANNED 1 CALL REJECT 0 CLAIM FAILED 2 ROWS RETURN N/P
RAN REDUCED 0 RECORDS RET. N/P
ONE DB2 COOR=N 0 DATA DES.RET N/P
ONE DB2 ISOLAT 0 TABLES RET. N/P
SEQ - CURSOR 0 DESCRIBES N/P
SEQ - NO ESA 0
SEQ - NO BUF 0
SEQ - ENCL.SER 0
MEMB SKIPPED(%) 0
DISABLED BY RLF NO
SERVICE UNITS CLASS 1 CLASS 2 OPTIMIZATION TOTAL
------------- -------------- -------------- ------------------ --------
CPU 7600249 7600188 REOPTIMIZATION 0
TCB 1607420 1607359 PREP_STMT_MATCH 0
TCB-STPROC 0 0 PREP_STMT_NO_MATCH 0
PAR.TASKS 5992829 5992829 IMPLICIT_PREPARES 0
PREP_FROM_CACHE 0
CACHE_LIMIT_EXCEED 0
PREP_STMT_PURGED 0
---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P TABLE ID: N/P SERV.UNITS: N/P CPU SECONDS: 0.000000 MAX CPU SEC: N/P
BP0 TOTAL BP2 TOTAL BP4 TOTAL
--------------------- -------- --------------------- -------- --------------------- --------
BPOOL HIT RATIO (%) 100 BPOOL HIT RATIO (%) 0 BPOOL HIT RATIO (%) 50
GETPAGES 107 GETPAGES 5835348 GETPAGES 300350
BUFFER UPDATES 0 BUFFER UPDATES 0 BUFFER UPDATES 0
SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0 SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 0 SYNCHRONOUS READ 18796 SYNCHRONOUS READ 754
SEQ. PREFETCH REQS 0 SEQ. PREFETCH REQS 163939 SEQ. PREFETCH REQS 702
LIST PREFETCH REQS 0 LIST PREFETCH REQS 0 LIST PREFETCH REQS 0
DYN. PREFETCH REQS 0 DYN. PREFETCH REQS 22121 DYN. PREFETCH REQS 3944
PAGES READ ASYNCHR. 0 PAGES READ ASYNCHR. 5795249 PAGES READ ASYNCHR. 148634
HPOOL WRITES 0 HPOOL WRITES 0 HPOOL WRITES 0
HPOOL WRITES-FAILED 0 HPOOL WRITES-FAILED 0 HPOOL WRITES-FAILED 0
PAGES READ ASYN-HPOOL 0 PAGES READ ASYN-HPOOL 0 PAGES READ ASYN-HPOOL 0
HPOOL READS 0 HPOOL READS 0 HPOOL READS 0
HPOOL READS-FAILED 0 HPOOL READS-FAILED 0 HPOOL READS-FAILED 0