B.7 Content of SQL_DBAREAS

SQL_DBAREAS stores DB area definition information. Each row stores information for one DB area.

The following table describes the content of SQL_DBAREAS.

Table B‒9: Content of SQL_DBAREAS
No.	Column name	Data type	Stored information
1	`DBAREA_NAME`	`VARCHAR(100)`	DB area name
2	`DBAREA_ID`	`SMALLINT`	DB area ID
3	`DBAREA_TYPE`	`CHAR(4)`	DB area type: `'MAST'`: Master directory DB area `'DICT'`: Dictionary DB area `'DATA'`: Data DB area `'WORK'`: Work table DB area `'STBL'`: System-table DB area
4	`PAGE_SIZE`	`SMALLINT`	DB area page size (bytes) For the work table DB area, the page size specified for the `adb_init_wrk_page_size` operand, which is an initialization option in the `adbinit` command, is stored. Note that the page size that was specified in the `adbinit` command is stored even if the page size has been changed by using the `adb_dbarea_wrk_page_size` operand in the server definition.
5	`SEGMENT_SIZE`	`SMALLINT`	DB area segment size (bytes)
6	`N_TABLE`	`SMALLINT`	Number of base tables stored in DB areas For the master directory DB area and work table DB area, 0 is stored.
7	`N_INDEX`	`SMALLINT`	Number of indexes stored in the DB area. (sum of all indexes) For the master directory DB area and work table DB area, 0 is stored.