PI80997: RECOVERY PLANS NOT GENERATED IF AUTOMATION TOOL OBJECT PROFILE USE " ADVANCED SQL "

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a recovery plan generation is attempted using an Automation
  Tool object profile that contains "Advanced SQL" we see message:
    .
    ARYZ017E - No objects to recover were found" is displayed.
  .
  It appears that the dynamic SQL (created by using the "Advanced
  SQL" option) in the Automation Tool object profile is not run by
  ARY when generating recovery plans.
  
  NOTE: Advanced SQL for object selection was introduced in
        Automation Tool V4.1 in 2013.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a recovery plan generation is      *
  *                      attempted using an Automation           *
  *                      Tool object profile that contains       *
  *                      "Advanced SQL" we see message:          *
  *                        ARYZ017E - No objects to recover      *
  *                         were found" is displayed.            *
  *                      It appears that the dynamic SQL         *
  *                      (created by using the "Advanced         *
  *                      SQL" option) in the Automation Tool     *
  *                      object profile is not run by            *
  *                      ARY when generating recovery plans.     *
  *                      NOTE: Advanced SQL for object selection *
  *                            was introduced in Automation Tool *
  *                            V4.1 in 2013.                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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$$SEQ
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI48809

     UP17/07/22 P F707

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.