DSXchange

Is there a way to use orchadmin or other unix utility to ftp a dataset from one server to another? If so, what is the command?

sambarand wrote:Is there a way to use orchadmin or other unix utility to ftp a dataset from one server to another? If so, what is the command?

unable to move or copy the data set

we want to copy the dataset from one server to another..

sambarand wrote:we want to copy the dataset from one server to another..

it is not possible, if copy the dataset from one server to another server,dataset control file will missed out,
better to load with datastage job from one server to another server

You can copy a dataset from one server to another, but it is not very simple. Do an "orchadmin ll {dataset}" to your descriptor file. That will give you the names and paths to the actual data files. Copy the descriptor and data files to the new machine, the descriptor file can go anywhere, but the data files must be located in the same path on the new machine as on the old.

Sam

if it is NFS mounted between 2 server . you can copy dataset by creating a job were input dataset pointing to 1st server and output dataset to other server . its like file sharing in windows

Thanks
Sanjay

n.parameswara.reddy@accen wrote:

sambarand wrote:we want to copy the dataset from one server to another..

it is not possible, if copy the dataset from one server to another server,dataset control file will missed out,
better to load with datastage job from one server to another server

Copying across mounted file systems will not make difference as the data location is controlled by configuration file.

You will have to force a different configuration file during your copy.

Thanks all for your suggestions..