Interesting bug in DB2 Z/os V8

A freind of mine encountered this bug in his shop and forwarded it to me to watch out for. I thought I will let y’all know. Its a silly bug that can crash the subsystem. Click here to go bug report

Here is the brief  description :

Problem summary

****************************************************************
* USERS AFFECTED: All DB2 users of constraints.                *
****************************************************************
* PROBLEM DESCRIPTION: ABEND04E RC00E70005 at DSNXIAB2:P068 on *
*                      ALTER TABLE DROP FOREIGN KEY.           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
DB2 is not correctly handling some error conditions when
processing constraints, which may result in unexpected symptoms,
such as ABEND04E RC00E70005 at DSNXIAB2:P068 on ALTER TABLE DROP
FOREIGN KEY.

Affected SQL statements:
CREATE TABLE PRIMARY KEY
CREATE TABLE UNIQUE
CREATE TABLE FOREIGN KEY
CREATE TABLE CHECK
ALTER TABLE ADD PRIMARY KEY
ALTER TABLE ADD UNIQUE
ALTER TABLE ADD FOREIGN KEY
ALTER TABLE ADD CHECK
ALTER TABLE DROP PRIMARY KEY
ALTER TABLE DROP UNIQUE
ALTER TABLE DROP FOREIGN KEY
ALTER TABLE DROP CHECK
ALTER TABLE DROP CONSTRAINT

											

About rpillai

I am a technology enthusiasts and love to work with databases and other technology. Learning new things everyday and don't think the path ever ends ...
This entry was posted in db2 and tagged , , , . Bookmark the permalink.