PI 7.0 DB migration

[Former Member]

Hi

We are using PI 7.0 (Windows environment).This is HA/Distributed environment

PI Application and DB both are running on different host with Microsft Cluster technology for HA

We wanted to move DB instance (only DB as we do not want to make any change into Application) on Linux or Solaris Server

Do we just need to use statndard OS/DB Migration system copy Guide for DB instance move to another server? We also want to have HA for DB after moving to new server

In addition to DB migration do we need to make any changes for below configuration after DB move to new server?

1. Change in PI Exchange profile file

2. SLD Configuration Changes

3. JCO Connection configuration Change

4. Visual and Configtool related changes

I appreciate expert opinion on this

Thanks in advance

Thanks

Deelip

[Former Member]

Hi Deelip,

You need to use standard OS/DB migration, though in this case you are just migrating your DB and not application, but it is advisable to run sapinst on both servers because I am assuming that generally hostname naming convention for Windows and Unix/Linux changes plus your listener settings on application server will also change,

....but if you do not wish to run migration sapinst on your app server then you need to do manual changes on app. server for listener and your DB hostname should not change.

Then you need to check "R3trans -d" for ABAP part and you need to check Configtool is getting connected or not.

Let say you will be successful in making your java up in that case also you need to send your new data to SLD, check your SMSY, LMDB for correctness of DB server information.

When your java will be up, then VA and JCo should not be an issue.

Unless you don't have enough time to go through this experimental process. Please run migration on both servers and follow PI db copy documents also for few missing post steps.

[Former Member]

Hi

Thanks for your prompt response

Need couple of clarification

you have mentioned to run sapinst on both host, are you taking about running sapinst on source DB Server and Target DB Server?

I am assuming that once DB is migrated to new host then HA Cluster configuration needs to be done, right??

Do we need to make any changes to PI Exchange profile files?

What is LMDB?

Thanks

Deelip