首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > IBM DB2 >

DB2数据库:向表里导入数据时报sqlcode=-968 SQLSTATE 57011异常

2012-02-21 
DB2数据库:向表里导入数据时报sqlcode-968 SQLSTATE 57011错误执行命令db2 list tablespace show detail

DB2数据库:向表里导入数据时报sqlcode=-968 SQLSTATE 57011错误
执行命令db2 list tablespace show detail
查看的Database managed space的可用空间都足够,但是就是报这个错,求高手指教:

Tablespace ID = 0
 Total pages = 16384
 Useable pages = 16380
 Used pages = 13444
 Free pages = 2936

 Tablespace ID = 1
 Name = TEMPSPACE1
 Type = System managed space
 Total pages = 1
 Useable pages = 1
 Used pages = 1
 Free pages = Not applicable

 Tablespace ID = 2
 Name = ESBTBS
 Type = Database managed space
 Total pages = 12288
 Useable pages = 12280
 Used pages = 11800
 Free pages = 480

 Tablespace ID = 3
 Name = ESBBIZTS
 Type = Database managed space
 Total pages = 4096
 Useable pages = 4088
 Used pages = 2624
 Free pages = 1464

 Tablespace ID = 4
 Name = ESBTEMP01
 Type = System managed space
 Total pages = 1
 Useable pages = 1
 Used pages = 1
 Free pages = Not applicable

 Tablespace ID = 5
 Name = SYSTOOLSPACE
 Type = Database managed space
 Total pages = 8192
 Useable pages = 8188
 Used pages = 172
 Free pages = 8016

 Tablespace ID = 6
 Name = SYSTOOLSTMPSPACE
 Type = System managed space
 Total pages = 1
 Useable pages = 1
 Used pages = 1
 Free pages = Not applicable

[解决办法]
什么操作系统,df -g 看看是不是数据库相关的目录满了

包括:建库目录,日志目录,表空间容器目录。。。

热点排行