A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' APPLY jobs fails with a return code 1012 / RC1012 and a message: ---------------------------------------------------------------- ADB27AC - Conversions for Alter Column(s) ---------------------------------------------------------------- ADBC001I Alter for table BA.BA09RSTB ADBC139E INTFIN and C001 mismatch. Colnames not Equal INTFIN: <blank> C001 : <col-name>
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * the DB2 Object Comparison Tool for z/OS who * * run an APPLY job to insert a NOT NULL NO * * DEFAULT column into a table and choose High * * Performance Unload (HPU) as the UNLOAD * * method. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool's APPLY * * job fails in the ADB27AC CONVERT step * * with error message ADBC139E: * * INTFIN and C001 mismatch. Columns * * not Equal, when High Performance * * Unload (HPU) is used as the Unload * * method. * * * * This APAR also fixes the following * * problems: * * * * 1. In the APPLY DDL, partition * * number in the ALTER PARTITION * * statement is truncated when the * * partition number is greater than * * 100, which causes SQLERROR = * * -644 / SQLCODEN644 during the * * APPLY: * * * * 2. Compare issues message * * IBM0441W ONCODE=150 The * * STRINGSIZE condition was raised, * * From entry point ALTERED_DROPFK. * * Compare may fail with ABEND=S000 * * U4083 REASON=00000002. * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Administration Tool's APPLY job fails in the ADB27AC CONVERT step with error message MSGADB139E: INTFIN and C001 mismatch. Columns not Equal, when High Performance Unload (HPU) is used as the Unload method. This APAR also fixes the following problems: 1. In the APPLY DDL, partition number in the ALTER PARTITION statement is truncated when the partition number is greater than 100, which causes SQLERROR = -644 / SQLCODEN644 - 'INVALID VALUE SPECIFIED FOR KEYWORD OR CLAUSE PART IN STATEMENT ALTER' during the APPLY. 2. Compare issues message IBM0441W ONCODE150 The STRINGSIZE condition was raised, From entry point ALTERED_DROPFK. Compare may fail with ABEND=S000 U4083 REASON=00000002. Additional symptons: ABENDU4083 RC02 RSN02
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM42495
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-06-27
Closed date
2011-08-31
Last modified date
2011-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMF ADB2CMP ADB27AC
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK71423
UP11/09/02 P F109
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:
03 October 2011