The database manager provides a single view of all database configuration elements across multiple partitions. This means that you can update or reset a database configuration across all database partitions without invoking the db2_all command against each database partition.
You can update a database configuration across partitions by issuing only one SQL statement or only one administration command from any partition on which the database resides. By default, the method of updating or resetting a database configuration is on all database partitions.
DB2_UPDDBCFG_SINGLE_DBPARTITION=TRUE
CALL SYSPROC.ADMIN_CMD
('UPDATE DB CFG USING sortheap 1000')
To update a
single database partition, call the ADMIN_CMD procedure as follows: CALL SYSPROC.ADMIN_CMD
('UPDATE DB CFG DBPARTITIONNUM 10 USING sortheap 1000')
#define db2CfgSingleDbpartition 256
If you do not set the db2CfgSingleDbpartition value, the value for the database configuration applies to all database partitions unless you set the DB2_UPDDBCFG_SINGLE_DBPARTITION registry variable to TRUE or you set versionNumber to anything that is less than the version number for Version 9.5, for the db2CfgSet API that sets the database manager or database configuration parameters.
When upgrading your databases to Version 9.7, existing database configuration parameters, as a general rule, retain their values after database upgrade. However, new parameters are added using their default values and some existing parameters are set to their new Version 9.7 default values. Refer to the "DB2® server behavior changes" topic in Upgrading to DB2 Version 9.7 for details about the changes to existing database configuration parameters. Any subsequent update or reset database configuration requests for the upgraded databases will apply to all database partitions by default.
For existing update or reset command scripts, the same rules mentioned previously apply to all database partitions. You can modify your scripts to include the DBPARTITIONNUM option of the UPDATE DATABASE CONFIGURATION or RESET DATABASE CONFIGURATION command, or you can set the DB2_UPDDBCFG_SINGLE_DBPARTITION registry variable.
For existing applications that call the db2CfgSet API, you must use the instructions for Version 9.5 or later. If you want the pre-Version 9.5 behavior, you can set the DB2_UPDDBCFG_SINGLE_DBPARTITION registry variable or modify your applications to call the API with the Version 9.5 or later version number, including the new db2CfgSingleDbpartition flag and the new dbpartitionnum field to update or reset database configurations for a specific database partition.