Skip to Content
Technical Articles
Author's profile photo Bhargav Bhatt

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

 

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Robert Waywell
      Robert Waywell

      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 )

       

      Author's profile photo Bhargav Bhatt
      Bhargav Bhatt
      Blog Post Author

      Hi Robert,

      Yes you are right.. Thank you for bringing this up.

      Regards

      Bhargav Bhatt

      Author's profile photo Roland Kramer
      Roland Kramer

      Hello Bhargav Bhatt

      you can use tx. DBACOCKPIT to monitor the SAP IQ Database

      Note 3094594 – Enable SAP IQ for DBACOCKPIT

      a new and improved update for DBACOCKPIT is available soon. See also the Answer in the Question -  How to Capture Historical Database and DB Space Sizes in SAP HANA Cloud, data lake and SAP IQ

      best regards Roland