Unix data volume filesystem number query

[Former Member]

Hi,

Does anyone have a definitive answer as to whether more than 1 data filesystem is supported in MaxDB 7.8 on Unix?

I cant easily find an answer in any of the guides or on Marketplace. I'm presuming yes and it should be no problem, certainly in my experience on other sites there are always sapdata1, 2, 3 etc. but this is my first MaxDB site and there is only 1 sapdata FS here. We need to extend the data area but the volume group is restricted in size so we are looking at all possible options (I already know what the other options are, so I just want to know about a secondary data FS).

If someone can point me to the official SAP answer to this (or provide one) that would be much appreciated.

Thanks,

Chaz.

[former_member229109]

Hello Chaz,

1. Are you SAP customer?

If YES => Please see SAP Note No. 1173395.

2. "Does anyone have a definitive answer as to whether more than 1 data filesystem is supported in MaxDB 7.8 on Unix?"

Yes, you could use more as 1 FS for the datavolumes location.

SAP MaxDB 7.8 Library:

http://maxdb.sap.com/doc/7_8/default.htm

Glossary

Data Volume

Regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Many thanks for your reply.

Yes we are a SAP Customer and I'd already checked that note (and many others) around MaxDB configuration.

I had also looked at the glossary for MaxDB data volumes, but nowhere could I find a definitive answer. The closest I could find was this statement: "When you create a new database, you need to configure at least one data volume...".

I had just been presuming it was ok to add more than 1 FS, but wanted to check as I am new to MaxDB. However I guessed it would be ok, its just always good to have anwer from SAP!

Thanks again.

Chaz.

[former_member188883]

Hi Chaz,

Does anyone have a definitive answer as to whether more than 1 data filesystem is supported in MaxDB 7.8 on Unix? 

Answer is Yes. I have already configured SAP systems with sapdata1, sapdata2, sapdata3 and sapdata4 on MaxDB On Unix.

I have done it for Livecache database.

I cant easily find an answer in any of the guides or on Marketplace. I'm presuming yes and it should be no problem, certainly in my experience on other sites there are always sapdata1, 2, 3 etc. but this is my first MaxDB site and there is only 1 sapdata FS here. We need to extend the data area but the volume group is restricted in size so we are looking at all possible options (I already know what the other options are, so I just want to know about a secondary data FS).

When you install SAP on MaxDB database default it shows only single sapdata with its size. On the same screen there is an option to add another sapdata with similar or higher size. Path of each sapdata<X> can be changed in the same screen.

For eg. On the OS you have 4 file systems sapdata1, sapdata2, sapdata3, sapdata4.

While Installation I may create 4 sapdata<x> and distribute the same as shown below.

/sapdb/<SID>/sapdata1 2000MB

/sapdb/<SID>/sapdata2 2000MB

/sapdb/<SID>/sapdata3 2000MB

/sapdb/<SID>/sapdata4 2000MB

Similarly I can create a separate filesystem for log

/sapdb/<SID>/saplog 2000MB

Note: You may not find such information written in SAP notes as there is no standard definition like how many sapdata<x> you may have in your system. SAP installation process expects minimum 1 sapdata<x> and 1 saplog<x> partitions for installation to complete in MaxDB.

Regards,

Deepak Kori