Modifying the log area of MAXDB 7.8

[Amit_Patil]

Hi,

Please help us with the procedure to change the "saplog" path from one directory to other directory on MAXDB 7.8.

e.g., In my current situation, saplog directory path is H:/sapdb/DEV/saplog/, which we need to change to F:/sapdb/DEV/saplog.

Thank You

Regards,

Amit

[former_member188883 · Accepted solution]

Hi Amit,

You can use dbmrelocate command to change the log file path.

Refer to documentation below for detailed information

dbmrelocate - MaxDB - SCN Wiki

Hope this helps.

Regards,

Deepak Kori

[Amit_Patil · Accepted solution]

Hi Deepak,

Thanks for your quick reply. I'm very new to MAXDB. Please let me know if you need to bring the database to any specific mode (just like mount/no mount in oracle). Also can you confirm below command will modify only log area or complete db path.

>dbmrelocate -d DEV -sourcedata "H:\sapdb\DEV\saplog\" -target "F:\sapdb\DEV\saplog"

Thank You

Regards,

Amit

[yashwanthkumar_kethineed · Accepted solution]

Hello Amit,

dbmrelocate is to relocate the existing MaxDB installation to another installation. You cannot move LogVolumes

Refer to the Wiki section below on how to move MaxDB volumes:

http://scn.sap.com/community/maxdb/blog/2008/09/11/questions-to-sap-support-how-to-move-maxdb-volume...

Regards,

Yashwanth

[thorsten_zielke · Accepted solution]

Hello Amit,

as Yashwanth has put it correctly: you cannot use dbmrelocate for moving volumes...

But let me add that the above referred Wiki section describes changing the volume path with the GUI Database Manager only. Very good GUI guide, but a bit outdated since for newer database releases we have switched to MaxDB Database Studio.

If you want to, you can always use the command line as an alternative approach:

1. establish a dbmcli session via 'dbmcli -d <database name>  -u <user,password>

2. bring the database to 'offline' state.

3. Identify the current location of the volume you want to move e.g. the path is part of the KnlMsg file or you can get it via the 'param_getvolsall' command.

4. Change the path via 'param_directput DataVolumeName...'.

Here is an example of moving data volume 1 from C: to F: (database is already in offline state):

dbmcli on tz79>param_getvolsall

OK

UseMirroredLog                   NO

MaxLogVolumes                    2

MaxDataVolumes                   64

LogVolumeName001                 6400       F  C:\sapdb\data\TZ79\volumes\log\DISKL0001  1

DataVolumeName0001               32000      F  C:\sapdb\data\TZ79\volumes\data\DISKD0001

dbmcli on tz79>param_getvalue DataVolumeName0001

OK

C:\sapdb\data\TZ79\volumes\data\DISKD0001

dbmcli on tz79>param_directput DataVolumeName0001 F:\sapdb\data\TZ79\volumes\data\DISKD0001

OK

dbmcli on tz79>param_getvolsall

OK

UseMirroredLog                   NO

MaxLogVolumes                    2

MaxDataVolumes                   64

LogVolumeName001                 6400       F  C:\sapdb\data\TZ79\volumes\log\DISKL0001  1

DataVolumeName0001               32000      F  F:\sapdb\data\TZ79\volumes\data\DISKD0001

Thorsten

[Amit_Patil · Accepted solution]

Thanks Yashwanth.. It worked as expected.