I'm running Informix IDS 7.3 on RH 7.2. The logical logs have filled up and I can't connect. A message says backup is needed. The system was originally set up to dump the logs so they never fill up. Since that time, a new chunk was added to the root dbspace. Also, a new dbspace was created in another new chunk.
So far I haven't been able to do the archive. The server only comes up in quiescent mode. No connections are possible in quiescent mode, and I don't know wheter archives can be run from quiescent mode. When I try to archive (ontape -s -L 0), the message returned is "server is in incompatible state or user authentication failure". The user has successfully archived in the past, so I don't think that's the problem.
The server entered this state when a large transaction was run and filled the logical log files.
RE adding new log files. I read that new log files wouldn't be available to use until an archive is performed. Do you know if that is correct? So far I haven't been able to do an archive (ontape -s -L 0).
I'm in the process of trying emergency logical log file backup, using ondatartr as described in ch. 6 and ch. 9 of IDS 7.3 Archive and Backup Guide. If anyone has any experience with using ondatartr to do emergency logical log backups, I'd be happy to hear about it. In the meantime, I'll be reading the documentation and giving it a try.
I found that suggestion on a post from jsalomon(guest) on 4-5-2001.