PH18943: DB2 OBJECT COMPARISON TOOL ALTER ARCHIVE BASE TABLES WSL RUN JOB SQLCODE = -20554 / SQLCODEN20554

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using Object Compare to generate a WSL for ALTERs
  to both an archive table and a base table, and the
  tablespace name for the archive table alphabetically precedes
  that of the base table, the ALTER statement for the archive
  table will precede the ALTER for the base table in the WSL.
  The execution of these statements in this order may result
  in the following error at run time:
  
  
  DSNT408I SQLCODE = -20554, ERROR: TABLE >tablename<
  WAS SPECIFIED AS AN ARCHIVE TABLE, BUT THE TABLE DEFINITION IS
  NOT VALID FOR AN ARCHIVE TABLE. REASON CODE 10
  
  ADB5185E The run is ending due to errors.
  ADBT010W Rollback performed due to previous error
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 Z/OS who use archive and archive-enabled     *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an archive table's tablespace is   *
  *                      processed before its archive-enabled    *
  *                      pairing's tablespace due to how they    *
  *                      are named, Compare may produce a WSL    *
  *                      that, when run, results in              *
  *                      SQLCODE = -20554.                       *
  ****************************************************************
  Tablespaces are processed in a sorted alphabetical order. This
  can create scenarios when an archive table's tablespace is
  processed before its archive-enabled pairing's tablespace. In
  this case, Compare may create a WSL that contains DDL in the
  incorrect order. When executing this WSL it may result in a
  SQLCODE = -20554 error:
  
  DSNT408I SQLCODE = -20554, ERROR: TABLE >tablename<
  WAS SPECIFIED AS AN ARCHIVE TABLE, BUT THE TABLE DEFINITION IS
  NOT VALID FOR AN ARCHIVE TABLE. REASON CODE 10
  

Problem conclusion

• The issue 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:

  UI67438

Modules/Macros

• ADB2CMO  ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67438

     UP20/02/04 P F001

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.