1、切换到db2用户
su - db2inst1
2、连接db2的数据库
这里所使用的数据库为 WAREHOUS，根据实际情况连接到需要的数据库
db2 connect to WAREHOUS
备注：db2 LIST DATABASE DIRECTORY 可以查看实例下有哪些数据库
3、查看表空间使用率，确认需要扩容的表空间
db2 "select substr(tbsp_name,1,20) as TABLESPACE_NAME,substr(tbsp_content_type,1,10) as TABLESPACE_TYPE,sum(tbsp_total_size_kb)/1024 as TOTAL_MB,sum(tbsp_used_size_kb)/1024 as USED_MB,sum(tbsp_free_size_kb)/1024 as FREE_MB,tbsp_page_size AS PAGE_SIZE from SYSIBMADM.TBSP_UTILIZATION group by tbsp_name,tbsp_content_type,tbsp_page_size order by 1"
4、查看表空间信息
db2 "LIST TABLESPACES"
5、通过Tablespace ID查找表空间容器
例如：查找Tablespace ID =8 的表空间使用的容器
[db2inst1@GZDC-SVR-TIVOLI ~]$ db2 list tablespace containers for 8 show detail
Tablespace Containers for Tablespace 8
Container ID = 0
Name = /home/db2inst1/db2inst1/NODE0000/SQL00002/TGKLZ_CPU
Type = File
Total pages = 134072
Useable pages = 134016
Accessible = Yes
6、扩容容器大小
扩容有多种方式，这种方式就是将相应的容器都扩大1000页，也就是增加1000页。
db2 " ALTER TABLESPACE TSTGKLZ_CPU EXTEND (FILE '/home/db2inst1/db2inst1/NODE0000/SQL00002/TGKLZ_CPU' 1000) "
FAQ：
1、容器扩容提示表空间类型AUTOMATIC STORAGE
举例：
[db2inst1@VM-Tivoli ~]$ db2 " ALTER TABLESPACE USERSPACE1 EXTEND (FILE '/home/db2inst1/db2inst1/NODE0000/WAREHOUS/T0000002/C0000000.LRG' 5824512) "
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20318N Table space "USERSPACE1" of type "AUTOMATIC STORAGE" cannot be
altered using the "EXTEND" operation. SQLSTATE=42858
解决：
表空间可以自动扩展，不需要扩容，手动也扩容不了。
2、表空间名字包含小写
举例：
[db2inst1@VM-Tivoli ~]$ db2 " ALTER TABLESPACE TSCDNetwork EXTEND (FILE '/home/db2inst1/db2inst1/NODE0000/SQL00002/CDNetwork' 307200) "
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "TSCDNETWORK" is an undefined name. SQLSTATE=42704
解决：从db2数据库图形话界面进行容器扩容。