How much time CLEAR command takes to clear RT_LOG of 2 GB

satish_valavala · Post by **satish_valavala** » Fri Feb 20, 2009 3:50 pm

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

chulett · Post by **chulett** » Fri Feb 20, 2009 3:52 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Feb 20, 2009 5:10 pm

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

chulett · Post by **chulett** » Fri Feb 20, 2009 5:13 pm

Or that.

kduke · Post by **kduke** » Fri Feb 20, 2009 5:14 pm

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.

chulett · Post by **chulett** » Fri Feb 20, 2009 5:19 pm

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.

kduke · Post by **kduke** » Sat Feb 21, 2009 12:11 am

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

ray.wurlod · Post by **ray.wurlod** » Sat Feb 21, 2009 2:41 am

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.