{"id":7326,"date":"2024-03-14T05:22:19","date_gmt":"2024-03-14T05:22:19","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/"},"modified":"2025-08-02T14:45:37","modified_gmt":"2025-08-02T14:45:37","slug":"how-to-view-the-tablespace-where-a-table-is-located-in-db2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/","title":{"rendered":"Find DB2 Table Tablespace: Quick SQL Guide"},"content":{"rendered":"<p>To view the tablespace where a table is located, you can use the following SQL statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> TBNAME, TBSPACE\r\n<span class=\"hljs-keyword\">FROM<\/span> SYSCAT.TABLES\r\n<span class=\"hljs-keyword\">WHERE<\/span> TABSCHEMA <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'YourSchema'<\/span>\r\n<span class=\"hljs-keyword\">AND<\/span> TBNAME <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'YourTable'<\/span>;\r\n<\/code><\/pre>\n<p>Replace YourSchema with the name of the schema where the table is located, and replace YourTable with the name of the table you want to view, then execute the query to obtain the tablespace where the table is located.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To view the tablespace where a table is located, you can use the following SQL statement: SELECT TBNAME, TBSPACE FROM SYSCAT.TABLES WHERE TABSCHEMA = &#8216;YourSchema&#8217; AND TBNAME = &#8216;YourTable&#8217;; Replace YourSchema with the name of the schema where the table is located, and replace YourTable with the name of the table you want to view, [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[390,935,9339,1034,3165],"class_list":["post-7326","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-administration","tag-db2","tag-db2-tables","tag-sql-query","tag-tablespace"],"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>Find DB2 Table Tablespace: Quick SQL Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.\" \/>\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-view-the-tablespace-where-a-table-is-located-in-db2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Find DB2 Table Tablespace: Quick SQL Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-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-14T05:22:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T14:45:37+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\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=\"Benjamin Taylor\" \/>\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-view-the-tablespace-where-a-table-is-located-in-db2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"Find DB2 Table Tablespace: Quick SQL Guide\",\"datePublished\":\"2024-03-14T05:22:19+00:00\",\"dateModified\":\"2025-08-02T14:45:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/\"},\"wordCount\":62,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database administration\",\"DB2\",\"DB2 tables\",\"SQL query\",\"Tablespace\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/\",\"name\":\"Find DB2 Table Tablespace: Quick SQL Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T05:22:19+00:00\",\"dateModified\":\"2025-08-02T14:45:37+00:00\",\"description\":\"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Find DB2 Table Tablespace: Quick SQL Guide\"}]},{\"@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\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Find DB2 Table Tablespace: Quick SQL Guide - Blog - Silicon Cloud","description":"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.","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-view-the-tablespace-where-a-table-is-located-in-db2\/","og_locale":"en_US","og_type":"article","og_title":"Find DB2 Table Tablespace: Quick SQL Guide","og_description":"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T05:22:19+00:00","article_modified_time":"2025-08-02T14:45:37+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"Find DB2 Table Tablespace: Quick SQL Guide","datePublished":"2024-03-14T05:22:19+00:00","dateModified":"2025-08-02T14:45:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/"},"wordCount":62,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database administration","DB2","DB2 tables","SQL query","Tablespace"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/","name":"Find DB2 Table Tablespace: Quick SQL Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T05:22:19+00:00","dateModified":"2025-08-02T14:45:37+00:00","description":"Learn how to locate DB2 table tablespaces instantly with our SQL query guide. Step-by-step instructions included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-tablespace-where-a-table-is-located-in-db2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Find DB2 Table Tablespace: Quick SQL Guide"}]},{"@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\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7326","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7326"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7326\/revisions"}],"predecessor-version":[{"id":152101,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7326\/revisions\/152101"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}