SEO

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 [mailtowner-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