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-listis 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-specis 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

Page 203
Image 203
Compaq AA-Q88CE-TE manual Newstate, Valid Transaction State Changes, SINCE=date