Skip to Content
avatar image
Former Member

Backup post archiving into SAP IQ

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 07, 2015 at 07:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 30, 2015 at 06:53 PM

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

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

    Add comment
    10|10000 characters needed characters exceeded