The LIST STATUS command displays information about recovery operations in progress. The processor id option provides additional detailed information about a specific down AMP.
The LIST LOCKS command displays a list of all locks currently held by online transaction recovery.
The LIST ROLLBACK TABLES command displays the list of tables which are currently being rolled back in the system. Separate listings are generated to distinguish between online transaction recovery and system recovery. Table ids can be selected from this listing for executing the CANCEL ROLLBACK ON TABLE command. In case a '*' character follows the table names then they cannot be specified in the CANCEL ROLLBACK ON TABLE command.
The LIST CANCEL ROLLBACK TABLES command displays the list of tables for which rollback processing is pending cancellation during the online transaction recovery. These tables are removed from the list when all the journal rows corresponding to the tables have been skipped on all the AMPs.
The DEFAULT PRIORITY command sets the recovery priority to Low and the rebuild priority to Medium.
The CANCEL ROLLBACK ON TABLE command is used to specify a table for which rollback processing is to be canceled for an online user requested abort or during system recovery. The DBC password is required to execute this command. Multiple tables can be specified by separating their table ids with commas.