MaxDB read only state

[former_member239283]

Hello,

I'm going to migrate the maxdb to another hardware, and I would like to put the database in read-only state while restoring to the new maxdb.

Could anyone have any clue how to do that?

Thanks in advance.

Regards,

Maria

[markus_doehr2 · Accepted solution]

This is not possible on database level, you'd need to do that on the application side.

Markus

[former_member239283 · Accepted solution]

Thanks

[lbreddemann]

Hi Maria,

Markus is right - there's no "read only mode" for MaxDB.

Anyhow, if I'm not mistaken, want you actually want is:

1) Users should be able to look at their data while you perform the migration.

No changes to the data are expected to be found in the migrated database.

and

2) You want the original state of the database to be kept unchanged so that you could come back to it should anything go wrong.

If that is what you want, you may be able to do this with MaxDBs Snapshot feature.

Create a snapshot of the database before opening the system for the users for their "read-only" access.

The snapshot will be keep the database just at the point you created and can be restored within seconds.

All changes that happened since than will be gone of course.

One word of caution: usually systems (whether it's a SAP instance or something else doesn't matter now) do have interfaces that are triggered by various events - data change, time schedule, manual trigger, rfc ...

So even if you're database is kind of read-only, then you've to make sure that not a single one of these interfaces can be activated as this might lead to inconsistencies between the components of your system that don't store their data in that MaxDB instance.

But if you turn off all those things (don't forget printers...) then you could give this a try.

best regards,

Lars

[former_member239283]

Thanks a lot