DSXchange

How much time CLEAR.FILE RT_LOGnnn command takes to clear RT_LOG of 2 GigaBytes (executing this command from DataStage Administrator).

No time to speak of. It basically deletes what's there and recreates it empty, from what I've seen.

Subtract the time when the command is issued from the time that the command finishes, and you will have your answer.

Or that.

A lot fo the time the RT_LOG file is corrupt when it hits 2GB. Then CLEAR.FILE may never come back. Sometimes you have to trick it to fix it. You need to make sure no program has the file open. Then copy a blank file over it. If it is a dynamic file then DATA.30 and OVER.30 need to be copied over. This is a totally unsupported way to fix this. So you never heard this from me.

Hmmm... I've done CLEAR.FILE on overblown corrupted logs and don't recall it every having a problem. But then perhaps I just got lucky. Or my memory is shot.

It does not always hang. In fact most of the time it does not hang.

Indeed the only time that CLEAR.FILE can hang is if there is some obstacle to it operating - either the file being open (by any process) or any process owning an update lock of any kind in the hashed file.