Filter
Top Products
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–126 RTR Command Line Interface