PH12076: DELETE RECEIVED ABEND04E DSNIDILS 5005 AFTER ALTER DROP CLONE AND ALTER ADD COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DELETE received 04E DSNIDILS ERQUAL5005 after ALTER DROP CLONE
  & ALTER ADD COLUMN, because DSNIDILS was given wrong OBFREC with
  OBDRECID = 8003
  SQLs being performed:
   ALTER TABLE base_table DROP CLONE ;
   ALTER TABLE base_table ADD COLUMN c1 ;
   ALTER TABLE base_table ADD COLUMN c2 ;
   ALTER TABLE base_table ADD COLUMN c3 ;
   DELETE FROM base_table WHERE ...  ;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Db2 for z/OS V12 with clone                     *
  * tables                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABND=04E-00C90101 DSNIDILS:5005                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Db2 internal error triggered when trying to delete a row and
  the table ID did not match the versioning meta data control
  block that describes the row even though the meta information
  was correct. This may happen when meta data saved in the
  system page has a table id indicating that table is a clone.
  If the data set is exchanged then the base table now has the
  clone table system page. The clone is then dropped followed
  by altering the base table to create data versioning. A Db2
  internal sanity check that does not consider if the meta data
  was originally created when a clone table existed will result
  in an ABNEND04E.
  
  
  
  Example SQL to recreate this abend:
  ALTER TABLE T1 ADD CLONE T11;
  INSERT INTO T1
  INSERT INTO T11
  EXCHANGE DATA BETWEEN TABLE T1 AND T11;
  INSERT INTO T1
  INSERT INTO T11
  ALTER TABLE T1 DROP CLONE;
  ALTER TABLE T1 ADD C3 INTEGER;
  DELETE FROM T1 WHERE ...;
  

Problem conclusion

• Db2 code updated to compare the correct ID value based on
  original meta information when comparing table with data
  versioning control blocks.
  

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:

  UI64577

Modules/Macros

• DSNIDILS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI64577

     UP19/08/17 P F908

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.