Re: Isolation Level

Srinivas Sreekumar wrote: > > Hi DBAs, > > In one of my database I am getting he below status when I give onstat. > Informix ver is 7.30 running on HP UX. I want to know why the database is > blocked and says that checkpoin is reqd. I have got enough free logical > logs. I'm not sure what this has to do with the subject of this thread. > Informix Dynamic Server Version 7.30.UC3 -- On-Line (CKPT REQ) -- Up > 01:19:19 > -- 8928 Kbytes > Blocked:CKPT "CKPT REQ" means "Checkpoint Requested", not "Checkpoint Required". In other words the checkpoint has started but has to wait for users to exit critical sections of code. On a busy system this can take some time. > I tried doing a manual checkpoint, but still the status is the same. Well running another checkpoint whilst one is attempting to run will do nothing. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+