solaris async i/o mode

solaris async i/o mode allows you to select various asynchronous IO modes on the Solaris platform.

Summary Information
Default value	0 (off)
Valid values	0 (off), 1 (on)
Status	Static
Display level
Required role	System administrator
Configuration group	Disk I/O

Allows you to select various asynchronous IO modes on the Solaris platform. This parameter is effective if SAP ASE is running in threaded kernel mode. This parameter is static, therefore is effective after restarting the server.

0 – (Default) Use this mode if the Solaris patch containing the fix for Oracle BugID 16054425 is not installed. You may see sub-optimal IO performance.

1 – (Recommended) You must have the Solaris patch containing the fix for Oracle BugID 16054425 installed.

Install the following Oracle patch for your platform:

For Solaris 10 SPARC: 148888-03
For Solaris 10 x86/x64: 148889-03
For Solaris 11, latest SRU containing fix for Oracle Bug 16054425

Note: If solaris async i/o mode is set to 1 without the patch for Oracle BugID 16054425, Adaptive Server may report 694 or 823 errors and require restarting the server. Oracle Bug 15868517 refers to backport of Oracle Bug 16054425 for S10U11.