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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- db2 export loadDB2Export
- DB2 LOAD相關DB2
- db2 load 自增測試DB2
- DB2 Load造成tablespace pendingDB2
- db2 load 自增 generated always as identityDB2IDE
- Goldengate for DB2 8.2的介質為DB2 9.7做init loadGoDB2
- Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'System.EnterpException
- DB2資料的匯入(Import) 匯出(Export)(Load)DB2ImportExport
- db2解決load後系統空間不足問題DB2
- C++記錄程式崩潰時的dumpfileC++
- 從Export Dumpfile file 中讀出DDL 語句Export
- ExceptionException
- db2資料庫load出現SQL3508N問題DB2資料庫SQL
- Oracle exceptionOracleException
- Java——ExceptionJavaException
- db2解決load資料後現在SQL1477N錯誤DB2SQL
- 使用db2 load from時導致DB的tablespace置成backup pending狀態DB2
- Exception和ErrorExceptionError
- 異常(Exception)Exception
- 2.4.ExceptionException
- Exception testingException
- deadlock exceptionException
- debug exceptionException
- -Objc -all_load -force_loadOBJ
- Sanic Exception – 異常Exception
- ch12_exceptionException
- jQuery load()jQuery
- Xcode裡-ObjC, -all_load, -force_loadXCodeOBJ
- 【譯】Exception Helper – Rethrown ExceptionsException
- Sanic exception() 方法/函式Exception函式
- PHP 異常類 ExceptionPHPException
- Oracle 中的exception——(Raise)OracleExceptionAI
- oracle 使用異常exceptionOracleException
- Exception和Error的理解ExceptionError
- Java之Undeclared Checked ExceptionJavaException
- Oracle XA Exception error codeOracleExceptionError
- EXCEPTION裡捕捉行號Exception
- 【Exception】:own error messageExceptionError