PH44947: OBJECT COMPARE: STRINGSIZE CONDITION WITH ERROR: " ONCODE()=" 150"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare:  Stringsize condition with Error: "
  oncode()=" 150"
  
  
  DESCRIPTION:  A STRINGSIZE error is generated from the parser
  when processing a subselect with many correlational tables. The
  procedure that handles this when copying information over to a
  new structure was using incorrect indices on the re-assignment.
  
  
  example
  
  Stringsize raised Error: " oncode()="      150"
  onloc()="RESOLVE_COMMON_TAB"
  online()="
  ond()="" oncondid()="            18"
  Check the names aren't too long
  Length of stmt:  11461
  
  CREATE VIEW c1.v1 AS WITH RUN_TT AS(SELECT  etc.
  
  STRINGSIZE condition was raised
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: A stringsize error occurs when the      *
  *                      parser processes a view.                *
  ****************************************************************
  When invoking the parser on view, DDL that contains many
  correlational tables might result in the following error:
  
  Stringsize raised
  Error: " oncode()="      150" onloc()="RESOLVE_COMMON_TAB"
  online()=">line_number<" onoffset()=">offset<" oncondc
  ond()="" oncondid()="            18"
  Check the names aren't too long
  Length of stmt:  >size_of_statement<
  
  Keyword: ONCODE150
  

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:

  UI81113

Modules/Macros

• ADB2PA7
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81113

     UP22/06/23 P F206

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.