While reading a DB2 tech report and best practice , I see that many IBM DB2 internal experts now do not suggest running reorgchk to find out the tables that needs to be reorg’d . \u00c2\u00a0Instead they suggest using the following sqls to find the tables that needs to be reorg’d :<\/p>\n
select TABNAME
\nfrom SYSIBMADM.SNAPTAB
\nwhere (ROWS_READ > 999)
\nand ((OVERFLOW_ACCESSES * 100) \/ (ROWS_READ + 1) > 3);<\/p>\n
One of the primary reason is that they want to avoid running runstats before the reorgchk. \u00c2\u00a0While this can find the tables that needs to be reorg’d, it doesn’t help to find the indexes. The only way to find the indexes are still via reorgchk. While reading a DB2 tech report and best practice , I see that many IBM DB2 internal experts now do not suggest running reorgchk to find out the tables that needs to be reorg’d . \u00c2\u00a0Instead they suggest using the following sqls to find the tables that needs to be reorg’d : select TABNAME from […]<\/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,124,48,400,50,30],"class_list":["post-780","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-db2-reorg","tag-inplace-reorg","tag-reorg","tag-reorgchk","tag-runstats"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/780","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=780"}],"version-history":[{"count":3,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/780\/revisions"}],"predecessor-version":[{"id":853,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/780\/revisions\/853"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nI am currently testing this and incorporating this to my offline\u00c2\u00a0reorg script<\/a> <\/a> and inplace reorg<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"