Solution : https://service.sap.com/sap/support/notes/1077887 (SAP Service marketplace login required)
Summary :
This SAP Note addresses I/O configuration for VxFS on HP-UX systems, specifically for SAP Database Instances. It includes guidance for setting the correct blocksize for various database systems like Oracle, Sybase, MaxDB, and DB2 to optimize performance. It emphasizes the use of Concurrent I/O (CIO) over Direct I/O (DIO) and Buffered I/O, highlighting that CIO avoids double buffering and inode contentions, routinely outperforming other I/O configurations. Recommendations for creating filesystems with specific blocksizes are provided. The note also covers appropriate settings for buffercache/filecache based on system memory and includes links to further documentation on filesystem management and performance.
Key words :
customer component bc-op-hpx hp-ux priority recommendations / additional info category performance validity, /enterprise/w1/en/os/hpux11i-fsvm-whats-, /dev/vg01/lvol1 /test vxfs ioerror=mwdisable, /vx/tunefstab /dev/vgxx/lvolxx discovered_direct_iosz=128k, /dev/vg01/lvol1 /test vxfs convosync=direct, /dev/vg01/lvol1 /test vxfs convosync=direct, /bc/docs/support/supportmanual/c01915880/c01915880, /bc/docs/support/supportmanual/c01919408/c01919408, /dev/vg01/lvol1 /test vxfs delaylog, hp-ux systems running db2 luw 1431798 oracle 11
Related Notes :
| 1586523 | DB6 on HP: DIO is not being set by DB2 with VxFS 5.x |
| 1538899 | DB6: SCHED_NOAGE on HP-UX |
| 1471717 | DB6: Tempspace Performance |
| 1451361 | DB6: Best Practices for HP-UX systems running DB2 LUW |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |
| 1075118 | SAP on HP-UX: FAQ |
| 999524 | Oracle 10.2 platform support for Async IO |
| 993848 | Direct I/O mount options for liveCache/MaxDB |
| 830576 | Parameter recommendations for Oracle 10g |
| 793113 | FAQ: Oracle I/O configuration |
| 172747 | SAP on HP-UX: OS kernel parameter recommendations |
| 147634 | DB6: Tips and tricks for creating DB2 tablespaces |