5.12 Estimating the size of the system-table DB area
Use the following formula to determine the system-table DB area size.
Formula (kilobytes)
|
|
![[Figure]](GRAPHICS/F0000245.GIF)
Explanation of variables
- STBLSIZE_SUM
-
Total size of each system table
Use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000246.GIF)
- STBLTABLESSIZE
-
Size of the table STATUS_TABLES
- STBLCOLUMNSSIZE
-
Size of the table STATUS_COLUMNS
- STBLINDEXESSIZE
-
Size of the table STATUS_INDEXES
- STBLCHUNKSSIZE
-
Size of the table STATUS_CHUNKS
- STBLSYNONYMDICSIZE
-
Size of the table STATUS_SYNONYM_DICTIONARIES
Determine the size of each system table as explained in 5.12.1 Estimating the sizes of system tables.
- REORGSDAREASIZE
-
Size of the area for executing the adbreorgsystemdata command
Add this variable when executing the adbreorgsystemdata command.
Use the following formula to determine this value.
Formula (kilobytes)
![[Figure]](GRAPHICS/F0000247.GIF)
The largest of the following system table sizes:
- STBLTABLESSIZE
-
Size of the table STATUS_TABLES
- STBLCOLUMNSSIZE
-
Size of the table STATUS_COLUMNS
- STBLINDEXESSIZE
-
Size of the table STATUS_INDEXES
- STBLCHUNKSSIZE
-
Size of the table STATUS_CHUNKS
- STBLSYNONYMDICSIZE
-
Size of the table STATUS_SYNONYM_DICTIONARIES
Determine the size of each system table as explained in 5.12.1 Estimating the sizes of system tables.
A single system-table DB area file (file name: ADBSTBL), which constitutes the system-table DB area, is created using a regular file under the DB directory. It can also be created using a block special file that is not under the DB directory.
- Organization of this section