Page 1 of 1

Dataset removal

Posted: Wed Jan 30, 2008 12:18 am
by just4u_sharath
We remove datasets using ORCHADMIN command in unix. But once i removed a dataset using normal RM command in Unix. This deleted only descriptor file not the original data.
My question is, By mistake if we delete datasets using normal RM command (only descriptor file is deleted), can we still found the original Data and delete it

Posted: Wed Jan 30, 2008 12:24 am
by Maveric
No direct way of doing it. But there is an FAQ by Arndw which tell a way to delete the orphaned data files. This is the link to the post:

viewtopic.php?t=107450

Posted: Wed Jan 30, 2008 1:42 am
by lstsaur
Yes, you still can locate your original datasets by checking your configurations file's resource disk "/Ascential/DataStage/Datasets" {pools ""}, then you know the original datasets were created in that dirctory.

Then, go to the Datasets directory and delete the original datasets.