Resets the configuration of a specific database to the system defaults.
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
>>-RESET----+-DATABASE-+---+-CONFIGURATION-+-------------------->
'-DB-------' +-CONFIG--------+
'-CFG-----------'
>----FOR--database-alias---------------------------------------><
Command Parameters
Usage Notes
To view or print a list of the database configuration parameters, use GET DATABASE CONFIGURATION.
To change the value of a configurable parameter, use UPDATE DATABASE CONFIGURATION.
For more information about these parameters, see the Administration Guide.
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 reset 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
UPDATE DATABASE CONFIGURATION.