Retrieving health indicator configuration using the CLP

The GET ALERT CONFIGURATION command allows you to view the factory settings and the instance, global, and object settings.

Procedure

  1. To view the global settings for database-level health indicators, which apply to all databases without customized settings for the health indicator, issue the following command:
    DB2 GET ALERT CONFIGURATION FOR DATABASES
  2. To view the global settings for database-level health indicators, which apply to all databases without customized settings for the health indicator, issue the following command:
    DB2 GET ALERT CONFIGURATION FOR DATABASES
    The output of each health indicator's settings indicates whether it has been changed from its default. In the following output, the global settings have not been updated; therefore, they are the same as the default factory settings. To view factory settings for database-level health indicators, issue the same command as in the preceding example with the DEFAULT keyword.
               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
     ...
  3. To view the custom settings for the SAMPLE database, issue the following command:
    DB2 GET ALERT CONFIGURATION FOR DATABASE ON SAMPLE
    If there are no specific settings for a particular health indicator on the object specified, the global settings for all databases are displayed. To view the settings for a particular health indicator, add the USING health-indicator-name clause to any of the preceding examples.