db2 load dumpfile for exception

flywiththewind發表於2019-07-24

[db2inst1@onekey :~/load 7]$ db2 "create table test(id int not null primary key,name char(10))"

DB20000I  The SQL command completed successfully.

[db2inst1@onekey :~/load 8]$ db2 "create table test_exp like test"

DB20000I  The SQL command completed successfully.

[db2inst1@onekey :~/load 9]$ db2 "alter table test_exp add column ts timestamp add column msg clob(32K)"

DB20000I  The SQL command completed successfully.

[db2inst1@onekey :~/load 10]$ db2 reorg table test_exp

DB20000I  The REORG command completed successfully.

[db2inst1@onekey :~/load 12]$ cat 1.del

1,'aaa'

1,'ddd'

2,'ddd'

'aaa',2

1a',asdf'

3,'aaaaaaaaaaaaa'


db2 "load from 1.del of del modified by dumpfile="/tmp/2.dmp"  messages 1.msg replace into test for exception test_exp nonrecoverable"


[root@onekey tmp]# cat /tmp/2.dmp.load.000 

'aaa',2

1a',asdf'


[db2inst1@onekey :~ 2]$ db2 "select * from test_exp"


ID          NAME       TS                         MSG                                                                                                                                                                       

 1 'ddd'      2019-07-24-11.04.12.575140 00001I0000500001 


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26224914/viewspace-2651642/,如需轉載,請註明出處,否則將追究法律責任。

相關文章