Resets the configuration of a specific database to the system defaults.
This command only affects the database partition that the application is connected to.
Database
>>-RESET--+-DATABASE-+--+-CONFIGURATION-+-----------------------> '-DB-------' +-CONFIG--------+ '-CFG-----------' >--FOR--database-alias--+----------------------------------+--->< '-DBPARTITIONNUM--db-partition-num-'
CALL SYSPROC.ADMIN_CMD( 'reset db cfg for SAMPLE' )
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.