PM93670: WSL VALIDATION FAILED FOR DROP/RECREATE TEMPORAL TABLE CONTAINS LOB COLUMN,REORG UTILITY NOT GENERATED AFTER ALTER TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS.
  WSL validation failed for drop/recreate temporal table contains
  LOB column, the auxiliary table of the history table is dropped
  without being recreated in the change file.
  REORG utility not generated after ALTER TABLE ADD HASH statement
  even if REORG/REBUILD = Mandatory or ALL relevant.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who have dropped and created ahistory   *
  *                 table with a LOB column, or created a hash   *
  *                 table from a regular table.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes the following issues:   *
  *                                                              *
  *                      1 - When a history table with an        *
  *                      auxiliary table is dropped and created, *
  *                      the auxiliary table is not recreated    *
  *                      which causes the Validation step to     *
  *                      fail with the following error:          *
  *                                                              *
  *                      ADB3002E Error processing Index         *
  *                      >schema<.>table-name<_HIST_AUXIX in     *
  *                      CREATE statement: Table                 *
  *                      >schema<.>table-name<_HIST_AUX does     *
  *                      not exist.                              *
  *                                                              *
  *                      2 - When a regular table is altered to  *
  *                      become a hash table, a DB2 REORG        *
  *                      utility is created to remove the table  *
  *                      space from Advisory REORG-pending       *
  *                      (AREOR) status.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR fixes the following issues:
  
  1 - An auxiliary table of a dropped history table is not
  created by DB2 Object Compare.
  
  2 - When a regular table is altered to become a hash table,
  a DB2 REORG utility is created to remove the table space
  from Advisory REORG-pending (AREOR) status.
  

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

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK97937

     UP13/09/28 P F309

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.