These columns identify the significant multi-row requests made by application software on the file system. Rows are distinguished as permanent data (P), spool (S) or user append table / permanent journal table (APt).
Column Name | Mode | Description | Data Type |
---|---|---|---|
FileAPtBlkRead | count | Number of requests for an append data block read. | FLOAT |
FileAPtBlkReplace | count | Number of requests for an append data block replace. | FLOAT |
FileAPtRownins | count | Number of requests for an append data multi-row insert. | FLOAT |
FileAPtRowNDel | count | Number of requests for an append data multi-row delete. | FLOAT |
FileAPtRowNUpd | count | Number of requests for an append data multi-row update. | FLOAT |
FileAPtSortable | count | Number of requests for an append table sort. | FLOAT |
FileAPtTabdelete | count | Number of requests for an append table delete. | FLOAT |
FileAPtTabdelra | count | Number of requests for an append multi-row delete. | FLOAT |
FileAPtTabmrows | count | Number of requests for an append table modification. | FLOAT |
FileAPtTabrblocks | count | Number of requests for an append table multi-block read. | FLOAT |
FilePBlkRead | count | Number of requests for a permanent data block read. | FLOAT |
FilePBlkReplace | count | Number of requests for a permanent data block replace. | FLOAT |
FilePRowNDel | count | Number of requests for a permanent data multi-row delete. | FLOAT |
FilePRownins | count | Number of requests for a permanent data multi-row insert. | FLOAT |
FilePRowNUpd | count | Number of requests for a permanent data multi-row update. | FLOAT |
FilePSortable | count | Number of requests for permanent table sort. | FLOAT |
FilePTabdelete | count | Number of requests for a permanent table delete. | FLOAT |
FilePTabdelra | count | Number of requests for a multi-row delete. | FLOAT |
FilePTabmrows | count | Number of requests for a permanent table modification. | FLOAT |
FilePTabrblocks | count | Number of requests for a permanent table multi-block read. | FLOAT |
FileSBlkRead | count | Number of requests for a spool data block read. | FLOAT |
FileSBlkReplace | count | Number of requests for a spool data block replace. | FLOAT |
FileSRowNDel | count | Number of requests for a spool data multi-row delete. | FLOAT |
FileSRownins | count | Number of requests for a spool data multi-row insert. | FLOAT |
FileSRowNUpd | count | Number of requests for a spool data multi-row update. | FLOAT |
FileSSortable | count | Number of requests for spool table sort. | FLOAT |
FileSTabdelete | count | Number of requests for a spool table delete. | FLOAT |
FileSTabdelra | count | Number of requests for a spool multi-row delete. | FLOAT |
FileSTabmrows | count | Number of requests for a spool table modification. | FLOAT |
FileSTabrblocks | count | Number of requests for a spool table multi-block read. | FLOAT |