Active log detail report

The active log report provides information about the writing and retrieving of log records. It presents the number of reads, writes, and non-I/O waits related to the active log and the average elapsed times spent waiting for these events.

The report is ordered by the data set identifier.

The following command produces the active log report shown in I/O Activity Log Report.

 
IOACTIVITY
     REPORT
        LEVEL (ACTLOG)

I/O Activity Log Report

This is an example of the I/O Activity log report.

   LOCATION: LOCATION1                 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                    PAGE: 1-1
      GROUP: GROUP1                            I/O ACTIVITY REPORT - ACTLOG                     REQUESTED FROM: NOT SPECIFIED
     MEMBER: MEMBER1                                                                                        TO: NOT SPECIFIED
  SUBSYSTEM: DB2A                                 ORDER: INTERVAL-DATASET                        INTERVAL FROM: 01/30/15 05:00:00.00
DB2 VERSION: V10                                                                                            TO: 01/30/15 07:05:00.00

INTERVAL                       I/O REQ   READ REQ  --WRITE REQUESTS--  ------------  OTHER WAITS  ------------
 DATASET                         TOTAL      TOTAL      TOTAL CI/WRITE      ALLOC   DEALLOC      OPEN     CLOSE
                                   AET        AET        AET                 AET       AET       AET       AET
---------------------------  ---------  ---------  --------- --------  --------- --------- --------- ---------
01/30 05:00 - 06/01 05:05
 ACTLG001
                                     1          1          0      N/C          0         0         0         0
                              0.200000   0.200000        N/C                 N/C       N/C       N/C       N/C
01/30 05:20 - 06/01 05:25
 ACTLG002
                                     1          1          0      N/C          0         0         0         0
                              0.210000   0.210000        N/C                 N/C       N/C       N/C       N/C
01/30 06:00 - 06/01 06:05
 ACTLG003
                                     1          0          1 12345.00          0         0         0         0
                              0.220000        N/C   0.220000                 N/C       N/C       N/C       N/C

01/30 07:00 - 06/01 07:05
 ACTLG004
                                     1          0          0      N/C          1         0         0         0
                              0.270000        N/C        N/C            0.270000       N/C       N/C       N/C

 ACTLG005
                                     1          0          0      N/C          0         1         0         0
                              0.280000        N/C        N/C                 N/C  0.280000       N/C       N/C

 ACTLG006
                                     1          0          0      N/C          0         0         1         0
                              0.290000        N/C        N/C                 N/C       N/C  0.290000       N/C

 ACTLG007
                                     1          0          0      N/C          0         0         0         1
                              0.300000        N/C        N/C                 N/C       N/C       N/C  0.300000

 ** TOTAL **
 01/30 07:00 - 01/30 07:05
                                     4          0          0      N/C          1         1         1         1
                              0.285000        N/C        N/C            0.270000  0.280000  0.290000  0.300000
01/30 05:00 - 01/30 05:05
 ACTLG001
                                     1          1          0      N/C          0         0         0         0
                              0.200000   0.200000        N/C                 N/C       N/C       N/C       N/C



 
*** GRAND TOTAL ***
                                    14          4          2 12345.00          2         2         2         2
                              0.252857   0.205000   0.220000            0.270000  0.280000  0.290000  0.300000

I/O ACTIVITY REPORT COMPLETE

Column description

The following is a description of each column printed in the active log report:

OMEGAMON for Db2® Performance Expert Identifiers

The active log 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 active log data set where the reported activity occurs. It has the value ACTLGcxx, where c is the copy number and xx is the sequence number of the active log data set.

I/O REQ

TOTAL: The total number of I/O requests.
AET: The average elapsed time of all waits.

READ REQ

TOTAL: The total number of read requests.
AET: The average elapsed time of a read request.

WRITE REQUESTS

TOTAL: The total number of write requests.
AET: The average elapsed time of a write request.
CI/WRITE: The number of control intervals per write.

OTHER WAITS

ALLOC: The number of waits for resource allocation.
AET: The average elapsed time of a wait for resource allocation.
DEALLOC: The number of waits for resource deallocation.
AET: The average elapsed time of waits for resource deallocation.
OPEN: The number of waits to open data sets.
AET: The average elapsed time of a wait to open data sets.
CLOSE: The number of waits to close data sets.
AET: The average elapsed time of a wait to close data sets.

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.