Modifies individual entries in a specific database configuration file.
A database configuration file resides on every node on which the database has been created.
Scope
This command only affects the node on which it is executed.
Authorization
One of the following:
Required Connection
Instance. An explicit attachment is not required. If the database is listed as remote, an instance attachment to the remote node is established for the duration of the command.
Command Syntax
>>-UPDATE----+-DATABASE-+---+-CONFIGURATION-+------------------->
'-DB-------' +-CONFIG--------+
'-CFG-----------'
.-------------------------.
V |
>----FOR--database-alias---USING-----config-keyword value---+--><
Command Parameters
Usage Notes
To view or print a list of the database configuration parameters, use GET DATABASE CONFIGURATION.
To reset the database configuration parameters to the recommended database manager defaults, use RESET DATABASE CONFIGURATION.
For more information about DB2 configuration parameters, see the Administration Guide.
The values of these parameters differ for each type of database node configured (server, client, or server with remote clients). See the Administration Guide for the ranges and the default values that can be set on each node type.
Not all parameters can be updated.
Most changes to the database configuration file become effective only after they are loaded into memory. All applications must disconnect from the database before this can occur.
If an error occurs, the database configuration file does not change.
The database configuration file cannot be updated if the checksum is invalid. This may occur if the database configuration file is changed without using the appropriate command. If this happens, the database must be restored to reset the database configuration file.
See Also