IBM 5695-DF1, 5655-DB2 manual BP4 Read Operations Quantity Minute

Models: 5695-DF1 5655-DB2

1 274
Download 274 pages 18.18 Kb
Page 239
Image 239

1

LOCATION: USIBMT6BOAPLX

 

 

DB2 PERFORMANCE MONITOR (V5)

 

 

 

PAGE: 2-13

 

 

 

GROUP: BOAG

 

 

STATISTICS REPORT - LONG

 

 

REQUESTED FROM: 02/12/99 15:06:03.00

 

MEMBER: NB22

 

 

 

 

 

 

 

 

TO: 02/12/99 15:44:05.00

SUBSYSTEM: NB22

 

 

 

 

 

 

 

INTERVAL FROM: 02/12/99 15:09:49.64

DB2 VERSION: V5

 

 

 

SCOPE: MEMBER

 

 

 

 

TO: 02/12/99 15:43:45.80

---- HIGHLIGHTS

----------------------------------------------------------------------------------------------------

 

 

 

 

 

 

 

 

 

 

INTERVAL START

: 02/12/99 15:09:49.64

SAMPLING START: 02/12/99 15:09:49.64

TOTAL THREADS

:

0.00

 

 

INTERVAL END

: 02/12/99 15:43:45.80

SAMPLING END : 02/12/99 15:43:45.80

TOTAL COMMITS

:

2.00

 

 

INTERVAL ELAPSED:

33:56.157107

OUTAGE ELAPSED:

 

0.000000

DATA SHARING MEMBER:

N/A

 

 

BP4

GENERAL

 

QUANTITY

/MINUTE

/THREAD

/COMMIT

BP4

READ OPERATIONS

QUANTITY

/MINUTE

/THREAD

/COMMIT

---------------------------

 

--------

-------

-------

-------

---------------------------

--------

-------

-------

-------

CURRENT ACTIVE BUFFERS

1.77

N/A

N/A

N/A

BPOOL HIT RATIO (%)

55.12

 

 

 

UNAVAIL.BUFFER-VPOOL FULL

0.00

0.00

N/C

0.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

GETPAGE REQUEST

221.8K

6534.43

N/C

110.9K

NUMBER OF DATASET OPENS

0.00

0.00

N/C

0.00

GETPAGE REQUEST-SEQUENTIAL

18427.00

542.99

N/C

9213.50

 

 

 

 

 

 

 

GETPAGE REQUEST-RANDOM

203.3K

5991.43

N/C

101.7K

BUFFERS ALLOCATED - VPOOL

50000.00

1473.36

N/C

25.0K

 

 

 

 

 

 

 

BUFFERS ALLOCATED - HPOOL

100.0K

2946.73

N/C

50.0K

SYNCHRONOUS READS

613.00

18.06

N/C

306.50

HPOOL BUFFERS BACKED

51417.53

1515.13

N/C

25.7K

SYNCHRON. READS-SEQUENTIAL

64.00

1.89

N/C

32.00

 

 

 

 

 

 

 

SYNCHRON. READS-RANDOM

549.00

16.18

N/C

274.50

DFHSM MIGRATED DATASET

0.00

0.00

N/C

0.00

 

 

 

 

 

 

 

DFHSM RECALL TIMEOUTS

0.00

0.00

N/C

0.00

GETPAGE PER SYN.READ-RANDOM

370.36

 

 

 

HPOOL EXPANS. OR CONTRACT.

0.00

0.00

N/C

0.00

SEQUENTIAL PREFETCH REQUEST

577.00

17.00

N/C

288.50

VPOOL EXPANS. OR CONTRACT.

0.00

0.00

N/C

0.00

SEQUENTIAL PREFETCH READS

577.00

17.00

N/C

288.50

VPOOL OR HPOOL EXP.FAILURE

0.00

0.00

N/C

0.00

PAGES READ VIA SEQ.PREFETCH

18440.00

543.38

N/C

9220.00

 

 

 

 

 

 

 

S.PRF.PAGES READ/S.PRF.READ

31.96

 

 

 

CONCUR.PREF.I/O STREAMS-HWM

0.00

N/A

N/A

N/A

PREF.I/O STREAMS REDUCTION

0.00

0.00

N/C

0.00

PARALLEL QUERY REQUESTS

0.00

0.00

N/C

0.00

PARALL.QUERY REQ.REDUCTION

0.00

0.00

N/C

0.00

PREF.QUANT.REDUCED TO 1/2

0.00

0.00

N/C

0.00

PREF.QUANT.REDUCED TO 1/4

0.00

0.00

N/C

0.00

LIST

PREFETCH

REQUESTS

0.00

0.00

N/C

0.00

LIST

PREFETCH

READS

0.00

0.00

N/C

0.00

PAGES READ VIA LIST PREFTCH

0.00

0.00

N/C

0.00

L.PRF.PAGES READ/L.PRF.READ

N/C

 

 

 

DYNAMIC PREFETCH

REQUESTED

2515.00

74.11

N/C

1257.50

DYNAMIC PREFETCH

READS

2515.00

74.11

N/C

1257.50

PAGES READ VIA DYN.PREFETCH

80470.00

2371.23

N/C

40.2K

D.PRF.PAGES READ/D.PRF.READ

32.00

 

 

 

PREF.DISABLED-NO

BUFFER

0.00

0.00

N/C

0.00

PREF.DISABLED-NO

READ ENG

0.00

0.00

N/C

0.00

SYNC.HPOOL READ

 

0.00

0.00

N/C

0.00

ASYNC.HPOOL READ

 

0.00

0.00

N/C

0.00

HPOOL READ FAILED

 

0.00

0.00

N/C

0.00

ASYN.DA.MOVER HPOOL READ-S

0.00

0.00

N/C

0.00

ASYN.DA.MOVER HPOOL READ-F

0.00

0.00

N/C

0.00

PAGE-INS REQUIRED FOR READ

59.00

1.74

N/C

29.50

DB2 PM Statistics Report 217

Page 239
Image 239
IBM 5695-DF1, 5655-DB2 manual BP4 Read Operations Quantity Minute