PK27071: ROLLUP GA APAR FOR RECOVERY EXPERT V1.1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR will fix multiple issues in Recovery Expert v1.1 as
  part of
  a GA PTF.
  1. Storage group dependant objects are not moved to log analysis
  advisor for quiet time reporting.
  2. Plan/Package/Object Profile dependent objects are not moved
  to log
  analysis for quiet time reporting
  3. Performance degradation when trying to display large amounts
  of
  objects repeatedly.
  4. Object profiles using wildcarding not displaying tablespaces
  5. Samplib member ARYDDLA does not warn user that SYSTOOLS may
  exist
  for other products in job comments.
  6. Samplib member ARYDSCIX does not warn user that catalog
  indexes may
  already exist on catalog tables
  7. Installation jobs fail on systems using "decimal point is
  comma".
  8. Installation jobs used to create objects did not allow user
  to
  change SQLLID.
  9. Removal of Topic 1.2.2 from the README.txt.
  10. Request to add additional information to the README.txt.
  Users
  must recycle the agent to pick up new default RBA values
  11. Grouper views missing from Samplib members ARYGRT1 &
  ARYDRP1.
  12. DEXTRACT services should exclude system objects such as
  DSNDB01/DB06
  13. Changes to edit macro to include values for BSDS, ZPARM,
  SARYMENU
  14. Users unable to change the default high level qualifier for
  dataset needed to perform recoveries
  15. Group Automation Tool related objects together in samplib
  member
  ARYGRT1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR will fix multiple issues in   *
  *                      Recovery Expert v1.1 as part of a GA    *
  *                      PTF.                                    *
  *                      1. Storage group dependant objects are  *
  *                      not moved to log analysis advisor for   *
  *                      quiet time reporting.                   *
  *                      2. Plan/Package/Object Profile          *
  *                      dependent objects are not moved to log  *
  *                      analysis for quiet time reporting.      *
  *                      3. Performance degradation when trying  *
  *                      to display large amounts of objects     *
  *                      repeatedly.                             *
  *                      4. Object profiles using wildcarding    *
  *                      not displaying tablespaces.             *
  *                      5. Samplib member ARYDDLA does not      *
  *                      warn user that SYSTOOLS may exist for   *
  *                      other products in job comments.         *
  *                      6. Samplib member ARYDSCIX does not     *
  *                      warn user that catalog indexes may      *
  *                      already exist on catalog tables.        *
  *                      7. Installation jobs fail on systems    *
  *                      using "decimal point is comma".         *
  *                      8. Installation jobs used to create     *
  *                      objects did not allow user to change    *
  *                      SQLLID.                                 *
  *                      9. Removal of Topic 1.2.2 from the      *
  *                      README.txt.                             *
  *                      10. Request to add additional           *
  *                      information to the README.txt. Users    *
  *                      must recycle the agent to pick up new   *
  *                      default RBA values.                     *
  *                      11. Grouper views missing from Samplib  *
  *                      members ARYGRT1 & ARYDRP1.              *
  *                      12. DEXTRACT services should exclude    *
  *                      system objects such as DSNDB01/DB06.    *
  *                      13. Changes to edit macro to include    *
  *                      values for BSDS, ZPARM, SARYMENU.       *
  *                      14. Users unable to change the default  *
  *                      high level qualifier for dataset        *
  *                      needed to perform recoveries.           *
  *                      15. Group Automation Tool related       *
  *                      objects together in samplib member      *
  *                      ARYGRT1.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct these conditions.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    ARY#ACES ARY#CCUP ARYBND71 ARYBND81 ARYCFIOR
  ARYCFIPC ARYCFIQT ARYDB2ST ARYDDLA  ARYDDLG  ARYDDL0  ARYDDL7
  ARYDDL71 ARYDDL72 ARYDDL8  ARYDDL81 ARYDDL82 ARYDEXRI ARYDE7AN
  ARYDE7CA ARYDE7DA ARYDE7DB ARYDE7DT ARYDE7IC ARYDE7IP ARYDE7IX
  ARYDE7KA ARYDE7K0 ARYDE7K1 ARYDE7K2 ARYDE7K3 ARYDE7OT ARYDE7OX
  ARYDE7PA ARYDE7PT ARYDE7P0 ARYDE7P1 ARYDE7P2 ARYDE7P3 ARYDE7QA
  ARYDE7RA ARYDE7SA ARYDE7SG ARYDE7SR ARYDE7SV ARYDE7SY ARYDE7TA
  ARYDE7TB ARYDE7TC ARYDE7TP ARYDE7TR ARYDE7TS ARYDE7TV ARYDE7XA
  ARYDE8AN ARYDE8CA ARYDE8DA ARYDE8DB ARYDE8DT ARYDE8IC ARYDE8IP
  ARYDE8IX ARYDE8KA ARYDE8K0 ARYDE8K1 ARYDE8K2 ARYDE8K3 ARYDE8OT
  ARYZQPLN ARYZQQTJ ARYZQREN ARYZQSAV ARYZQSUB ARYZQT   ARYZQTS
  ARYZQVAL ARYZQVQT ARYZRPL  ARYZRPLN ARYZSPCE ARYZSPEC ARYZSS
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R110 PSY UK16197

     UP06/07/19 P F607

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.