15.00 - SHOWAMPRECOVERYBLC - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SHOWAMPRECOVERYBLC

Purpose  

The SHOWAMPRECOVERYBLC command shows which compress and uncompress operations are in progress during a system recovery after a restart.

Syntax  

Usage Notes  

Space allocations are automatically updated following compress and uncompress operations.

Example  

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
 
DatabaseName.Table Name              Table ID          BLC Options
1. DB.t5                             0     2482 0      TABCOMPRESS
*. ALL of the above

     Do you want to cancel the above BLC operation (Y/N) ?
? (Y/N)
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 ==>