15.00 - ALTCI - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

ALTCI

Purpose  

There are two copies of each CI, only one of which is active at any time. The active copy reflects the current state of the cylinder. The ALTCI command makes the non-active copy the active copy, and the formerly active copy the non-active one.

Note: This command can be used only when Teradata Database is not running on the affected AMP; the AMP cannot be ONLINE.

Syntax  

 

Syntax Element

Description

cylid

The 64-bit identifier of a cylinder, entered as a 16‑character hexadecimal number.

Usage Notes  

ALTCI can be used only when the scope is set to one vproc. For more information on the SCOPE command, see “SCOPE (or VPROC)” on page 206.

Caution:

Picking the alternate copy of a CI might result in overlapping tableids/rowids across cylinders and mismatches between the WCI and the blocks on the associated cylinder. After performing this command, use scandisk to determine whether additional repairs are required.

Example  

Filer ==>
scope vproc 0

1 of 4 amps have been selected

Filer ==>
altci 000600000000000A
 
*** WARNING ***
Picking the alternate copy of a [W]CI might result in overlapping
tableids/rowids across cylinders and mismatches between the [W]CI
and the blocks on the associated cylinder. After performing this command,
use scandisk to determine whether additional repairs are required.
*** WARNING ***
 
Do you want to switch the effective copy to the alternate copy? (Y/N)
> y
 
vproc  0 (0000)  response
 
Active CI
---------
Location            : PRIMARY
Blk Code            :  CI
Version Number      : 16
WLSN                : (00000000000FD453)
Stamp               : Mon Jul 25, 2011 16:02:54.06 (1E F6 2D 4E 06)
 
Non-Active CI
-------------
Location            : SECONDARY
Blk Code            : CI
Version Number      : 2
WLSN                : (00000000000FD294)
Stamp               : Mon Jul 25, 2011 16:02:29.53 (05 F6 2D 4E 35)
 
New Active CI
-------------
Location            : SECONDARY
Blk Code            : CI
Version Number      : 2
WLSN                : (00000000000FD294)
Stamp               : Mon Jul 25, 2011 16:02:29.53 (05 F6 2D 4E 35)
 
 
Successfully alternated the CI.