Performance related to randomly accessed files can be improved by increasing the number of disk drives devoted to those files, and therefore, the number of operations per second performed against those files.
Random files include those for the IQ store, the temporary store, the catalog store, programs (including the SAP Sybase IQ executables, user and stored procedures, and applications), and operating system files.
Conversely, performance related to sequentially accessed files can be improved by locating these files on dedicated disk drives, thereby eliminating contention from other processes. Sequential files include the transaction log and message log files.
Keep random disk I/O away from sequential disk I/O. Also for best performance, use only one partition from a physical device (disk or HW RAID set) per dbspace.
Isolate SAP Sybase IQ database I/O from I/O in other databases or other I/O intensive application.
Place the database file, temporary dbspace, and transaction log file on the same physical machine as the database server.