A fix is available
APAR status
Closed as program error.
Error description
DB2 Object Restore 2.1; creating DDL after DROP of GODBTP03 database; "S" option works for some time, then ABENDs with S0C4; Object Restore encounters a S0C4 ABEND when attempting to restore a database that contains a table with identity columns SYSTEM COMPLETION CODE=0C4 REASON CODE=00000004 OFFSET=00000CDA NAME= AUO#TBG7
Local fix
The following is ZAP JCL that can run by customer to fix the problem while waiting for the SMPE fix. //AMASPZAP EXEC PGM=AMASPZAP //SYSPRINT DD SYSOUT=* //SYSLIB DD DISP=SHR,DSN=AUO.IBMTAPE.SAUOLOAD //SYSIN DD * NAME AUO#TBG7 AUO#TBG7 VER 0CD0 D21E,802A,B2D4 REP 0CD0 DD1E /*
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Object Restore. * **************************************************************** * PROBLEM DESCRIPTION: DB2 Object Restore 2.1; creating DDL * * after DROP of GODBTP03 database; * * "S" option works for some time, * * then ABENDs with S0C4; * * Object Restore encounters a S0C4 ABEND * * when attempting to restore a database * * that contains a table with identity * * columns. * * SYSTEM COMPLETION CODE=0C4 * * REASON CODE=00000004 * * OFFSET=00000CDA NAME= AUO#TBG7 * **************************************************************** * RECOMMENDATION: * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK00487
Reported component name
DB2 OBJECT REST
Reported component ID
5655E7201
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2005-02-02
Closed date
2005-02-08
Last modified date
2005-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK00382
Modules/Macros
AUO#TBG7
Fix information
Fixed component name
DB2 OBJECT REST
Fixed component ID
5655E7201
Applicable component levels
R210 PSY UK00382
UP05/02/16 P F502
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]
Document Information
Modified date:
30 March 2021