PI92401: INTERNAL APAR RESOLVING MULTIPLE ISSUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This internal APAR resolves the following issues:
  1) "ARYA107E-No useable image copy found for tablespace" for
   Undo SQL recovery plans involving LOB tablespaces.
  2) ARYB209E - SQL error occurred in ARYCRL9D on line 313.
   SQLCODE = -805.
  3) Bind warnings for SQLCODE=-206 TOKENS=TP.LIMITKEY_INTERNAL
   after v11 to v12 migration.
  4) ARYX65535I during the Recovery JCL generation.
  5) PLAN setting is ignored by the batch utility if PIT=CURRENT.
  6) ABEND U0066 for Undo SQL recovery plans.
  7) Typo in ARYR411E message.
  8) Recovery fails trying to recover an object at the SG level.
  9) VSAM ICs are not used as a source of recovery.
  10) Incorrect PLAN IS INVALID message for cloned object.
  11) DSNUM not coded for IC during Fast Replication Recovery.
  12) Contention errors during the parallel recovery of
   COPY YES indexes.
  13) SLR records for auxiliary relations are not updated after
   some ALTERs.
  14) 'Reset ISPF client passwords' does not work.
  15) ARYX093S - An unexpected error occurred
   (./AryAgentRequestGenRecPlans.cpp,294) for empty profiles.
  16) Message "ARYZ090E - Any 'automatic' image copy should be
   of 'Local Primary' type." is issued incorrectly randomly.
  17) Default indexspace bufferpool can't be specified for ARY
   database.
  18) Default value of 'Qualifier for Db2 Automation Tool objects'
   is changed from 'HAA' to 'DLC'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Recovery Expert z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: This internal APAR resolves the followi *
  *                      1s "ARYA107E-No useable image copy      *
  *                       found for tablespace" for              *
  *                       Undo SQL recovery plans involving      *
  *                       LOB tablespaces.                       *
  *                      2. ARYB209E - SQL error occurred in     *
  *                       ARYCRL9D on line 313. SQLCODE = -805.  *
  *                      3. Bind warnings for SQLCODE=-206       *
  *                       TOKENS=TP.LIMITKEY_INTERNAL            *
  *                       after v11 to v12 migration.            *
  *                      4. ARYX65535I during the Recovery JCL   *
  *                       generation.                            *
  *                      5. PLAN setting is ignored by the       *
  *                       batch utility if PIT=CURRENT.          *
  *                      6. ABEND U0066 for Undo SQL recovery    *
  *                       plans.                                 *
  *                      7. Typo in ARYR411E message.            *
  *                      8. Recovery fails trying to recover an  *
  *                       object at the SG level.                *
  *                      9. VSAM ICs are not used as a source    *
  *                       of recovery.                           *
  *                      10. Incorrect PLAN IS INVALID message   *
  *                       for cloned object.                     *
  *                      11. DSNUM not coded for IC during Fast  *
  *                       Replication Recovery.                  *
  *                      12. Contention errors during the        *
  *                       parallel recovery of COPY YES indexes. *
  *                      13. SLR records for auxiliary           *
  *                       relations are not updated after        *
  *                       some ALTERs.                           *
  *                      14. 'Reset ISPF client passwords' does  *
  *                       not work.                              *
  *                      15. ARYX093S - An unexpected error      *
  *                       occurred                               *
  *                       (./AryAgentRequestGenRecPlans.cpp,294) *
  *                       for empty profiles.                    *
  *                      16. Message "ARYZ090E - Any 'automatic' *
  *                       image copy should be of 'Local         *
  *                       Primary' type." is issued incorrectly  *
  *                       randomly.                              *
  *                      17. Default indexspace bufferpool       *
  *                       can't be specified for ARY database.   *
  *                      18. Default value of 'Qualifier for     *
  *                       Db2 Automation Tool objects'           *
  *                       is changed from 'HAA' to 'DLC'.        *
  ****************************************************************
  * 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:

  UI54327

Modules/Macros

•    ARY$$PRM ARY$$SEQ ARY$ADMN ARY$BPRC ARY$CONV
  ARY$DEVT ARY#CSIA ARY#ISPS ARY#LSQL ARY@BAKO ARY@DB2R ARY@MJCR
  ARY@SIMX ARYACONN ARYACSTL ARYAFDCM ARYAFLST ARYALOG2 ARYALST2
  ARYAMETL ARYARYST ARYASQLE ARYAUTIL ARYBIND1 ARYBIND2 ARYBIND3
  ARYCAL9D ARYCAL9L ARYCAL9S ARYCAQ1D ARYCAQ1L ARYCAQ1S ARYCCT9D
  ARYCCT9L ARYCCT9S ARYCDB9D ARYCDB9L ARYCDB9S ARYCDPND ARYCDPNL
  ARYCDPNS ARYCDTND ARYCDTNL ARYCDTNS ARYCDT0D ARYCDT0L ARYCDT0S
  ARYCDT1D ARYCDT1L ARYCDT1S ARYCDT9D ARYCDT9L ARYCDT9S ARYCD001
  ARYCD002 ARYCFNND ARYCFNNL ARYCFNNS ARYCFN0D ARYCFN0L ARYCFN0S
  ARYCFN9D ARYCFN9L ARYCFN9S ARYCIXND ARYCIXNL ARYCIXNS ARYCIX0D
  H30R320J
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI54327

     UP18/03/22 P F803

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.