PI89309: DB2 ADMINISTRATION TOOL - COMPARE GENERATED WSL GETTING SQLCODE -650 REASON CODE 22

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare generated WSL getting SQLCODE -650 reason code 22. This
  happens when we do two modifications at same time on a table
  1) Remove the WITH DEFAULT on column in the primary key
  2) adding a column to the table and the view
  
  SQLCODEN650
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who generate WSLs              *
  *                 using Compare.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Compare operation that generates      *
  *                      a WSL fails with SQLCODE -650 /         *
  *                      SQLCODEN650 RC22 when run.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A Compare operation that generates a WSL fails with
  SQLCODE=-650 RC22 when run. The WSL contains
  statements to ALTER a table column to drop the default
  and to DROP a view. Compare need to drop the view
  first before attempting to alter the table.
  

Problem conclusion

• 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:

  UI53335 UI53336

Modules/Macros

•    ADB2CME
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI53335

     UP18/01/24 P F801

• RC10 PSY UI53336

     UP18/01/24 P F801

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.