Deletion of client in SAP system with MaxDB

[Former Member]

Hello!

We have a development/test SAP system with several dummy/test clients. Also there we have several clients comming from copy of productive clients.

Now we are considering to delete some of not used clients.

Does the size of DB automatically decrease after this action or do we need to do the DB reorganisation in order to stop the growth of the DB?

Thank you!

[former_member188883]

Hi Alex,

After client deletion , you may need to perform reorganization to reduce the DB occupany space.

If not, SAP will be automatically reuse the free blocks available in the database space.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello!

Many thanks!

We are currently ussing MaxDB Release 7.8.02.034.

Can some one tell me how old this MaxDB release is?

What is the current MaxDB release we should upgrade for?

Thank you!

[former_member188883]

Hi Alex,

Latest MaxDB version is 7.9 for SAP. Check on SAP PAM for the latest supported version for your SAP release.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Alex, no reorganization is possible for maxDB. But the data is deleted asynchronously by the garbage collectors. If you grought the database to admin mode while the garbage collector was droppping the data then it can happen that data which is already marked for deleteion still persists in the database as occupied because the garbage collector does not remove this data anymore. So we recommend to run a check data in admin mode. It is necessary to run this check data in admin mode to get the marked as deleted pages given to the free block manager again. If this does not help - then it looks like unreferenced LOB data is still occupying the data area. If so you have to open a SAP customer ticket on component: BC-DB-SDB Development team can trigger the remove of the unreferenced lobs. Regards, Christiane