MaxDB: How to resize log volume

[Former Member]

Being new to MaxDB (and DB admin in general) I created a 20 GB log volume during the SAP Content Server installation.

Now I think several smaller (200 MB or so) volumes would be better than one huge one (right?).

I have looked high and low and have not been able to find documentation to resize or delete the existing volume, data volumes yes but not log volumes. I have tried everything I can in the MaxDB GUI in online, admin and offline modes, de-activate logging etc.

Any advice would be GREATLY appreciated and points awarded. Thank you all,

David

[former_member229109]

Hello David,

-> What is the version of the installed database?

-> Are you SAP customer? Please let me know, if you could review the SAP notes::

129352 Homogeneous system copy with MaxDB (SAP DB)

820824 FAQ: MaxDB / SAP liveCache technology

869267 FAQ: MaxDB LOG area

-> You need to create the databackup first, then initialize the database for the restore using

the DBMGUI tool, for example, and during the initialization of the database parameters

reset the size of the logvolumes. Follow further steps & restore the database using the created databackup.

Please review the SAP note 129352 for the details/steps.

-> Please review the documents at http://maxdb.sap.com/documentation/

-> Tutorials -> Creating and Configuring a Database Instance

&

-> Glossary -> Log area

&

-> Basic Information -> Concepts of the Database System -> Creating and Configuring a Database Instance

< Please also review the 'Planning Databases' at http://maxdb.sap.com/doc/7_7/44/c36449865960efe10000000a155369/content.htm

for the general recommendations of the database volumes parameter configuration. >

-> See https://www.sdn.sap.com/irj/sdn/wiki?path=/display/maxdb/main -> MaxDB Support Guide

Thank you and best regards, Natalia Khlopina