the explain of tbcheck -pt

Posted in 1998

jjdai@hotmail.com — Mon, 21 Sep 1998 03:39:52 GMT — source: Informix-list mailing list archive (1991-1998)

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 ? 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 ? is there some relationship between the line 7 and line 11 and 12 ? Thanks JianJun jjdai@pek-co.cn.dhl.com -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum