PH62044: ADB7350E ADB2CMT MODULE : ADB2CMT DETECTED AN ONCODE CONDITION 520 IN COMPARE_TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALTER TABLE RENAME COLUMN failed with : ADB7350E ADB2CMT Module
  : ADB2CMT detected an ONCODE condition 520 in COMPARE_TABLES at
  xxxxx when the table has he column, the row or both access
  control.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ONCODE condition 520 occurs when        *
  *                      running ALT or Object Comparison Tool.  *
  ****************************************************************
  ONCODE condition 520 occurs when an ALTER statement is generated
  from the ALT line command or Object Comparison Tool on a table
  with row access control, column access control, or both.
  
  The following message is returned:
  ADB7350E ADB2CMT Module: ADB2CMT detected an ONCODE condition
           520 in COMPARE_TABLES at xxxxx
  
  Keywords: ACCESS CONTROL MSGADB7350E ONCODE520
  

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:

  UI98522 UI98530

Modules/Macros

• ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI98530

     UP24/09/26 P F409

• RD10 PSY UI98522

     UP24/09/26 P F409

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.