Dataset removal

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
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Dataset removal

Post 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
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post 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
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post 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.
Post Reply