DBS Control...


DBS Control...

Hi All
Can any body reply on the following questions
What is the DBS control and How and what kind of information it is keeping...?

Thanks in Advance....

Re: DBS Control...

Use DBS Control to perform the following:
• Display the values of the DBS Control Record fields
• Modify the values of the writable DBS Control Record fields

The DBS Control Record stores various fields used by the Teradata Database for the following:
• Debugging/diagnostic purposes
• Establishing known global system values
• Performance tuning

The DBS Control Record fields are grouped logically based on their use by the Teradata Database, into 4 types.
1. General used for various purposes throughout the Teradata Database.
2. File System of specific interest to the Teradata Database file system.
3. Performance of specific interest to the Teradata Database performance features.
4. Checksum used to set and to define the meanings of the checksum levels based on specific table types.

After starting DBSCONTROL and typing display u can see all these.
Check the TD Manual Utilities for more details.

Teradata Employee

Re: DBS Control...

hello, newbie here. i would like to ask how can i invoke dbscontrol from the test VM installation (TD1310_40GB)..


is there a way from BTEQ to show all parameters (i.e "show parameter <param string>") in Oracle

Teradata Employee

Re: DBS Control...

got the basics out of it.. continuing to explore further:

s10-1310:/tmp # /usr/tdbms/bin/dbscontrol


    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

    Release Version

    DBSControl Utility (Dec 99)