PH29634: CAPACITY PLANNING AND FORECASTING FOR DB2

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Capacity planning and forecasting for DB2 is not provided in
  IBM Z Performance and Capacity Analytics.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Z Performance and Capacity Analytics     *
  *                 users who want to perform capacity           *
  *                 planning and forecasting for Db2.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Capacity planning and forecasting for   *
  *                      Db2 is not provided with IBM Z          *
  *                      Performance and Capacity Analytics.     *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF                       *
  ****************************************************************
  IBM Z Performance and Capacity Analytics definitions do not
  support capacity planning and forecasting for Db2.
  

Problem conclusion

Temporary fix

Comments

• Conclusion:
  
  1.IBM Z Performance and Capacity Analytics is enhanced to add
   the following tables and views:
  
  A) Db2 package level tables & views:
  
  Table                View
  
  CP_DB2_PACK_T, CP_DB2_PACK_TV
  CP_DB2_PACK_H, CP_DB2_PACK_HV
  CP_DB2_PACK_D, CP_DB2_PACK_DV
  CP_DB2_PACK_W, CP_DB2_PACK_WV
  CP_DB2_PACK_M, CP_DB2_PACK_MV
  
  B) Db2 plan level tables & views:
  
  Tables              Views
  
  CP_DB2_PLAN_T, CP_DB2_PLAN_TV
  CP_DB2_PLAN_H, CP_DB2_PLAN_HV
  CP_DB2_PLAN_D, CP_DB2_PLAN_DV
  CP_DB2_PLAN_W, CP_DB2_PLAN_WV
  CP_DB2_PLAN_M, CP_DB2_PLAN_MV
  
  C) Db2 Subsystem level tables & views:
  
  Tables                Views
  
  CP_DB2_SYSTEM_T, CP_DB2_SYSTEM_TV
  CP_DB2_SYSTEM_H, CP_DB2_SYSTEM_HV
  CP_DB2_SYSTEM_D, CP_DB2_SYSTEM_DV
  CP_DB2_SYSTEM_W, CP_DB2_SYSTEM_WV
  CP_DB2_SYSTEM_M, CP_DB2_SYSTEM_MV
  CP_DB2_SYSTEM_F, CP_DB2_SYSTEM_FV
  
  D) Db2 User (Authid) Level Tables & Views
  
  Tables               Views
  
  CP_DB2_USER_T, CP_DB2_USER_TV
  CP_DB2_USER_H, CP_DB2_USER_HV
  CP_DB2_USER_D, CP_DB2_USER_DV
  CP_DB2_USER_W, CP_DB2_USER_WV
  CP_DB2_USER_M, CP_DB2_USER_MV
  
  2.IBM Z Decision Support and IBM Z Performance and Capacity
  Analytics are enhanced to provide the following out-of-the-
  box Cognos reports for the CP DB2 component:
  
  CPDB201 DB2 MVS System Analysis
  CPDB202 DB2 System Analysis
  CPDB203 DB2 Plan Analysis
  CPDB204 DB2 Plan Trend by Month
  CPDB205 DB2 Plan Trend by Week
  CPDB206 DB2 Plan Trend by Day
  CPDB207 DB2 Plan Trend by Hour
  CPDB208 DB2 Plan Trend by Timestamp
  CPDB209 DB2 Package Analysis
  CPDB210 DB2 Package Trend by Month
  CPDB211 DB2 Package Trend by Week
  CPDB212 DB2 Package Trend by Day
  CPDB213 DB2 Package Trend by Hour
  CPDB214 DB2 Package Trend by Timestamp
  CPDB215 DB2 User Trend by Month
  CPDB216 DB2 User Trend by Week
  CPDB217 DB2 User Trend by Day
  CPDB218 DB2 User Trend by Hour
  CPDB219 DB2 User Trend by Timestamp
  CPDB220 DB2 System Forecast
  
  Furthermore, the reports contain the following
  drill-throughs:
  DB2 MVS System Analysis
      -> DB2 System Analysis
          -> DB2 Plan Analysis
              -> DB2 Plan Trend
              -> DB2 Package Analysis
                  -> DB2 Package Trend
                  -> DB2 User Trend
              -> DB2 Package Trend
              -> DB2 User Trend
          -> DB2 Plan Trend
              -> DB2 Package Trend
              -> DB2 User Trend
          -> DB2 User Trend
      -> DB2 User Trend
  
  3.IBM Z Decision Support and IBM Z Performance and Capacity
  Analytics is enhanced to add the following forecast Configs.
  
    FC_DB2_SYSTEM_W_6M
    PFC_DB2_SYSTEM_W_6M
  
  4. The following documentation addendum is added to IBM Z
  Decision Support and IBM Z Performance and Capacity Analytics.
  
  A new section entitled 'Capacity Planning for Db2'
  is included as a downloadable PDF file.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI75934 UI75935 UI75936

Modules/Macros

• DRLDOD17 DRLICPDB DRLJCP0A DRLJMTVK DRLPJFC  DRLSCPDB DRLTCPD1
  DRLTCPD2 DRLTCPD3 DRLTCPD4 DRLTCPL6 DRLTKZH3 DRLTKZH7 DRLUCPD1
  DRLUCPD2 DRLWC31M DRLWCPCA DRLWECPA DRLWEING DRLWS000 DRLWS001
  DRLWS002 DRLWSPCA
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• RC01 PSY UI75934

     UP21/06/25 P F106

• RCA8 PSY UI75936

     UP21/06/25 P F106

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.