Teradata Cylinder Size

Database
Kks
N/A

Teradata Cylinder Size

Let me know any method to find the Cylinder size

1 REPLY

Re: Teradata Cylinder Size

First, find the total space in your system:

select sum(maxperm)
from dbc.diskspace;

Then, go into Teradata Manager, select menu option "Investigate", then "Space Usage", then "Cylinders by Vproc". When you run that, it tells you the number of available cylinders.

Now, divide the total space by the number of cylinders to get the size of a cylinder.