Long Transactions
One of the most critical things that can happen to an Informix instance is a long transaction. A long transaction occurs when a transaction begins in one logfile and spans multiple logfiles. If it gets to a certain point of logfile usage, the transaction begins to roll back. If there is not enough logfile space available for the rollback, the Informix engine cannot make the database consistent. If this happens, the database needs to be reinitialized and restored from an archive. If you get into this problem, pray that your support contract is up to date because Informix Support may be the only source of help. Otherwise, you'll have to restore from an archive.
This is almost the worst thing that can happen to the database. You'll ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
