CODEWITHSUNDEEP
linuxdatabasewindowsdb2
Kirill Achramionok
Kirill Achramionok

Reputation: 113

Move db2 from Windows to Linux

I'm trying to move db2 db from windows to linux server. When I move data to linux db by this command:

db2move DBNAME load -lo REPLACE -u userID -p password > load_remote.txt

I had this error:

 SQLCODE:  -3126  -  SQLSTATE:
 SQL3126N  Remote client requires absolute path for files and directories.

Thanks.

Upvotes: 0

Views: 833

Answers (1)

mao
mao

Reputation: 12307

Do you mean to use the 'load client' syntax (instead of just load) ?

See the details in the documentation.

The LOAD command requires that the files to be loaded are already on the Db2-target-server.

The LOAD CLIENT alternative allows the files to be on a remotely connected Db2-client (or on your Windows Db2-server if that is the source machine).

You can also just copy the IXF files to the Linux Db2-server, and open an SSH session to that Linux environment and run the LOAD command there. Your choice.

As with the LOAD command, LOAD CLIENT operates on one file at a time (in your case, one file per table) unless using lobsinsepfiles option, or other special cases.

Upvotes: 1

Related Questions