IDS Forum

Re: ONTAPE Level 1 resource usage

Posted By: MATTHEW HOUSTON
Date: Wednesday, 18 April 2012, at 9:37 p.m.

In Response To: Re: ONTAPE Level 1 resource usage (Art Kagel)

Art:

I would love to attend ANYTHING to get up to speed, unfortunately my current company is a bit short sighted when it comes to that. I only inherited this project as it runs on a Linux box and I'm the only one who knows anything about Linux, I have absolutely zero knowledge in DB admin let alone Informix. I'm in Sydney, AUS at the moment so it might be a bit of a stretch to get the company to spring for that sort of flight!

The process for logical logs seems to be just as simple, and easy enough to teach to the non-Linux guys so I thank you again for your help!

I'm still slogging through the Informix documentation but what I was after was a timed backup (e.g every 10 minutes), is it possible to have the logs rotate on a schedule rather then wait until they are full?

Can I get your insight on the two possible scenarios I'm looking at:

1. Increase the log number and decrease the size so that the logs are cycled more regularly, triggering the ALARMPROGRAM setting. Downside is that no guarantee when this will run - for instance at the moment the log files are running at whatever the original guys set it up to and doesn't rotate at all during the day, the only log I can see generated is at 7:10PM, that's how little transactions are being put through. Some hours will get a lot of activity, some not much at all.

2. Rotate the log manually at intervals using a cron job, allows us to specify exact times for the backup regardless of activity in the DB.

I'm leaning towards the second option as the management is very set on having specifically timed backups.

I cant believe I didn't include this before, such bad manners, but output of onstat -version:

$ onstat -version

Program Name: onstat
Build Version: 11.50.FC5WE
Build Number: N104
Build Host: vidar
Build OS: Linux 2.6.9-34.ELsmp
Build Date: Tue Jul 14 19:22:49 CDT 2009
GLS Version: glslib-4.50.FC6

Messages In This Thread

• ONTAPE Level 1 resource usage
  MATTHEW HOUSTON -- Wednesday, 18 April 2012, at 7:27 p.m.
  • Re: ONTAPE Level 1 resource usage
    Fernando Nunes -- Wednesday, 18 April 2012, at 7:43 p.m.
  • Re: ONTAPE Level 1 resource usage
    Art Kagel -- Wednesday, 18 April 2012, at 8:09 p.m.
  • Re: ONTAPE Level 1 resource usage
    MATTHEW HOUSTON -- Wednesday, 18 April 2012, at 8:48 p.m.
    • Re: ONTAPE Level 1 resource usage
      Art Kagel -- Wednesday, 18 April 2012, at 9:08 p.m.
      • Re: ONTAPE Level 1 resource usage
        MATTHEW HOUSTON -- Wednesday, 18 April 2012, at 9:37 p.m.
        • Re: ONTAPE Level 1 resource usage
          Art Kagel -- Wednesday, 18 April 2012, at 11:09 p.m.
          • Re: ONTAPE Level 1 resource usage
            MATTHEW HOUSTON -- Monday, 23 April 2012, at 9:03 p.m.
            • Re: ONTAPE Level 1 resource usage
              Art Kagel -- Monday, 23 April 2012, at 9:09 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.