Device Selection

Store databases and database objects on devices. On all platforms, these devices can be operating system files, or they can be portions of a disk, called raw partitions. When you create a database, SAP Sybase IQ determines automatically whether it is a raw partition or a disk file.

In a production environment, raw partition installations may improve processing performance and recovery capabilities. File systems, however, offer easier device management, and may be preferable in a development environment.

Note: The catalog store and the transaction log cannot be on a raw partition.