Long Transaction Abort and Recovery problem with Informix Online (fwd)

Ellory Yu writes: > > Hi folks, > > I have a problem with Informix Online. I have a database with >buffered transaction logging turned on. I run an application that will select > from one table and massively insert into another table on the same database. > At some point, the logical logs fills up and sends the message "Logical Logs > are Full -- Please back up." to the turbo.log file even with continuous logs > running (to tape). The application aborts abnormally leaving the process in > a Long Transaction abort (LTX) state. Since the logical logs are full and the > process is in an LTX, it seems to be in some dead embrace. At this point, > the database is hang. Shutting it down and bring it up brings Informix Online > into a recovery mode that never recovers. > several options come to mind: 1) check into setting your LTXHWM and LTXEHWM configuration varaiable (you dont say which version of online you are running, these variables became available with v5, i think). 2) turn the buffered logging off prior to running this application using the tbtape utility and then turn logging back on after running the app. 3) break the application up into smaller chuncks. 4) possibly change the application to do a) output the data to a fixed format data file b) use dbload to load from the fixed format data file into the table with -n <some small number>, breaking the massive load into many smaller transactions. > I spoke with Informix tech support and they have given me only two > options: 1) Restore from a previous level 0 archive or 2) they dial in to our > system and patch something and gets it back online. Both these options are the 'patch' that your referring to is not desirable - it has a high chance of leaving your database in an unknown state. essentially, it tells online that there are no transactions in progress - even if there are. > unacceptable to us because of the time it takes to restore our database or > that the problem can occur in the early hours of the morning where reaching > for an Informix tech support to patch our DB is next to impossible. > > If you have a similar situation and have a solution that can be > of help, please reply. > > Ellory Yu > > -- regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | |----------------------------------------------------------------------------| | 'connectionLESS IS MORE' -- Data Broker | |----------------------------------------------------------------------------| | Duct tape is like the force. It has a light side, and a dark side, and | | it holds the universe together ... | | -- Carl Zwanzig | +----------------------------------------------------------------------------+