6.19 Estimating the size of files required to reorganize a base table
This section describes how to determine the size of files that are required to reorganize a base table.
To reorganize a base table, use the adbexport command to export the data from the target base table, and then use the adbimport command to restore the data to the base table. For details about reorganization of a base table, see the following sections:
-
11.4.14 Reorganizing a multi-chunk table: Chunk-based reorganization
-
11.4.15 Reorganizing a multi-chunk table: Reorganization of an entire table
-
11.4.16 Reorganizing a multi-chunk table: Reorganization using a sample shell script
If your system operation requires reorganization of a base table, estimate the total size of files that will be used for reorganization (REORGFILESIZE). Also, prepare a disk that has a sufficient amount of free space.
Use the following formula to determine the total size of files that are required for reorganization (REORGFILESIZE).
Formula (kilobytes)
REORGFILESIZE = EXPORTFILESIZE + IMPORTWRKFILESIZE
Explanation of variables
- EXPORTFILESIZE
-
Total size of output data files that are output by the adbexport command to export the reorganization-target base table or chunk (kilobytes)
Determine the value as explained in 6.18 Estimating the size of a file output by the adbexport command.
- IMPORTWRKFILESIZE
-
Size of the temporary work file that is used by the adbimport command to restore the data of the reorganization-target base table or chunk (kilobytes)
Determine the value by referring to ■ Temporary work files for creating indexes in 6.21.1 Estimating the size of the temporary work file for executing the adbimport command.