DOMINO AND DB2

Configuration variables modified during DB2 server enablement
When you enable an IBM® Lotus® Domino™ server to communicate with an IBM® DB2 Universal Database™ Enterprise Server Edition server, IBM® Lotus® 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® or Linux®

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
See also