A fix is available
APAR status
Closed as program error.
Error description
Changed the default value for a nullable column, ALTER TABLE ALTER COLUMN should have been used, however, drop/recreate was used by Admin.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool for * * z/OS who alter the default value for a * * column and it is the only update for that * * column. * **************************************************************** * PROBLEM DESCRIPTION: Object Compare dropped and recreated * * a table instead of generating the * * ALTER TABLE ALTER COLUMN colname * * SET default clause when altering * * the default value and its the only * * change to that column. * **************************************************************** * RECOMMENDATION: * **************************************************************** Object Compare dropped and recreated a table instead of generating the ALTER TABLE ALTER COLUMN colname SET default clause.
Problem conclusion
Problem has been resolved. A new informational message ADB7145I is generated if the table can not be altered due to DB2 restrictions: ADB7145I Column column_name cannot be altered by the ALTER TABLE ALTER COLUMN SET WITH DEFAULT statement. Reason code reason_code. Explanation: The table can not be altered due to DB2 restrictions. The table will be dropped and re-created. See the following list for an explanation of the reason code: 1. The table must not be referenced by a view or a Materialized Query Table (MQT). 2. For LOB columns, only the default for inline LOB columns can be changed. The new default length can not be greater than the inline length. System action: Processing continues. User response: No action is required.
Temporary fix
Comments
APAR Information
APAR number
PM78895
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-12-10
Closed date
2013-05-23
Last modified date
2013-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMP ADB2CMT ADB7000
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.
[{"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":"A10"}]
Document Information
Modified date:
31 March 2021