After you configure a default area for an object, you can check and show the default areas for table, index, and LOBs using the following command: 
SHOW DATABASE DEFAULT AREA [ ALL | TABLE | INDEX | LOB ];
In the preceding command:
  • SHOW DATABASE DEFAULT AREA—Displays the default area for an object.
  • ALL | TABLE | INDEX | LOB —The object for which you want to display the default area. You can view the default areas for all objects by using ALL or for specific objects by using TABLE, INDEX, or LOB

The preceding command returns the configured default area name and area number for the object type. If you did not set the default area for the object type, then the result does not contain an entry for that object type. If you did not set the default area for any object type, then this command returns an empty result.

The following example shows the results of when default areas are set for an object and when they are not set for an object:

Display all default areas 

SHOW DATABASE DEFAULT AREA ALL;

Area Name		       Area Number	Object Type
----------------------------------------------------
DefaultTableArea		    8		     Tables
DefaultIndexArea	      9		     Indexes
DefaultLobArea	         10		    LOBs

Display default area for a table 

SHOW DATABASE DEFAULT AREA TABLE;

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

Display default area for an index

SHOW DATABASE DEFAULT AREA INDEX;

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

Display default area for a LOB

SHOW DATABASE DEFAULT AREA LOB;

Area Name		       Area Number	Object Type
----------------------------------------------------
DefaultLobArea	          10		LOBs

When the default area is not set for an object

If the default area is not set for an object, the query displays a general error. For example: 
proutil test -C dispobjectdfaultarea index

Area Name		       Area Number	Object Type
----------------------------------------------------
		 					

Default areas for db objects not set.

Alternatively, you can also view default areas using the PROUTIL utility.

proutil db-name -C dispobjectdefaultarea [ All | Table | Index | LOB ]
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
  • dispobjectdefaultarea—Displays the default area for an object
  • ALL | Table | Index | LOB —The object for which you want to display the default area. You can view the default areas for all objects by using ALL or for specific objects by using TABLE, INDEX, or LOB.