Recovery Manager Commands
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 PRIORITY command can be used to either display or set the current priorities for rebuild or recovery. For example:
RECOVERY PRIORITY displays the current recovery priority setting.
RECOVERY PRIORITY LOW sets the recovery priority to Low.
DEFAULT PRIORITY 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 cancelled 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.
Notice:
The target table will be unusable after this command is issued and will become usable only when the table is dropped and created again, when the table is restored from an archived backup, or when a DELETE ALL operation is performed on that table. The CANCEL ROLLBACK command should only be used in cases where the rollback will take longer than the restore of the table or where the table is unimportant (such as a temporary table). A single table retrieve operation can be performed on the target table by using the READ OVERRIDE locking modifier on it.
The ROLLBACK SESSION... PERFORMANCE GROUP command can be used to either display or set the current performance group of the rollback for a particular session. The priority associated with the specified performance group is used to change the priority of the rollback for the specified host-id and session number.