Backup from InformixHQ and continous log backup

Hello. Actually I have two questions. 1). I set up a backup from informixHQ. Is there a way to send me an email when the backup is in progress or if it fails? I have configured Informix to email me from various alerts, but I can't find the backup alert. 2).In my current configuration after log file is full alarmprogram is backup it. But backup file 1GB and it comes to full after 2-3 days of work. But I want backup it each hour. I think I can use onmode -l and ontape -a -d each hour. But it not looks fine. As another way I know about ontape -c. But i not sure how it will be work. When i start it it create backup curent log file from start or from time when i started ontape -c? How to automate use ontape-c after Informix reboot? If i can copy this file during it still in process? Or in my case it will be better use small log files? ------------------------------ Alexander Ivanov ------------------------------ #Informix

Alexander: You didn't specify your version so I can only assume it is a relatively current one, v12 or v14. On your second question: If you change your LTAPEDEV to be a directory or file system mount point ontape will create a new separate file for each logical log file. BTW, if you have it set to a file name, that file only contains a single logical log, not 2-3 days of logs. Ontape overwrites the file if it already exists, it does not append! You should have BACKUP_CMD set as follows in your alarmprogram.sh so that it uses LTAPEDEV to specify where to place the log files: BACKUP_CMD="ontape -a -d" The directory set in LTAPEDEV then will contain files that look like this: I don't have an answer to your first question. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

Hi, to question 1: https://informix.hcldoc.com/12.10/help/index.jsp?topic=%2Fcom.ibm.adref.doc%2Fids_adr_0669.htm Backup events have class id 16/17. You can react on those events in the alarmprogram Best, Marcus

Thanks a lot for your answer. Perhaps I was unclear. I was looking for the possibility of backing up log files not as they fill up, but by time. Every hour for example. It is desirable to use the internal capabilities of INFORMIX. At this point, I've come to a decision. I've set up a task through InformixHQ that runs "onmode -l" every hour. Next, alarmprogram.bat fires and saves it. ------------------------------ Alexander Ivanov ------------------------------

Thanks a lot for your answer. I would like to be able to set up task completion messages in InformixHQ, but using events is currently a good option. ------------------------------ Alexander Ivanov ------------------------------

That's exactly the way to do it. Force a switch to a new log on a schedule (hourly for example) with "onmode -l". Then the alarmprogram will take care of backing up the last logical log used. I would recommend following the onmode -l with onmode -c to perform a checkpoint. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------