I/O Activity

This block shows the I/O activity for each object performed by the event.

I/O Activity Workload Block Example

The following example shows the I/O activity workload block. 
--- I/O ACTIVITY -------------------------------------------------------------------------------------------------------------------
      DATABASE  PAGESET  - I/O REQUEST -  ------- READ REQUEST  (WITH OR WITHOUT I/O) -------  ------------ WRITE REQUEST ----------
      MEMBER    BP       TOTAL     AET    TOTAL  TYPE   AET/WITH    %WITH PAGE/WITH  %WITHOUT  TOTAL  TYPE  CAST      AET  PAGE/WRIT
      DBPARALL  TSPARALL
      SE12      BP4          3  0.1296        3  SYNCH  0.129597   100.00      1.00      0.00
      WRKSE12   DSN4K01
      SE12      BP0        102  0.0164      102  SYNCH  0.016358   100.00      1.00      0.00

Field description

Here is a description of the field labels shown in the I/O activity workload block:
DATABASE
The database name. If the name is not available, the decimal DBID/OBID is printed.
PAGESET
The page set name. If the name is not available, the decimal DBID/OBID is printed.
MEMBER
The name of the Db2® member within the Db2 data sharing group. This field shows N/P in a non-data-sharing environment.
BP
The buffer pool name.
I/O REQUEST TOTAL
The total number of I/O requests.
I/O REQUEST AET
The average elapsed time for each I/O request.
READ REQUEST TOTAL
The number of read I/O requests of a specific type.
READ REQUEST TYPE
The type of read request:
SYNCH
Synchronous read request
SEQPF
Sequential prefetch request
DYNPF
Dynamic prefetch request
LSTPF
List prefetch request
READ REQUEST AET/WITH
The average elapsed time for a read with I/O of a specific type.
READ REQUEST %WITH
The percentage of total read requests with I/O for a particular type.
READ REQUEST PAGE/WITH
The pages read for each read request with I/O of a particular type.
READ REQUEST %WITHOUT
The percentage of total read requests without I/O for a particular type. This can occur because all the pages requested by a prefetch read were already in the buffer pool.
WRITE REQUEST TOTAL
The number of write I/O requests.
WRITE REQUEST TYPE
The type of write request.
WRITE REQUEST CAST
Indicates whether the write operations were initiated due to a coupling facility castout.
WRITE REQUEST AET
The average elapsed time for each write.
WRITE REQUEST PAGE/WRITE
The number of pages written.