TMF Operations and Recovery Guide (G06.24+)
Occasional Operations
HP NonStop TMF Operations and Recovery Guide—522417-002
3-22
Deleting Transactions
While the status of a distributed transaction is active or prepared at the home node, its
final outcome cannot be determined, and the RESOLVE TRANSACTION command
should not be used to resolve it.
The following command aborts transaction number 227919 that originated in CPU 6 of
the system \SFO:
TMF 12> RESOLVE TRANSACTION \SFO.6.227919, STATE ABORTED
For more information on distributed transactions, see Section 2, Routine Maintenance.
For more information on using the RESOLVE TRANSACTION command, see the TMF
Reference Manual.
Deleting Transactions
The DELETE TRANSACTION command removes a transaction from the system. In
certain situations, transactions might remain in the system after you expect their
removal, resulting in resources such as audit trails or data locks being held for a long
time.
If a transaction is in the hung or committed state, you can force its deletion by using
the DELETE TRANSACTION command. For example, you can use this command to
remove a committed distributed transaction from the parent node if the child node is
destroyed and will never come back online. In that situation, the committed transaction
appears in the STATUS TRANSACTIONS display until you remove it.
Table 3-1. Resolving Distributed Transactions
Transaction State
at Home Node Action to Take at Remote Node
Aborted Issue the RESOLVE TRANSACTION command with the STATE
ABORTED option.
Aborting Issue the RESOLVE TRANSACTION command with the STATE
ABORTED option.
Committed Issue the RESOLVE TRANSACTION command with the STATE
COMMITTED option.
Nonexistent Issue the RESOLVE TRANSACTION command with the STATE
ABORTED option.
Caution. Contact the Global Customer Support Center (GCSC) or your service provider
before issuing this command.
Using the RESOLVE TRANSACTION command to resolve a transaction that is in any state
other than those listed in Table 3-1
will result in an inconsistent database.