A fix is available
APAR status
Closed as program error.
Error description
A redirected recovery of a COPY YES index using a FLASHCOPY as copy base fails with abend04E RC00C20305 in DSNIOPNP at x'896C'. The user is running the following: RECOVER TABLESPACE dbname.tstarget DSNUM ALL FROM dbname.tssource TOLASTCOPY REPAIR CATALOG TABLESPACE dbname.tstarget REPAIR CATALOG INDEXSPACE dbname.ixtarget0 RECOVER INDEXSPACE dbname.ixtarget FROM dbname.ixsource TOLASTCOPY The RECOVER of the indexspace terminates with: DSNU017I ... DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C20305' Analysis of the dump shows that the non-partitioned index is opened with a wrong partition number (1 instead of zero).
Local fix
BYPASS/CIRCUMVENTION: Use a sequential image copy as recovery base.
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 13 for z/OS users running * * redirected recovery on a COPY YES * * non-partitioned index (NPI) * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C20305, * * LOC=DSNIDM.DSNIOPNP OFFSET0896C * * occurs during redirected recovery * * of a COPY YES non-partitioned index * * when executing the RECOVER * * INDEXSPACE utility. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** When executing the RECOVER INDEXSPACE utility on a COPY YES non-partitioned index, ABEND04E RC00C20305, LOC=DSNIDM.DSNIOPNP OFFSET0896C occurs. The failed RECOVER utility is a redirected recovery, where an incorrect partition number is used to open the non-partitioned index during the TRANSLAT phase, leading to the ABEND.
Problem conclusion
Db2 code has been updated to use the correct partition number when opening the non-partitioned index during the TRANSLAT phase of the RECOVER utility in redirected recovery.
Temporary fix
Comments
APAR Information
APAR number
PH65168
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2025-02-10
Closed date
2025-03-05
Last modified date
2025-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UO02349
Modules/Macros
DSNKNTRA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UO02349
UP25/03/13 P F503
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":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Document Information
Modified date:
02 April 2025