How much time CLEAR command takes to clear RT_LOG of 2 GB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
How much time CLEAR command takes to clear RT_LOG of 2 GB
How much time CLEAR.FILE RT_LOGnnn command takes to clear RT_LOG of 2 GigaBytes (executing this command from DataStage Administrator).
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.