Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
nansekar
Participant
Posts: 29 Joined: Mon Nov 03, 2008 6:23 am
Post
by nansekar » Wed Aug 08, 2012 11:29 pm
Hello
Is it possible to copy a dataset with a orchadmin Dump command.
For eg. if i have created a dataset as ABC.ds in a Job and i want to have a copy of the dataset as ABC_DATE.ds.
In my 2nd Job can i read the ABC_DATE.ds,
is there any possiblites, if so a seperate Datafile n descriptor file will be created ?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Aug 08, 2012 11:59 pm
Yes. Exactly as you say.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ShaneMuir
Premium Member
Posts: 508 Joined: Tue Jun 15, 2004 5:00 am
Location: London
Post
by ShaneMuir » Thu Aug 09, 2012 2:02 am
There is an orchadmin copy command.
>> orchadmin cp <from.ds> <to.ds>
nansekar
Participant
Posts: 29 Joined: Mon Nov 03, 2008 6:23 am
Post
by nansekar » Thu Aug 09, 2012 7:21 am
Thank you Ray, I have tried the Orchadmin Cp command and it worked..
Is it advisable to copy datasets using this command.. Are there any possibilites that the dataset would be corrupted.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Aug 09, 2012 7:35 am
nansekar - actually, your advice came from ShaneMuir , not Ray.
nansekar
Participant
Posts: 29 Joined: Mon Nov 03, 2008 6:23 am
Post
by nansekar » Thu Aug 09, 2012 8:05 am
ShaneMuir wrote: There is an orchadmin copy command.
>> orchadmin cp <from.ds> <to.ds>
Thank you Shane Muir. The orchadmin cp command worked
ShaneMuir
Premium Member
Posts: 508 Joined: Tue Jun 15, 2004 5:00 am
Location: London
Post
by ShaneMuir » Thu Aug 09, 2012 8:46 am
nansekar wrote: Is it advisable to copy datasets using this command.. Are there any possibilites that the dataset would be corrupted.
Personally I have never seen any problem with using the command. I have used it extensively to capture datasets after an abort with no issues.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Aug 09, 2012 8:53 am
I am using this at my present site to copy datasets around (for CDC and recovery purposes), perhaps 30-60Gb per day in about 40 datasets. It is as efficient as one can get since it mainly uses the OS-level cp which is about as fool-proof as one can get.
nansekar
Participant
Posts: 29 Joined: Mon Nov 03, 2008 6:23 am
Post
by nansekar » Fri Aug 10, 2012 1:59 am
Thank you DSXchange.. marking this topic has resolved.