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
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 )
Hi Robert,
Yes you are right.. Thank you for bringing this up.
Regards
Bhargav Bhatt
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