PI40261: DB2 OBJECT COMPARE ENDS RC(0) BUT RETURNS: IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Compare ends rc(0) but at end of output the following
  error is reported:
        IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
           From entry point STORE_MQT_CREATE at statement 36621 at
                compile unit offset +00000572 at entry offset
                +00000572 at address 3B94E7D2.
           From entry point COMPARE_TABLES at statement 6941 at
                compile unit offset +00016F36 at entry offset
                +00016F36 at address 3B9FA7FE.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who run Object Compare         *
  *                 with Materialized Query Tables (MQT).        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running compare with MQTs, Object  *
  *                      Compare may end with a Return Code 0 /  *
  *                      RC=0 but returns an ONCODE150 /         *
  *                      ONCODE=150 error in the SYSOUT          *
  *                      DD:                                     *
  *                                                              *
  *                      IBM0441W  ONCODE=150  The STRINGSIZE    *
  *                      condition was raised.                   *
  *                      From entry point STORE_MQT_CREATE       *
  *                      at statement 36621 at compile unit      *
  *                      offset >offset< at entry offset         *
  *                      >offset< at address >address<..         *
  *                                                              *
  *                      This ONCODE=150 error does not affect   *
  *                      the correctness of the Object Compare   *
  *                      report and the APPLY job / Work         *
  *                      Statement List ( WSL ) generated.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running compare with MQTs involved, Object Compare may
  end with a Return Code 0 / RC=0 but returns an ONCODE150 /
  ONCODE=150 error in the SYSOUT DD.
  
  This ONCODE=150 error does not affect the correctness of the
  Object Compare report and the APPLY job / Work Statement
  List ( WSL ) generated.
  

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:

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI29162

     UP15/07/10 P F507

• RB10 PSY UI29163

     UP15/07/10 P F507

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.