Filter
Top Products
118 Storage Management with DB2 for OS/390
needs values from the statistics report shown in Figure 41: the NOWAIT counter
C, and the number of control intervals created in the active log, counter D.Use
the following formula:
avgsizeoflogrecordinbytes=
D * 4096 / C
Using this value to estimate logging needs, plus considering the available device
sizes, the DB2 system administrator can update the output of the installation
CLIST to modify the calculated values for active log data set sizes.
Figure 41. Log Statistics in a Sample DB2 PM Statistics Report
LOG ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
READS SATISFIED-OUTPUT BUFF 15756.00 F 11.21 2.82 0.07
READS SATISFIED-OUTP.BUF(%) 100.00
READS SATISFIED-ACTIVE LOG 0.00 G 0.00 0.00 0.00
READS SATISFIED-ACTV.LOG(%) 0.00
READS SATISFIED-ARCHIVE LOG 0.00 A 0.00 0.00 0.00
READS SATISFIED-ARCH.LOG(%) 0.00
TAPE VOLUME CONTENTION WAIT 0.00 0.00 0.00 0.00
WRITE-NOWAIT C 2019.6K 1437.45 361.15 8.70
WRITE OUTPUT LOG BUFFERS E 250.3K 178.17 44.76 1.08
BSDS ACCESS REQUESTS 2041.00 1.45 0.36 0.01
UNAVAILABLE OUTPUT LOG BUFF B 0.00 0.00 0.00 0.00
CONTR.INTERV.CREATED-ACTIVE 59442.00 D 42.31 10.63 0.26
ARCHIVE LOG READ ALLOCATION 0.00 0.00 0.00 0.00
ARCHIVE LOG WRITE ALLOCAT. 2.00 0.00 0.00 0.00
CONTR.INTERV.OFFLOADED-ARCH 65023.00 46.28 11.63 0.28
READ DELAYED-UNAVAIL.RESOUR 0.00 0.00 0.00 0.00
LOOK-AHEAD MOUNT ATTEMPTED 0.00 0.00 0.00 0.00
LOOK-AHEAD MOUNT SUCCESSFUL 0.00 0.00 0.00 0.00