Hello,
how can i get the size (in cylinders) of a table ?
Thanks for your help .
Huh? Same size as what?Did the unload data have the same size ?
db2sysdba wrote:SELECT SPACEF FROM SYSIBM.SYSTABLES
WHERE NAME='your table name'
WITH UR;
model 3390 disk:
--56664 bytes in a track,
--15 tracks /cyl
--849960 byte /cyl
CONTROLINTERVALSIZE(size)
...
You can define a size from 512, to 8K in increments of 512 or from 8K to 32K in increments of 2K (where K is 1024 in decimal notation). If you use a size that is not a multiple of 512 or 2048, VSAM chooses the next higher multiple.
...