{"id":26597,"date":"2024-03-16T06:57:28","date_gmt":"2024-03-16T06:57:28","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/"},"modified":"2024-03-22T08:58:19","modified_gmt":"2024-03-22T08:58:19","slug":"how-to-release-space-after-deleting-a-table-in-db2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/","title":{"rendered":"How to release space after deleting a table in DB2?"},"content":{"rendered":"<p>In DB2, when you delete a table, the space is not immediately released. Instead, DB2 keeps the space of the deleted table for future use. This is done to improve performance and avoid frequent space allocation and deallocation.<\/p>\n<p>If you are sure that the space of the table you have deleted can be released, you can follow these steps to free up space:<\/p>\n<ol>\n<li>Firstly, after deleting a table, you should commit the current transaction and disconnect from the database. This will ensure that no other sessions are utilizing the space of the deleted table.<\/li>\n<li>Next, log in to the database using the DB2 command line window or the DB2 Control Center (GUI tool).<\/li>\n<li>Execute the following command to rebuild the directory of the database&#8217;s catalog table spaces:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('&lt;database_name&gt;')\r\n<\/code><\/pre>\n<p>Replace <database_name> with the name of your database.<\/p>\n<ol>\n<li>Execute the following command to reorganize the database table spaces:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>CALL SYSPROC.ADMIN_MOVE_TABLE('&lt;table_space_name&gt;', '&lt;table_name&gt;', '&lt;new_table_space_name&gt;')\r\n<\/code><\/pre>\n<p>Replace <table_space_name> with the tablespace name of the deleted table, <table_name> with the name of the deleted table, and <new_table_space_name> with a new tablespace name.<\/p>\n<ol>\n<li>Finally, reconnect to the database using the DB2 command line window or DB2 Control Center and verify that the space of the deleted table has been released.<\/li>\n<\/ol>\n<p>Please make sure to backup the database before proceeding with these steps in order to prevent any unexpected situations. Additionally, these steps may take some time to complete, depending on the size and complexity of the database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In DB2, when you delete a table, the space is not immediately released. Instead, DB2 keeps the space of the deleted table for future use. This is done to improve performance and avoid frequent space allocation and deallocation. If you are sure that the space of the table you have deleted can be released, you [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-26597","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to release space after deleting a table in DB2? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to release space after deleting a table in DB2?\" \/>\n<meta property=\"og:description\" content=\"In DB2, when you delete a table, the space is not immediately released. Instead, DB2 keeps the space of the deleted table for future use. This is done to improve performance and avoid frequent space allocation and deallocation. If you are sure that the space of the table you have deleted can be released, you [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T06:57:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T08:58:19+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"How to release space after deleting a table in DB2?\",\"datePublished\":\"2024-03-16T06:57:28+00:00\",\"dateModified\":\"2024-03-22T08:58:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\"},\"wordCount\":241,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\",\"name\":\"How to release space after deleting a table in DB2? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T06:57:28+00:00\",\"dateModified\":\"2024-03-22T08:58:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to release space after deleting a table in DB2?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to release space after deleting a table in DB2? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/","og_locale":"en_US","og_type":"article","og_title":"How to release space after deleting a table in DB2?","og_description":"In DB2, when you delete a table, the space is not immediately released. Instead, DB2 keeps the space of the deleted table for future use. This is done to improve performance and avoid frequent space allocation and deallocation. If you are sure that the space of the table you have deleted can be released, you [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T06:57:28+00:00","article_modified_time":"2024-03-22T08:58:19+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"How to release space after deleting a table in DB2?","datePublished":"2024-03-16T06:57:28+00:00","dateModified":"2024-03-22T08:58:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/"},"wordCount":241,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/","name":"How to release space after deleting a table in DB2? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T06:57:28+00:00","dateModified":"2024-03-22T08:58:19+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-release-space-after-deleting-a-table-in-db2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to release space after deleting a table in DB2?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=26597"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26597\/revisions"}],"predecessor-version":[{"id":60771,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26597\/revisions\/60771"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=26597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=26597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=26597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}