db2 load dumpfile for exception
[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博客 ” ，链接：https://blog.itpub.net/26224914/viewspace-2651642/ ，如需转载，请注明出处，否则将追究法律责任。
