Explanation for DB parameter settings with version 8.
Hi,
I would like to get hold of some documentation that explains the "DB2 Profile registry" parameters and also provides an insight into performance aspects when these parameters are changed.
For example-
CATALOGCACHE_SZ
LOGBUFSZ
UTIL_HEAP_SZ
BUFFPAGE
LOCKLIST
DB2_REDUCED_OPTIMIZATION
DB2_INLIST_TO_NLJN
DB2_MINIMIZE_LISTPREFETCH
DB2_ANTIJOIN
DB2_EVALUNCOMMITTED
Though standard SAP Notes are available that provide start up values for the above parameters, i would like to get documentation explaining the purpose of these parameters and their impact on performance.
thanks for your time.
regards
shaibal