Toad World® Forums

db2move export load .... whats happening


#1

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 $


#2

Hello,

What is in message file tab1.msg, tab2.msg, tab3.msg? Can you please upload them?

Regards
Ondrej


#3

tab1.msg

SQL3104N The Export utility is beginning to export data to file “tab1.ixf”.

SQL3105N The Export utility has finished exporting “475” rows.

SQL3104N The Export utility is beginning to export data to file “tab1.ixf”.

SQL3105N The Export utility has finished exporting “475” rows.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

~
tab2.msg

SQL3104N The Export utility is beginning to export data to file “tab2.ixf”.

SQL3105N The Export utility has finished exporting “0” rows.

SQL3104N The Export utility is beginning to export data to file “tab2.ixf”.

SQL3105N The Export utility has finished exporting “0” rows.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

tab3.msg

SQL3104N The Export utility is beginning to export data to file “tab3.ixf”.

SQL3105N The Export utility has finished exporting “6” rows.

SQL3104N The Export utility is beginning to export data to file “tab3.ixf”.

SQL3105N The Export utility has finished exporting “6” rows.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

~

tab4.msg

SQL3104N The Export utility is beginning to export data to file “tab4.ixf”.

SQL3105N The Export utility has finished exporting “9” rows.

SQL3104N The Export utility is beginning to export data to file “tab4.ixf”.

SQL3105N The Export utility has finished exporting “9” rows.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

SQL3004N The load, import, or export utility failed because the specified
file type is not supported.

~
~


#4

empty directory

db2move export into the directory for a selected schema

going the other way

db2move load off the same directory

error!

How do you shoot this?


#5

Hello,

Are these tables defined in a multi-partitioned database?

Regards
Ondrej