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 |