RE: How do I truncate a LONG transaction

Doug You can try Informix Support, but unless you have a free log (LBU_PRESERVE=1) the answer will be to recover from archive. You can roll forward your logs, but NOT to the start of the offending transaction. Murray Wood -----Original Message----- From: Doug Gray [SMTP:dgray@coldstorage.com] Sent: Sunday, November 21, 1999 8:43 PM To: informix-list@iiug.org Subject: How do I truncate a LONG transaction My high watermark and exclusive high watermark were set too high and I have a transaction that has filled up my logs my system won't recover from it. I need to kill or truncate that transaction, can someone tell me how. Thanks Doug