All Forums Database
mihirdhakan93 14 posts Joined 04/15
09 Sep 2015
Which DBS control settings affect Teradata Performance?

Hi all,
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
 
 
 

dnoeth 4628 posts Joined 11/04
10 Sep 2015

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/index.html#page/Utilities/B035_1102_015K/DBScontrol.31.0001.html) 

Dieter

mihirdhakan93 14 posts Joined 04/15
10 Sep 2015

Thanks a lot Dieter, 
It helped me alot. Thanks a Ton.
 
 

mihirdhakan93 14 posts Joined 04/15
10 Sep 2015

One more Dieter,
What all Values should be Majorly changed in DBS Control for Development and Production Environment? which may Majorly affect both individually.

dnoeth 4628 posts Joined 11/04
11 Sep 2015

In most environments both Prod and Dev will have exactly the same settings.

Dieter

mihirdhakan93 14 posts Joined 04/15
13 Sep 2015

Okay Dieter, 
Thank You

You must sign in to leave a comment.