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)"