RE: Isolation Level

Posted in 2000

Srinivas Sreekumar — Wed, 13 Dec 2000 17:34:27 +0530 — source: Informix-list mailing list archive (1991-1998)

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. Informix Dynamic Server Version 7.30.UC3 -- On-Line (CKPT REQ) -- Up 01:19:19 -- 8928 Kbytes Blocked:CKPT I tried doing a manual checkpoint, but still the status is the same. Pls advice. Thsnk, Srini -----Original Message----- From: Andrew Hamm [mailto:ahamm@sanderson.net.au] Sent: Wednesday, December 13, 2000 12:10 PM To: informix-list@iiug.org Subject: Re: Isolation Level Andrew Hamm wrote in message <3a36bc4e@news.iprimus.com.au>... > >Hey - I read (in Tech Notes Vol10 issue 3) that XPS supports stored >procedures called > >public.sysdbopen() >"user".sysdbopen() > >I don't suppose the more mundane engines support that too? I suppose I COULD >test it for myself ;-( I've tested, and it appears not to be supported on 7.30 engine. Sigh.