File System Columns | ResUsageSps Table | Teradata Vantage - File System: Segments Acquired 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 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