CONNECT TO dbname;drop BUFFERPOOL BFPOOL8;--建緩衝池CREATE BUFFERPOOL BFPOOL8 IMMEDIATE SIZE 25000 PAGESIZE 8 K ;--建表空間,路徑要修改CREATE TABLESPACE DMS_DATA8K PAGESIZE 8 K MANAGED BY DATABASE USING (FILE "/home/DB2/NODE0000/DMS_DATA8K.DMS" 3G) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL BFPOOL8 DROPPED TABLE RECOVERY OFF;--擴充套件表空間（調整容器大小）--ALTER TABLESPACE DMS_DATA8K resize (FILE "/home/DB2/NODE0000/DMS_DATA8K.DMS" 2G);--擴充套件表空間（增加容器大小）--ALTER TABLESPACE DMS_DATA8K extend (FILE "/home/DB2/NODE0000/DMS_DATA8K.DMS" 2G);--擴充套件表空間（給表空間增加容器）--ALTER TABLESPACE DMS_DATA8K add (FILE "/app149/DB2/NODE0000/DMS_DATA8K.DMS" 5G);