Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question