Re: Help - I've hit the maximum number of extents in Informix 5

Be warned. Severe performance problems will arise as the number of extents escalates. You would be best served by unloading and reloading the data and increasing the first and next extent size. djw@smooth1.demon.co.uk on 03/19/98 05:13:20 PM Please respond to djw@smooth1.demon.co.uk To: informix-list@iiug.org cc: (bcc: Dan Weeks/AGInc) Subject: Re: Help - I've hit the maximum number of extents in Informix 5 In article <35116385.3817@tasc.com>, Ray Russell <rlrussell@tasc.com> writes >Has anyone out there seen what happens when a table grows to the point >where it reaches the maximum number of extents. Can this cause >corruption in the dbspace, or just an error message? > Unknown, run tbcheck. >Ray Russell -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care