Backup post archiving into SAP IQ

[Former Member]

Hi Team,

Have heard about the option about that an event is triggered post archiving has finished into the SAP IQ side.

When the event has been triggered, how do we define on SAP IQ side for the backup to be triggered?

[tayeb_hadjou · Accepted solution]

Hi,

Is your event created with event type "BackupEnd" ?

I've just done a simple test in IQ16 SP08 PL35 on Windows. It worked as expected :

-- Create test event

Create event backup_test

TYPE BackupEnd

handler

begin

Message 'HELLO. Backup process finished. BY'

end ;

-- Enable it

alter event backup_test enable ;

- Perform a full database backup

backup database to 'repro.bck' ;

-- Look in srvlog or IQ windows messages

Starting checkpoint of "repro" (repro.db) at Wed Oct 07 2015 09:16

Finished checkpoint of "repro" (repro.db) at Wed Oct 07 2015 09:16

Starting checkpoint of "repro" (repro.db) at Wed Oct 07 2015 09:21

Finished checkpoint of "repro" (repro.db) at Wed Oct 07 2015 09:21

HELLO. Backup process finished. BY

Starting checkpoint of "repro" (repro.db) at Wed Oct 07 2015 09:21

Regards,

Tayeb.

[Former Member]

We have a note for correction but not sure about the process.

Event based backup automation does not work with SAP IQ sp03 1966432