DPA Database cleanup?

Hi,

When a database maintenance plan runs it deletes rows from within the database, depending on how the plan is configured. However it will not reduce the size of the actual database, as it is just deleting rows from inside the database structure. This empty space will then be re-used and filled with new data being inserted into the database.

If you wish to reduce the size of the database file then you will need to perform a vacuum/shrink (the terminology and exact command will depend on the database you are using) on the database. Your dba looking after the DPA database should be able to do this for you.

Kind Regards

David

David Russell
EMC

Hi,

Can you also tell me how i can do this? is there no tool available to do this for me?

thanks

Michel

Hi Michel,

What database are you using? (iAnywhere, SQL Server, oracle, etc)

Thanks

David

David Russell

EMC

Hi David,

i use iAnywhere.

thanks,

Michel

Hi Michel,

The instructions do it on iAnywhere are in the DPA 5.8 Product Guide on page 82. In iAnywhere the process is called a reorg.

Thanks

David

David Russell

EMC

Hi Michel,

We have probably got as far as we can by using the forum, as you have run the correct command, and it hasn't reduced. I would recommend at this stage opening a service request with EMC Support to investigate why the REORG command isn't shrinking the database down.

Thanks

David

David Russell

EMC

Hi David,

i have just run the command: dpa_dbmaint -m reorg

only nothing is happend with the size of the database its still 26,5 GB.

i see that the back-up file is a lot smaller. This file is 19 GB. so it looks like that there is a lot of empty space.

thanks a lot

Michel