Re: Re: CKPT REQ - Blocked:CKPT

Rajib, I have the same problem when I restored my latest backup to the Primary. Can I just kill this user session that has the flag -X? Thanks fo your help. P.S. I can ping my secondary so my network connection seems to be good. Originally posted by Rajib Sarkar > 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: > Wrom: DDJBLVLMHAALPTCXLYRWTQTIP > 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 -- Posted via http://dbforums.com