A fix is available
APAR status
Closed as program error.
Error description
DB2 OBJECT COMPARISON TOOL FOR Z/OS incorrectly processes TIMESTAMP COLUMN when adding new tables
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * DB2 Object Comparison Tool for z/OS who * * use the Generate (GEN) function or Compare * * function against a table which contains a * * TIMESTAMP column. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS, * * when running GEN against a table * * which has a TIMESTAMP column on a * * DB2 release prior to DB2 10 New * * Function Mode (NFM), but option * * 'Target DB2 version' on panel * * ADB2GEN 'Generate SQL from DB2 * * catalog' is specified as DB2 10 * * New Function Mode or above, the * * DDL statement generated uses * * TIMESTAMP (0) instead of * * TIMESTAMP (6) as the column * * definition. * * * * In DB2 Object Comparison Tool * * for z/OS, when using Compare to * * add a table or a TIMESTAMP * * column from DB2 10 conversion * * mode to DB2 10 New Function * * Mode, the generated APPLY job * * uses TIMESTAMP (0) instead of * * TIMESTAMP (6) as the column * * definition. * **************************************************************** * RECOMMENDATION: * **************************************************************** In DB2 Administration Tool for z/OS, when running GEN against a table which has a TIMESTAMP column on a DB2 release prior to DB2 10 New Function Mode (NFM), but option 'Target DB2 version' on panel ADB2GEN 'Generate SQL from DB2 catalog' is specified as DB2 10 New Function Mode or above, the DDL statement generate uses TIMESTAMP (0) instead of TIMESTAMP (6) as the column definition. In DB2 Object Comparison Tool for z/OS, when using Compare to add a table or a TIMESTAMP column from DB2 10 conversion mode to DB2 10 New Function Mode, the generated APPLY job uses TIMESTAMP (0) instead of TIMESTAMP (6) as the column definition.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI09533
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-01-14
Closed date
2014-03-19
Last modified date
2014-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI16210 UI16211
Modules/Macros
ADB2REG
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":"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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 April 2014