PH07498: DB2 ADMINISTRATION TOOL - DROP OF A HISTORY TABLE RESULTS IN ONCODE CONDITION 8094 OR INVALID ALTER STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DROP of a HISTORY TABLE of a table with VERSIONING gets abend:
  ADB7350E Module : ADB2CMF detected an ONCODE condition 8094
           in DROP_OBJECT at 15415
  
  ADB7380E Module ADB2CMP - Severe error Compare  has been
  stopped.
  
  ERROR condition was raised
  Traceback of user routines:
  Compile Unit   Entry          Statement
                 DROP_OBJECT    15415
                 CMR0008        143
                 DROP_OBJECT_DRIVER
                                12371
                 COMPARE_FILES  6572
                 ADB2CMF        2838
                 ADB2CMP        4996
                 GOC2CMP        175
  
  Note: Statement numbers are approximate, and may vary somewhat,
        depending on release or other maintenance applied.
  
  May also see an invalid ALTER TABLE statement instead of an
  abend.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS  *
  *                 who drop a history table's table space       *
  *                 without drop versioning.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When trying to drop a table space       *
  *                      containing a history table without      *
  *                      dropping the versioning first, an       *
  *                      ERROR condition was raised and          *
  *                      Traceback of user routines shows        *
  *                      DROP_OBJECT.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When trying to drop a table space containing a history table
  without dropping the versioning first, an ERROR condition was
  raised and Traceback of user routines shows DROP_OBJECT. With
  this fix, a new error message ADB8070E will be issued instead.
  Additionally, when trying to drop a table space containing a
  history table after dropping the versioning, error ADB7220E
  occurs when attempting to drop the history table's index
  without first dropping the history table.
  Lastly, a new error message ADB8071E will be issued when
  an invalid ALTER TABLE ... DROP VERSIONING statement is
  encountered such as to drop versoning on history table but not
  on temporal table.
  
  ADB8070E Table space table_space_name cannot be dropped,
  because it contains a history table. Explanation An attempt
  was made to drop the specified table space, which contains a
  history table. As part of the Db2  restrictions for system-
  period data versioning, you cannot drop a table space that
  contains a history table.
  table_space_name:
  The qualified name of the table space.
  System action: Processing stops.
  User response: None required. However, if you still want to
  drop the specified table space, you must drop versioning
  first so that the table in the table space is no longer a
  history table.
  Related information:
  Restrictions for system-period data versioning
  
  ADB8071E Versioning cannot be dropped from table table_name
  Explanation An attempt was made to drop versioning from the
  specified table, but this DROP operation is invalid.
  table_name:
  The qualified name of the table.
  System action: Processing stops.
  User response: Read the restrictions for the DROP VERSIONING
  clause in ALTER TABLE, correct the DDL statement, and try
  again.
  

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:

Modules/Macros

•    ADBCCMM  ADB2CMT  ADB2CMU  ADB8000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62635

     UP19/04/27 P F904

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.