SEO

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