Progress
Database Administration
Guide and Reference


Storing Database Extents On Raw Partitions

Progress allows users to store database extents on raw partitions. Storing database extents on raw partitions can sometimes improve performance issues associated with the UNIX file system, such as asynchronous I/O, large file sizes, and security.

To create a database with raw partitions, use the PROSTRCT CREATE command:

prostrct create db-name structure-file-name  

However, the structure file must have the following line format:

d    devicename    r    size 

devicename

Specifies the disk where the database will be created.

size

Specifies the size of the raw partition. You must specify a raw partition size, because a raw partition cannot have a variable-length extent.

NOTE: For the complete syntax of the PROSTRCT utility see Database Administration Utilities."

For example, the following structure file creates a database with two data extents and one BI extent on raw partitions. The remaining overflow extents are on the filesystem and look like regular files:

d    /dev/rdsk/c0d1s0         r    50000
d    /dev/rdsk/c0d2s0         r    50000
d    /usr1/data/dbname.d1
b    /dev/rdsk/c0d3s0         r    50000
b    /usr2/bifile/dbname.b1 

NOTE: All databases must have an overflow BI extent that is variable length. This overflow extent must reside on the filesystem.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095