How to delete a dataset file which is in unix server

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

Post Reply
jpradeep.net
Participant
Posts: 21
Joined: Mon Jul 12, 2010 2:05 am
Location: India

How to delete a dataset file which is in unix server

Post by jpradeep.net »

to delete the datafile and descriptor file belongs to a dataset which is in a unix server
nitkuar
Participant
Posts: 46
Joined: Mon Jun 23, 2008 3:09 am

Post by nitkuar »

In datastage 8x version, we can delete datasets(descriptor and their corresponding data files) using orchadmin del <dataset_name> ...not sure about version 7x...but u can give a shot...

Thanks
Nitin
sultan@cts
Participant
Posts: 31
Joined: Thu Jul 05, 2007 11:57 pm
Location: India
Contact:

Re: How to delete a dataset file which is in unix server

Post by sultan@cts »

jpradeep.net wrote:to delete the datafile and descriptor file belongs to a dataset which is in a unix server
Orchadmin is a command line utility provided by datastage to research on data sets.

search for the Orchadmin commadns to delete the dataset.

other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset management utility.
Thanks
Sultan
jpradeep.net
Participant
Posts: 21
Joined: Mon Jul 12, 2010 2:05 am
Location: India

Re: How to delete a dataset file which is in unix server

Post by jpradeep.net »

sultan@cts wrote:
jpradeep.net wrote:to delete the datafile and descriptor file belongs to a dataset which is in a unix server
Orchadmin is a command line utility provided by datastage to research on data sets.

search for the Orchadmin commadns to delete the dataset.

other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset managenet utility.

Thank you verymuch
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

nitkuar wrote:In datastage 8x version, we can delete datasets(descriptor and their corresponding data files) using orchadmin del <dataset_name> ...not sure about version 7x... but u can give a shot...
It's there in 7.x as well. And it's "you", not "u" please.
-craig

"You can never have too many knives" -- Logan Nine Fingers
srinivas.g
Participant
Posts: 251
Joined: Mon Jun 09, 2008 5:52 am

Post by srinivas.g »

use the below command
orchadmin rm "datastet.ds"
Srinu Gadipudi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Amazed that no-one mentioned the Data Set Management utility available from the Tools menu in Designer client. Simply select the Data Set and click the Delete tool.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

ray.wurlod wrote:Amazed that no-one mentioned the Data Set Management utility
Its there :idea:
sultan@cts wrote: other wise you can delete the dataset from dstaset management utility also, which you can find in Datastage designer tool-->dataset managenet utility.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ray kind of... skims... sometimes. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
rahulverma
Participant
Posts: 11
Joined: Wed Feb 25, 2009 11:00 pm
Location: Bangalore/Hyderabad

Post by rahulverma »

The unix rm utility cannot be used to delete the datasets. The orchadmin delete or rm command should be used to delete one or more persistent data sets.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

rahulverma wrote:The unix rm utility cannot be used to delete the datasets.
Instead of "can not", I would use "should not". rm command can be used if you understand what you need to delete and from where. However I won't suggest any one to use that as there are more sophesticated and cleaner utilities/tools to do the same like orchadmin and dataset management utility.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply