How to change minimum data size of MaxDB while installing SAP ERP 6.0

[Former Member]

I am installing SAP ERP 6.0 with MaxDB on a Linux system.

The installation document says the minimum size of SAP data is 70 GB.

But while installing the minimum Data size is showing as 240000 MB (240 GB).

On what parameter/system attribute this value of "Minimum data size" depends?

If possible how can we change this value?

[former_member188883 · Accepted solution]

Hi Swap,

Minimum data size depends on the export dump size as well as Database type.

Please provide more space than 240GB as requested.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks Deepak,

For MaxDB, do I have to mount all the volumes on same mount point "/sapdb/<DBSID>/sapdata"

or I can also mount them on different mount points like "/sapdb/<DBSID>/sapdata1", "/sapdb/<DBSID>/sapdata2" ... and so on?

[former_member188883 · Accepted solution]

Hi Swap,

You can have different mounts like /sapdata1..sapdata4.

During installation make sure you add these volumes and distribute the data accordingly.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

I created these on three LVM logical volumes on Linux.

But while installing in "Create database instance" phase I got below error:

Error in log file:

class com.sap.sdb.sllib.utils.DbCommand | <DBMException -24988 ERR_SQL SQL error

-902,I/O error

3,Database state: OFFLINE

6,Internal errorcode, Error code 9050 "disk_not_accessible"

20030,Formatting of data area failed>

What could be the reason behind this? is it because I used logical volumes instead of raw disks OR

the size of logical volumes?

I created 3 logical volumes. two of them with size 125GB each and one with 30 GB.

What should be the appropriate size of each volumes for minimum data size 240GB?

Regards,

Swap

[former_member188883 · Accepted solution]

Hi Swap,

Looks like logical volumes have issue and this has resulted into DB being offline.

Please make the database online & check the status of  data volumes

dbmcli -d <SID> -u control,control param_getvolsall

If possible attach sapinst_dev.log

Regards,

Deepak Kori

[thorsten_zielke · Accepted solution]

Hi,

let me suggest to look into the 'KnlMsg' log file (via Database Studio - or convert it manually from pseudo xml to text with e.g. from the database rundirectory 'protconv KnlMsg > knldiag'.

With any luck there is more info in that log file. Also, locate the Data Volumes on file system level and check if any volume has been created so far (probably not). The '902, I/O error' is quite generic and could mean anything from permission problems to 'file not found' (please make sure the path really exists, MaxDB does not create directories on OS level!).

Thorsten

[Former Member · Accepted solution]

Hi,

I have attached sapinst_dev.log file

Please also check the output of this command.

sqdlpm 1>  dbmcli -d LPM -u control,control param_getvolsall

Error! Connection failed to node (local) for database LPM:

-24950,ERR_USRFAIL: User authorization failed

Thanks,

Swap

sapinst_dev.log.txt.zip

[Former Member · Accepted solution]

Thanks Thorsten,

This issue is resolved now. As per your suggestion I checked knlmsg log file.

Error in this file told me that disk space is not enough. So, I increased

the disk space and it worked.