PM17534: ONCODE=520 IN ANALYZE MERGE JOB ON CREATE FOREIGN KEY FFA10 PM18631.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When Object Comparison Tool for z/OS, Change Management
  function ANALYZE is run on a job which has multiple
  foreign keys, message failure
  ADBCCME - Error(s) found. Please review output
  Subscriptrange raised due to an internal error
  Program ADBCCMM detected an Oncode condition  520 in
  MERGE_RELATIONS.
  .
  Object details at the time of error:
  .
    Operation       : CREATE
    Object Type     : Foreign key for table
    Object Qualifier: xxxx
    Object Name     : xxxxxxxxxxxx
  .
  ADBC012E - Subscript range condition detected
  ADBC002E - Severe error. Merge terminates
  .
  Additional Symptoms: rc12 rc=12 oncode=520 msgoncode520
    oncode520
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who use the Change             *
  *                 Management function.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: During the analyze process,             *
  *                      the merge step results in an            *
  *                      ONCODE 520 (subscriptrange)             *
  *                      while processing a table that has       *
  *                      multiple foreign keys.                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The analyze results in the following error while processing
  multiple foreign keys on a table:
  
  Subscriptrange raised due to an internal error
  
  Program ADBCCMM detected
  an Oncode condition  520 in MERGE_RELATIONS.
  
  Object details at the time of error:
    Operation       : CREATE
    Object Type     : Foreign key for table
    Object Qualifier: XXXXX
    Object Name     : XXXXXXXXXXXX
  
  ADBC012E - Subscript range condition detected
  ADBC002E - Severe error. Merge terminates.
  

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:

  UK62274

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK62274

     UP10/11/23 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.