How to move data or log volumes and change data or log volumes path on SAP MaxDB database?

SAP MAXDB move data/log Volumes or chnage data/log volumes path.

Steps:

 1. Stop the database (DBM command db_offline). Copy the volume to the new location/drive (just copy and do not move until the database is started, so  you have a backup!)

2. Change the volume path: for Database Studio: Administration -> Data Area >>> choose volume >>> Edit: Device/File >>> OK for DBMCLI prompt: with DBM command param_put , for example, param_put DataVolumeName0001 F:\sapdb\data\DISKD0001 for

3. Database Manager: Configuration -> Volumes / >>> double-click the volume you want to move >>> set Device/Path >>> OK

4. Repeat step 3) for all affected volumes.

5. Start the database (DBM command db_online). In case the database started successfully to operational state ONLINE, you can delete the volumes from the old location.

6. If the database cannot start up, you can use DBM command param_restore (dbmcli -U c
param_restore 1) to get back the settings from before the change and start the database with the files
in the old location.