Dataset Delete script

Mandy23 · Post by **Mandy23** » Fri Dec 16, 2011 11:16 am

Hi,

I have been looking for a way to cleanup Datasets created by DataStage.I have found ORCHADMIN but scenario is different.

My Jobs overwrite DataSet (*.ds) files for each run. But the files in Dataset path in the config file some times do not get deleted. If we use ORCHADMIN to delete it deletes the current dataset file. But i wanted to delete old & unnecessary files from actual dataset path for which the DataSet descriptor file is not present.

Any suggestions on this are welcome.

zulfi123786 · Post by **zulfi123786** » Fri Dec 16, 2011 11:40 am

If there are an orphan data files whose descriptor files are missing and you wish to delete the orphaned data files then go for naming convention which says the first part of the data files is the actual dataset name so try locating the dataset descriptor file from the data files if not present then delete the data files

Beware that though the above is a documented fact there is a chance that IBM can change the naming convention in the future releases

Mandy23 · Post by **Mandy23** » Fri Dec 16, 2011 11:48 am

Thanks Zulfi.