A fix is available
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 number
PH12076
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-14
Closed date
2019-08-02
Last modified date
2019-09-01
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 September 2019