RESET DATABASE CONFIGURATION command using the ADMIN_CMD procedure

The RESET DATABASE CONFIGURATION command resets the configuration of a specific database to the system defaults.

Scope

This command only affects the database partition that the application is connected to.

Authorization

One of the following authorities:
  • SYSADM
  • SYSCTRL
  • SYSMAINT

Required connection

Database

Command syntax

Read syntax diagramSkip visual syntax diagramRESET DATABASEDBCONFIGURATIONCONFIGCFGFORdatabase-aliasMEMBERmember-number

Command parameters

FOR database-alias
Specifies the alias of the database whose configuration is to be reset to the system defaults. The database alias must be one that is defined in the catalog on the server, and must refer to a local database on the server.
MEMBER member-number
If a database configuration reset is to be applied to a specific member, this parameter may be used. If this parameter is not provided, the reset will take effect on all members.

Example

Reset the configuration of a database cataloged with alias SAMPLE on the server 
CALL SYSPROC.ADMIN_CMD( 'reset db cfg for SAMPLE' )

Usage notes

To view or print a list of the database configuration parameters, use the SYSIBMADM.DBCFG administration view.

To change the value of a configurable parameter, use the UPDATE DATABASE CONFIGURATION command.

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 might 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.

The RESET DATABASE CONFIGURATION command will reset the database configuration parameters to the documented default configuration values, where auto_runstats will be ON. Self_tuning_mem will be reset to ON on non-partitioned database environments and to OFF on partitioned database environments.

Command execution status is returned in the SQLCA resulting from the CALL statement.

The database-alias must be a local database defined in the catalog on the server because the ADMIN_CMD procedure runs on the server only.

The RESET DATABASE CONFIGURATION command does not change the database configuration parameters ENCRLIB and ENCROPTS. The RESET DATABASE CONFIGURATION command is not done through a database connection, so Db2® is not able to determine whether a user holds SECADM authority.

Compatibilities

For compatibility with previous versions:
  • DBPARTITIONNUM can be substituted for MEMBER, except when the DB2_ENFORCE_MEMBER_SYNTAX registry variable is set to ON.