{"id":226,"date":"2009-04-23T03:45:17","date_gmt":"2009-04-22T21:45:17","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=226"},"modified":"2016-01-07T11:31:13","modified_gmt":"2016-01-07T05:31:13","slug":"simple-offline-db2-reorg-script-take-2","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=226","title":{"rendered":"Simple Offline DB2 Reorg Script &#8211; Take 2"},"content":{"rendered":"<p>A few weeks back, I had published a script that will dynamically create a reorg script and execute it.\u00c2\u00a0\u00c2\u00a0 Now I have made few modifications to it.\u00c2\u00a0 The new script does couple of things more :<\/p>\n<ul>\n<li>It has an exclude list . Any table name or index name will be excluded from the reorg script<\/li>\n<li>It now includes the &#8220;USE&#8221; temporary tablespace feature.<\/li>\n<li>It will also email the reorg report to an email address<\/li>\n<\/ul>\n<p>Offline or classic reorgs are much faster and lot more efficient. It however needs exclusive access to the table.\u00c2\u00a0 Here is a new script : <a href=\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2009\/04\/reorg.zip\">reorg.zip<\/a>\u00c2\u00a0\u00c2\u00a0 The zip has two files, one is the reorg script and the other one is called from the reorg.sh that generates the report.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few weeks back, I had published a script that will dynamically create a reorg script and execute it.\u00c2\u00a0\u00c2\u00a0 Now I have made few modifications to it.\u00c2\u00a0 The new script does couple of things more : It has an exclude list . Any table name or index name will be excluded from the reorg script [&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,130,125,124,126,129,127,128],"class_list":["post-226","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-db2-classic-reorg","tag-db2-offline-reorg","tag-db2-reorg","tag-db2-reorg-script","tag-db2-reorg-status","tag-db2-reorg-use-temporary-tablespace","tag-reorg-status"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/226","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=226"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions"}],"predecessor-version":[{"id":229,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions\/229"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}