Re: CKPT REQ - Blocked:CKPT

This means that the instance is waiting on a CHECKPOINT to complete. From the info..it looks like an HDR pair where the Primary is waiting for the Checkpoint to complete. check the onstat -u output and look for flags -X- on any of the sessions, which means this session is in a critical section of the code and the engine is waiting on that session to finish its work and then complete the checkpoint ... Since, its HDR another scenario could be that the primary is waiting on the secondary to finish its checkpoint as with checkpoints the primary-secondary pair sync up. In this situation, I think u better check up your network status as well ... HTH Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Solutions Ph: 602-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi Monday, June 23, 2003 10:44 AM To: informix-list@iiug.org cc: From: schmotom@yahoo.com (tomL) Subject: CKPT REQ - Blocked:CKPT hello, When i run (onstat -) the return i get looks like this: Informix Dynamic Server 2000 Version 9.21.HC5 -- On-Line (Prim) (CKPT REQ) -- Up 3 days 00:31:02 -- 1102976 Kbytes Blocked:CKPT could someone enlighten me what this means when i see (CKPT REQ) and Blocked:CKPT ? this gets returned when the log says a checkpoint is not even happening.... Thanks in advance! Tom sending to informix-list