Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.