Previous Topic: Using RESERVE and ENQNext Topic: Step 15: (Optional) Install Optional Online Interfaces


Database Extent Considerations

In a multiple CPU environment, it is possible to have processes in each system image accessing a database extent.

To minimize contention, we recommend that you place each database extent on a dedicated volume. Where possible, the size of the volume must match the size of the database extent. This allows each extent to be accessed by its own server (device address) and prevents I/O for multiple extents from queuing on the same device address, which can happen if multiple database extents are allocated on the same device.

Place the first extent of the index and the database on dedicated volumes because the RESERVE processing uses the data set name and volume of the first extent to serialize all accesses. If multiple database or index extents are on the same volume, then RESERVE can prevent access to the other database or index extents.