CDR Issue
Aix 6.1 IDS 11.70.fc3X9 I got the below message tonight in my online log. about 2 hours later I got a second message showing that the snooping was complete and the users were unblocked. What sort of thing might cause this to happen? Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 ----- Forwarded by Peter Logan/Corporate/Spartan on 05/05/2013 01:22 AM ----- From: informix (spartan42) <informix@spartan42.spartanstore.com> To: pdllogan77@yahoo.com, peter_logan@spartanstores.com, Date: 05/04/2013 11:57 PM Subject: Re: Subject: ods_prd_tcp : Attention! : DDR Subsystem notification. To: peter_logan@spartanstores.com cc: pdllogan77@yahoo.com DDR Log Snooping - DDRBLOCK phase started, userthreads blocked
You are out of or cdr thinks you are close to being out of logspace Cheers Paul Paul Watson +1 913-387-7529 www.oninit.com On May 5, 2013, at 0:26, "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> wrote: > Aix 6.1 > IDS 11.70.fc3X9 > > I got the below message tonight in my online log. about 2 hours later I > got a second message showing that the snooping was complete and the users > were unblocked. What sort of thing might cause this to happen? > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 05/05/2013 01:22 AM > ----- > > From: informix (spartan42) <informix@spartan42.spartanstore.com> > To: pdllogan77@yahoo.com, peter_logan@spartanstores.com, > Date: 05/04/2013 11:57 PM > Subject: Re: > > Subject: ods_prd_tcp : Attention! : DDR Subsystem notification. > To: peter_logan@spartanstores.com > cc: pdllogan77@yahoo.com > > DDR Log Snooping - DDRBLOCK phase started, userthreads blocked > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.
What is strange is this has now happened 3 times in the past couple of months ... Always on a Saturday night, always a couple of hours after a reboot. Nothing has changed with the databases and from what I'm told no new jobs are executing and the data volumes are the same. One thing I still have to check out is that I believe they may have moved a couple of the servers from Fiber Channel adapters to virtual IO cards ... which I fought and lost ... might something like that cause this? Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Paul Watson" <paul@oninit.com> To: ids@iiug.org, Date: 05/05/2013 01:15 PM Subject: Re: CDR Issue [30195] Sent by: ids-bounces@iiug.org You are out of or cdr thinks you are close to being out of logspace Cheers Paul Paul Watson +1 913-387-7529 www.oninit.com On May 5, 2013, at 0:26, "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> wrote: > Aix 6.1 > IDS 11.70.fc3X9 > > I got the below message tonight in my online log. about 2 hours later I > got a second message showing that the snooping was complete and the users > were unblocked. What sort of thing might cause this to happen? > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 05/05/2013 01:22 AM > ----- > > From: informix (spartan42) <informix@spartan42.spartanstore.com> > To: pdllogan77@yahoo.com, peter_logan@spartanstores.com, > Date: 05/04/2013 11:57 PM > Subject: Re: > > Subject: ods_prd_tcp : Attention! : DDR Subsystem notification. > To: peter_logan@spartanstores.com > cc: pdllogan77@yahoo.com > > DDR Log Snooping - DDRBLOCK phase started, userthreads blocked > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Peter Look in the the syscdr_ddr table, ddrblock is triggered if you are heading for a log wrap If the engine is approaching ddrblock then you should also see spooler threads that will spool transactions to disk, this should allow the replay position to advance. If ER reaches the point that all the dd_logpage2block are exhausted then you will be get a DDRBLOCK. You minimize the likelihood of a DDRBLOCK by setting the LTX watermarks to say 35/45 (LTXHWM ~25/35% of LTXEHWM) You can also look at CDR_MAX_DYNAMIC_LOGS - 0 is off, -1 is unlimited, positive integer is the max that can added. With ER you really can't have too many logs :)' Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Monday, May 06, 2013 7:10 AM To: ids@iiug.org Subject: Re: CDR Issue [30206] What is strange is this has now happened 3 times in the past couple of months ... Always on a Saturday night, always a couple of hours after a reboot. Nothing has changed with the databases and from what I'm told no new jobs are executing and the data volumes are the same. One thing I still have to check out is that I believe they may have moved a couple of the servers from Fiber Channel adapters to virtual IO cards .... which I fought and lost ... might something like that cause this? Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Paul Watson" <paul@oninit.com> To: ids@iiug.org, Date: 05/05/2013 01:15 PM Subject: Re: CDR Issue [30195] Sent by: ids-bounces@iiug.org You are out of or cdr thinks you are close to being out of logspace Cheers Paul Paul Watson +1 913-387-7529 www.oninit.com On May 5, 2013, at 0:26, "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> wrote: > Aix 6.1 > IDS 11.70.fc3X9 > > I got the below message tonight in my online log. about 2 hours later I > got a second message showing that the snooping was complete and the users > were unblocked. What sort of thing might cause this to happen? > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > ----- Forwarded by Peter Logan/Corporate/Spartan on 05/05/2013 01:22 AM > ----- > > From: informix (spartan42) <informix@spartan42.spartanstore.com> > To: pdllogan77@yahoo.com, peter_logan@spartanstores.com, > Date: 05/04/2013 11:57 PM > Subject: Re: > > Subject: ods_prd_tcp : Attention! : DDR Subsystem notification. > To: peter_logan@spartanstores.com > cc: pdllogan77@yahoo.com > > DDR Log Snooping - DDRBLOCK phase started, userthreads blocked > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.