Preserving custom Db2 configuration settings between upgrades

Starting with version 1.0.15.0, you can preserve some of the custom Db2 settings when upgrading IAS.

Note: Changing Db2 configuration settings may result in performance degradation, crashes, or other unwanted results. It is recommended to consult IBM Support, specifically when making memory related changes.

About this task

You can provide your custom values in the following files in the /opt/ibm/appliance/storage/head/db2_config/ directory:
  • db.cfg
  • dbm.cfg
  • db2set.text
For db.cfg and dbm.cfg, provide key and value with a single space:
LOGFILSIZ 500000
LOCKLIST 65535
LOGPRIMARY 50
For db2set.text (registry values), provide key and value with an equal sign without any spaces:
DB2_OBJECT_TABLE_ENTRIES=65536
DB2_EXTENDED_OPTIMIZATION="COL_PAR_IUD_DEGREE_FACTOR 1.5"