CYlinder size

General
Enthusiast

CYlinder size

Hi,

How to check the size of the cylinder which holds the data blocks in TD. 14:10

I want to know whether we have small cylinder (3872 sectors)  or  large cylinder   23,232 sectors

Thanks

3 REPLIES
Senior Apprentice

Re: CYlinder size

Without access to DBA tools, the easiest way is:

CREATE VOLATILE TABLE vt, DATABLOCKSIZE = 20 KBYTES(i INT) 

If this returns an error message your system uses large cylinders.

On those systems the minimum blocksize is 21KB, on system with small cylinders it's 8KB.

Enthusiast

Re: CYlinder size

Thanks Dieter

I got the below message

the specified DATABLOCKSIZE value must be within the range of 21248 and 1048319

Enthusiast

Re: CYlinder size

How do i find the size of the cylinder ? if that query errors out can I assume that our cylinder size is   23,232 sectors