TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)
74 Chapter3
Defining a Database
Set Part
set, the maximum capacity is the only required parameter.
Verify that there is enough disk space for a data set to be expanded. Performance may be
impacted by the number of entries incremented when a master data set is dynamically
expanded. The number of disk extents used for the data set file may also impact the
performance of TurboIMAGE/XL.
NOTE
For existing databases, use DBChange Plus or a third-party utility to specify
the expansion parameters.
Detail Data Sets
The set part syntax and parameters for detail data sets are provided below. The maximum
capacity, the initial capacity, and the incremental amount are new parameters for the
detail data set CAPACITY definition. These parameters allow a detail data set to be
expanded dynamically (up to a new maximum capacity specified in the root file) during
DBPUT when the detail data set space is exhausted.
Syntax
{NAME:
N: }
set name
, D[ETAIL]][(
read class list/write class list
)][,
device class
];
{ENTRY:
E: }
item name
[([!]
master set name
[
(sort item name)
])],
.
.
.
item name
[(
master set name
[(
sort item name
) ])];
{CAPACITY:
C: }
maximum capacity
[(
blocking factor
)][,
initial capacity
[,
increment
]];
Parameters
set name is the data set name. It must be a valid TurboIMAGE/XL data name as
defined in "Data Sets" in chapter 2 and in the discussion of the DBUTIL
>>CREATE command in chapter 8. A maximum of 199 data sets, including
both masters and details, is allowed.
DETAIL (or D) denotes a detail data set.
read class list is a group of user class numbers between 0 and 63, inclusive, separated by
commas. User class numbers are described in chapter 2.
write class list is a group of user class numbers between 0 and 63, inclusive, separated by
commas. User class numbers are described in chapter 2.
device class is the class name of the MPE/iX device on which the data set resides. The
device must be a member of the volume set on which the database resides.
item name is the name of a data item defined in the item part. Each item defined as a
search item must be a simple item. Up to 16 items can be search items.