File System: Data Block Update Operations Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

These columns identify the file system operations required when a data block is being updated (BlkUpd). When a block is updated, it can be ‘in place’ and requires no new data blocks, or it could spill over the current data block and require one, two, three or more new data blocks in addition to the current data block. Only logical I/Os and the amount moved (KB) are identified, except for the amount moved for cylinder indexes because they can be calculated by multiplying the current fixed cylinder index size by the I/Os. Data block updates should only be performed on permanent tables (including append and transient journal tables), so no attempt is made to separate permanent and spool data segments.

Column Name Mode Description Data Type
FileCiUpd0IO count Number of cylinder index logical I/Os performed for a block update operation requiring no new data blocks. FLOAT
FileCiUpd1IO count Number of cylinder index logical I/Os performed for a block update operation requiring 1 new data blocks. FLOAT
FileCiUpd2IO count Number of cylinder index logical I/Os performed for a block update operation requiring two new data blocks. FLOAT
FileCiUpd3IO count Number of cylinder index logical I/Os performed for a block update operation requiring three new data blocks. FLOAT
FileCiUpdNIO count Number of cylinder index logical I/Os performed for a block update operation requiring over three new data blocks. FLOAT
FileDbUpd0IO count Number of data block logical I/Os performed for a block update operation requiring no new data blocks. FLOAT
FileDbUpd1IO count Number of data block logical I/Os performed for a block update operation requiring one new data blocks. FLOAT
FileDbUpd2IO count Number of data block logical I/Os performed for a block update operation requiring two new data blocks. FLOAT
FileDbUpd3IO count Number of data block logical I/Os performed for a block update operation requiring three new data blocks. FLOAT
FileDbUpd0KB count KB moved by FileDbUpd0IO. FLOAT
FileDbUpd1KB count KB moved by FileDbUpd1IO. FLOAT
FileDbUpd2KB count KB moved by FileDbUpd2IO. FLOAT
FileDbUpd3KB count KB moved by FileDbUpd3IO. FLOAT
FileDbUpdNKB count KB moved by FileDbUpdNIO. FLOAT
FileDbUpdNIO count Number of data block logical I/Os performed for a block update operation requiring over three new data blocks. FLOAT