A fix is available
APAR status
Closed as program error.
Error description
DB2 Object Comparison Tool generates drop / create scenario when table columns are changed from VARCHAR to CHAR datatype. This datatype change can lead to invalid LOAD utility statements with incorrect POSITION parameters. . Reported case shows start value larger than end value: POSITION( 1048: 1047) LOAD utility fails rc8 rc08 with msgdsnu048i
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison * * Tool for z/OS generating a drop / create * * scenario where table columns are * * changed from VARCHAR to CHAR * * data type, but the column length does * * not change. * **************************************************************** * PROBLEM DESCRIPTION: When the DB2 Object Comparison * * Tool generates a drop / create * * scenario where table columns are * * changed from VARCHAR to CHAR * * data type, this change can lead * * to invalid LOAD utility statements * * with incorrect POSITION parameters, * * causing the LOAD utility to fail with * * rc8 and message DSNU048I , * * "INVALID OPERAND FOR * * KEYWORD POSITION". * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** The ending POSITION value was being incorrectly calculated for a column change from VARCHAR to CHAR when the column length did not change, and the ALTER Column Truncation action is Truncate in the IFF file--which is always set to Truncate by Object Compare.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM18752
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-19
Closed date
2010-10-27
Last modified date
2011-02-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB27AC
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK61717
UP10/11/02 P F011
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":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 February 2011