Command Reference

UPDATE DATABASE MANAGER CONFIGURATION

Modifies individual entries in the database manager configuration file.

Authorization

sysadm

Required Connection

None or instance. An instance attachment is not required to perform local DBM configuration operations, but is required to perform remote DBM configuration operations. To update the database manager configuration for a remote instance, it is necessary to first attach to that instance.

Command Syntax

>>-UPDATE----+-DATABASE MANAGER-+---+-CONFIGURATION-+----------->
             +-DB MANAGER-------+   +-CONFIG--------+
             '-DBM--------------'   '-CFG-----------'
 
             .-------------------------.
             V                         |
>-----USING-----config-keyword value---+-----------------------><
 

Command Parameters

USING config-keyword value

Specifies the database manager configuration parameter to be updated. For a brief description of configurable parameters, see GET DATABASE MANAGER CONFIGURATION.

Usage Notes

To view or print a list of the database manager configuration parameters, use GET DATABASE MANAGER CONFIGURATION.

To reset the database manager configuration parameters to the recommended database manager defaults, use RESET DATABASE MANAGER CONFIGURATION.

For more information about database manager 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 manager configuration file become effective only after they are loaded into memory. For a server configuration parameter, this occurs during execution of db2start. For a client configuration parameter, this occurs when the application is restarted. If the client is the command line processor, it is necessary to invoke TERMINATE.

If an error occurs, the database manager configuration file does not change.

The database manager configuration file cannot be updated if the checksum is invalid. This may occur if the database manager configuration file is changed without using the appropriate command. If this happens, the database manager must be reinstalled to reset the database manager configuration file.

When updating the SVCENAME, NNAME, or TPNAME database manager configuration parameters for the current instance, if LDAP support is enabled and there is an LDAP node registered for this instance, the LDAP node will be updated with the new value or values.

See Also

GET DATABASE MANAGER CONFIGURATION

RESET DATABASE MANAGER CONFIGURATION.