pdtrnqing (Start or release the transaction queuing facility)

Function

The pdtrnqing command starts or releases transaction queuing for a back-end server. This command is applicable to a HiRDB/Parallel Server that is using the system switchover facility.

If a transaction is executing when transaction queuing is to start, execution of this command is placed on hold until the transaction terminates. If the back-end server is starting when transaction queuing is to be released (except when the -f option is specified), execution of this command is placed on hold until the server startup processing is completed.

Executor

HiRDB administrator

Format

 pdtrnqing [-d [-f]] -s server-name

Options

Specifies that transaction queuing is to be released. When this option is omitted, startup of transaction queuing is assumed.

When transaction queuing is to be released (when the -d option is specified), specifies that forcible release of transaction queuing is to be performed (such as when an error has occurred). You can execute the pdtrnqing command with this option specified from the following locations:

Specifies the name of the back-end server that is to be the target of transaction queuing startup or release. You must specify a back-end server that is using the standby-less system switchover (effects distributed) facility.

Rules

  1. Whether or not the pdtrnqing command can be executed depends on the options that are specified and server's operating status. Note that the unit must be running.
    Specified optionsStatus of back-end server
    InactiveStandbyStartingRunningStopping
    None[Figure][Figure][Figure]Y1[Figure]
    -d[Figure]W2,3Y2Y[Figure]
    -d -fYYYYY
    Legend:
    Y:
    Transaction queuing can be started or released.
    [Figure]:
    Transaction queuing cannot be started or released.
    W:
    Waits for completion of server startup processing. If server startup processing is completed in the executing unit within the time specified in the pd_ha_trn_queuing_wait_time operand in the system definition, transaction queuing is released. If the startup processing is not completed, the command terminates with an error.
    1
    This command is placed on hold until the transaction in the back-end server specified in -s is completed. If the transaction is not completed within the time specified in the pd_ha_trn_queuing_wait_time operand in the system definition, the command results in an error.
    2
    If the back-end server specified in -s is in standby status or is starting in the unit where this command is executed, the command waits for completion of the server startup processing. If the server startup processing is not completed within the time specified in the pd_ha_trn_queuing_wait_time operand in the system definition, the command results in an error.
    3
    When the system switchover facility is being used, if this command is executed from the point in time immediately after the server is switched over to the running system by means of the cluster software command until the server status managed by HiRDB is set to Starting, command execution is placed on hold in order to prevent errors.
  2. The pdtrnqing command can be executed from any server machine.
  3. If error is specified in the pd_ha_transaction operand in the system definition, the command terminates itself without starting or releasing transaction queuing. In such a case, the return code is 4.

Notes

  1. If an attempt is made to start transaction queuing while transaction queuing is already being started, or if transaction queuing is released during normal operation (when transactions are not queued), this command terminates normally without changing the status.
  2. Release of transaction queuing is also executed as an extension of server startup processing.
  3. If transaction queuing is released while the server is in standby wait status, the command waits for completion of the server startup processing. Therefore, release of transaction queuing executed for the wrong unit (a unit in standby status) does not immediately result in an error.
  4. The following are the pdtrnqing command's return codes:
    0: Normal termination
    4: Warning termination (transaction queuing cannot be achieved because pd_ha_transaction=queuing is not specified in the system definition)
    8: Abnormal termination (invalid execution environment, operation error, etc.)
    12: Abnormal termination