Re: Permenant Recovery

In article <5jhr73$9c6$1@gulfa.kuwait.net>, Rudy Fernandes <rferdy@kuwait.net> writes >In article <01bc4eda$a357ab40$7ec348c2@lyndons>, > "L.Shaw" <lyndons@enterprise.net> wrote: >>I am runing Informix Online 7.13 and today the system came to a stand still >>as the logical logs passed the declared High Water Mark and the logs >>completely filled. >> >>I made the mistake of shutting the system down, but what I believe I should >>have done was back up the logs to relieve some space. > >This appears to be a Long Transaction problem. Backing up of logs would NOT >help. In fact, the only available option when your system locks >because of a Long tx is to restore from your previous Level 0. > Or call Informix support who will be able to truncate the logical log back to the last checkpoint or possibly add a logical log. They have tools that can do this. These are not given to customer (it is a sackable offence for an Informix emploeee to leave these tools on a cutstomers machine!). -- David Williams