Separating O4I from IS DB

, ,
1

Hi Team,

As of now we are using same DB for our Integration Server and O4I. Please let us know the procedure to separate the DB for O4I. And what can be its impact.

Thanks in advance.

2

Hi Priyanka,

we are using two database instances, one for main integration parts (containing IS, TN, Archive, MWS etc.) and one for the Optimize data.

Each instance has its own schema on the Optimize DB.

Create the new optimize schema on the new database and after moving the data to the new schema (your DBA might assist you here)
you can drop the optimize parts from the old db/schema.
Remember to change your optimize configuration via central configuration in MWS and to redeploy/restart your environments before dropping the old schema.

Regards,
Holger

3

Hi Team,

We are not able to find the exact table name where these O4I rules gets stored. Can u please highlight something on this.

Thanks in advance

4

Hi Priyanka,

please check if it is possible for you to extract the data via Deployer and redeploy it to new database after creating the new schema.

As the Optimize schema has a lot of objects it is quite difficult to find the correct table.

Regards,
Holger