File System Columns | ResUsageSps Table | Teradata Vantage - 17.05 - File System: Segments Acquired 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 total disk memory segments acquired by the File System during the log period. Logical acquires (Acqs) and the logical amount acquired (AcqKB) are identified. Acquires causing physical reads (AcqReads) and the amount read (AcqReadKB) are identified as a subset of logical acquires.

Column Name Mode Description Data Type
FileAPtAcqs count Total number of append table or permanent journal table data block or cylinder index disk segments acquired. FLOAT
FilePCiAcqs count Total number of permanent cylinder index disk segments acquired. FLOAT
FilePDbAcqs count Total number of permanent data block disk segments acquired. FLOAT
FileSCiAcqs count Total number of regular or restartable spool index disk segments acquired. FLOAT
FileSDbAcqs count Total number of regular or restartable spool data block disk segments acquired. FLOAT
FileTJtAcqs count Total number of transient journal table disk segments acquired. FLOAT
FileAPtAcqKB count Total KB acquired by FileAPtAcqs. FLOAT
FilePCiAcqKB count Total KB acquired by FilePCiAcqs. FLOAT
FilePDbAcqKB count Total KB acquired by FilePDbAcqs. FLOAT
FileSCiAcqKB count Total KB acquired by FileSCiAcqs. FLOAT
FileSDbAcqKB count Total KB acquired by FileSDbAcqs. FLOAT
FileTJtAcqKB count Total KB acquired by FileTJtAcqs. FLOAT
FileAPtAcqReads count Number of append table or permanent journal table data block or cylinder index disk segments that caused a physical read. FLOAT
FilePCiAcqReads count Number of permanent cylinder index disk segment acquires that caused a physical read. FLOAT
FilePDbAcqReads count Number of permanent data block disk segment acquires that caused a physical read. FLOAT
FileSCiAcqReads count Number of regular or restartable spool index disk segments that caused a physical read. FLOAT
FileSDbAcqReads count Number of regular or restartable spool data block disk segments that caused a physical read. FLOAT
FileTJtAcqReads count Number of transient journal table disk segments that caused a physical read. FLOAT
FileAPtAcqReadKB count KB physically read by FileAPtAcqReads. FLOAT
FilePCiAcqReadKB count KB physically read by FilePCiAcqReads. FLOAT
FilePDbAcqReadKB count KB physically read by FilePDbAcqReads. FLOAT
FileSCiAcqReadKB count KB physically read by FileSCiAcqReads. FLOAT
FileSDbAcqReadKB count KB physically read by FileSDbAcqReads. FLOAT
FileTJtAcqReadKB count KB physically read by FileTJtAcqReads. FLOAT