Execution environment

You can execute the rebalancing utility only when HiRDB is active.
You can execute the rebalancing utility at the server machine containing the single server or the server machine where the system manager is located.
Whether or not you can execute the rebalancing utility depends on the open attribute and status of the RDAREAs that contain the rebalancing table and indexes. For details about whether or not the rebalancing utility can be executed, see Appendix C. RDAREA Status During Command Execution.

If no file output destination is specified in the control information file during execution of the rebalancing utility, the utility outputs files to the directory shown in Table 10-2 Directory to which pdrbal outputs files as specified by the server or Table 10-3 Directory to which files are output as specified by the command execution environment.

Table 10-2 Directory to which pdrbal outputs files as specified by the server

Control statement^#1	pd_tmp_directory operand in the system definition
	Specified	Omitted
		TMP^#2 environment variable
		Specified	Omitted
Specified	Directory or file specified in the control statement
Omitted	Directory specified in pd_tmp_directory	Directory specified in TMP	%PDDIR%\tmp directory

#1: index, idxwork, or sort statement

#2: Specification of system environment variable

Table 10-3 Directory to which files are output as specified by the command execution environment

report statement	pd_tmp_directory operand in the system definition
	Specified	Omitted
		TMP^# environment variable
		Specified	Omitted
Specified	Directory or file specified in the control statement
Omitted	Directory specified in pd_tmp_directory	Directory specified in TMP	%PDDIR%\tmp directory

#: Environment variable specified in the command execution environment

When a recovery-unnecessary front-end server is used, whether or not pdrbal is executable depends on the applicability of the recovery-unnecessary front-end server and the operating status of the front-end servers, as shown below:

Recovery-unnecessary front-end server		Whether or not pdrbal is executable
Front-end servers that have not been applied	Front-end servers that have been applied	Whether or not pdrbal is executable
All active	None	Y
Some inactive		N (because the front-end server is inactive)
All inactive		N (because the table definition cannot be acquired)
All active	All active	Y
	Some inactive	Y
	All inactive	Y
None	All active	Y
	Some inactive	Y
	All inactive	N (because the table definition cannot be acquired)

Legend:: Y: Executable; N: Not executable

10.1.3 Execution environment