Archives of the TeradataForum
Message Posted: Fri, 04 Aug 2000 @ 18:16:35 GMT
I think you'll find that most multi-machine sites have the same values (default or not) for all machines. I'm not saying that's the best, but I'd be willing to bet that is what most sites have.
A couple of things to remember about this topic.
Some of the settings in DBSCONTROL potentially affect the results of queries and so I think should be the same for all machines at a site. The only reason that I can think of for having different values for this type of setting is if you've got different applications accessing different machines (that goes against the idea of the "Enterprise Data Warehouse", but I know of some sites where that happens). Some settings which fall into this category are CenturyBreak, MaxDecimal and DateFormat.
Other settings are to do with performance and those may justifiably be different on your different machines. Some obvious ones here are MaxLoadTasks and the DBSCacheCtrl & ...Thr settings. The DBSCache... Settings may be different based on the amount of memory on each Node in the different machines.
From your email I note that you've got 14 amps/node on one system and 8 amps/node on the other which sounds like you've got different machine types and/or memory per node. You may want to consider making changes to these types of settings for the two systems.
Also of course you have to consider the work load on the two systems. often in this case, the smaller machin eis development/test whilst the larger one is for production work. That in itself may well dictate differences between the two machines.
The bottom line that I'm coming to is this:- I believe that some settings must be the same for all machines because they potentially affect the application whilst others are more dependent on the physical configuration of the machine and the workload - the values should be tailored on an individual machine basis.
I hope that is of use.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|