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. It is not supported in
DB2® pureScale® environments.
For more information, see Health monitor has been deprecated..
Authorization
One of the following authorities:
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.