10.1.3 Execution environment

  1. You can execute the rebalancing utility only when HiRDB is active.
  2. You can execute the rebalancing utility at the server machine containing the single server or the server machine where the system manager is located.
  3. To execute the rebalancing utility, set the LANG environment variable. To use character codes that are not supported by the OS in an environment in which the rebalancing utility is executed, you must set the PDLANG environment variable. For details about LANG and PDLANG, see the HiRDB Version 9 UAP Development Guide.
  4. The rebalancing utility does not support a utility special unit.
  5. 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.
  6. 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#1pd_tmp_directory operand in the system definition
    SpecifiedOmitted
    TMPDIR#2 environment variable
    SpecifiedOmitted
    SpecifiedDirectory or file specified in the control statement
    OmittedDirectory specified in pd_tmp_directoryDirectory specified in TMPDIR/tmp directory
    #1: index, idxwork, or sort statement
    #2: Environment variable specified in the process server process (pdprcd) that is started from init (OS process)

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

    report statementpd_tmp_directory operand in the system definition
    SpecifiedOmitted
    TMPDIR# environment variable
    SpecifiedOmitted
    SpecifiedDirectory or file specified in the control statement
    OmittedDirectory specified in pd_tmp_directoryDirectory specified in TMPDIR/tmp directory
    #: Environment variable specified in the command execution environment
  7. 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 serverWhether or not pdrbal is executable
    Front-end servers that have not been appliedFront-end servers that have been applied
    All activeNoneY
    Some inactiveN (because the front-end server is inactive)
    All inactiveN (because the table definition cannot be acquired)
    All activeAll activeY
    Some inactiveY
    All inactiveY
    NoneAll activeY
    Some inactiveY
    All inactiveN (because the table definition cannot be acquired)
Legend:
Y: Executable
N: Not executable