Home | Previous Page | Next Page   Configuration > Installing and Configuring the Database Server >

Allocating Disk Space

Configuring your disks is the most important task for obtaining optimum performance with data marts and data warehouses. Disk I/O is the longest portion of the response time for an SQL operation. The database server offers parallel access to multiple disks on a computer.

Extended Parallel Server offers the advantage of parallel access to multiple disks spread across many coservers.

Before you allocate the disk space, study the information about disk space in your operating-system administration guide.

To allocate disks for the database server
  1. Configure a raw device or create an unbuffered file for each disk.
  2. Create standard device names or filenames.
  3. Set permissions, ownership, and group for each raw device or unbuffered file.
  4. Set up access to disks across all nodes.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]