SET TRANSACTION

Usage Notes

The command can only be executed on a backend node in which the journal is located and the RTR log file must be turned on to record the transaction changes. RTR needs to be started before using this command.

When a transaction's state is changed, the new state is written to the RTR journal synchronously. RTR will try to determine whether the change also affects other portion of RTR environment. For example, in a runtime situation where RTR routers and RTR backend servers are active, the RTRACP will send the new status to applicaiton servers as well as RTR routers to make sure that the change takes effect on all nodes in the RTR facility or facilities.

However, in an off-line situation where an RTR facility has not been created, RTR will simply update the transaction state in place in the RTR journal. The RTR log file must be turned on before using the SET TRANSACTION command to record the state changes. See the SET LOG command.

There are eight legitimate situations where you can change a transaction's state; See Table 6–19.

Parameters

transaction-id

Specifies a particular transaction or transactions whose transaction state you want to change. The transaction_id format is the same as that displayed by DUMP JOURNAL and SHOW TRANSACTION commands.

If no transaction_id is specified then all transactions ("*") that satisfy the specifying qualifiers are processed by the command.

Qualifiers

/BEFORE[=date]

Selects only those transactions whose timestamp is before the specified date. Default is the current date.

/STATE=current_state

Selects a particular transaction or a set of transactions that are in the specified state transaction state. This qualifier is required and the state value must be specified.

Value of state may be one of the following:

SENDING

VOTED

COMMIT

EXCEPTION

PRI_DONE

Use the DUMP JOURNAL or SHOW TRANSACTION command to help you find what is the current state of a particular transaction.

/FACILITY

/FACILITY=RTR$DEFAULT_FACILITY (D)

Specifies the name of a facility for selecting transactions. The default facility, RTR$DEFAULT_FACILITY, is used if this qualifier is not specified.

6–126RTR Command Line Interface

Page 202
Image 202
Compaq AA-Q88CE-TE Usage Notes, Transaction-id, BEFORE=date, STATE=currentstate, Facility FACILITY=RTR$DEFAULTFACILITY D