orchadmin copy command

Lavanya B · Post by **Lavanya B** » Thu Sep 08, 2011 1:06 am

The requirement is: Using orchadmin command, copy the data from one dataset to a new dataset and the data files for the new dataset should be created.
I executed orchadmin copy command:
orchadmin copy | cp sourcedataset targetdataset

I see that the descriptor file for target dataset is created. However it
points to the segment file of source dataset. No data files are created for the target dataset.
But in one of the posts I read that the data file will be created for the target dataset beginning with target descriptor file name in the resource disk.
Apart from job creation, is there any other option that will suffice the requirement?

arvind_ds · Post by **arvind_ds** » Thu Sep 08, 2011 1:58 am

Try to use dataset management utility in DataStage Designer tool to copy the datasets.You need to test it first and then see whether it creates the required files or not.

kduke · Post by **kduke** » Thu Sep 08, 2011 2:22 am

There is a way to dump a dataset in orchadmin. Then you can reload to a new one. You can also switch config files this way. Don't know the syntax but I don't think it is too complex.

arvind_ds · Post by **arvind_ds** » Thu Sep 08, 2011 2:26 am

use the below command to get the syntax

orchadmin -h

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2011 4:08 am

Did you really have copy | cp in your command?

Think about what this is doing!

jwiles · Post by **jwiles** » Thu Sep 08, 2011 9:19 am

Your command string did exactly what you commanded it to do:

1) execute "orchadmin copy"
2) execute "cp sourcedataset targetdataset"

and therefore, you ended up with a copy of just the dataset descriptor file.

On the linux command line, the pipe character "|" is essentially a command separator which also routes the stdout from the left-hand command to the stdin file of the right-hand command.

By convention, in the help output of a command, the "|" is used to show optional values for a command's parameters. For orchadmin, "cp" and "copy" are the two orchadmin commands for copying a dataset. It looks like you just copied and pasted the orchadmin help output verbatim.

Regards,

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2011 4:57 pm

Looks like James did your thinking for you.

chulett · Post by **chulett** » Thu Sep 08, 2011 6:10 pm

He's a thinker, that James fella.

jwiles · Post by **jwiles** » Thu Sep 08, 2011 8:35 pm

Yeah, maybe once a month during certain moon phases...