lartool Command—Start Logging, Archiving, and Recovery Utility

Permission required: System administrator. On VMS, OpenVMS privileges.

The lartool command starts the logging, archiving, and recovery utility.

The lartool (logging, archiving, and recovery) utility permits the system administrator to manually abort or commit distributed transactions without bringing down the entire installation. A distributed transaction may need to be manually aborted or committed if it is left in a willing commit state following the loss of the coordinator of the distributed transaction.

This utility can also abort orphaned transactions that cannot be removed by removing the session owner.

The lartool command has the following format:

lartool [-help]

• -help

  Displays the lartool utility commands online.

lartool Example

This example shows how to use the lartool utility to abort or commit a transaction:

1. Identify the ID of the transaction you wish to abort or commit, by using ipm or logstat.
2. Enter the command lartool. The utility prompts you to select an operation, either ABORT or COMMIT.
3. Select the operation. You are prompted for the transaction ID (TX_ID). Lartool then performs the requested operation.
4. To exit from lartool, type the command: exit.

Caution! Use this utility for a well-defined purpose only. Be aware that if you are aborting a transaction, it may take time to complete. In this case, do not bring the server down. Doing so merely transfers the rollback chore to the recovery process instead of the DBMS Server process. The rollback must still be processed, and the transaction will not be fully removed until rollback processing is completed.