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部落格 ” ,連結:http://blog.itpub.net/26224914/viewspace-2651642/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- C++記錄程式崩潰時的dumpfileC++
- Oracle exceptionOracleException
- 異常(Exception)Exception
- Exception和ErrorExceptionError
- Lazy Load
- DB2 WLMDB2
- db2 -attribute of key are miss in result set . db2 錯誤DB2
- Sanic Exception – 異常Exception
- java exception and finally returnJavaException
- ch12_exceptionException
- Domcontentloaded、load、finish
- load與initialize
- 理解load averages
- This is my Load.
- gRPC Load BalancingRPC
- db2 reorg,runstatsDB2
- DB2的STMTIDDB2
- Db2 備份DB2
- DB2 安裝DB2
- Exception和Error的理解ExceptionError
- Oracle 中的exception——(Raise)OracleExceptionAI
- oracle 使用異常exceptionOracleException
- 【譯】Exception Helper – Rethrown ExceptionsException
- Symfony\Component\Debug\Exception\FatalErrorExceptionExceptionError
- Sanic exception() 方法/函式Exception函式
- Java-Exception與RuntimeExceptionJavaException
- PHP 異常類 ExceptionPHPException
- Laravel pivot 新增 loadLaravel
- transformers(1) 、load模型ORM模型
- linux load解釋Linux
- docker tag save loadDocker
- jQuery – AJAX load() 方法jQuery
- ORACLE GoldenGate Initial LoadOracleGo
- torch.save(),torch.load(),state_dict(),load_state_dict()
- DB2 SQL改寫DB2SQL
- DB2 HADR效能分析DB2
- The Db2 Recovery History FileDB2
- Oracle連線Db2OracleDB2