A fix is available
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 number
PI92401
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-01-12
Closed date
2018-03-07
Last modified date
2018-04-03
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.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 April 2018