Page 1 of 1

Deletion of Dataset without Orchadmin command

Posted: Wed Jan 06, 2010 7:54 am
by ReachKumar
Hi,

I am new to DataStage. I created one dataset using ds job and i removed the dataset using rm command from unix( Without orchadmin command).

My question is, Does any information exist regarding dataset or total information has been removed.

If exists, what kind of information exists and how can we see that.

Please do the needful

Posted: Wed Jan 06, 2010 9:27 am
by chulett
Bad Idea. What exactly did you remove - a file that ended with a .ds extension? If so, that's not the dataset but rather the dataset descriptor file that has all of the metadata, including the location of the actual dataset file(s) which could be located across multiple nodes. Deleting things manually like that generally just results in orphaned data clogging up your disk space.

Use the proper tools to do this.

Posted: Wed Jan 06, 2010 11:18 am
by kduke
The files have the same name based on the directories in the config file. You can figure out what files belong to what datasets and remove them manually. As an admin I have scripts which find these orphaned files and remove them. Be careful and not remove a good file.

Posted: Wed Jan 06, 2010 11:08 pm
by ReachKumar
Hi kduke,

Can you make it clear?

Thanks for the replies guys.

Posted: Wed Jan 06, 2010 11:12 pm
by ray.wurlod
Look at the files in the directories specifed as resource disk in your configuration file. These files are the data files associated with Data Sets and File Sets. Somewhere in the very long, generated name of each is the name of the control file for the Data Set or File Set to which it belong(ed).

Posted: Thu Jan 07, 2010 1:32 am
by ReachKumar
Yup..

My configuration file uses 2 nodes and i saw two files regarding the dataset in resource disk path.

So Can we remove these two files using rm or any other way.
And if we remove using rm command, will it remove all the information regarding orphan dataset.

Thanks in advance.

Posted: Thu Jan 07, 2010 3:03 am
by ray.wurlod
Yes, provided that the xyz.ds file (the descriptor file for the Data Set) has already been deleted, which the early part of this post seems to suggest is the case.

Posted: Thu Jan 07, 2010 3:40 am
by ReachKumar
Thanks guys.. :)