Datastage - House keeping

RelianceDss · Post by **RelianceDss** » Sat Jun 02, 2007 1:38 am

Hi,

At times our datastage project just hangs. We are not able to do anything, not even reset the aborted jobs. We clear the &PH& directory by CLEAR.FILE command and everything is normal.
1. Is it standard pratice to use CLEAR.FILE for clearing &PH&? If not what is the alternative?
2. Is there any check list we can maintain for regular house keeping? Basically what are the different things we need to keep track off for good administration of the project?
3. Do we have any best practice document for these things?

any help on this is appreciated.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 02, 2007 3:03 am

1. Yes. Alternative is delete entries more than x days old.

2. Purge job logs. Clean up unneeded files in UVTEMP directory.

3. No.

RelianceDss · Post by **RelianceDss** » Wed Jun 20, 2007 7:24 am

Thnks a lot Ray.

We have incorporated ur suggestion.

rgrds
deepak

ray.wurlod · Post by **ray.wurlod** » Wed Jun 20, 2007 5:03 pm

More 2. If you use server side tracing clean these files from the &COMO& directory once you've finished with them.