Bootstrap Data Set Activity

This section shows an example of how to produce the Bootstrap Data Set (BSDS) report and explains fields shown in the report.

The following command produces the archive log/BSDS report in I/O Activity—Bootstrap Data Set Activity.

 
IOACTIVITY
     REPORT
        LEVEL (ARCLOG)

I/O Activity—Bootstrap Data Set Activity

BOOTSTRAP DATA SET ACTIVITY --------------------------------------------------------------------------------------------------------
 
DATASET
 INTERVAL                    WAIT TYPE         TOTAL       AET
---------------------------  -------------- -------- ---------
BSDS0001
 01/29 14:00 - 01/29 14:05
                             READ                  2  0.001947
                             WRITE                 2  0.001098
                             READ AND WRITE        4  0.001523

 01/29 14:05 - 01/29 14:10
                             READ                  8  0.001644
                             WRITE                 8  0.001216
                             READ AND WRITE       16  0.001430

 01/29 14:20 - 01/29 14:25
                             READ                 94  0.001747
                             WRITE                94  0.001050
                             READ AND WRITE      188  0.001398

 01/29 14:25 - 01/29 14:30
                             READ                700  0.001248
                             WRITE               215  0.001030
                             READ AND WRITE      915  0.001197

 01/29 14:30 - 01/29 14:35
                             READ                460  0.001233
                             WRITE               212  0.000992
                             READ AND WRITE      672  0.001157

 ** TOTAL **
 BSDS0001
                             READ               1264  0.001283
                             WRITE               531  0.001021
                             READ AND WRITE     1795  0.001206

 BSDS0002
  01/29 14:00 - 01/29 14:05
                             READ                  2  0.001660
                             WRITE                 2  0.001049
                             READ AND WRITE        4  0.001354

*** GRAND TOTAL ***
                             READ               1795  0.001392
                             WRITE              1062  0.001040
                             READ AND WRITE     2857  0.001261

I/O ACTIVITY REPORT COMPLETE

Field description

The following field descriptions are for the bootstrap data set activity section of the archive log/BSDS report.
OMEGAMON for DB2® Performance Expert Identifiers
The bootstrap data set activity report presents data summarized by OMEGAMON for Db2 Performance Expert identifiers. The report can be ordered by up to three OMEGAMON for Db2 Performance Expert identifiers. The identifiers used to sort the report are printed in the leftmost column. They are printed whenever they change. The second and third identifiers are indented to appear under the relevant column subheading.
Note:
  1. Blank or null OMEGAMON for Db2 Performance Expert identifiers are denoted by the word 'BLANK'.
  2. DATASET is the most significant identifier. It is the 8-byte ID that identifies the BSDS data set where the reported activity occurs. It can have either of the following values:
    • BSDS0001
    • BSDS0002
WAIT TYPE
 
READ
The total number of BSDS reads. and the average elapsed time per BSDS read.
WRITE
The total number of BSDS writes and the average elapsed time per BSDS write.
READ AND WRITE
The total number of BSDS reads and writes and the average elapsed time per BSDS read and write.
SUBTOTAL
When a report is ordered by three identifiers and there is more than one third-level identifier reported under it, a subtotal is printed each time the second-level identifier changes.
TOTAL
When a report is ordered by two or three identifiers and there is more than one second-level identifier reported under it, a total is printed each time the first-level identifier changes.
GRAND TOTAL
A grand total is printed at the end of each location if there is more than one first-level identifier reported.