37.2.1 Explanation of the specification format and options

Organization of this subsection

(1) Specification format
(2) Explanation of options

(1) Specification format

adbreorgsystemdata [-g output-interval-for-reorganization-processing-progress-messages]
                   [-w name-of-directory-storing-temporary-work-files]
                   [--timeout timeout-period]
                     -c table
                     -f directory-path-file-name-specified-for-storing-unload-files
                     -n table-to-be-processed

To Page Top

(2) Explanation of options

● -g output-interval-for-reorganization-processing-progress-messages

~<integer>((0 to 1,000,000,000))<<0>>(in 1,000 rows)

Specifies the interval at which to output progress messages for reorganization processing. For example, if 2 is specified in this option, the KFAA80205-I progress message is output each time 2,000 rows of data have been processed.

Note that separate progress messages are output for unload processing and reload processing.

If this option is omitted or 0 is specified in this option, no progress message is output.

● -w name-of-directory-storing-temporary-work-files

~<OS path name>((2 to 518 bytes))<<$DBDIR/ADBWORK>>

Specifies, using an absolute path, a storage location for the temporary work files that are created during reorganization processing.

The rule for specifying this option is as follows:

Do not specify a forward slash (/) at the end of a path name.

For the estimated space occupied by the temporary work files that will be created under the directories specified in the -w option, see Estimating the size of the temporary work file for executing the adbreorgsystemdata command in the HADB Setup and Operation Guide. If this option is omitted, temporary work files are created under $DBDIR/ADBWORK.

If the disk that stores temporary work files runs out of free space, specify another disk with a larger capacity as the storage location. For details about what to do if the disk that stores temporary work files runs out of free space, see Steps to take in the event of a shortage of disk space for storing temporary work files during command execution in the HADB Setup and Operation Guide.

● --timeout timeout-period

~<integer>((0 to 65,535))<<3,600>>(units: seconds)

Specifies the amount of time until the adbreorgsystemdata command times out.

If the execution time of the adbreorgsystemdata command exceeds the time specified in this option, the processing of the adbreorgsystemdata command is canceled.

If this option is not specified, the adbreorgsystemdata command times out at 3,600 seconds (1 hour).

If 0 is specified for this option, no timeout period is set for the adbreorgsystemdata command. Even if execution of the adbreorgsystemdata command takes a long time, the command processing continues without timing out.

Note: If execution of the adbreorgsystemdata command takes such a long time that system operation is affected, consider setting a timeout period.

▪ If you are using the multi-node function

In the following statuses, the processing of the adbreorgsystemdata command is not canceled, even after the timeout period specified in this option has elapsed. The processing of the adbreorgsystemdata command is canceled after the pending status is resolved.

Pending switch to master node
Pending node recovery
Pending ongoing transaction on another node

● -c table

Specifies a table as the processing target of the adbreorgsystemdata command.

● -f directory-path-file-name-specified-for-storing-unload-files

~<OS path name>((2 to 510 bytes))

Specifies, using an absolute path, the name of the file that specifies the storage locations for unload files that are created temporarily during reorganization processing.

The following shows an example specification of the directory path file that specifies the storage locations of unload files.

Example specification of a directory path file

/home/adbmanager/unld

The rules for specifying directory path files are as follows:

One directory for storing unload files can be specified in a directory path file.
The storage directory for unload files must be expressed as an absolute path consisting of 2 to 510 bytes.
The same characters can be used in the path name for the storage directory for unload files, as for the name of the directory path file that specifies storage locations for unload files.
Spaces in the path name of the directory for storing unload files are not ignored. Spaces at the beginning and end of a path name are also treated as part of the path name.
The only rows that are ignored in a directory path file are those that include line break characters.

For the estimated space occupied by the unload files that will be created under the directories specified in the -f option, see Estimating the size of an unload file in the HADB Setup and Operation Guide.

If the disk that stores unload files runs out of free space, specify another disk with a larger capacity as the storage destination. For details about what to do if there is insufficient space on the disk that stores unload files, see Steps to take in the event of a shortage of disk space for storing unload files in the HADB Setup and Operation Guide.

● -n table-to-be-processed

Specifies the target system table of reorganization processing.

You can specify the names of the following system tables as tables to be processed:

STATUS_TABLES
STATUS_COLUMNS
STATUS_INDEXES
STATUS_CHUNKS
STATUS_SYNONYM_DICTIONARIES

To Page Top