Oninit cdi / Archive
Talk to an expert →

RE: stuck on checkpoint

Posted in 2008

Topics: Logging & Checkpoints, Versions, Editions & End-of-Life

LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

I have a server running IDS 10. After rebooting the server, my database came back up and is stuck in a checkpoint. It has been like that for a day now. What are some suggestions of things to look at that might be the cause of the problem? LS

↪ replying to LARRY SORENSEN
NILESH BHAVSAR — — source: IIUG Forums & Mailing Lists

Hi, Whats the output of onstat - and onstat -m command? Try to give ontape -a command, if its blocked for checkpoint.It will take logical log backup clear the Blocked CKPT.

↪ replying to NILESH BHAVSAR
LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

I don't have anymore details yet. I am scheduled to log into the server soon. I just hoped to get some ideas before I get there.> To: ids@iiug.org> From: nilesh_bhavsar@satyam.com> Subject: Re: RE: stuck on checkpoint [11142]> Date: Mon, 4 Feb 2008 17:06:28 -0500> > Hi, > > Whats the output of onstat - and onstat -m command? > > Try to give ontape -a command, if its blocked forcheckpoint.It will take > logical log backup clear the Blocked CKPT. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference> The Power Conference for Informix Professionals> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas> http://www.iiug.org/conf>; Registration Now Open!!

Related threads

Glossary