How to move dataset from one server to another in IBM InfoSphere DataStage

Answer

There are two options for moving a dataset:

1. Create a job that reads the dataset and writes to a sequential file.
   Then move the sequential file to the new system and create a job to read the sequential file and write to a dataset
   
2. As long as both systems can rsh/ssh between each other, you can set up a configuration file that utilizes node pools for each system.
   
   As an example:
   {
   node "node1"
   {
   fastname "server1"
   pools "Serv1" ""
   resource disk "/sample/resource" {pools ""}
   resource scratchdisk "/sample/scratch" {pools ""}}
   node "node2"
   {
   fastname "server1"
   pools "Serv1"
   resource disk "/sample/resource" {pools ""}
   resource scratchdisk "/sample/scratch" {pools ""}}
   node "node3"
   {
   fastname "server1"
   pools "Serv1"
   resource disk "/sample/resource" {pools ""}
   resource scratchdisk "/sample/scratch" {pools ""}}
   node "node4"
   {
   fastname "server2"
   pools "Serv2"
   resource disk "/sample/resource" {pools ""}
   resource scratchdisk "/sample/scratch" {pools ""}}
   node "node5"
   {
   fastname "server2"
   pools "Serv2"
   resource disk "/sample/resource" {pools ""}
   resource scratchdisk "/sample/scratch" {pools ""}}
   }
   
   Then create job on server1
   
   dataset > copy > dataset
   
   In the copy stage, set the Node Pool and Resource Constraints on advanced tab, then select Node Pool in constraint column and select Serv2 (the target node pool)
   
   Once the job has run, the data will be on the target system but the dataset header file for the target dataset will still be on the source server. You will have to move the header files to your target system (same paths).