Creating appropriate reorg script for UDB can be challenging. A little research made me right this sql that will generate the reorg script from the reorgchk utilities \u00c2\u00a0:<\/p>\n
CALL SYSPROC.REORGCHK_TB_STATS(‘S’,’MYSCHEMA’);
\nselect * from session.TB_stats where reorg like ‘%*%’;
\nselect coalesce (‘reorg table ‘ || rtrim(a.tabschema) || ‘.’ ||
\nrtrim(a.tabname) || ‘ index ‘ || coalesce(max(case indextype when ‘CLUS’
\nthen rtrim(indschema) || ‘.’ || rtrim(indname) end), max(case uniquerule
\nwhen ‘P’ then rtrim(indschema) || ‘.’ || rtrim(indname) end), max(case iid
\nwhen 1 then rtrim(indschema) || ‘.’ || rtrim(indname) end)) || ‘ inplace;’,
\n‘reorg table ‘ || rtrim(a.tabschema) || ‘.’ || rtrim(a.tabname) || ‘
\ninplace;’) from syscat.tables a left outer join syscat.indexes b on
\na.tabschema = b.tabschema and a.tabname = b.tabname where
\nrtrim(a.tabschema) || ‘.’ || rtrim(a.tabname) in (select
\nrtrim(table_schema)||’.’||rtrim(table_name) from session.TB_stats where
\nreorg like ‘%*%’) group by a.tabschema, a.tabname;<\/p>\n
select ‘runstats on table ‘||rtrim(table_schema)||’.’||rtrim(table_name)||
\n‘ with distribution on key columns and indexes all;’
\nfrom session.TB_stats where reorg like ‘%*%’;<\/p>\n
CALL SYSPROC.REORGCHK_IX_STATS(‘S’,’MYSCHEMA’);
\nselect ‘reorg indexes all for table
\n‘||rtrim(TABLE_SCHEMA)||’.’||TABLE_NAME||’ allow write access;’
\nfrom session.IX_stats where reorg like ‘%*%’;<\/p>\n
\u00c2\u00a0<\/p>\n
The select generates the db2 script required to run the reorg.<\/p>\n","protected":false},"excerpt":{"rendered":"
Creating appropriate reorg script for UDB can be challenging. A little research made me right this sql that will generate the reorg script from the reorgchk utilities \u00c2\u00a0: CALL SYSPROC.REORGCHK_TB_STATS(‘S’,’MYSCHEMA’); select * from session.TB_stats where reorg like ‘%*%’; select coalesce (‘reorg table ‘ || rtrim(a.tabschema) || ‘.’ || rtrim(a.tabname) || ‘ index ‘ || coalesce(max(case […]<\/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":[],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-db2"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/18","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=18"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":20,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions\/20"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}