DOMINO AND DB2

Configuration variables modified during DB2 server enablement
When you enable a Domino server to communicate with a DB2 server, Domino modifies the following DB2 database manager configuration parameters for optimal performance:
Configuration parameterValue
FCM_NUM_BUFFERS4096.00
KEEPFENCEDYES
NOTIFYLEVEL0.00
MAXAGENTS400.00
PRIV_MEM_THRESH32767.00
INTRA_PARALLELOFF
MAX_QUERYDEGREE1.00
SHEAPTHRES40960.00
FEDERATEDYES
When you enable a Domino server to communicate with an existing DB2 database, Domino modifies the following DB2 database management configuration parameters:
Configuration parameterValue
MAXFILOP128.00
MAXAPPLSAUTOMATIC
SORTHEAP1024.00
DBHEAP4096 on Microsoft Windows

20000 on IBM AIX

SHEAPTHRES_SHR8192.00
DFT_QUERYOPT0.00
APPLHEAPSZ512.00
STMTHEAP8192.00
APP_CTL_HEAP_SZ8192.00
APPGROUP_MEM_SZ30000.00
UTIL_HEAP_SZ5000.00
LOCKLIST2500.00
CATALOGCACHE_SZ512.00
MINCOMMIT1.00
NUM_IOCLEANERS20.00
NUM_IOSERVERS1.00
SEQDETECTNO
LOGBUFSZ512.00
LOGFILSIZ131077.00
LOGPRIMARY3.00
LOGSECOND0.00