DSXchange

Hi There,

What happens actually if we do not Clear & PH& logs & RT_LOG at regular intervals or if we dont clear the unwanted logs in scratch disk.

Can it cause datstage jobs being HUNG or LOCKED?


thanks in advance for kind input on this.

Akumar

Nothing will happen.

I thought a poster who is level 5 in both Server and PX will be aware of that.

Well ... in my humble opinion I would clear those logs regulary, DS jobs can and will fail if not under certain conditions

It will be good to state that I'm just level 3, not 5 (Before I get a very rude or judgemental reply from another level 5 poster)

Regards

Yeah... creates an issue when the &PH& gets full.
And RT_LOG, you can purge it with Admin level settings. Either Time based or run based.
Maintenance is all what, we talking about.

Hi Kumar , thanks for the kind input on this , however I just wanted to know whether this will cause datstage jobs being HUNG/LOCKED or not?

I believe it should never get hung or get locked because of it.

Hi

Best one clear every month or ever weekly.

Datastage will not hung but bit slow down when you compile or view log.


Thanks
Man

Unless you get warnings on every row then a log file will not get filled up. By default they hold 2GB. &PH& is a directory and the files in here are very small. I have seen a lot of places not clear these and they run fine. Logs should be auto purged based on days or number of job runs especially in DEV. Set these up at the begining of a project.

You may want to change your rating. It is usually wise to be under estimated than over estimated on a web site like this. Make yourself a 5 on your resume otherwise you might take abuse from someone on this site. Ray can call himself a 1 and everybody knows he is a 5. The truth is nobody knows it all. So you might be a 5 in many aspects. I have no idea. Besides it is just a number.

The more entries that exist in &PH& and/or logs, the slower job startup times will be, particularly on operating systems that use linear directory file structures. &PH&, being a directory, can not fill with files until there are more than 4G entries (or the disk fills).

If RT_LOGnnn fills (reaches 2GB) it will become corrupted. It will no longer be able to open this log in Director (fortunately Clear Log can be invoked from Status view). A full log will not prevent the job from being opened in Designer. However a full or corrupted log will prevent the job from being run.

We have had instances where the RT_LOGnnn files got huge and it slowed the start up times of the parallel jobs literally around 2-4 minutes. We cleared the log files and things came back to normal.