17.20 - File System: Multi-Row Requests Columns - Analytics Database - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables - 17.20

Product
Analytics Database
Teradata Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-17
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval

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