{"id":29,"date":"2009-02-20T04:36:37","date_gmt":"2009-02-19T22:36:37","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=29"},"modified":"2016-01-07T11:31:15","modified_gmt":"2016-01-07T05:31:15","slug":"an-sql-to-find-out-how-full-your-db2-tablespace-is-on-udb","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=29","title":{"rendered":"An sql to find out how full your db2 tablespace is on UDB"},"content":{"rendered":"<p>You need to have the IBM stored procedure SNAP_GET_TBSP_PART<\/p>\n<p>select tbsp_name, ((tbsp_used_pages * 100)\/tbsp_usable_pages) as percent_full\u00c2\u00a0 from table(SNAP_GET_TBSP_PART (&#8216; &#8216;,-1)) as tabl1<\/p>\n<p>This will show you how much percent full your tablespace is. You can insert the result set into a table and create a trend analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You need to have the IBM stored procedure SNAP_GET_TBSP_PART select tbsp_name, ((tbsp_used_pages * 100)\/tbsp_usable_pages) as percent_full\u00c2\u00a0 from table(SNAP_GET_TBSP_PART (&#8216; &#8216;,-1)) as tabl1 This will show you how much percent full your tablespace is. You can insert the result set into a table and create a trend analysis.<\/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":[1],"tags":[943,8,7],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-misc","tag-db2","tag-sql","tag-tablespace"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/29","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=29"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":97,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions\/97"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}