By default, ABL, SQL, and the Data Dictionary create new database objects in the next storage area after the schema area.

To take advantage of the performance capabilities of Type II areas, you can specify a default area for the creation of tables, LOBs, and indexes, so that they are created in a Type II area instead of a Type I area like the schema area. You may also change the default object creation area at any time, whether or not the database is running.

Note: User-specified detault storage areas must be Type II areas.

You can use the PROUTIL utility to configure or display default areas.

For more information on configuring default areas, see the PROUTIL SETOBJECTDEFAULTAREA qualifier.

For details about showing default areas, see the PROUTIL DISPOBJECTDEFAULTAREA qualifier.

To assign or change default storage areas for database objects, use these SQL statements:
Note: Default storage area configuration and changes are currently unsupported at any time for objects created in schema holder databases for foreign databases (Data Servers), partitioned tables, or tenant-specific syntax for multi-tenant databases. You cannot set an encryption area as the default storage area.