File System Columns | ResUsageSps Table | Teradata Vantage - File System: Segments Acquired Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
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