Resets the parameters in the database manager configuration file to the system defaults. The values are reset by node type, which is always a server with remote clients.
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 reset the database manager configuration for a remote instance, it is necessary to first attach to that instance.
Command Syntax
>>-RESET----+-DATABASE MANAGER-+---+-CONFIGURATION-+-----------><
+-DB MANAGER-------+ +-CONFIG--------+
'-DBM--------------' '-CFG-----------'
Command Parameters
None
Usage Notes
To view or print a list of the database manager configuration parameters, use GET DATABASE MANAGER CONFIGURATION.
To change the value of a configurable parameter, use UPDATE DATABASE MANAGER CONFIGURATION.
For more information about these parameters, see the Administration Guide.
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 reset 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 installed again to reset the database manager configuration file.
See Also
GET DATABASE MANAGER CONFIGURATION
UPDATE DATABASE MANAGER CONFIGURATION.