Automating SAP IQ backups using IQ cockpit

[bhargav_bhatt]

Hello Guys,

 

In this Blog I will be explaining about Backup automation of SAP IQ database and how we can schedule regular backups using SAP IQ cockpit.

for scheduling backups in SAP IQ we have first create events object in the IQ Cockpit.

Here is reference SAP Note for how to create event : https://launchpad.support.sap.com/#/notes/2743607

 

So for creating events login to SAP IQ db

execute below command for creating backup event using isql

CREATE EVENT FullBackup SCHEDULE START TIME '1:00AM' EVERY 24 HOURS HANDLER BEGIN BACKUP DATABASE full TO '/backup/path/IQ_FULL_BKP' END

 

 

This will create a backup event name " FullBackup " which will run at 1:00 AM daily

 

Now we can manage this using IQ cockpit as shown below

Click on explore tab > complied objects > Event

 

 

You have to select the event which you want to manage and click on Action button on top right corner.

 

 

on SQL you can change the backup command.

on schedules tab you can manage the time on which you want to run backup

 

 

 

Please note that backups scheduled using events generate backup file size of 2 GB each.

Hence if the size of database it large it will generate many files of 2 GB.

 

Currently SAP is working on the bug fix and you can subscribe to KBA 2697951 - SIZE clause ignored when BACKUP statement is in a procedure - SAP IQ

https://launchpad.support.sap.com/#/notes/0002697951

 

 

Regards

Bhargav Bhatt