Setting logical log backup thresholds in 11.50

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