Converting data volume type from LINK to FILE on a Linux OS

[Former Member]

Dear experts,

I am currently running MaxDB 7.7.04.29 on Red Hat Linux 5.1. The file types for the data volumes were

initially configured as type LINK and correspondingly made links at the OS level via "ln -s" command.

Now (at the OS level) we have replaced the link with the actual file and brought up MaxDB. The system

comes up fine without problems but I have a two part question:

1) What are the ramifications if MaxDB thinks the data volumes are links when in reality they are files.

(might we encounter a performance problem).

2) In MaxDB, what is the best way to convert a data volume from type LINK to type FILE?

Your feedback is greatly appreciated.

--Erick

[lbreddemann · Accepted solution]

> 1) What are the ramifications if MaxDB thinks the data volumes are links when in reality they are files.

> (might we encounter a performance problem).

Never saw any problems, but since I don't have a linux system at hand I cannot tell you for sure.

Maybe it's about how to open a file with special options like DirectIO if it's a link...

> 2) In MaxDB, what is the best way to convert a data volume from type LINK to type FILE?

There's no 'converting'.

Shutdown the database to offline.

Now logon to dbmcli and list all parameters there are.

You'll get three to four parameters per data volume, one of them called

DATA_VOLUME_TYPE_0001

where 0001 is the number of the volume.

open a parameter session and change the value for the parameters from 'L' to 'F':

param_startsession
param_put DATA_VOLUME_TYPE_0001 F
param_put DATA_VOLUME_TYPE_0002 F
param_put DATA_VOLUME_TYPE_0003 F
...
param_checkall
param_commitsession

After that the volumes are recognizes as files.

regards,

Lars

Edited by: Lars Breddemann on Apr 28, 2009 2:53 AM

[Former Member · Accepted solution]

Lars,

Thank you very much. Your answer solved my problem!