Re: if logical logs got filled

In article <6emqua$eis$1@news.xmission.com>, "ANTS" <sui@naseej.com> wrote: > >Hi, > >In Informix 5.x if logical logs filled, the engine will not work until you >re-initialize it. > >However, I would like to know if there any low-level tools from Informix >where they can access the raw data and extract the data out!!!??? >We have logical log water mark set to 50%, I dont know why it's still filled >without warning! Did I miss anything?? > >System: Informix 5 on AIX 3.5 > >Regards, > >Nien > >=========================================== >Mails are checked daily and processed right away. >If you don't get my replies within 3 days please send your mail again. > > The water mark is a reference point used by *EACH QUERY* to determine whether sufficient logs remain should a rollback be required. If more than one query is running, the query that hits the 50% plateau you established would find itself out of logs should any other queries be creating log entries. Try setting the water mark to something more like 40%. Ray Garrison