DB2 Version 9.7 for Linux, UNIX, and Windows

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 in Version 9.7. For more information, see Health monitor has been deprecated.

Authorization

One of the following:

SYSADM
SYSMAINT
SYSCTRL

Required connection

Instance. An explicit attachment is not required.

Command syntax


>>-RESET ALERT--+-CONFIGURATION-+--FOR-------------------------->
                +-CONFIG--------+        
                '-CFG-----------'        

>--+-+-DATABASE MANAGER-+------------------------------------------------------------------------------------+-><
   | +-DB MANAGER-------+                                                                                    |   
   | '-DBM--------------'                                                                                    |   
   +-CONTAINERS----------------------------------------------------------------------------------------------+   
   +-DATABASES-----------------------------------------------------------------------------------------------+   
   +-TABLESPACES---------------------------------------------------------------------------------------------+   
   '-+-CONTAINER--container-name--FOR--tblspace-name-+--ON--database-alias--+------------------------------+-'   
     +-DATABASE--------------------------------------+                      '-USING--health-indicator-name-'     
     '-TABLESPACE--tblspace-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.