Re: the explain of tbcheck -pt
In article <36069CFA.6267@bellsouth.net>, "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > 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. > Hi John , I am JianJun , thanks for you answer , to my understanding of your reply , you said only one extend for this table , so only the first extent is allocated, but there are 34 pages of data in the table , and the size of the first extent is 23 pages , so , I think there should have 3 (1 first and 2 next ) extents for this table , but why there is only one extent the tbcheck told to me . Thanks Further , I still have a question to ask , one morning I found one of my DBspace is full , how can I find the space occupied status of each database on this dbspace , and how can I find the space occupied status of each table on each database ? 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