Online Table Extents 2

Someone wrote: >This is a follow up to my earlier post regarding online table extents. > On doing some more searching in the manuals, I found the oncheck command. > Running oncheck -pt for the tables mentioned in earlier post shows > that the first extent is 30 pages, next extent 15 pages. This is half of what > I specified in create database statement ( create table extent size 60 next >size 30). > Any enlightment would be appreciated. I believe it maybe because you misunderstand what you are specifying in the first extend/next extent sizes. The sizes you specify are in Kilobytes and NOT informix pages. See the create table syntax in SQL Reference Manual. If you look in your onconfig file, you will find a line that specifies the BUFFSIZE, the size of an informix page. I bet you will find this is 2k (2048 bytes). oncheck reports the extent sizes, as you have noticed, as a number of INFORMIX PAGEs, so 60/2 = 30 pages. Hope this helps. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk