You can set the default area for tables, indexes, and LOBs using the following command: 
SET DATABASE DEFAULT AREA area_name FOR [ ALL|TABLE|INDEX|LOB ];
In the preceding command:
  • SET DATABASE DEFAULT AREA—Sets the default area for an object.
  • area-name—Specifies the name of the storage area for which you want to create a default area.
  • ALL—Specifies that all objects (tables, indexes, and LOBs) are created in the default area.
Note: You can use the same command to change the default areas. This command replaces the existing default area for the objects with a new default area.

The following examples show how to set the default area for table, index and LOBs:

Configure all default areas 

SET DATABASE DEFAULT AREA “DefaultArea” FOR ALL;

Example: 


Area Name		    Area Number	Object Type
----------------------------------------------------
DefaultArea			8			     Tables
DefaultArea	       8  	  		 Indexes
DefaultArea	       8				  LOBs

Configure the default area for a table

SET DATABASE DEFAULT AREA “DefaultTableArea” FOR Table;

Area Name	     Area Number	Object Type
----------------------------------------------------
DefaultTableArea		8		  Tables

Configure the default area for an index

SET DATABASE DEFAULT AREA “DefaultIndexArea” FOR Index;

Area Name		       Area Number	Object Type
----------------------------------------------------
DefaultIndexeArea	     9		      Indexes

Configure the default area for a LOB

SET DATABASE DEFAULT AREA “DefaultLobArea” FOR LOB;

Area Name		       Area Number	Object Type
----------------------------------------------------
DefaultLobArea	          10		  LOBs
Alternatively, you can also configure default areas using the PROUTIL utility.
proutil db-name -C setobjectdefaultarea area-name [ object-type | all ]
In the preceding command:
  • proutil—The database utility required to configure default areas
  • db-name—Specifies the database you are using
  • -C: Specifies a particular utility or function when you use PROUTIL
  • setobjectdefaultarea—Sets the default area for an object
  • area-name—Specifies the name of the storage area for which you want to create a default area
  • object-type—Specifies the object for which the default area is being created
  • all—Specifies that all objects (tables, indexes, and LOBs) are created in the default area
Note: You can use the same PROUTIL command to change the default areas. This command replaces the existing default area for the objects with a new default area.