15.00 - QUARLIST - Teradata Database

Teradata Database Support Utilities

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

QUARLIST

Purpose  

The QUARLIST command displays a list of cylinders whose owning AMPs cannot be determined.

Cylinders are designated for quarantine automatically when a data corruption in the cylinder index prevents the system from determining the AMP to which the cylinder belongs. A list of quarantined cylinders is maintained on a single AMP in each storage subpool, usually the AMP with the lowest vproc number. AMPs that can potentially own these cylinders are kept down, and the file system is not started on these AMPs during Teradata Database system startup. To bring the AMPs back up, use Filer to repair or reinitialize the quarantined cylinders.

The QUARLIST command can scan these cylinders for possible diagnoses. After the quarantined cylinders have been fixed, use the ASSIGN command to reassign the cylinders to their appropriate AMPs, or use the /R option of QUARLIST to remove the cylinder from the list, making the cylinder available for use from the general pool of storage cylinders.

For more information on the ASSIGN command, see “ASSIGN” on page 103.

Syntax  

 

Syntax Element

Description

cylid

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

/P

Prints the list of quarantined cylinders.

/S

Scans a quarantined cylinder and attempts to diagnose problem. If no cylid is specified, scans all quarantined cylinders.

/R

Initializes a quarantined cylinder and releases it back into the general storage pool. If no cylid is specified, initializes and releases all quarantined cylinders.

/X cylid

Initializes the cylinder specified by cylid, but does not release it back to storage. Used for durable cylinders, which should never be released to general storage, such as those used for master indexes and startup information.

Usage Notes  

After repairing a cylinder on the quarantine list, use the ASSIGN command to re-associate the cylinder with its AMP. For more information, see “ASSIGN” on page 103.

The /R option is related to the ASSIGN command. The /R option releases a repaired cylinder back into the general storage pool, while ASSIGN re-associates a repaired cylinder back to a specific AMP.

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