16.10 - ALTCI - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

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.

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

Syntax



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).

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 ALTCI command

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.