A fix is available
APAR status
Closed as program error.
Error description
When a table containing a primary key is dropped, the foreign key references from child tables are also dropped. When AUO restores the Parent table it will not generate ALTER ADD statements to restore the foreign keys on the undropped child tables. This fix will add the ability for AUO to restore these foreign keys. ** This applies to tables within the same table space only.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Object Restore. * **************************************************************** * PROBLEM DESCRIPTION: When a table containing a primary key * * is dropped, the foreign key references * * from child tables are also dropped. * * When AUO restores the Parent table it * * will not generate ALTER ADD statements * * to restore the foreign keys on the * * undropped child tables. This fix will * * add the ability for AUO to restore * * these foreign keys. ** This applies to * * tables within the same table space * * only. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK55537
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
2007-10-26
Closed date
2008-02-07
Last modified date
2008-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK33526
Modules/Macros
AUO$MAIN AUO#BPV7 AUO#BPV8 AUO#BPV9 AUO#RIAF AUO#SVCI AUO@DDL7 AUO@DDL8 AUO@F7RI AUO@F8RI AUO@JCL8 AUO@REC7 AUO@RIG7 AUO@RIG8 AUO@XSQL AUOCHKDT AUODB2L AUOSTR01 AUOSTR03 AUOSTR04 AUOSTR4A AUOSTR4B AUOXDDL H23L210J
Fix information
Fixed component name
DB2 OBJECT REST
Fixed component ID
5655E7201
Applicable component levels
R210 PSY UK33526
UP08/02/15 P F802
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:
17 March 2021