Purpose
The SHOWAMPRECOVERYBLC command shows which compress and uncompress operations are in progress during a system recovery after a restart.
Syntax
{ SHOWAMPRECOVERYBLC | SHOWAMPR }
Usage Notes
Space allocations are automatically updated following compress and uncompress operations.
Example: Displaying in-progress compression during system recovery
The following is a portion of the output of the SHOWAMPRECOVERYBLC command when compress is in progress during recovery.
Ferret ==> showampr The following BLC operation is in progress by AMP recovery Database Name Table Name Map Name Table ID BLC Options ------------------------------ ------------------------------ ------------------------------ ----------------- ----------- 1. ShowCmdsshowampr T8_table_WithoutFallback TD_MAP2 0 3274 0 TABCOMPRESS *. ALL of the above Do you want to cancel the above BLC operation....? (Y/N) > Y Y Enter the number of the operation to cancel, or type * to cancel all > * * Cancelling the currently in progress BLC operation on all above tables Note: Additional Compress / Uncompress operations may still be pending as part of recovery Ferret ==>