PH60656: OBJECT COMPARE: SQLCODE -104 WHEN COMPARE ALTERS OLD VARCHAR COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare:  SQLCODE -104 when Compare alters old
  VARCHAR column
  
  
  DESCRIPTION:  When Object Compare alters an old VARCHAR column
  (that has COLTYPE='VARBIN' in SYSIBM.SYSCOLUMNS), the generated
  CREATE TABLE statement has invalid characters after the changed
  column type and it fails with SQLCODE -104.
  

Local fix

• Replace the imported statement from ALTER COLUMN to REPLACE
  COLUMN for tables with old varchar columns as a workaround.
  
  Another workaround is to convert old varchar columns to new with
  ALTER COLUMN before analyzing the change.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Change Management (CM) apply job      *
  *                      fails with SQLCODE -104 because of      *
  *                      invalid characters in the CREATE TABLE  *
  *                      statement.                              *
  ****************************************************************
  When CM processes an ALTER COLUMN statement for an old VARCHAR
  column (that has  COLTYPE='VARBIN' in SYSIBM.SYSCOLUMNS), the
  generated CREATE TABLE statement has invalid characters in the
  definition for the altered column.
  

Problem conclusion

• The problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI97254

Modules/Macros

• ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI97254

     UP24/07/01 P F406

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.