Page 1 of 1

Archiving DataStage PX DataSets

Posted: Wed Jul 25, 2007 7:22 am
by poorna_76
Hi all,

Is there a way to archive the DataSets from one UNIX directory to other UNIX directory, without corrupting the DataSets?

Thanks in Advance.

Posted: Wed Jul 25, 2007 7:34 am
by ArndW
Use the orchadmin cp command from UNIX to copy datasets. By using a new APT_CONFIG file you can also change the location (and amount) of data files.

Posted: Wed Jul 25, 2007 1:27 pm
by ray.wurlod
You can also use the Data Set Management tool in Manager to copy the data set. Beware, though, that only the control file lives in the directory; the actual data files live in the directories identified in the configuration file as resource disk. The utilites are aware of this, and will copy the data files as well as the control file.

Posted: Wed Jul 25, 2007 2:22 pm
by ssbhas
Also, when copied with "orchadmin cp" datastage uses default config file "default.apt". Make sure that the configuration in default.apt is the one you want to use.

Posted: Wed Jul 25, 2007 9:19 pm
by Zhang Bo
but why when i used orchadmin cp,system reply
-bash: orchadmin: command not found,
wish your reply

Posted: Wed Jul 25, 2007 9:30 pm
by ArndW
You need to set up your environment correctly in order to do that. The $PXHOME/bin directory must be part of your PATH environment variable, otherwise specify the full path to that program. You will also need to specify an APT_CONFIG_FILE in your environment and running $DSHOME/dsenv should set up all your libraries correctly.

Posted: Thu Jul 26, 2007 2:16 pm
by poorna_76
ArndW wrote:Use the orchadmin cp command from UNIX to copy datasets. By using a new APT_CONFIG file you can also change the location (and amount) of data files.
Thanks Arndw.