15.00 - REALLOCDUR - Teradata Database

Teradata Database Support Utilities

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

REALLOCDUR

Purpose  

The REALLOCDUR command reallocates cylinders for a specified durable cylinder type. Durable cylinders are special cylinders used by the file system itself, such as cylinders used to store the master index (MI) and the file system trace buffer (FTR). Durable cylinders are not available to be allocated for general storage.

Use REALLOCDUR when durable cylinders have been lost, or cannot otherwise be repaired. This command allocates new durable cylinders for these structures. If cylinders which used to be part of the durable cylinder remain on the bad or quarantine lists, they should be freed by using the BADLIST /R or QUARLIST /R command, as appropriate. For more information on these commands, see “BADLIST” on page 107, and “QUARLIST” on page 174.

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

Syntax  

 

Syntax Element

Description

cyltype

Specifies the type of durable cylinders to be allocated.

cyltype can be one of the following:

  • MICYL
    Specifies that durable cylinders for the master index be reallocated.
  • FTRCYL
    Specifies that durable cylinders for the trace buffers be reallocated.
  • Usage Notes  

    Use this command when there are multiple large durable cylinders in the quarantine list. For more information, see “QUARLIST” on page 174.

    For more information on the proper use of this command to repair large file system structures, see “Repairing Cylinders” on page 90.