PQ92279: RUNNING OBJECT COMPARE WSL RESULTS IN ONCODE150 MESSAGE STRINGSZE CONDITION FROM ADB27AC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool R310 returned ONCODE150 message when
  using a Work Statement List ( WSL ) and comparing at the table
  level.  Source table contained an additional colummn that was
  added to the middle of the table. A non-unique index exists
  on the table in both target and source.
  The job completes with RC0.
  .
   IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
    From compile unit ADB27AC at entry point ADD_ENFORCE_NO
    at statement 8254 at compile unit offset +00094C58
    at entry offset +00000554 at address 19803C00.
    From compile unit ADB27AC at entry point WRITE_NEW_LOAD_STMT
    at statement 2238 at compile unit offset
    +00025B86 at entry offset +00001542 at address 19794B2E.
  .
  Additional Symptoms:  MSGIBM0441W
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL, who also use DB2    *
  *                 Object Comparison Tool, may be affected      *
  *                 (when WSL is used).                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool R310 gave    *
  *                      " ONCODE150 Message" when using a       *
  *                      Work Statement List ( WSL ) and         *
  *                      comparing at the table level.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The problem is reported in DB2 Object Comparison Tool and the
  fix is provided in DB2 ADMIN TOOL.
  

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

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R420 PSY UQ92709

     UP04/09/15 P F409

• R510 PSY UQ92710

     UP04/09/15 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.