Indexing detail CMRDETL records
CMRDETL record file data can be indexed to obtain information from the T6E and T6D records.
To report the data in these fields, use a FOR-NEXT statement to set up a counter. Within the FOR-NEXT loop, index the fields by the variable counter, assign the value of the indexed fields to variables, and report each variable using the variable names and column headings.
The following table lists the T6E and T6D fields that can be used for indexing.
Field name | Use |
|---|---|
T6EQUAL | Format of the file data, as a decimal value of
|
T6EFCNT | Number of files per task The maximum value is 40 for expanded format records and 255 for original format records. |
T6EFI | File type, identified by
|
T6EFN | File or database name |
T6EFT | Elapsed I/O request time |
T6EFC | Number of I/O requests to the file |
T6ERD | Number of file read or DB2 select requests |
T6ERU | Number of file read for update or DB2 open requests |
T6EWR | Number of file write or DB2 close requests |
T6ERW | Number of file rewrite or DB2 insert requests |
T6EDL | Number of file delete or DB2 delete requests |
T6EUL | Number of file unlock or DB2 update requests |
T6ESB | Number of file start browse or DB2 fetch requests |
T6ERN | Number of file read next or DB2 commit requests |
T6ERP | Number of file read previous or DB2 other requests |
T6EEB | Number of file end browse requests |
T6ERB | Number of file reset browse requests |
T6EOT | Number of file other requests |
T6EV1 | First volume serial number associated with the file |
T6EV2 | Second volume serial number associated with the file |
T6EV3 | Third volume serial number associated with the file |
Related topic