IDS Forum

Re: Logical logs - push or pull?

Posted By: Art Kagel
Date: Thursday, 3 October 2013, at 10:08 a.m.

In Response To: RE: Logical logs - push or pull? (Alexandre Marini)

Um, Andre, what you describe would be a PUSH since the ALARMPROGRAM is
pushing them out.

I would disagree about delaying until there are several logs outstanding.
The whole point of backing up the logs, as alluded to by others, is to
make sure you can restore to the last transaction possible if you lose the
entire server machine. Can't do that if several logs are only on disk in
the server and not yet backed up.

Art

Art S. Kagel, Principal Consultant

Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Thu, Oct 3, 2013 at 9:24 AM, Alexandre Marini <alexandre@briug.org>wrote:

> Hello.
> It is always the best practice to pull the logs, but make sure you have
> enough
> backup window in your SM/drives, so that your backups will not be hang in
> the
> line.
>
> This is great for dedicated drives, but if your SM is managing several
> databases/OSes backups, you might face some long periods of long backup
> lines.
>
> You can also modify your alarmprogram, so that Informix only starts to pull
> the logs after some amount of logs are not backed up. If you need help,
> please
> advice.
>
> Regards.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Informix Senior DBA - Orizon Brasil
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: smiley73@gmail.com
> > Subject: Re: Logical logs - push or pull? [31590]
> > Date: Thu, 3 Oct 2013 09:03:33 -0400
> >
> > Bill
> >
> > By pushing the logs you are sure they get backed up the instant they fill
> > and
> > so your roll-forward point is as recent as possible. If you pull the logs
> > (depending on your interval between the pulls) you may not get a log
> backed
> > up for some minutes after it fills. If you lose your machine in this
> period
> > and
> > have to restore then you will not have this log to use for roll-forward.
> >
> > Would not be an issue if the pull process could switch to the next log
> > before
> > pulling but I don't know if that is possible.
> >
> > Keith
> >
> > On 3 October 2013 13:01, BILL GLIDDEN <bglidden1962@gmail.com> wrote:
> >
> > > Good morning folks,
> > >
> > > We have implemented On-Bar with the CommVault Simpana storage manager
> > > (love it
> > > so far!). I'm wondering if there is any advantage either way to a)
> letting
> > > Informix backup the logical logs through ALARMPROGRAM (push) or b)
> > > scheduling
> > > periodic logical log backups through Simpana (pull)?
> > >
> > > I have my own opinion on this, but would like some other opinions so
> that
> I
> > > can state my case with backup :)So even if your thoughts are basic, and
> you
> > > feel like answering, go for it.
> > >
> > > Thanks!
> > >
> > >
> > >
> > >
> >
>
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11332252dec53504e7d5cf0d
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e012946ba5f96df04e7d6b704

Messages In This Thread

• Logical logs - push or pull?
  BILL GLIDDEN -- Thursday, 3 October 2013, at 8:01 a.m.
  • Re: Logical logs - push or pull?
    Art Kagel -- Thursday, 3 October 2013, at 8:15 a.m.
  • Re: Logical logs - push or pull?
    Fernando Nunes -- Thursday, 3 October 2013, at 8:56 a.m.
    • Re: Logical logs - push or pull?
      Art Kagel -- Thursday, 3 October 2013, at 10:04 a.m.
      • Re: Logical logs - push or pull?
        Cesar Inacio Martins -- Thursday, 3 October 2013, at 12:09 p.m.
  • RE: Logical logs - push or pull?
    Mueller, Daniel D. -- Thursday, 3 October 2013, at 8:57 a.m.
  • Re: Logical logs - push or pull?
    Keith Simmons -- Thursday, 3 October 2013, at 9:03 a.m.
    • RE: Logical logs - push or pull?
      Alexandre Marini -- Thursday, 3 October 2013, at 9:24 a.m.
      • Re: Logical logs - push or pull?
        Art Kagel -- Thursday, 3 October 2013, at 10:08 a.m.
      • Re: Logical logs - push or pull?
        Madison Pruet -- Thursday, 3 October 2013, at 10:34 a.m.
  • Re: Logical logs - push or pull?
    BILL GLIDDEN -- Thursday, 3 October 2013, at 9:21 a.m.
    • Re: Logical logs - push or pull?
      Madison Pruet -- Thursday, 3 October 2013, at 9:38 a.m.
      • Re: Logical logs - push or pull?
        Paul Watson -- Thursday, 3 October 2013, at 10:45 a.m.
  • Re: Logical logs - push or pull?
    Khaled Bentebal -- Thursday, 3 October 2013, at 11:08 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.