Skip to Content
Technical Articles

Automating SAP IQ backups using IQ cockpit

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

 

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi Bhargav,

     

    Good job on the blog.

     

    I just want to make sure that you are aware that due to the Adobe Flash EOL that will be happening at the end of this year, IQ Cockpit will no longer be available because it depends on Flash. The mitigation plan will rely on using other existing SAP IQ features and tools to accomplish the same tasks. For example you will still be able to create and use scheduled events, you will just have to create them with a CREATE EVENT SQL statement.

     

    For more information, you can keep an eye on SAP Note: 2905488 – SAP IQ Cockpit End of Life: December 2020 ( https://launchpad.support.sap.com/#/notes/2905488 )