Health reports

System health reports

System health reports display information that is relevant to the entire Db2 subsystem or data sharing group, such as indoubt threads and stopped utilities. Specifically, these reports include the following information and metrics:

• CPU busy
• Paging rate
• Db2 group information
• RLMIT status
• Profile status
• Buffer pool information
• Log information
• Thread information
• DDF information
• Utility information
• Accelerator information

For an example system health report and instructions on how to generate this report, see Running a system health report.

Application health reports

Application health reports display information for Db2 objects, such as spaces in restricted states or objects for which copies are recommended. Specifically, these reports include the following information and metrics:

• Number of databases, table spaces, and indexes
• DSNACOXX recommendations:
  • Spaces in restricted or advisory states
  • RUNSTATS, COPY, and REORG recommendations
  • Underlying data sets with too many extents
• Objects running out of space
• Deprecated objects
• Stopped procedures
• Stopped functions
• Stopped REST services
• Invalid, inoperative, and old packages

To run an application report, you must first define an application and then add Db2 objects to it. In the context of health reports, an application is simply a group of objects. For example, you might create an application called PAYROLL to which you add all Db2 objects that are used by your company's payroll application. The objects that you can add to a health report application are: table spaces, packages, functions, procedures, and services.

You can also optionally define a group of applications. For example, you might create a group called FINANCE, to which you add your financial applications, including the PAYROLL application.

When you run an application health report, you can run it on either an application or a group. You can also use wildcard characters to run an application health report on a set of applications or groups that have a certain name pattern.

Additionally, you can designate a certain group or groups as vital, or critically important. You can then run an application health report on all vital groups instead of specifying a group or application name.

For an example application health report and instructions on how to generate this report, see Running an application health report.

Thresholds

Many items reported in the system and application health reports have thresholds, or set limits. When the value meets this threshold, the item is flagged as needing your attention. For example, if the threshold for Number of failed utilities last 24 hours is greater than 3, an attention flag (>>>) will be shown if this threshold is reached, as shown in the following example in the ATN column:

ADB2ZHRP              DD1A HR - System Health Report        Row 41 to 61 of 63 
Command ===>                                                  Scroll ===> DATA 
                                                                     More: >   
Commands: EXPORT  EXCLUDES                                                     
Line commands:                                                                 
 S - Show detail report  TH - Thresholds  CTH - Create threshold               
 CEX - Create exclude  ? - Show all line commands                              
                                                                               
Sel ATN D Description                                 Value     Unit    Status 
    *   * *                                           *         *       *      
--- --- - ------------------------------------------> --------- ------- ------ 
           DDF available                              YES               OK     
           DDF THREADS INACTIVE                       YES               OK     
           TCP/IP port                                3640              OK     
           TCP/IP SECURE port                         3642              OK     
           TCP/IP RESYNC port                         3641              OK     
           Max number of active DBAT (MAXDBAT)        200                      
           Max number of connection for DBAT (CONDBAT 10000                    
           Max number of queued connections (MAXCONQN OFF                      
           Number of active DBATs (ADBAT)             1                 OK     
           Number of connections (IUDBAT + INACONN +  1                 OK     
           Number of queued connections waiting DBAT  0                 OK     
          Utilities ---------------------------------                          
        Y  Number of stopped utilities                0                 OK     
        Y  Number of utilities last 24 hours          1089                     
    >>> Y  Number of failed utilities last 24 hours   5                 NOT OK 
          Accelerator information -------------------                          
           Number of accelerators                     2                        
           Accelerators not in a healthy state        0                 OK     
           Highest CPU utilization for coordinator no 30        %       OK     
           Highest CPU utilization for worker nodes   30        %       OK     
           Highest storage utilization                0         %       OK     

You can define your own threshold values and conditions; otherwise, default values are used. You view the current threshold value in the A threshold is considered met when the actual value satisfies the specified condition (equal to, less than, less than or equal to, greater than, greater than or equal to, or not equal) for the threshold value. The threshold value, condition, and origin (default or user-defined) are listed in the report columns Threshold (the value), CD (the condition), and TO (threshold origin).

Thresholds do not apply to all report items. For those items have a blank Threshold column, a threshold cannot be defined. All other items in a report can have one defined threshold. The exception is those report items that are recommendations from the Db2 stored procedure DSNACCOX.

Report items that are DSNACCOX recommendations can have additional thresholds for DSNACCOX options. Specify these options if you want to provide your own criteria for DSNACCOX to use when determining its recommendations. For instructions, see Specifying DSNACCOX criteria for application health reports.

Excludes

You can choose to exclude certain items from a health report. For example, if you do not want the number of active buffer pools reported, you can remove this line from the report by creating an exclude. You can later add this line back to the report if needed.

If you exclude an item from a system health report, that system exclude applies to all system health reports. If you exclude an item from an application health report, that exclude can apply to either all reports for a particular group or all reports for a particular application.

For instructions on how to exclude items, see Excluding items from health reports.

Batch jobs for running health reports

As an alternative to using the ISPF panels, you can use batch jobs to run both system and application health reports. For instructions, see Running health reports in batch.

Health report database objects

To support the generation of health reports, Db2 Admin Tool maintains a health report database, which stores information about various health report objects. This database is called ADBDHR, unless you specified a different name in TCz.