各位好,求教一个问题。
我有一TD_PM_NET_INTERFACE表 ,里面有40个字段 ,
select sum(length),count(*) from syscat.columns where tabname='TD_PM_NET_INTERFACE';
结果
length cnt
---------------------
8985 40
执行语句这条语句报错
create table BAK_TD_PM_NET_INTERFACE_201106 like TD_PM_NET_INTERFACE in ITCC_TAB_11;
报错:
17:50:19 [CREATE - 0 row(s), 0.000 secs] [Error Code: -289, SQL State: 57011] DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=SYSCATSPACE, DRIVER=3.57.82
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
ITCC_TAB_11 表空间中
的CODE是
CREATE BUFFERPOOL ITCC_BP32K_11 IMMEDIATE SIZE 1000 PAGESIZE 32 K;
CREATE REGULAR TABLESPACE ITCC_TAB_11
PAGESIZE 32 K
MANAGED BY DATABASE USING
( FILE '/home/db2inst1/db2inst1/timedb/ITCC_TAB_11_200M_01.DAT' 12800,
FILE '/home/db2inst1/db2inst1/timedb/ITCC_TAB_11_200M_02.DAT' 12800 )
EXTENTSIZE 16
PREFETCHSIZE 32
BUFFERPOOL ITCC_BP32K_11;
数据定义值也挺大的啊 ,怎么回事呢?
------解决方案--------------------------------------------------------
你还是看看这个表空间的状态吧
------解决方案--------------------------------------------------------
大小似乎不是问题,难道是某个容器出问题?