PH47164: OBJECT COMPARE GENERATING IBM0421S ONCODE 520 AND IBM0441W ONCODE 150

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare raises an oncode 520 SUBSCRIPTRANGE - per IBM
  documentation: An array subscript exceeded the declared bound
  for the array.
  
  Compare raises an oncode 150 STRINGSIZE - per IBM documentation:
  A string was assigned to a shorter string, causing right-hand
  characters or bits in the source string to be truncated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) Comparing DDL for views results in   *
  *                      ONCODE 520.                             *
  *                                                              *
  *                      2) Comparing tables results in ONCODE   *
  *                      150.                                    *
  ****************************************************************
  1) A comparison that involves many views with a large number of
  table references can result in the following error:
  
  IBM0421S ONCODE=520  The SUBSCRIPTRANGE condition was raised.
  From entry point COMPARE_VIEWS at statement 23086 at
  compile unit offset >unit_offset< at entry offset
  >entry_offset< at address >address<.
  
  Note: The statement number might change based on the current
  maintenance level.
  
  2) A comparison between tables might result in the following
  warning message:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point COMPARE_FILES at statement 3824 at compile
  unit offset >unit_offset< at entry offset >entry_offset<
  at address >address<.
  
  Note: The statement number might change based on the current
  maintenance level.
  
  Keyword: ONCODE520S, ONCODE150W
  

Problem conclusion

• The problem is 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:

  UI82003

Modules/Macros

• ADB2CME  ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI82003

     UP22/08/20 P F208

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.