Posted in 1997
Topics: Logging & Checkpoints
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
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.