DBS Control Field Groups - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

The DBS Control fields are grouped logically based on their use by Teradata Database, as shown in the following table.

Group Description
General Miscellaneous settings that affect how Teradata Database operates.
File System Settings that affect the Teradata Database file system.
Compression Settings that affect data compression at the data block level.
Native Object Store

or NOS

Settings that affect access to foreign table data.

Foreign tables allow Teradata Database to access data from external, cloud-based data storage, such as AWS S3, without requiring you to manually move the data into the database first from where it natively resides. Foreign tables are identified by a hostname, path, and other metadata that point to the external storage. Teradata Database can read and process semi-structured or unstructured external data in foreign tables using standard SQL. For example, you can use Teradata analytic functions to examine the data, join it to the relational data in the database, and issue queries against it as you can for other data in Teradata Database.

Performance Settings that affect Teradata Database performance features.
Storage Settings that determine the temperature assigned to data loaded into empty tables. The temperature corresponds to expected frequency of data access, and can be used to determine how data is stored.
This group is visible only when temperature-based block-level compression is enabled, or on systems that have licensed Teradata Virtual Storage (VS).
Checksum Special diagnostic settings that are used to ensure the integrity of disk I/O operations on database tables.

For information on the checksum group of settings, see Checksum Fields.

Optimizer Statistics Settings that are used for statistics recollection.