Re: more on extent problem
On Tue, 25 Jan 2000, Yan Zhu wrote:
>
> hey all,
> thanks for all the suggestions, they are great!. :)
> doing some more digging around, did a oncheck -pt and it's showing
> the following on the table
>
> Number of pages allocated 16777215
> Number of pages used 16777215
> Number of data pages 16129687
>
> so I went to check the Administrator Guide for Informix Dynamic Server,
> and it says that the largest number
> that can be stored in the three most-signifcant bytes of a rowid is
> 16,777,215, this figure is the upper limit of
> the number of pages that cvan be contained in a single tblspace.
>
> so according to that, i am out of pages in the tblspace.
> My question is, what is the common solution to that? I only have
> about 30 gigs of data and 100 million records, what do
> people do when their pages in the tblspace is maxed?
> thanks a lot.
> yan
>
>
>
You could fragment the table which would give you a seperate tblspace for
each fragment. I am sure others will have suggestions for you as well.
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-4123
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================