db2 tablespace 基本操作

DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0289N  Unable to allocate new pages in table space "USERSPACE1".  SQLSTATE=57011
Mon 13 Feb 2012 11:34:27 PM CST: CRRBFEEEEE: 31387: Database: DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0289N  Unable to allocate new pages in table space "USERSPACE1".  SQLSTATE=57011
出现上面的错误表示需要增加tablespace的空间

db2 connect to xxx user username using userpassword

然后查看那tablespce的

db2 list tablespaces show detail

找到USERSPACE1的索引号

db2 LIST TABLESPACE CONTAINERS for 2 show detail  (USERSPACE1 is the 2nd tablespace)

 

最后修改USERSPACE1 的空间
db2 "alter tablespace USERSPACE1 RESIZE (ALL 360 M)"