DB2 Version 9.7 for Linux, UNIX, and Windows

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

Authorization

None

Required connection

Instance. An explicit attachment is not required.

Command syntax


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

>--+-+-+-DATABASE MANAGER-+-+--+---------+-----------------------+-->
   | | +-DB MANAGER-------+ |  '-DEFAULT-'                       |   
   | | '-DBM--------------' |                                    |   
   | +-DATABASES------------+                                    |   
   | +-CONTAINERS-----------+                                    |   
   | '-TABLESPACES----------'                                    |   
   '-+-DATABASE----------------------------+--ON--database alias-'   
     +-TABLESPACE--name--------------------+                         
     '-CONTAINER--name--FOR--tablespace-id-'                         

>--+----------------------------------+------------------------><
   |        .-,---------------------. |   
   |        V                       | |   
   '-USING----health indicator name-+-'

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 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    = Enabled

The following 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