Defining, Generating, and Punching a DMCL › Adding Segments to the DMCL › Area Overrides

Area Overrides

The following information can be specified or overridden at the area level:

• Page reserve
• Central version area status
• Sharability state of an area

Overriding Page Reserve

Page reserve is space allocated on a database page for the expansion of variable-length records, bottom-level (SR8) index records, and compressed record occurrences or rows. Certain types of processing may benefit from tailored page reserves. For example, you may want to increase page reserve during an index load, after which, you reduce the page reserve.

To change the page reserve assigned to an area for a particular DMCL, override the area's definition:

create segment prodemp;

create area emp-area
   primary space 50 pages
   page size 1000 characters
   page reserve 0 characters
 .
 .
 .
alter dmcl idmsdmcl
   add segment prodemp
   add area prodemp.emp-area
        page reserve 250 characters;

After loading the index, drop the area's page reserve by dropping the area override from the DMCL definition:

alter dmcl idmsdmcl
   drop area prodemp.emp-area;