Installation of SAP Netweaver2004s on AIX box using MAXDB...

[Former Member]

During installation of SAP NetWeaver 2004s on AIX box using MAXDB...

It asks for database parameters. In that volume media type.

1) Raw Devices

2) File Systems

Which one should be chosen?

What's the difference between two?

Thanks

[Former Member]

In database parameters

I choose raw device.

While creating raw device=>

What should be the physical partition size for Raw device?

[former_member229109]

Hello,

As you know data and log entries of a MaxDB database instance are stored on so called volumes which are either files or, where this is possible, raw devices.

The benefits of a RAW device is a faster write performance. Also, a RAW device is much more secure because of the direct write to disks instead of caching the writes. The caching of writes could cause inconsistencies if a crash occurs.

Please go at :

http://dev.mysql.com/doc/maxdb/ -> MaxDB Library

-> Concepts of the Database System -> Creating and Configuring a Database Instance

-> Planning the Database Instance < & Technical Restrictions >

At the 'Planning the Database Instance' section in the paragraph 'Database Size and Configuration of Volumes' you will find more information.

And you could see in more details, why we recommend to use raw devices for

data and log volumes in MAXDB on UNIX systems.

Please also review the information at link - MaxDB FAQ (frequently asked questions) on the MySQL site (target audience: Open Source) :

http://dev.mysql.com/doc/maxdb/maxdb_faq.html

< '5.2. How do I configure the database files?' >

SAP customers can find more information in SAP Note 820824.

And if you are SAP customer please review the SAP notes for additional

information:

628131 SAP DB / MaxDB operating system parameters on Unix

767598 Available documentation

748225 Measurement IO times on liveCache/SAP DB/MaxDB DATA/LOG

Volumes

Thank you and best regards, Natalia Khlopina

[Former Member]

Thanks Natalia...

[Former Member]

In database parameters

I choose raw device.

While creating raw device=>

What should be the physical partition size for Raw device?