Which DBS control settings affect Teradata Performance?

Database
Enthusiast

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

5 REPLIES
Junior Contributor

Re: Which DBS control settings affect Teradata Performance?

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/DBScontr...

Enthusiast

Re: Which DBS control settings affect Teradata Performance?

Thanks a lot Dieter, 

It helped me alot. Thanks a Ton.

Enthusiast

Re: Which DBS control settings affect Teradata Performance?

One more Dieter,

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

Junior Contributor

Re: Which DBS control settings affect Teradata Performance?

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

Enthusiast

Re: Which DBS control settings affect Teradata Performance?

Okay Dieter, 

Thank You