建立表格空間

設定 DB2® 以與 IBM® Product Master 搭配使用的第四個步驟是在已啟用自動儲存體的資料庫中建立表格空間。

關於此作業

如需如何建立表格空間的相關資訊，請參閱 Db2 文件或諮詢您的 DBA。

如需相關資訊，請參閱 表格空間需求 及 自訂表格空間名稱。

程序

建立表格空間。

範例

下列範例提供用於建立表格空間的範例陳述式。 在 Db2 伺服器中修改儲存器路徑 /db/a1/db2inst1/ 及 /db/a5/db2inst1/ 適當的路徑。
大型表格空間:
CREATE LARGE TABLESPACE USERS PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL USERSBP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE INDX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL INDXBP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE BLOB_TBL_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL BLOBBP
FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE XML_DATA PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL XML_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;

CREATE LARGE TABLESPACE XML_LARGE_DATA PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL XML_LARGE_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;

CREATE LARGE TABLESPACE XML_INDEX PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL XML_INDX_BP
FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;
如果您使用自訂表格空間，請確保包含下列額外表格空間:
CREATE LARGE TABLESPACE ITA_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITA_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ITM_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITM_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ITD_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITD_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ICM_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ICM_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE LCK_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL LCK_DATA_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ITA_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITA_IX_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ITM_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITM_IX_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ITD_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ITD_IX_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE ICM_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL ICM_IX_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;

CREATE LARGE TABLESPACE LCK_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE
BUFFERPOOL LCK_IX_BP
NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
暫存表格空間:
CREATE USER TEMPORARY TABLESPACE TEMP_USER PAGESIZE 16K MANAGED
BY AUTOMATIC STORAGE
BUFFERPOOL TEMPUSRBP;

CREATE SYSTEM TEMPORARY TABLESPACE TEMP_SYSTEM PAGESIZE 16K MANAGED
BY AUTOMATIC STORAGE
BUFFERPOOL TEMPSYSBP;

CREATE USER TEMPORARY TABLESPACE TEMP_USER32 PAGESIZE 32K MANAGED
BY AUTOMATIC STORAGE
BUFFERPOOL TEMPUSRBP32;

CREATE SYSTEM TEMPORARY TABLESPACE TEMP_SYSTEM32 PAGESIZE 32K MANAGED
BY AUTOMATIC STORAGE
BUFFERPOOL TEMPSYSBP32;
附註: 順利完成綱目及產品安裝需要所有表格空間。