Re: Re: CKPT REQ - Blocked:CKPT

No .. don't do that ... I would suggest bouncing the SECONDARY and seeing if both servers sync up or not ... otherwise you'll have to do the physical restore to re-establish HDR again from scratch ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi antzz <member37779@dbfo To: informix-list@iiug.org rums.com> cc: Sent by: Subject: Re: Re: CKPT REQ - Blocked:CKPT owner-informix-li st@iiug.org 09/08/2003 11:42 AM Please respond to antzz 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 sending to informix-list

Rajib, How do you bounce the Secondary? Whenever I do the restore (i.e. using the same backup), I get the same problem. Pls advise. Thanks. Originally posted by Rajib Sarkar > No .. don't do that ... I would suggest bouncing the SECONDARY > and seeing > if both servers sync up or not ... otherwise you'll have to do the > physical > restore to re-establish HDR again from scratch ... > > Thanx much, > > Rajib Sarkar > Advisory Software Engineer (RAS) > IBM Data Management Group > Ph : (602)-217-2100 > Fax: (602)-217-2100 > T/L : 667-2100 > > As long as you derive inner help and comfort from anything, keep it -- > Mahatma Gandhi > > > > antzz > <member37779@dbfo To: informix- > list@iiug.org > rums.com> cc: > Sent by: Subject: Re: Re: CKPT > REQ - Blocked:CKPT > owner-informix-li > st@iiug.org > > > 09/08/2003 11:42 > AM > Please respond to > antzz > > > > > > > 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/http://dbforums.com > > sending to informix-list -- Posted via http://dbforums.com