Archive Log Activity
This section shows an example of how to produce the Archive Log/BSDS report and explains fields and columns shown in the report.
The following command produces the Archive Log/BSDS report in I/O Activity—Archive Log Activity Report.
IOACTIVITY
REPORT
LEVEL (ARCLOG)
I/O Activity—Archive Log Activity Report
This is an example of an archive log/BSDS report.
LOCATION: LOCATION1 IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-1 GROUP: GROUP1 I/O ACTIVITY REPORT - ARCLOG REQUESTED FROM: NOT SPECIFIED MEMBER: DB1A TO: NOT SPECIFIED SUBSYSTEM: DB1A ORDER: DATASET-INTERVAL INTERVAL FROM: 01/30/15 14:00:00.00 DB2 VERSION: V10 TO: 01/30/15 14:35:00.00 ARCHIVE LOG ACTIVITY --------------------------------------------------------------------------------------------------------------- DATASET INTERVAL WAIT TYPE TOTAL AET OTHER WAITS TOTAL AET --------------------------- -------------- -------- --------- -------------------------- -------- --------- 00111583 01/30 14:25 - 01/30 14:30 READ FROM DASD 0 N/C ALLOCATE 0 N/C READ FROM TAPE 0 N/C DEALLOCATE 0 N/C OFFLOAD 1 71.230139 OPEN 0 N/C OTHER 0 N/C CLOSE 0 N/C HSM RECALL 0 N/C BLOCKS/OFFLOAD 26999.00 CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C 00111584 01/30 14:30 - 01/30 14:35 READ FROM DASD 0 N/C ALLOCATE 0 N/C READ FROM TAPE 0 N/C DEALLOCATE 0 N/C OFFLOAD 1 67.210716 OPEN 0 N/C OTHER 0 N/C CLOSE 0 N/C HSM RECALL 0 N/C BLOCKS/OFFLOAD 26999.00 CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C 00111585 01/30 14:30 - 01/30 14:35 READ FROM DASD 0 N/C ALLOCATE 0 N/C READ FROM TAPE 0 N/C DEALLOCATE 0 N/C OFFLOAD 1 64.683949 OPEN 0 N/C OTHER 0 N/C CLOSE 0 N/C HSM RECALL 0 N/C BLOCKS/OFFLOAD 26999.00 CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C
LOCATION: LOCATION1 IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-2 GROUP: GROUP1 I/O ACTIVITY REPORT - ARCLOG REQUESTED FROM: NOT SPECIFIED MEMBER: DB1A TO: NOT SPECIFIED SUBSYSTEM: DB1A ORDER: DATASET-INTERVAL INTERVAL FROM: 01/30/15 14:00:00.00 DB2 VERSION: V10 TO: 01/30/15 14:35:00.00 ARCHIVE LOG ACTIVITY --------------------------------------------------------------------------------------------------------------- DATASET INTERVAL WAIT TYPE TOTAL AET OTHER WAITS TOTAL AET --------------------------- -------------- -------- --------- -------------------------- -------- --------- 10111583 01/30 14:25 - 01/30 14:30 READ FROM DASD 0 N/C ALLOCATE 2 0.119761 READ FROM TAPE 0 N/C DEALLOCATE 2 0.000664 OFFLOAD 0 N/C OPEN 2 0.005564 OTHER 8 0.038971 CLOSE 2 0.029896 HSM RECALL 0 N/C BLOCKS/OFFLOAD N/C CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C 10111584 01/30 14:25 - 01/30 14:30 READ FROM DASD 0 N/C ALLOCATE 2 0.108854 READ FROM TAPE 0 N/C DEALLOCATE 0 N/C OFFLOAD 0 N/C OPEN 2 0.006097 OTHER 5 0.049937 CLOSE 1 0.019781 HSM RECALL 0 N/C BLOCKS/OFFLOAD N/C CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C 01/30 14:30 - 01/30 14:35 READ FROM DASD 0 N/C ALLOCATE 0 N/C READ FROM TAPE 0 N/C DEALLOCATE 2 0.000614 OFFLOAD 0 N/C OPEN 0 N/C OTHER 3 0.014140 CLOSE 1 0.041191 HSM RECALL 0 N/C BLOCKS/OFFLOAD N/C CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C
LOCATION: LOCATION1 IBM OMEGAMON FOR DB2 PERFORMANCE EXPERT (V5R5M0) PAGE: 1-3 GROUP: GROUP1 I/O ACTIVITY REPORT - ARCLOG REQUESTED FROM: NOT SPECIFIED MEMBER: DB1A TO: NOT SPECIFIED SUBSYSTEM: DB1A ORDER: DATASET-INTERVAL INTERVAL FROM: 01/30/15 14:00:00.00 DB2 VERSION: V10 TO: 01/30/15 14:35:00.00 ARCHIVE LOG ACTIVITY --------------------------------------------------------------------------------------------------------------- DATASET INTERVAL WAIT TYPE TOTAL AET OTHER WAITS TOTAL AET --------------------------- -------------- -------- --------- -------------------------- -------- --------- ** TOTAL ** 10111584 READ FROM DASD 0 N/C ALLOCATE 2 0.108854 READ FROM TAPE 0 N/C DEALLOCATE 2 0.000614 OFFLOAD 0 N/C OPEN 2 0.006097 OTHER 8 0.036513 CLOSE 2 0.030486 HSM RECALL 0 N/C BLOCKS/OFFLOAD N/C CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C 10111585 01/30 14:30 - 01/29 14:35 READ FROM DASD 0 N/C ALLOCATE 2 0.061112 READ FROM TAPE 0 N/C DEALLOCATE 2 0.000672 OFFLOAD 0 N/C OPEN 2 0.003976 OTHER 8 0.021197 CLOSE 2 0.019029 HSM RECALL 0 N/C BLOCKS/OFFLOAD N/C CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C . . . *** GRAND TOTAL *** READ FROM DASD 0 N/C ALLOCATE 12 0.089906 READ FROM TAPE 0 N/C DEALLOCATE 12 0.000704 OFFLOAD 3 67.708268 OPEN 12 0.005138 OTHER 48 0.030689 CLOSE 12 0.027008 HSM RECALL 0 N/C BLOCKS/OFFLOAD 26999.00 CATALOG LOCATE 0 N/C MULTI DATA SET TAPE VOLUME 0 N/C TAPE VOLUME POSITIONING 0 N/C WTOR ISSUED 0 N/C DATA SET UNAVAILABLE 0 N/C PHYSICAL UNIT UNAVAILABLE 0 N/C READER SERVICE UNAVAILABLE 0 N/C
Column description
The following is a description
of each column printed in the archive log activity section of the
archive log/BSDS report.
- OMEGAMON for Db2® PE Identifiers
- The archive log activity report presents data summarized by OMEGAMON for Db2 PE identifiers.
The report can be ordered by up to three OMEGAMON for Db2 PE 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:
- Blank or null OMEGAMON for Db2 PE identifiers are denoted by the word 'BLANK'.
- DATASET is the most significant identifier. It is the 8-byte ID that identifies the archive log data set where the reported activity occurs. It has the value cxxxxxxx, where c is the copy number and xxxxxxx is the sequence number. The sequence number is the same as the last seven characters of the data set name.
- WAIT TYPE
-
- READ FROM DASD
- The total number of waits and the average elapsed time of a wait for archive log reads from the DASD.
- READ FROM TAPE
- The total number of waits and the average elapsed time of a wait of archive log reads from the tape.
- OFFLOAD
- The total number of waits for archive log write requests and the average elapsed time of waits per archive log write.
- OTHER
- The total number of non-I/O waits and the average elapsed time of non-I/O waits on the archive log data set.
- OTHER WAITS
- The following fields identify the other waits section.
- ALLOCATE
- The total number of waits and the average elapsed time of a wait for resource allocation.
- DEALLOCATE
- The total number of waits and the average elapsed time of a wait for resource deallocation.
- OPEN
- The total number of waits and the average elapsed time of a wait to open a data set.
- CLOSE
- The total number of waits and the average elapsed time of a wait to close a data set.
- HSM RECALL
- The total number of waits and the average elapsed time of a wait for HSM to recall data sets.
- CATALOG LOCATE
- The total number of waits and the average elapsed time of a wait to locate data sets through the catalog.
- MULTI DATA SET TAPE VOLUME
- The total number of waits and the average elapsed time per wait for multi-data set tape volume.
- TAPE VOLUME POSITIONING
- The total number of waits and the average elapsed time per wait for tape volume positioning.
- WTOR ISSUED
- The total number of waits and the average elapsed time of waits due to a write-to-operator message being issued.
- DATA SET UNAVAILABLE
- The total number of waits and the average elapsed time of a wait due to a data set being unavailable.
- PHYSICAL UNIT UNAVAILABLE
- The total number of waits and the average elapsed time of a wait due to an unavailable physical unit.
- READER SERVICE UNAVAILABLE
- The total number of waits and the average elapsed time per wait for an unavailable reader service task.
- 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.