Re: How can fetch cause long transaction

Posted in 2008

Nilesh Ozarkar — Sat, 16 Feb 2008 16:11:29 -0600 — source: Usenet: comp.databases.informix

> I have one more question: > > When DYNAMIC_LOG is set 2, does it starts to add more logical logs > dynamically when next logical log in the sequence has open > transaction. Does this become active only during roll back and next > logical log has an open transaction or could it also become active if > all the logical logs need backup ? It is used only to avoid database server hangs from a long transaction rollback. Nilesh.