Page 1 of 1

Need to know how to clean up datasets (whose header is gone)

Posted: Mon Apr 09, 2007 1:09 pm
by jherr22
Given a dataset file (xxxxx.ds), which is a pointer to the actual data stored in a Datasets directory.
If we have deleted the header file (xxxxx.ds), without using the utility 'orchadmin delete' command, then we end up with orphaned dataset file in the Datasets directory.
I understand that there exists scripts that know how to clean up such unreferenced orphaned files.
Right???
-- john herr (denver)
303-977-3955

Re: Need to know how to clean up datasets (whose header is g

Posted: Mon Apr 09, 2007 1:22 pm
by santoshg
jherr22 wrote:Given a dataset file (xxxxx.ds), which is a pointer to the actual data stored in a Datasets directory.
If we have deleted the header file (xxxxx.ds), without using the utility 'orchadmin delete' command, then we end up with orphaned dataset file in the Datasets directory.
I understand that there exists scripts that know how to clean up such unreferenced orphaned files.
Right???
-- john herr (denver)
303-977-3955
Jon,
The best way to clean up the datasets is from Datstage manager using dataset mangement utilty.

Posted: Mon Apr 09, 2007 1:35 pm
by DSguru2B
ArndW posted a method to get rid of these orphaned datasets by analyzing their magic number. He has posted commands to do so. Search for it.

Posted: Mon Apr 09, 2007 3:04 pm
by ray.wurlod
Search the disks where Data Sets are stored. Each Data Set file name includes the name of its control file. Filter on these.