RESET ALERT CONFIGURATION command

The RESET ALERT CONFIGURATION command resets the health indicator settings for specific objects to the current defaults for that object type or resets the current default health indicator settings for an object type to the install defaults.

Important: This command or API has been deprecated and might be removed in a future release because the health monitor has been deprecated. It is not supported in Db2® pureScale® environments. For more information, see Health monitor has been deprecated.

Authorization

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

Required connection

Instance. An explicit attachment is not required.

Command syntax

Read syntax diagramSkip visual syntax diagramRESET ALERT CONFIGURATIONCONFIGCFG FORDATABASE MANAGERDB MANAGERDBMCONTAINERSDATABASESTABLESPACESCONTAINERcontainer-nameFORtblspace-nameDATABASETABLESPACEtblspace-nameONdatabase-aliasUSINGhealth-indicator-name

Command parameters

DATABASE MANAGER | DB MANAGER | DBM
Resets alert settings for the database manager.
CONTAINERS
Resets default alert settings for all table space containers managed by the database manager to the install default. These are the settings that apply to all table space containers that do not have custom settings. Custom settings are defined using the CONTAINER container-name FOR tblspace-name ON database-alias clause.
DATABASES
Resets alert settings for all databases managed by the database manager. These are the settings that apply to all databases that do not have custom settings. Custom settings are defined using the DATABASE ON database-alias clause.
TABLESPACES
Resets default alert settings for all table spaces managed by the database manager to the install default. These are the settings that apply to all table spaces that do not have custom settings. Custom settings are defined using the TABLESPACE tblspace-name ON database-alias clause.
CONTAINER container-name FOR tblspace-name ON database-alias
Resets the alert settings for the table space container called container-name, for the table space specified using the FOR tblspace-name clause, on the database specified using the ON database-alias clause. If this table space container has custom settings, then these settings are removed and the current table space containers default is used.
DATABASE ON database-alias
Resets the alert settings for the database specified using the ON database-alias clause. If this database has custom settings, then these settings are removed and the install default is used.
TABLESPACE tblspace-name ON database-alias
Resets the alert settings for the table space called tblspace-name, on the database specified using the ON database-alias clause. If this table space has custom settings, then these settings are removed and the install default is used.
USING health-indicator-name
Specifies the set of health indicators for which alert configuration will be reset. Health indicator names consist of a two-letter object identifier followed by a name that describes what the indicator measures. For example: 
db.sort_privmem_util
If you do not specify this option, all health indicators for the specified object or object type will be reset.