{"id":411,"date":"2009-08-11T09:32:51","date_gmt":"2009-08-11T03:32:51","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=411"},"modified":"2016-01-07T11:31:11","modified_gmt":"2016-01-07T05:31:11","slug":"terminate-lock-chain-applications","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=411","title":{"rendered":"Terminate Lock chain applications"},"content":{"rendered":"<p>At my work, I used to get paged saying the reorg is on a lock wait, because some rouge application(s) are holding locks. This became annoying since it started to happen often, so I wrote a dirty little script that will loop through and force all the applications that causes reorg to go on lock wait. \u00c2\u00a0However the script can be used for any application that goes on lock wait. \u00c2\u00a0The script simply find a lock session thats on lock wait, then identify the culprit application and force that application handle and then checks for lock wait, if it find its releases that as well, it does it until all the locks are gone . \u00c2\u00a0The script can be modified to suite your need. Like I said I planned to run the script only when the monitor picked up reorg getting on lock wait state. \u00c2\u00a0Here is the script : \u00c2\u00a0<a href=\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2009\/08\/lockchain_killer.txt\" target=\"_blank\">lockchain_killer.sh<\/a> The script will only work on DB2 V9.1 and higher.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At my work, I used to get paged saying the reorg is on a lock wait, because some rouge application(s) are holding locks. This became annoying since it started to happen often, so I wrote a dirty little script that will loop through and force all the applications that causes reorg to go on lock [&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":[943,247,249,248],"class_list":["post-411","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-db2-lock","tag-force-application","tag-lock-wait"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/411","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=411"}],"version-history":[{"count":5,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/411\/revisions"}],"predecessor-version":[{"id":1532,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/411\/revisions\/1532"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}