求助:db2move import 问题

[llxzj60]

求助:DB2数据库
执行db2 db2move import database -u username -p password中import TWMS_PLTLOCKLINE表时报错
* IMPORT: table "DBM "."TWMS_PLTLOCKLINE"
***ERROR -3306. Check message file tab27.msg!
*** SQLCODE: -3306 - SQLSTATE:
*** SQL3306N 当将一行插入到表中时发生 SQL 错误 "-289"。

[hehecn]

可以去看看tab27.msg里报了什么错误．

[jorson_zhou]

把tab27.msg贴出来呀

[zwj0712]

光看这样的信息基本上判断不出来了!

[welyngj]

D:\Documents and Settings\JZ9WCQ>db2 ? sql00289


SQL0289N Unable to allocate new pages in table space
"<tablespace-name>".

Explanation:

One of the following conditions is true:

1. One of the containers assigned to this SMS table space has
reached the maximum file size. This is the likely cause of
the error.

2. All the containers assigned to this DMS table space are
full. This is the likely cause of the error.

3. The table space object table for this DMS table space is
full.

4. A rebalance is in progress, but has not progressed far enough
to enable the newly added space to be used.

5. A redirected restore is being done to containers that are too
small.

6. A rollforward is being done following a redirected restore
and all the containers assigned to this tablespace are
full.

7. A rollforward skipping add containers is being done and all
the containers assigned to this tablespace are full.

8. An attempt was made to create a table space with less than 5
usable extents.

User Response:

Perform the action corresponding to the cause of the error:

1. either switch to a DMS TABLESPACE or recreate the SMS
TABLESPACE with more directories (PATHs) such that: (number
of directories) >= (max tablesize / maxfilesize). Note
that maximum file size is operating system dependent.

2. add new container(s) to the DMS table space and try the
operation again, after the rebalancer has made the new pages
available for use.

3. drop unnecessary tables from this DMS table space.

4. wait for the rebalancer to make more progress.

5. perform the redirected restore again to larger containers.

6. perform the redirected restore again to larger containers.

7. perform the rollforward again allowing add containers, or
perform a redirected restore to larger containers.

8. resubmit the CREATE TABLESPACE statement, ensuring that the
table space has at least 5 usable extents.

sqlcode : -289

sqlstate : 57011


D:\Documents and Settings\JZ9WCQ>

[ggbilo]

Unable to allocate new pages in table space

------------
应该是表空间不够了，增加表空间吧

[hemaily]

[Quote=引用 5 楼 ggbilo 的回复:]
Unable to allocate new pages in table space

------------
应该是表空间不够了，增加表空间吧
[/Quote]