AIX 環境下創建 DB2 表空間完整實操步驟指南

操作步驟

1. 設置代碼頁：db2set db2codepage=819
2. 創建數據庫：db2 create database easytest on /home/db2inst1
3. 連接數據庫：db2 connect to test04 user db2inst1 using db2
4. 創建 8K 頁緩衝池：db2 CREATE Bufferpool USER8 SIZE 100000 PAGESIZE 8K
5. 創建 16K 頁緩衝池：db2 CREATE Bufferpool USER16 SIZE 1000 PAGESIZE 16K
6. 創建 32K 頁緩衝池：db2 CREATE Bufferpool USER32 SIZE 1000 PAGESIZE 32K
7. 停止數據庫管理器：db2stop force
8. 啟動數據庫管理器：db2start
9. 重新連接：db2 connect to test04 user db2inst1 using db2
10. 創建 8K 正規表空間：db2 "CREATE REGULAR TABLESPACE TS_USER8 PAGESIZE 8K MANAGED BY SYSTEM USING ('FSMS_8K_1') BUFFERPOOL USER8"
11. 創建 16K 正規表空間：db2 "CREATE REGULAR TABLESPACE TS_USER16 PAGESIZE 16K MANAGED BY SYSTEM USING ('FSMS_16K_1') BUFFERPOOL USER16"
12. 創建 32K 正規表空間：db2 "CREATE REGULAR TABLESPACE TS_USER32 PAGESIZE 32K MANAGED BY SYSTEM USING ('FSMS_32K_1') BUFFERPOOL USER32"
13. 創建 8K 臨時緩衝池：db2 CREATE Bufferpool TMPBUF8 SIZE 10000 PAGESIZE 8K
14. 創建 8K 臨時表空間：db2 "CREATE TEMPORARY TABLESPACE TempTS_USER8 PAGESIZE 8K MANAGED BY SYSTEM USING ('/home/db2inst1/db2inst1/TEMPNODE0004') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL TMPBUF8 DROPPED TABLE RECOVERY OFF"
15. 授予用戶 EASYMIS 數據庫管理權限：db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT,LOAD ON DATABASE TO USER EASYMIS
16. 授予表空間使用權：db2 GRANT USE OF TABLESPACE TS_USER8 TO easymis、TS_USER16、TS_USER32
17. 以 easymis 用戶連接並執行結構腳本：db2 connect to test04 user easymis using easymis → db2 -f dbstruct.sql > kk.log