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 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) 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 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) 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 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) 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/CColumn 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® Performance Expert Identifiers
- The archive log 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:
- Blank or null OMEGAMON for Db2 Performance Expert 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.