beautypg.com

Set transaction, Related commands – Compaq AA-Q88CE-TE User Manual

Page 203

background image

SET TRANSACTION

/NEW_STATE

Specifies the new transaction state that selected transactions will be changed to.
This qualifier is required and new state value must be specified.

Value of

new_state

may be one of the following:

ABORT
COMMIT
DONE
EXCEPTION

Note that one cannot always change a transaction’s state from one legitimate
transaction state to another. Some state changes are not valid. The following
table shows state changes that are valid.

Table 6–19 Valid Transaction State Changes

NEW STATE

Current State

COMMIT

ABORT

EXCEPTION

DONE

SENDING

YES

VOTED

YES

YES

COMMIT

YES

YES

EXCEPTION

YES

YES

PRI_DONE

YES

/NODE[=node-list]
/NODE=default-node-list (D)

Specifies that the command is executed on all nodes specified in

node-list

. If

node-list

is omitted then the command is executed only on the node where the

command was issued.

/OUTPUT[=file-spec]
/OUTPUT=stdout (D)

Specifies that the resulting information is written to the file

file-spec

. If

/OUTPUT

or

file-spec

is omitted then the standard or default output is used.

/PARTITION
/PARTITION=partition_name

Specifies the name of a partition from which all transactions are running within.
A partition name must be supplied.

Use SHOW PARTITION to view the names of the currently active partitions.

/SINCE[=date]

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

Related Commands

SHOW TRANSACTION

DUMP JOURNAL

RTR Command Line Interface 6–127