All Forums General
Radsubra2003 10 posts Joined 05/14
03 Jun 2015
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

dnoeth 4628 posts Joined 11/04
03 Jun 2015

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.

Dieter

Radsubra2003 10 posts Joined 05/14
04 Jun 2015

Thanks Dieter
 
I got the below message
 
the specified DATABLOCKSIZE value must be within the range of 21248 and 1048319

Radsubra2003 10 posts Joined 05/14
04 Jun 2015

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
 

You must sign in to leave a comment.