이기종간 Database 옮길려면 import / export 사용해야 한다고 하는데.
그보다 db2move 를 사용하면 더 쉽다고 하는데..
자세한 설명이 없네요.
$ db2move db2aa export EXPORT.out tab1.ixf tab1.msg
export 화일을 옮겨서
하면
$dv2move db2aa import Action: IMPORT
Start time: Fri Dec 19 18:10:31 2003
Connecting to database DB2INST1 ... successful! Server: DB2 Common Server V8.1.0
Binding package automatically ... Bind file: /home/db2inst1/sqllib/bnd/db2move.bnd
Bind was successful!
*** Table "DB2AA."AEBS_LOGGMS": ERROR 3107. Check message file tab1.msg! *** SQL Warning! SQLCODE is 3107 *** SQL3107W There is at least one warning message in the message file. ........ Disconnecting from database ... successful! End time: Fri Dec 19 18:14:37 2003
$ db2move db2bb import -io REPLACE_CREATE 해봐도 마찬가지였습니다.
|