GET ALERT CONFIGURATION command
The GET ALERT CONFIGURATION command returns the alert configuration settings for health indicators for a particular instance.
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
None
Required connection
Instance. An explicit attachment is not required.
Command syntax
Command parameters
- DATABASE MANAGER
- Retrieves alert settings for the database manager.
- DATABASES
- Retrieves 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.
- CONTAINERS
- Retrieves alert settings for all table space containers managed by the database manager. These are the settings that apply to all table space containers that do not have custom settings. Custom settings are defined using the CONTAINER name ON database alias clause.
- TABLESPACES
- Retrieves alert settings for all table spaces managed by the database manager. These are the settings that apply to all table spaces that do not have custom settings. Custom settings are defined using the TABLESPACE name ON database alias clause.
- DEFAULT
- Specifies that the install defaults are to be retrieved.
- DATABASE ON database alias
- Retrieves the alert settings for the database specified using the ON database alias clause. If this database does not have custom settings, then the settings for all databases for the instance will be returned, which is equivalent to using the DATABASES parameter.
- CONTAINER name FOR tablespace-id ON database alias
- Retrieves the alert settings for the table space container called name, for the table space specified using the FOR tablespace-id clause, on the database specified using the ON database alias clause. If this table space container does not have custom settings, then the settings for all table space containers for the database will be returned, which is equivalent to using the CONTAINERS parameter.
- TABLESPACE name ON database alias
- Retrieves the alert settings for the table space called name, on the database specified using the ON database alias clause. If this table space does not have custom settings, then the settings for all table spaces for the database will be returned, which is equivalent to using the TABLESPACES parameter.
- USING health indicator name
- Specifies the set of health indicators for which alert configuration information will be returned. 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. This is an optional clause, meaning that if it is not used, all health indicators for the specified object or object type will be returned.
Examples
The following section is typical output
resulting from a request for database manager information:
DB2 GET ALERT CFG FOR DBM
Alert Configuration
Indicator Name = db2.db2_op_status
Default = Yes
Type = State-based
Sensitivity = 0
Formula = db2.db2_status;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db2.sort_privmem_util
Default = Yes
Type = Threshold-based
Warning = 90
Alarm = 100
Unit = %
Sensitivity = 0
Formula = ((db2.sort_heap_allocated/sheapthres)
*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db2.mon_heap_util
Default = Yes
Type = Threshold-based
Warning = 85
Alarm = 95
Unit = %
Sensitivity = 0
Formula = ((db2.mon_heap_cur_size/
db2.mon_heap_max_size)*100);
Actions = Disabled
Threshold or State checking = EnabledThe
following section is typical output resulting from a request for configuration
information:
DB2 GET ALERT CFG FOR DATABASES
Alert Configuration
Indicator Name = db.db_op_status
Default = Yes
Type = State-based
Sensitivity = 0
Formula = db.db_status;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.sort_shrmem_util
Default = Yes
Type = Threshold-based
Warning = 70
Alarm = 85
Unit = %
Sensitivity = 0
Formula = ((db.sort_shrheap_allocated/sheapthres_shr)
*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.spilled_sorts
Default = Yes
Type = Threshold-based
Warning = 30
Alarm = 50
Unit = %
Sensitivity = 0
Formula = ((delta(db.sort_overflows,10))/
(delta(db.total_sorts,10)+1)*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.max_sort_shrmem_util
Default = Yes
Type = Threshold-based
Warning = 60
Alarm = 30
Unit = %
Sensitivity = 0
Formula = ((db.max_shr_sort_mem/
sheapthres_shr)*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.log_util
Default = Yes
Type = Threshold-based
Warning = 75
Alarm = 85
Unit = %
Sensitivity = 0
Formula = (db.total_log_used/
(db.total_log_used+db.total_log_available)
)*100;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.log_fs_util
Default = Yes
Type = Threshold-based
Warning = 75
Alarm = 85
Unit = %
Sensitivity = 0
Formula = ((os.fs_used/os.fs_total)*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.deadlock_rate
Default = Yes
Type = Threshold-based
Warning = 5
Alarm = 10
Unit = Deadlocks per hour
Sensitivity = 0
Formula = delta(db.deadlocks);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.locklist_util
Default = Yes
Type = Threshold-based
Warning = 75
Alarm = 85
Unit = %
Sensitivity = 0
Formula = (db.lock_list_in_use/(locklist*4096))
*100;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.lock_escal_rate
Default = Yes
Type = Threshold-based
Warning = 5
Alarm = 10
Unit = Lock escalations per hour
Sensitivity = 0
Formula = delta(db.lock_escals);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.apps_waiting_locks
Default = Yes
Type = Threshold-based
Warning = 50
Alarm = 70
Unit = %
Sensitivity = 0
Formula = (db.locks_waiting/db.appls_cur_cons)*100;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.pkgcache_hitratio
Default = Yes
Type = Threshold-based
Warning = 80
Alarm = 70
Unit = %
Sensitivity = 0
Formula = (1-
(db.pkg_cache_inserts/db.pkg_cache_lookups)
)*100;
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.catcache_hitratio
Default = Yes
Type = Threshold-based
Warning = 80
Alarm = 70
Unit = %
Sensitivity = 0
Formula = (1-
(db.cat_cache_inserts/db.cat_cache_lookups)
)*100;
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.shrworkspace_hitratio
Default = Yes
Type = Threshold-based
Warning = 80
Alarm = 70
Unit = %
Sensitivity = 0
Formula = ((1-
(db.shr_workspace_section_inserts/
db.shr_workspace_section_lookups))
*100);
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.db_heap_util
Default = Yes
Type = Threshold-based
Warning = 85
Alarm = 95
Unit = %
Sensitivity = 0
Formula = ((db.db_heap_cur_size/
db.db_heap_max_size)*100);
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.tb_reorg_req
Default = Yes
Type = Collection state-based
Sensitivity = 0
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.hadr_op_status
Default = Yes
Type = State-based
Sensitivity = 0
Formula = db.hadr_connect_status;
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.hadr_delay
Default = Yes
Type = Threshold-based
Warning = 10
Alarm = 15
Unit = Minutes
Sensitivity = 0
Formula = (db.hadr_log_gap*var.refresh_rate/60)
DIV(delta(db.hadr_secondary_log_pos));
Actions = Disabled
Threshold or State checking = Enabled
Indicator Name = db.db_backup_req
Default = Yes
Type = State-based
Sensitivity = 0
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.fed_nicknames_op_status
Default = Yes
Type = Collection state-based
Sensitivity = 0
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.fed_servers_op_status
Default = Yes
Type = Collection state-based
Sensitivity = 0
Actions = Disabled
Threshold or State checking = Disabled
Indicator Name = db.tb_runstats_req
Default = Yes
Type = Collection state-based
Sensitivity = 0
Actions = Disabled
Threshold or State checking = Disabled