Setting logical log backup thresholds in 11.50
Scott Yohonn (IDS 11.50 FC8) wanted logical logs backed up to tape at least every 15 minutes for a 15-minute RPO. Madison suggested a dbcron task that runs onmode -l to force a log switch followed by the log backup. Art Kagel agreed: a cron or task-manager job running onmode -l every 15 minutes triggers ontape/onbar to back up the log. Scott said it would be easy to implement.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I am running IDS 11.50 FC8 and run continuous logical log backups to tape. I want to be able to set a threshold for my logical log backup to tape to occur at-least every 15 minutes regardless if the most current log is 100% full or not. This is to fulfill a business continuity requirement of a 15 minute Recovery Point Objective (RPO). Does anyone know if an onconfig parameter or alarmprogram setting to meet this requirement? Also, is there any impact on performance with a setting of 15 minutes? Thanks, Scott
You can set up a dbcron task to do this. Basically spawn an onmode -l to
force a log switch followed by the log backup.
From: "SCOTT YOHONN" <syohonn@gmail.com>
To: ids@iiug.org
Date: 03/23/2012 01:20 PM
Subject: Setting logical log backup thresholds in 11.50 [26564]
Sent by: ids-bounces@iiug.org
I am running IDS 11.50 FC8 and run continuous logical log backups to tape.
I
want to be able to set a threshold for my logical log backup to tape to
occur
at-least every 15 minutes regardless if the most current log is 100% full
or
not. This is to fulfill a business continuity requirement of a 15 minute
Recovery Point Objective (RPO). Does anyone know if an onconfig parameter
or
alarmprogram setting to meet this requirement? Also, is there any impact on
performance with a setting of 15 minutes?
Thanks,
Scott
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Scott,
All you have to do is to have a cron task (or an Informix task manager task
for that matter) wake every 15 minutes and execute an "onmode -l" to force
the engine to change logs. That will automatically trigger the
ontape/onbar to archive that log file. If you want to get fancy, you could
check to see if the log file has anything in it first, but otherwise this
is trivial.
Art
Art S. Kagel
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 Fri, Mar 23, 2012 at 2:19 PM, SCOTT YOHONN <syohonn@gmail.com> wrote:
> I am running IDS 11.50 FC8 and run continuous logical log backups to tape.
> I
> want to be able to set a threshold for my logical log backup to tape to
> occur
> at-least every 15 minutes regardless if the most current log is 100% full
> or
> not. This is to fulfill a business continuity requirement of a 15 minute
> Recovery Point Objective (RPO). Does anyone know if an onconfig parameter
> or
> alarmprogram setting to meet this requirement? Also, is there any impact on
> performance with a setting of 15 minutes?
>
> Thanks,
> Scott
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3bb053a3e2b504bbede3d1
Thanks guys, this will be easy to put in place. Scott