db2move import dbname 时这几个表导不进数据。有什么简单的方法能恢复数据吗？

Ray001

db2move import dbname 时这几个表导不进数据。有什么简单的方法能恢复数据吗？


"BH" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (
            START WITH +1
            INCREMENT BY +1
            MINVALUE +1
            MAXVALUE +999999999
            CYCLE
            NO CACHE
            ORDER ),

都是有identity字段的表

同时我忘了做del格式的export ，并且已经把原始库drop了

wangzhonnew

(panipuri)/home/taoewang->db2 "create table t5 (c1 integer, c2 integer not null generated always as identity (start with +1 increment by +1 minvalue +1 maxvalue +9999999 cycle no cache order))"
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "insert into t5 values (1)"
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0117N  The number of values assigned is not the same as the number of
specified or implied columns.  SQLSTATE=42802
(panipuri)/home/taoewang->db2 "insert into t5 c1 values (1)"
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "c1 values" was found following "insert into T5
".  Expected tokens may include:  "<values>".  SQLSTATE=42601
(panipuri)/home/taoewang->db2 "insert into t5 (c1) values (1)"
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "insert into t5 (c1) values (2)"
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "insert into t5 (c1) values (3)"
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "select * from t5"

C1          C2
----------- -----------
          1           1
          2           2
          3           3

  3 record(s) selected.

(panipuri)/home/taoewang->db2move sample export -tn TAOEWANG.T5

*****  DB2MOVE  *****

Action:      EXPORT

Start time:  Tue Jul  4 15:11:46 2006


All table names matching:  TAOEWANG.T5;

Connecting to database SAMPLE ... successful!  Server: DB2 Common Server V8.2.3

Binding package automatically ...
Bind file: /home/taoewang/sqllib/bnd/db2move.bnd

Bind was successful!


Disconnecting from database ... successful!

End time:  Tue Jul  4 15:11:48 2006

(panipuri)/home/taoewang->db2 drop table t5
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "create table t5 (c1 integer, c2 integer not null generated always as identity (start with +1 increment by +1 minvalue +1 maxvalue +9999999 cycle no cache order))"
DB20000I  The SQL command completed successfully.
(panipuri)/home/taoewang->db2 "import from tab1.ixf of ixf method P(1) replace into t5 (c1)"
SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date
"20060704", and time "151354".

SQL3153N  The T record in the PC/IXF file has name "tab1.ixf", qualifier "",
and source "            ".

SQL3109N  The utility is beginning to load data from file "tab1.ixf".

SQL3110N  The utility has completed processing.  "3" rows were read from the
input file.

SQL3221W  ...Begin COMMIT WORK. Input Record Count = "3".

SQL3222W  ...COMMIT of any database changes was successful.

SQL3149N  "3" rows were processed from the input file.  "3" rows were
successfully inserted into the table.  "0" rows were rejected.


Number of rows read         = 3
Number of rows skipped      = 0
Number of rows inserted     = 3
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 3

(panipuri)/home/taoewang->db2 "select * from t5"

C1          C2
----------- -----------
          1           1
          2           2
          3           3

  3 record(s) selected.

(panipuri)/home/taoewang->

bpmfhu

“select tabschema, tabname, status, const_checked from syscat.tables where status='C'”查看所有表的状态是否为pengding状态，如果有状态为pengding的表，则通过“set integrity for TABSCHEMA.TABNAME immediate checked”命令解决pengding问题。

pchaos

IDENTITY字段重新导入的时候会变掉，如果有外键约束的话， 估计很难导入

nuoran

generated by default的字段可以import默认或者db2move进去。不过在后续的insert动作可能会报错803。指定参数人工import是最好的办法。使用IDENTITYMISSING, IDENTITYIGNORE参数。