Archiving DataStage PX DataSets

poorna_76 · Post by **poorna_76** » Wed Jul 25, 2007 7:22 am

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.

ArndW · Post by **ArndW** » Wed Jul 25, 2007 7:34 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 25, 2007 1:27 pm

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.

ssbhas · Post by **ssbhas** » Wed Jul 25, 2007 2:22 pm

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.

Zhang Bo · Post by **Zhang Bo** » Wed Jul 25, 2007 9:19 pm

but why when i used orchadmin cp,system reply
-bash: orchadmin: command not found,
wish your reply

ArndW · Post by **ArndW** » Wed Jul 25, 2007 9:30 pm

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.

poorna_76 · Post by **poorna_76** » Thu Jul 26, 2007 2:16 pm

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.