I'm trying to execute the
DB2MOVE command at a db2 prompt console in a windows 7 machine (I have db2 client installed, with proper catalogs and nodes created and tested.).
The steps I made was:
- Open the console (cmd)
- Run the
db2cmdcommand (it is on path) and it opens a new console window
- Run the db2 tool which puts me into the db2 console window
- Connect to a existent database:
connect to mydb user x using x
- Try to run the
db2move MYDB COPY -sn MYSCHEMA -tf C:/Users/MYUSER/Desktop/exp.lst -co TARGET_DB TESTDB USER user USING pass SCHEMA_MAP ((MYSCHEMA, MYSCHEMA_TEST)) PARALLEL 2
ps.: there is no enter on the command line
The error I'm getting is:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "db2move MYDB COPY -sn" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "". SQLSTATE=42601
I'm strictly following the rules on the docs what am I missing?
db2moveis an OS command, not the CLP command. You run it in the
'db2move' is not recognized as an internal or external command, operable program or batch file.Do I need to install anything in specific other than the client?
db2moveis part of the server installation, it may not be available if you only install a client.