PH02752: DB2 ADMIN TOOL - HISTORY TABLE CHANGES ARE REPORTED IN THE COMPARE BUT NOT GENERATED IN THE WORKLIST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Appending a column to temporal and history tables, Compare
  generates ALTER TABLE ADD COLUMN only for temporal table as
  Db2 appends same column to history table. However the generated
  statement fails during execution:
  
     ALTER TABLE <tablename>
           ADD OP_CODE CHAR(1) FOR SBCS DATA
           GENERATED ALWAYS AS (DATA CHANGE OPERATION) ;
  
     ADBT050E SQLERROR ON ALTER COMMAND, EXECUTE FUNCTION.
     DSNT408I SQLCODE = -20525, ERROR: THE REQUESTED ACTION IS
              NOT VALID FOR TABLE <tablename> BECAUSE THE TABLE
              IS THE WRONG TYPE OF TABLE.
              REASON CODE = 16
  
     Reason 16: An ALTER TABLE statement was specified to add a
                generated column other than a ROWID to a system-
                period temporal table or archive-enabled table.
  
     SQLCODEN20525
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
  *                 z/OS who append columns to temporal and      *
  *                 history tables.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When column appended to temporal and    *
  *                      to history tables have different        *
  *                      defaults, Object Comparison Tool        *
  *                      generates statement for changes in      *
  *                      temporal table only. Executing the      *
  *                      WSL returns SQLCODE -20525 /            *
  *                      SQLCODEN20525, READON CODE = 16         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  History Table changes are reported in the Compare but not
  generated in the WSL. When column appended to temporal and to
  history tables have different defaults, Object Comparison Tool
  should drop versioning first, alter temporal and history tables
  and add back versioning.
  

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:

  UI60203 UI60204

Modules/Macros

•    ADBTEP2  ADB2CMT  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI60203

     UP18/12/14 P F812

• RC10 PSY UI60204

     UP18/12/14 P F812

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.