Re: Long Transaction Abort and Recovery problem with Informix Online

Posted in 1993

andrew.shaw — Wed, 27 Oct 1993 14:55:07 GMT — source: Informix-list mailing list archive (1991-1998)

From article <yuwareCFIv7x.JL5@netcom.com>, by yuware@netcom.com (Ellory Yu): > [Infinite recovery due to massive insert filling logical logs] 1. To prevent the infinite recovery problem, set your high-water marks (*HWM in $INFORMIXDIR/etc/tbconfig file) to 50. This guarantees that any too-long transaction can always be rolled back. 2. To prevent logical logs from filling up: A. Have *lots* of them, or B. Disable logging before doing the insert (tbtape -S -N) an restore it after (tbtape -S -[UB]). Note that this operation will want to create an archive on your tape device (which can be /dev/null). C. Break up the insert into chunks that you know will fit. > > If you have a similar situation and have a solution that can be > of help, please reply. > > Ellory Yu > If this helps, can I be a beta tester for CSQUEL in an "unsupported" configuration (Sparc, SunOS4.1.3 [aka Solaris1.x], Informix Online5.0)? Andrew Shaw AT&T Bell Labs andrew.shaw@att.com