Use the REPAIR command to change the state of transactions. CAUTION The REPAIR command can corrupt data. Use it only if none of the resource managers participating in the transaction provides a means of changing transaction states. Use this command only if none of the resource managers participating in the transaction provides a means of changing the transaction state. For example, if Rdb is a participant in the transaction, do not use REPAIR; use the Rdb Management (RMU) utility commands instead. Similarly, if DBMS is a participant, use the Database Operator (DBO) utility commands. Change the transaction state only when you already know the outcome of the transaction and need to manually update the transaction log immediately. You might want to do this because, for example, you have lost the network link to a remote node. When you use the REPAIR command you use qualifiers to specify which transactions you want to change. By default, the REPAIR command selects all transactions. Once you have selected the transactions to change, you enter the REPAIR subcommand mode. Within this mode, the prompt changes to REPAIR> and you have a set of additional subcommands described in Subcommands of the REPAIR Command. You use these commands either to manually change the state of the transaction, or to select the next transaction that matches your selection criteria. The subcommands are as follows: Subcommand Action ABORT Specifies that a Prepared transaction is to be aborted by removing its record from the transaction log. This writes a record of type Forgotten for the transaction. Note that DECdtm services use the presumed abort logging protocol. COMMIT Specifies that a Prepared transaction is to be committed. This writes a record of type Committed for the transaction. EXIT Returns to the LMCP> prompt. FORGET Specifies that a Committed transaction can be removed from the transaction log. This writes a record of type Forgotten for the transaction. NEXT Displays the next transaction that matches your selection criteria. LMCP displays each of the selected transactions in turn, so that you can change them. For each selected transaction, you can either use the ABORT, COMMIT, and FORGET subcommands to change the state of the transaction, or use the NEXT subcommand to select the next transaction. To exit from the REPAIR subcommand mode, enter the EXIT subcommand or press Ctrl/Z.