Physical Data Storage

ASE can use both raw disk devices and UNIX files for data storage, although Sybase recommends the use of raw devices for data storage in production environments.

ASE initializes each disk device and maps virtual page numbers onto the device. When a database is allocated space on a device, the added space becomes a device fragment in the database. Before ASE 12.0, each database supported a maximum of 128 device fragments. Hence, the maximum size of a single database was 128 × < max_device_size_supported >. The largest supported device size on Solaris was 2 Gbytes until the introduction of 64-bit kernel asynchronous I/O (KAIO) in Solaris 2.5.1. Since the ASE 12.0 release, an unlimited number of device fragments has been supported. ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.