{"id":417,"date":"2009-08-14T10:21:15","date_gmt":"2009-08-14T04:21:15","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=417"},"modified":"2016-01-07T11:31:11","modified_gmt":"2016-01-07T05:31:11","slug":"interesting-bug-in-db2-zos-v8","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=417","title":{"rendered":"Interesting bug in DB2 Z\/os V8"},"content":{"rendered":"<p>A freind of mine encountered <a href=\"http:\/\/www-01.ibm.com\/support\/docview.wss?rs=0&amp;dc=DB550&amp;uid=swg1PK73452&amp;loc=en_US&amp;cs=utf-8&amp;lang=\" target=\"_blank\">this bug<\/a> in his shop and forwarded it to me to watch out for. I thought I will let y&#8217;all know. Its a silly bug that can crash the subsystem. <a href=\"http:\/\/www-01.ibm.com\/support\/docview.wss?rs=0&amp;dc=DB550&amp;uid=swg1PK73452&amp;loc=en_US&amp;cs=utf-8&amp;lang=\" target=\"_blank\">Click here to go bug report<\/a><\/p>\n<p>Here is the brief \u00c2\u00a0description :<\/p>\n<p style=\"text-align: left;\"><strong><span style=\"color: #3366ff;\">Problem summary<\/span><\/strong><\/p>\n<pre style=\"text-align: left;\"><span style=\"color: #3366ff;\">****************************************************************\r\n* USERS AFFECTED: All DB2 users of constraints.                *\r\n****************************************************************\r\n* PROBLEM DESCRIPTION: ABEND04E RC00E70005 at DSNXIAB2:P068 on *\r\n*                      ALTER TABLE DROP FOREIGN KEY.           *\r\n****************************************************************\r\n* RECOMMENDATION:                                              *\r\n****************************************************************\r\nDB2 is not correctly handling some error conditions when\r\nprocessing constraints, which may result in unexpected symptoms,\r\nsuch as ABEND04E RC00E70005 at DSNXIAB2:P068 on ALTER TABLE DROP\r\nFOREIGN KEY.\r\n\r\nAffected SQL statements:\r\nCREATE TABLE PRIMARY KEY\r\nCREATE TABLE UNIQUE\r\nCREATE TABLE FOREIGN KEY\r\nCREATE TABLE CHECK\r\nALTER TABLE ADD PRIMARY KEY\r\nALTER TABLE ADD UNIQUE\r\nALTER TABLE ADD FOREIGN KEY\r\nALTER TABLE ADD CHECK\r\nALTER TABLE DROP PRIMARY KEY\r\nALTER TABLE DROP UNIQUE\r\nALTER TABLE DROP FOREIGN KEY\r\nALTER TABLE DROP CHECK\r\nALTER TABLE DROP CONSTRAINT<\/span><\/pre>\n<pre style=\"text-align: left;\"><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;all know. Its a silly bug that can crash the subsystem. Click here to go bug report Here is the brief \u00c2\u00a0description : Problem summary **************************************************************** * USERS AFFECTED: All DB2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[251,943,231,250],"class_list":["post-417","post","type-post","status-publish","format-standard","hentry","category-db2","tag-apar","tag-db2","tag-db2-bug","tag-db2-zos"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=417"}],"version-history":[{"count":1,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions"}],"predecessor-version":[{"id":418,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions\/418"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}