A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS Change Management file created by the product changes the definition of the DECIMAL column in a SEQUENCE from DECIMAL(15) to DECIMAL(10) without warning when the "Generate apply jobs . . . . CHANGE" aka CMDELTA option is specified on panel GOC5 Generate Compare Jobs.
Local fix
Do not use the "Generate apply jobs CHANGE" / CMDELTA path to implement your change, import the DDL into Change Management directly.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool for * * z/OS who create sequences. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool DDL * * Reader ignores the user specified * * length for a decimal data type and * * uses an invalid default length of 10. * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Object Comparison Tool DDL Reader's failure to set the user specified data type length results in a DB2 processing error SQLCODEN846: DSNT408I SQLCODE = -846, ERROR: INVALID SPECIFICATION OF AN IDENTITY COLUMN OR SEQUENCE OBJECT sequence_name. REASON CODE = 2
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM31702
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-02-01
Closed date
2011-02-28
Last modified date
2011-04-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK65305
Modules/Macros
ADBCDTS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK65305
UP11/03/04 P F103
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:
04 April 2011