Re: Understanding tbcheck -pe
Posted in 1998
Aaron Gatzke <aaron_gatzke@idwear.com> wrote: >*Sample Data* > >Disk Usage for Chunk 1 Start Length >---------------------------- ----- ------ >stores.informix.customer 8066 8 >stores.informix.orders 8074 16 >stores.informix.customer 8090 8 > >- is the 'Length' measured in pages? Yes >- is each listing, an extent? Yes >- does this mean that table 'customer' has two extents of 8 pages each > and table 'orders' has 1 extent of 16 pages? Yes >- is there any utility or other tbcheck switches that will tell me > exactly how many extents each table has and what the size of the > next extent will be? tbcheck -pT db_name:table_name > >Thank you > >Aaron > *************************************************************** Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com ***************************************************************