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
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.