Informix

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
------------------------------

Original Message:
Sent: Wed November 30, 2022 01:38 AM
From: Alexander Ivanov
Subject: 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

Original Message:
Sent: 11/30/2022 6:37:00 AM
From: Art Kagel
Subject: RE: Backup from InformixHQ and continous log backup

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
------------------------------

Original Message:
Sent: Wed November 30, 2022 01:38 AM
From: Alexander Ivanov
Subject: 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

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
------------------------------

Original Message:
Sent: Wed November 30, 2022 07:58 AM
From: Marcus Haarmann
Subject: Backup from InformixHQ and continous log backup

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

Original Message:
Sent: 11/30/2022 6:37:00 AM
From: Art Kagel
Subject: RE: Backup from InformixHQ and continous log backup

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

Original Message:
Sent: Wed November 30, 2022 01:38 AM
From: Alexander Ivanov
Subject: 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

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
------------------------------

Original Message:
Sent: Wed November 30, 2022 06:36 AM
From: Art Kagel
Subject: Backup from InformixHQ and continous log backup

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

Original Message:
Sent: Wed November 30, 2022 01:38 AM
From: Alexander Ivanov
Subject: 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

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
------------------------------

Original Message:
Sent: Thu December 01, 2022 01:47 AM
From: Alexander Ivanov
Subject: Backup from InformixHQ and continous log backup

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

Original Message:
Sent: Wed November 30, 2022 06:36 AM
From: Art Kagel
Subject: Backup from InformixHQ and continous log backup

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

Original Message:
Sent: Wed November 30, 2022 01:38 AM
From: Alexander Ivanov
Subject: 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