Command Reference

UPDATE DATABASE CONFIGURATION

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:

• sysadm
• sysctrl
• sysmaint

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

FOR database-alias

Specifies the alias of the database whose configuration is to be updated.

USING config-keyword value

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

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

GET DATABASE CONFIGURATION

RESET DATABASE CONFIGURATION.