AIX 5.3 IO settings

[Former Member]

What is the best setting for IO in AIX on 64 bit?

There are several notes and it is not clear which is the best performance ? What do most production servers run?

I have heard the most AIX shops run AIO on AIX instances running Oracle?

Any help as to what is the best bang for the buck?

Thanks

Weyland Yutani

[former_member524429 · Accepted solution]

Hi,

JFS2 filesystem is recommended on AIX, to get better IO performance.

Please refer SAP Note 1048686 - Recommended AIX settings for SAP to get more information. Also, the Concerned Installation Guide will give you more information along with suggested relative SAP notes. Please refer them.

Regards,

Bhavik G. Shroff

[stefan_koehler]

Hello Weyland,

> I have heard the most AIX shops run AIO on AIX instances running Oracle?

That's what the most guys think, but it isn't true obviously. If you use JFS2 and the "FILESYSTEMIO_OPTIONS" is set to "SETALL", then you are using CIO (no matter how the filesystem itself is mounted).

For more information check my blog: /people/stefan.koehler/blog/2008/11/30/oracle-tuning-log-file-syncs-on-aix-with-diocio

Regards

Stefan