Chapter 10
Configuring Disk Storage for SPD
Server
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
SPD Server Component File Types and Sizes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
Creating SPD Server Component Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
Which Component Files Are Created for SPD Server Tables? . . . . . . . . . . . . . . . 106
Which Component Files Are Created for Indexes on SPD Server Tables? . . . . . . 106
Configuring LIBNAME Domain Disk Space . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
Example 1: Primary File System Storage for All Component Files . . . . . . . . . . . . 106
Example 2: Using ROPTIONS= to Store SPD Server Table
Data and Index Component Files in Other File Systems . . . . . . . . . . . . . . . . . . 107
Example 3: Adding More File Systems to a Path Option When
Its File System Is Full . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
Recommended: Use ROPTIONS= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
Introduction
This section discusses how to manage very large SPD Server data stores. Read this topic
if you manage large SPD Server data files that consume gigabytes of disk storage.
How you configure SPD Server disk storage is important, whether you have many SPD
Server users or a just a few large-scale users. In order to effectively configure SPD Server
disk storage for your installation, you need to understand the four types of component files
that SPD Server creates, the relative sizes of the component files, and when the component
files are created.
SPD Server Component File Types and Sizes
SPD Server uses four types of component files. Component files are physical file entities
that SPD Server uses to track table and index metadata. Component files, when combined,
form a logical structure that SPD Server understands and interprets as a single table. The
relative sizes of the four types of SPD Server component files are:
File Type File extension Relative size Number of
component files
-----------------------------------------------------------------------
105
