Re: cond wait: drcb_bqe problem

Lynn, Will you let me know if support recommends anything or finds a solution to your problem. I am currently experiencing a similar issue with HDR, logbf cond waits and long checkpoints. Thanks, Andrew ----- Original Message ----- From: "Lynn Nguyen" <Lynn.Nguyen@the401kcompany.com> To: "Madison Pruet" <mpruet@tx.rr.com>; <informix-list@iiug.org> Sent: Thursday, March 01, 2007 8:50 AM Subject: RE: cond wait: drcb_bqe problem > > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list