By default, ABL and SQL create new database objects in the schema area, and the Data Dictionary creates 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.

Set default storage areas with the PROUTIL utility

PROUTIL qualifiers let you set and show the default storage areas by object type:

For example, the following statement assigns mylobdefault as the default area where large objects will be created. 
proutil mydb -C setobjectdefaultarea mylobdefault lob

Set default storage areas with the Data Dictionary

The Data Dictionary also supports updating (set/reset) default area for table/index/lob. To update, click the drop down list to select the default area. If you select blank, the default area will be reset to the existing default area.

Set default storage areas with SQL

To set the default areas in SQL, use the SET DATABASE DEFAULT AREA statement. For details, see SET DATABASE DEFAULT AREA.