ECC change with database server and operating system (OS)

[Loed]

Hi guys,

Just wanted to ask an idea regarding the upcoming database and OS change in our ECC server. They are going to move the ECC database server to another DB and change the OS from linux to windows.

1. What should be done for this kind of scenario?

2. Is there an effect/impact with the DELTA extraction for different datasources (2LIS extractors, 0FI, etc.)?

3. What should we do then to avoid the disconnection of DELTA extraction? Or do we really need to do a re-setup all 2LIS extractors?

4. Any other info that I missed to ask?

Thank you.

Loed

[FCI]

Yes, we change the OS and the server of our database (Hana) a few weeks ago. The main issue was the code page change (which impact the communication with our ETL). I'm not directly involved on the BW side but I don't see why this technical change would impact the LIS queues.

[Loed]

Hopefully there would really no impact in DELTA extraction especially with 2LIS extractors. 😄

Thanks for your info cincet.frdric2.

Loed

[FCI]

Hi Loed,

Some inputs:

1. as already said : test, test test !

2. I would expect no effect for this kind of change (OS + db server migration) but this is definitively the point to be tested thoroughly. At least, it will be better to empty the delta queues.

4. This kind of change can generate the use of a new code page (little endian vs big endian), beware of communication issues. The code page of the db is actually dependant on the hardware (see oss note 552464).

Regards,

Frederic

[Loed]

Hi cincet.frdric2,

Did you already experience similar to this scenario? We are just worried with the DELTA since we are using 2LIS extractors. So maybe we really need to re-init all datasources? Or is there a way to avoid it?

Thank you.

Loed

[TammyPowlas]

Hello - this sounds like a database migration, which we have done, and this blog covers the big steps: https://blogs.sap.com/2016/02/08/migration-to-sap-hana-best-practices/

I'll be honest -steps 2-4 - we had to redo completely (but not using LIS at the time).

Perhaps others have ideas.

[Loed]

Thanks Tammy for the link.

Any other ideas on what should be done in BW side prior to transfer of ECC DB to other DB and change of OS from LINUX to WINDOWS?

Thank you.

Loed

[TammyPowlas]

Test, test, test! There's never enough time to adequately test everything.