Re: Permenant Recovery

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. > >Anyway when I attempted to restart the server It was in a recovery state >for at least >2hours. I interrupted the process and the system is now in a permenant >state of recovery. I cannot perform and immediate shutdown, nor can I back >up the logs as the message "server is in an incompatible state" is echoed >back. If I try and issue a checkpoint nothing happens. > >I believe to prevent future occurences I should add some more logical logs. Basically, try and prevent the 'Long trx.' lock using the following. 1. Increase the total size of your logs. 2. Reduce the size of your transactions. 3. Reduce LTXHWM and LTXEHWM significantly (50 and 60 should be OK if your logs are large enough) > > >Logical logs are not currently backed up and are piped to /dev/null. If I >use automatic backup to this device would this stop the situation happening >in future? Nope. see above. > > >Can anyone offer advice to get me back up and running, (I shall be calling >Informix Tech support tomorrow. > >I do not mind if the database loses the contents of the logs, as the work >being carried out at the time can be automatically repeated, once the >databases that were accessed at critical mass are dropped. > >Thanks in advance for your help. P.S. I have just posted some detailed info. about 'Long Tx.' - this has still to be validated by the group, but it could be worth a read. HTH. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------