Re: the explain of tbcheck -pt

jjdai@hotmail.com wrote: > > Hi , > > Thanks in advance , > I run informix online ver5 on our HP, > After i run tbcheck -pt dbsname , > I get the report of this command, > like : > > 1. Physical Address 600082 > 2. Creation date 07/07/98 09:58:00 > 3. TBLSpace Flags 2 Row Locking > 4. Maximum row size 18 > 5. Number of special columns 0 > 6. Number of keys 1 > 7. Number of extents 1 > 8. Current serial value 1 > 9. First extent size 23 > 10. Next extent size 8 > 11. Number of pages allocated 39 > 12. Number of pages used 34 > 13. Number of data pages 15 > 14. Number of data bytes 23022 > 15. Number of rows 1279 > > My question is : > what is the meaning of line 7 , is it the No. of extents used by this > table now ? This table only takes up one extent. > what is the meaning of line 11 and line 12 , is it the No. of extents > allocated to this table when the table at it largest ? 11 and 12 deal with the number of pages that the table currently takes up. 39 pages are currently allocated to this table, but only 34 pages are currently filled with data / index pages. > is there some relationship between the line 7 and line 11 and 12 ? The initial extent size of the table looks to be: first extent 23 next extent 8 When the table was loaded, it initially allocated 23 pages (as determined by 'first extent'). As the table contniued loading data, it then needed 8 more pages, bringing the total to 31. Toward the end of the load, it allocated another 8 pages (as determined by 'next extent'), but only used 4 pages. Thus, Informix loaded you data contiguously into one extent, but the table itself takes up 34 pages within 39 (23 + 8 + 8) extents. Hope that answers the question. John Carlson Informix DBA WH Smith, Inc.