15.00 - DBSCacheCtrl - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DBSCacheCtrl

Purpose  

Enables or disables preferential caching for data blocks from smaller tables. The threshold size for tables whose data blocks are to be preferentially cached is set using the DBSCacheThr field.

Field Group

Performance

Valid Settings

 

Setting

Description

TRUE

Enables preferential caching.

FALSE

Disables preferential caching.

Default

TRUE

Changes Take Effect

After the DBS Control Record has been written. Operations in progress at the time of the change are not affected.

Related Topics

See “DBSCacheThr” on page 289.