RE: Logical Log Files are Full -- Backup is Needed

It's quite probable that you hae a large transaction that the system is trying to roll-back. In fact the onstat -l and onstat -x that you have posted show precisely that. The transaction begins in logid 33 and fills all remaining logical logs. I assume that you must have LTCHWM and LTXEHWM set above the recommended 50 and 60. Otherwise this couldn't happen. About the only thing that you can do is to grovel to IBM/Informix tech support, grease their palms with silver or probably platinum, and pray. Who configured this system? It looks remarkably poorly configured IMHO Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Thomas Ronayne Sent: 14 February 2005 17:16 To: informix-list@iiug.org Subject: Logical Log Files are Full -- Backup is Needed I've got this in online.log: Mon Feb 14 10:12:40 2005 10:12:40 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh' 10:12:46 DR: DRAUTO is 0 (Off) 10:12:46 Informix Dynamic Server Version 7.30.U Software Serial Number AAC#A404657 10:12:46 Informix Dynamic Server Initialized -- Shared Memory Initialized. 10:12:46 Physical Recovery Started. 10:12:46 Physical Recovery Complete: 131 Pages Restored. 10:12:46 Logical Recovery Started. 10:13:21 Logical Log Files are Full -- Backup is Needed I can't seem to figure out what to do to just get rid of this condition -- I don't care if the data base gets blown away (it's backed up), I don't care about recovering what's in the logs, I just want to get the engine back so I can use the thing. Can somebody please tell me what the magic incantation is? Thanks. sending to informix-list