PH34921: ALT DROP COLUMN TEMPORAL TABLE RUN REORG/REBIND = 'M' SQL ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using line command ALT and Change Management to drop a
  column from a temporal table, and specifying 'RUN REORG/REBUILD'
  = 'M' ('Mandatory') in the Analyze job, the resulting run job
  does not include any REORGs. As a result, when the run job is
  executed, the following error may occur:
  
  
  
  ALTER TABLE >tablename<  ADD VERSIONING USE HISTORY
  TABLE >tablename< ON DELETE ADD EXTRA ROW;
  
  ADBT050E SQLERROR ON ALTER COMMAND, EXECUTE
                   FUNCTION.
  ADB7953I SQL statement:
  ADB7955E SQL error:
  ADB7955E DSNT408I SQLCODE = -20385, ERROR: THE
                    STATEMENT CANNOT BE PROCESSED
  ADB7955E          THERE ARE PENDING DEFINITION CHANGES
                    FOR OBJECT >tablespace name<
  ADB7955E          TYPE TABLESPACE (REASON 2)
  ADB7955E DSNT418I SQLSTATE = 57007 SQLSTATE RETURN
                    CODE
  ADB7955E DSNT415I SQLERRP = DSNXIATB SQL PROCEDURE
                    DETECTING ERROR
  ADB7955E DSNT416I SQLERRD = 315 0 0 -1 0 0 SQL
                    DIAGNOSTIC INFORMATION
  ADB7955E DSNT416I SQLERRD = X'0000013B' X'00000000'
                    X'00000000' X'FFFFFF
  ADB7955E X'00000000' X'00000000' SQL DIAGNOSTIC
                    INFORMATION
  
  ADB5185E The run is ending due to errors.
  
  ADBT010W Rollback performed due to previous error
  
  
  
  Keywords:
  msgadb7955e;msgadb5185E;msgadbT010W;msgadbt050e;sqlcode20385n
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Object Comparison Tool for z/OS          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error ADB7955E is returned              *
  *                      when running a WSL that                 *
  *                      drops a column in a temporal            *
  *                      and history table pair or               *
  *                      archive-enabled and archive             *
  *                      table pair.                             *
  ****************************************************************
  A change includes dropping a column from either a temporal
  table and its associated history table or an archive-enabled
  table and its associated archive table.
  Analyzing this change with the RUN REORG/REBUILD option
  set to M (Mandatory) might create a WSL that is missing a
  REORG before adding versioning or enabling archiving.
  
  Running the WSL might result in the following error:
  
  ADB7955E DSNT408I SQLCODE = -20385, ERROR: THE STATEMENT CANNOT
           BE PROCESSED
  ADB7955E THERE ARE PENDING DEFINITION CHANGES FOR OBJECT
           >databse_name<.>tablespace_name<
  ADB7955E TYPE TABLESPACE (REASON 2)
  ADB7955E DSNT418I SQLSTATE = 57007 SQLSTATE RETURN CODE
  ADB7955E DSNT415I SQLERRP = DSNXIATB SQL PROCEDURE
           DETECTING ERROR
  ADB7955E DSNT416I SQLERRD = 315 0 0 -1 0 0 SQL DIAGNOSTIC
           INFORMATION
  ADB7955E DSNT416I SQLERRD = X'0000013B' X'00000000' X'00000000'
                              X'FFFFFFFF'
  ADB7955E X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: SQLCODE20385N MSGADB7955E
  

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:

  UI75684

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75684

     UP21/07/02 P F106

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.