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"