Re: the explain of tbcheck -pt

jjdai@hotmail.com wrote: . . . snip snip snip . . . > 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 . > When Informix loads data, it will load the data into contiguous groups on the disk. Since there are no gaps in the data (in your instance), it calls it one extent. > 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 ? > onstat -d will give you basic chunk info, including free space. For the tables, oncheck -pt <database>:<table name> will give you used pages versusallocated pages. If you're using 7.x or higher, you can get all of this information through queries against the sysmaster database. John Carlson Informix DBA WH Smith, Inc.