Can anyone let me know which all settings are needed to be optimized in DBS Control Settings. Can u list down those which are recommended.? i have gone thorugh in Teradata PDF of Utilities. Need Just the Useful One.
Also PLEASE let me know from where (LOCATION) can i open the DBS Control Settings? I have a Unix Box Environment.
Thanks in advance
DBS control settings regarding performance (there's just a small number) usually default to a proper value.
Besides increasing DictionaryCacheSize and maybe MaxParseTreeSegs you should be very careful, better talk to Teradata support to ask for recommendations.
You start dbscontrol from Viewpoint's Remote Console (additional ways can be found on the first page of the manual: http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00
One more Dieter,
What all Values should be Majorly changed in DBS Control for Development and Production Environment? which may Majorly affect both individually.