We are doing async HDR. Our network pipe from Austin to Denver is DS3
45 mbits/sec. The ping time is 33 ms.
I didn't notice any L0, L1, or L2 at the time. Though I did see the
logbf in the cond wait.
Thanks,
Lynn Nguyen
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Madison Pruet
Sent: Wednesday, February 28, 2007 4:54 PM
To: informix-list@iiug.org
Subject: Re: cond wait: drcb_bqe problem
Lynn Nguyen wrote:
> Hello,
>
> We're having big performance problem with replication (HDR) and hoping
> you can help providing some suggestions. With replication on, our
> applications take 4 times longer to run. Onstat -g ses on the session
> showed a status of "cond wait drcb_bqe". I understand that this means
> sqlexec thread is waiting for an empty buffer arriving in the HDR
buffer
> queue, but I couldn't find any suggestions or solutions on the IBM
site
> as well as on IIUG.
What is the ping time between the primary and the secondary? Since you
are seeing the cond wait drcb_bqe, I'm assuming that you are doing async
HDR. Are you also seeing L0, L1, or L2 waits when doing onstat -g ath?
M.P.
>
> This problem has been reported to IBM Technical Support, but so far,
no
> solutions or recommendations provided. I'd appreciate any help you
can
> provide.
>
> Relevant info: IDS 9.40.FC5, AIX 5.2.
>
> Regards,
>
> Lynn T. Nguyen
>
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list