PI21091: DB2 OBJECT COMPARISON TOOL FOR Z/OS RESULTS IN ERROR IBM0342S ONCODE=340 THE SIZE CONDITION WAS RAISED..

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS ends with error message
  IBM0342S ONCODE=340  The SIZE condition was raised..
           From entry point COMPARE_TABLES at statement xxxx
  msgIBM0342S
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare Materialized Query      *
  *                 Tables (MQT) for which the DDL is greater    *
  *                 than 32K in length.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool for z/OS     *
  *                      ends with an ONCODE=340 / ONCODE340     *
  *                      error message when comparing            *
  *                      Materialized Query Tables for which     *
  *                      the DDL is greater than 32K in          *
  *                      length.                                 *
  *                                                              *
  *                      IBM0342S ONCODE=340  The SIZE           *
  *                      condition was raised.                   *
  *                      From entry point COMPARE_TABLES         *
  *                      at statement 11973 at compile unit      *
  *                      offset +0005374E at entry offset        *
  *                      +0005374E at address 3B66BF36.          *
  *                                                              *
  *                      The following ONCODE340 /               *
  *                      ONCODE=340 and ONCODE150 /              *
  *                      ONCODE=150 errors can also              *
  *                      be observed when DEBUG=6                *
  *                      is used to run the compare:             *
  *                                                              *
  *                      IBM0441W  ONCODE=150  The               *
  *                      STRINGSIZE condition was                *
  *                      raised.                                 *
  *                      From entry point SORT_FILES at          *
  *                      statement 6951 at compile unit          *
  *                      offset +00001706 at entry offset        *
  *                      +00001706 at address 3B1C9C0E.          *
  *                                                              *
  *                      IBM0342S ONCODE=340  The                *
  *                      SIZE condition was raised.              *
  *                      From entry point                        *
  *                      DUMP_SYMBOL_TABLE at                    *
  *                      statement 32114 at compile              *
  *                      unit offset +00002606 at entry          *
  *                      offset +00002606 at address             *
  *                      3B3B5B0E.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Object Comparison Tool for z/OS ends with an ONCODE=340 /
  ONCODE340 error message when comparing Materialized Query
  Tables for which the DDL is greater than 32K in length:
  
  IBM0342S ONCODE=340  The SIZE condition was raised.
  From entry point COMPARE_TABLES at statement 11973
  at compile unit offset +0005374E at entry offset
  +0005374E at address 3B66BF36.
  
  The following ONCODE340 / ONCODE=340 and ONCODE150 /
  ONCODE=150 errors can also be observed when DEBUG=6
  is used to run the compare:
  
  IBM0441W  ONCODE=150  The STRINGSIZE condition
  was raised.
  From entry point SORT_FILES at statement 6951 at
  compile unit offset +00001706 at entry offset
  +00001706 at address 3B1C9C0E.
  
  IBM0342S ONCODE=340  The SIZE condition was raised.
  From entry point DUMP_SYMBOL_TABLE at statement
  32114 at compile unit offset +00002606 at entry
  offset +00002606 at address 3B3B5B0E.
  

Problem conclusion

• Problems have 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

•    ADB2CMP  ADB2CMR  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI22965

     UP14/11/14 P F411

• RB10 PSY UI22966

     UP14/11/18 P F411

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.