The SHOWAMPRECOVERYBLC command shows which compress and uncompress operations are in progress during a system recovery after a restart.
Space allocations are automatically updated following compress and uncompress operations.
Syntax
{ SHOWAMPRECOVERYBLC | SHOWAMPR }
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 ==>