File System: Multi-Row Requests Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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