DB2_REDUCED_OPTIMIZATION
DB2_INLIST_TO_NLJN
DB2_MINIMIZE_LISTPREFETCH
DB2_ANTIJOIN
DB2_EVALUNCOMMITTED
are no initial values. They are recommended and should be set as requested by SAP.
BUFFPAGE is used as default for newly created bufferpools. If you need new bufferpools you should create it by specifying its size and don't rely on the default value.
The other parameters you have mentioned (CATALOGCACHE_SZ,
LOGBUFSZ,UTIL_HEAP_SZ,LOCKLIST) are really initial setting and need to be tuned. For this you need to check e.g. the package cache quality to tune CATALOGCACHE_SZ or the number of lock escalation to tune LOCKLIST. All those dependencies between snapshot counters and db config parameters are described in the "System Montioring Guide and Reference". The documentation gives you some rule of thumbs, but I suppose nobody can tell you exactly how much performance for example a log buffer overflow costs and how often it can occure before it has to be seen as a problem which causes a performance problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.