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

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
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 |   3704 |         272 |   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