SHOWCYLALLOC Command | Troubleshooting Teradata Virtual Storage | Vantage - SHOWCYLALLOC - Analytics Database - Teradata Vantage

Teradata Vantage™ - Teradata® Virtual Storage - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
ulv1628112427040.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hkz1472253437334
Product Category
Teradata Vantage

Shows a summary of the number of allocated and free cylinders on the system, categorized by the performance grade of the storage media where they are stored.

If local storage for spool is configured, the LOCAL row is shown in the summary.

Syntax

{ SHOWCYLALLOC | SHOWC }

SHOWCYLALLOC Output

 SYSTEM WIDE CYLINDER ALLOCATION SUMMARY
  +---------------+--------+-------------+--------+----------------+
  |    STORAGE    |  TOTAL |  ALLOCATED  |  FREE  |    FREE GBs    |             
  +---------------+--------+-------------+--------+----------------+
  | FAST RESERVED |    264 |         105 |   159  |      1.891271  |
  +---------------+--------+-------------+--------+----------------+
  | FAST          |   1248 |         322 |   926  |     11.014570  |
  +---------------+--------+-------------+--------+----------------+
  | MEDIUM        |   3688 |           2 |  3686  |     43.844173  |
  +---------------+--------+-------------+--------+----------------+
  | SLOW          |   1292 |          22 |  1270  |     15.106376  |
  +---------------+--------+-------------+--------+----------------+
  | LOCAL         |   1988 |         118 |  1870  |     22.243247  |
  +---------------+--------+-------------+--------+----------------+
 

Related Information

The following Ferret commands are used with Teradata Virtual Storage, a storage product available from Teradata. For more information about these commands, see Teradata Vantage™ - Teradata® Virtual Storage, B035-1179:
  • BEGIN OPTIMIZE
  • CANCEL OPTIMIZE
  • FORCE