15.10 - Spare Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

The ResUsageSpdsk table spare fields are named Spare00 through Spare19, and SpareInt.

The SpareInt field has a 32-bit internal resolution while all other spare fields have a 64-bit internal resolution. All spare fields default to count but can be converted to min, max, or track mode fields if needed when they are used.

Column Name Mode Description Data Type
Spare00 - Spare9, Spare17 - Spare19, SpareInt count Reserved for future use. FLOAT
Spare10 count Total number of 4KB blocks read.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheReadCnt column in Teradata Database 16.0.

FLOAT
Spare11 count Total number of 4KB blocks written.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheWriteCnt column in Teradata Database 16.0.

FLOAT
Spare12 count Number of 4KB blocks read from the disk cache.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheReadHitCnt column in Teradata Database 16.0.

FLOAT
Spare13 count Number of 4KB blocks written to the disk cache.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheWriteHitCnt column in Teradata Database 16.0.

FLOAT
Spare14 track Current KBs of disk cache in use.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheInUseKB column in Teradata Database 16.0.

FLOAT
Spare15 track Total KBs of disk cache available for the pdisk. The value is 0 if disk cache is disabled or not used.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheTotalKB column in Teradata Database 16.0.

FLOAT
Spare16 count Number of 4KB blocks written to the disk cache due to PDISK read operations.

Total 4KB blocks written to cache = DiskCacheWriteHitCnt+DiskCacheFillCnt.

This column is valid on SLES11 SP3 or later systems only.

This field will be converted to the DiskCacheFillCnt column in Teradata Database 16.0.

FLOAT