pdstjsync (Apply statistics log buffer to statistics log file)

Function

The pdstjsync command outputs information from the statistics log buffer to the statistics log file.

Executor

HiRDB administrator

Format

pdstjsync

Option

None

Rules

  1. You can execute the pdstjsync command only when HiRDB is active and statistical information is being acquired.
  2. Execute the pdstjsync command at the applicable server machine (on the unit where you wish to output information from the statistics log buffer to the statistics log file).
  3. When statistical information about system activities is being acquired, the pdstjsync command also outputs to the statistics log file statistical information about the system activity at the time of this command's execution. Figure 2-12 shows the statistics record output timing and the timing of output to the statistics log file.

    Figure 2-12 Statistics record output timing and timing of output to the statistics log file

    [Figure]

    Legend:
    sys: Statistical information about system activities
    uap: Statistical information about UAP
    obj: Statistical information about SQL object transfer
    Explanation
    1. Statistics log records are output to the statistics log buffer at the interval specified in the pdstbegin -m command.
    2. Statistics log records are output to the statistics log buffer when the pdstjsync command is executed.
    3. Statistics log records are output to the statistics log buffer when connection is established with HiRDB and when it is released from HiRDB.
    4. Statistics log records are output to the statistics log buffer when an SQL object execution request is issued.
    5. Information from the statistics log buffer is output to the statistics log file when the statistics log buffer becomes full.
    6. Information from the statistics log buffer is output to the statistics log file when acquisition of statistical information is stopped (when the pdstend command is executed).
    7. Information from the statistics log buffer is output to the statistics log file when the pdstop command is executed (normal or planned termination).
    8. Information from the statistics log buffer is output to the statistics log file when the pdstjsync command is executed.
    Note
    Nos. 2 and 8 are performed by a single execution of the pdstjsync command.
  4. The statistics log records containing statistical information about system activities are not only output at the interval specified in the pdstbegin command's -m option but also output to the statistics log buffer when the pdstjsync command is executed.

Notes

  1. If you execute the pdstjsync command while statistical information about system activities is being acquired, the amount of statistics log information to be output to the statistics log file increases. Therefore, when determining the value for the pd_stj_file_size operand in the system definition, you must take into account the number of times the pdstjsync command will execute. No other type of statistical information (other than system activity information) increases the amount of statistics log information.
  2. Executing the pdstjsync command has no effect on the editing of statistical information by pdstedit.
  3. For the pdstjsync command, return code 0 indicates normal termination, and return code 8 indicates abnormal termination (invalid option or nonavailability of statistical information).