Project Cleanup

bdixon · Post by **bdixon** » Tue Nov 22, 2005 10:42 pm

Hi All,

I have just upgraded from datastage 5.2 to 7.5.1A and in the administrator there is no cleanup button for the project. Can anyone tell me where this has gone or if it is now replaced with something else?

Brad

chulett · Post by **chulett** » Wed Nov 23, 2005 7:31 am

Pretty sure that all that option did was reindex the project and yes, it has been removed from the Administrator. You can fall back on the 'old fashioned' way and do the reindexing from DS.TOOLS or directly from a TCL prompt.

An exact search on 'cleanup project' will turn up quite a number of examples, Brad.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 23, 2005 10:03 am

As well as reindexing, Cleanup also searched for and removed orphans left over from incomplete job deletions. Yes, "they" took it out with no explanation given.

bdixon · Post by **bdixon** » Wed Nov 23, 2005 5:20 pm

how can i now in version 7.5 removed orphans left over from incomplete job deletions ?

ray.wurlod · Post by **ray.wurlod** » Thu Nov 24, 2005 2:54 am

Prevention is better than cure. "They" have allegedly made the deletion process more robust - the justification for removing the functionality.

I believe it still exists under the DS.TOOLS menu, however. Even if it doesn't, the command that it used to drive is almost certainly still in the VOC file, and if that's not there, the CLEAN.ACCOUNT tool will do it for you.

But, really, you don't need to be paranoid about things - orphans take up a tiny amount of disk space and don't really get in the way.