Olaf Döring wrote:
Hi List,
after i migrated my SAPDB 7.3 to MaxDB 7.6 i want to decrease the
Databasesize.
The database was initially sized to 60GB on the SAPDB 7.3 server.
The DB is filled with 8 GB and i want to make the DB smaller to about
~20GB.
I created the MaxDB with the same size as the old SAPDB before i did the
recovery. Is this still necessary or can i create a smaller DB for
recovery?
Or is there a possibility to make the resulting DB smaller?
Olaf,
you can shrink an existing 7.6 instance by deleting individual data volumes
of the database.
db_deletevolume data <volno>
will do the job in state 'online'.
In general, you have 2 options to shrink your data area:
- delete unnecessary data volumes
- or add new smaller volumes and delete the old volumes afterwards.
Or simply recover the data into a smaller database.
Henrik
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
