Migrating Event Collector Data for Oracle

If the database you are using is Oracle, you must install and run the migration stored procedure for Oracle to migrate the Event Collector data.

1. Copy the stored procedure file to a temporary location on the server, for example, C:\temp\install-migration-tools.sql.
2. Open the SQL*Plus command window and login using the TIBCO ActiveMatrix BPM Runtime Database user (default: bpmuser ) credentials.
3. Execute the following command to install the stored procedures and create the ec_migration table used to migrate the Event Collector data.

   @C:\temp\install-migration-tools.sql

4. You may have large amounts of event data to migrate, depending on the size of your system. Therefore, the amxbpm_migrate_events stored procedure enables you to specify the number of events to migrate, and the commit batch size. Execute the command multiple times to migrate the data. Call the amxbpm_migrate_events stored procedure directly. For example:

   CALL amxbpm_migrate_events(parameter1, parameter2)

   where:

   • parameter1 is the number of events to be migrated.
   • parameter2 is the batch size to commit.

   The default is 20,000 events in batches of 500. This results in the most recent 20,000 events being migrated. Repeat this command until all your data is migrated. For example:

   CALL amxbpm_migrate_events(20000, 500)

5. Once your data has migrated, run the following command to remove the migration tools used to migrate the Event Collector data.

   @C:\temp\remove-migration-tools.sql