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

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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