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 fieldsThe DBS Control Record stores various fields used by the Teradata Database for the following:• Debugging/diagnostic purposes• Establishing known global system values• Performance tuningThe 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.
Ramakrishna Vedantam, Tata consultancy services, Hyderabad
hello, newbie here. i would like to ask how can i invoke dbscontrol from the test VM installation (TD1310_40GB)..
or
is there a way from BTEQ to show all parameters (i.e "show parameter <param string>") in Oracle
got the basics out of it.. continuing to explore further:
s10-1310:/tmp # /usr/tdbms/bin/dbscontrol
_______
| | |
| ___ __ ____ | ____ __|__ ____
| / |/ \ ____| ____| ____| | ____|
| --- | / | / | / | | / |
| \___ | \____| \____| \____| |__ \____|Release 13.10.00.10 Version 13.10.00.14
DBSControl Utility (Dec 99)
Hi AllCan any body reply on the following questionsWhat is the DBS control and How and what kind of information it is keeping...?Thanks in Advance....