Re: Recovery OnLine, Long TX & Full Logs

I had this problem once at the 5.x level, and the only solution (shy of physical restore from level 0) was to have an Informix Engineer dial in and "zero out" the logical log files. So physical recovery happens, logical recovery doesn't. The engineer uploaded a program called tbzero.c, compiled it, and then ran it against the engine. We lost the pending transactions, but that was all. Leos Urban <Leos.Urban@aitix.cz> wrote in article <346d4332.1627990@news.cesnet.cz>... > Hi, > We tested some problem on our old OnLine (5.03) & OnLine went down > :-)) > > Situation is very simply: we executed some UPDATE on big table, filled > all logical logs and then we restarted OnLine. > > Now OnLine is in Recovery Mode and wait for checkpoint and Logs. > > * Logs are full. > * Backup of LL does nothing, because all logs are filled in one > uncommited transaction > * We cannot add new LL, we are not in quiescent mode. > * checkpoint (tbmode) doesn't make nothing > > We can reinitialize OnLine but for experience - have you any tip? > > Leos Urban >