A fix is available
APAR status
Closed as new function.
Error description
In DB2 Administration Tool for z/OS when changing RI key via ALC and ADDFK commands, the tool generates a DROP / CREATE solution, rather than DROP the FK relationship, perform the ALTERs, then re-establish the FK relationship. The DROP / CREATE scenario is not the preferred solution, and is inconsistent with DB2 Object Comparison Tool for z/OS handling, which performs smart ALTER.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the ALT table command to * * change the length of both primary and * * foreign keys. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for z/OS * * generates drop/create table for this * * case. A more efficient way is to DROP, * * ALTER and ADD. * **************************************************************** * RECOMMENDATION: * **************************************************************** This fix will generate a DROP FOREIGN KEY, ALTER the two related tables, then another ALTER to add the foreign key relationship back.
Problem conclusion
Temporary fix
Comments
Problem has been resolved.
APAR Information
APAR number
PM30063
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-08
Closed date
2011-04-01
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMP ADB2CMR ADB2CMT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK66440
UP11/04/08 P F104
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2011