15.10 - File System: Multi-Row Requests Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

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