PI76776: OBJECT COMPARISON TOOL VALIDATE STEP PROCESSING INDEX RESULTS IN ERRORS ADB3006E AND IBM0441W ONCODE=150

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a Compare job attempts to validate the addition of a column
  and a change in an index, the following errors may result:
  ADB3006E An error occurred while processing the Index
  schema.indexname
  object in
           column columname does not exist in the
  table.
  For CREATE INDEX statement:
  IBM0441W ONCODE=150 The STRINGSIZE condition
                     was raised.
                      From entry point VALIDATE_CREATE_INDEX
                      at statement >n< at compile unit offset
                      >offset_name< at entry offset >offset_name<
                      at address >address_name<.
  For ALTER INDEX ... ADD COLUMN or ALTER
  INDEX ... ADD INCLUDE COLUMN statement:
  IBM0441W ONCODE=150 The STRINGSIZE condition
                     was raised.
                     From entry point VALIDATE_ALTER_INDEX
                     at statement >n< at compile unit offset
                     >offset_name< at entry offset >offset_name<
                     at address >address_name<.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who run validate in the        *
  *                 compare job.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When 'Run Validate' =V' is specified    *
  *                      on panel GOC5 'Generate Compare         *
  *                      Jobs', the job fails with a RC=8 in     *
  *                      validate step TO3VAL, with error        *
  *                      message ADB3006E / msgadb3006e          *
  *                      and warning message IBM0441W            *
  *                      ONCODE=150 / ONCODE150.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When 'Run Validate' = 'V' is specified on panel
  GOC5, the job fails with a RC=8 in the validate step
  TO3VAL on a CREATE INDEX or ALTER INDEX ... ADD
  COLUMN or ALTER INDEX ... ADD INCLUDE COLUMN
  statement. Error message ADB3006E and
  informational message IBM0441W ONCODE=150 are
  observed:
  
  ADB3006E An error occurred while processing the Index
           >index_onwer<.>index_name< object in
           column >column_name< does not exist in
           the table.
  For CREATE INDEX statement:
  IBM0441W ONCODE=150 The STRINGSIZE condition
                     was raised.
                     From entry point VALIDATE_CREATE_INDEX
                     at statement >n< at compile unit offset
                     >offset_name< at entry offset >offset_name<
                     at address >address_name<.
  For ALTER INDEX ... ADD COLUMN or ALTER
  INDEX ... ADD INCLUDE COLUMN statement:
  IBM0441W ONCODE=150 The STRINGSIZE condition
                     was raised.
                     From entry point VALIDATE_ALTER_INDEX
                     at statement >n< at compile unit offset
                     >offset_name< at entry offset >offset_name<
                     at address >address_name<.
  

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

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI48498

     UP17/07/07 P F707

• RC10 PSY UI48499

     UP17/07/07 P F707

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.