db2move export load … whats happening
db2move RPTDMRT3 export -aw -sn ronish
Application code page not determined, using ANSI codepage 819
***** DB2MOVE *****
Action: EXPORT
Start time: Mon May 7 11:58:35 2018
All schema names matching: RONISH;
Connecting to database RPTDMRT3 … successful! Server : DB2 Common Server V10.5.8
EXPORT: 475 rows from table "RONISH ".“AUDITS_LEADS”
EXPORT: 0 rows from table "RONISH ".“QUESTSTAFF”
EXPORT: 6 rows from table "RONISH ".“TABLEA”
Disconnecting from database … successful!
End time: Mon May 7 11:58:36 2018
===> /home/ronish
ronish@mssuvd-dofrpt31 $
going the other way…
db2move RPTDMRT3 load -lo replace
Application code page not determined, using ANSI codepage 819
***** DB2MOVE *****
Action: LOAD
Start time: Mon May 7 11:59:38 2018
Connecting to database RPTDMRT3 … successful! Server : DB2 Common Server V10.5.8
-
LOAD: table "RONISH ".“AUDITS_LEADS”
*** ERROR -3004. Check message file tab1.msg!
*** SQLCODE: -3004 - SQLSTATE:
*** SQL3004N The load, import, or export utility failed because the specified file type is not supported. -
LOAD: table "RONISH ".“QUESTSTAFF”
*** ERROR -3004. Check message file tab2.msg!
*** SQLCODE: -3004 - SQLSTATE:
*** SQL3004N The load, import, or export utility failed because the specified file type is not supported. -
LOAD: table "RONISH ".“TABLEA”
*** ERROR -3004. Check message file tab3.msg!
*** SQLCODE: -3004 - SQLSTATE:
*** SQL3004N The load, import, or export utility failed because the specified file type is not supported.
**Error occured -1
Disconnecting from database … successful!
End time: Mon May 7 11:59:39 2018
===> /home/ronish
ronish@mssuvd-dofrpt31 $