A fix is available
APAR status
Closed as program error.
Error description
Db2 Admin Tool: Alter rename column fails for table with clone DESCRIPTION: The job generated by Admin Tool fails when renaming columns in a table that has an associated clone table. The Admin Tool did everything correctly in the generated WSL except when it came to loading data back into the clone table. The load control statements being used still had the original column names so the load step fails. The failure message issued by DSNUTILB is DSNU053I ? FIELD oldcolname NOT FOUND.
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who use ALT with clone tables * **************************************************************** * PROBLEM DESCRIPTION: When using the ALT command to rename a * * column in a table that has a clone * * table, a LOAD utility operation on the * * clone table fails with an error. * **************************************************************** The user is using ALT to rename a column in a table that has a clone table. When running the change, the JCL job fails during LOAD on the clone table with following error: DSNU053I FIELD colx NOT FOUND where colx is the old column name.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH48023
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-07-15
Closed date
2022-10-03
Last modified date
2022-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82694 UI82695
Modules/Macros
ADBGAJOB
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 November 2022