Re: Table extent config causing -566/-208 errors?!

In article <356338FA.E419FCFC@qsmint.com>, Jay Hannah <jay@qsmint.com> writes >Greetings -- > >A couple of weeks ago my company rolled out a fairly large Informix >implementation (48 tables), and after ironing out some bugs everything >seemed to be working pretty well. > >I went in a couple of days ago and noticed that "oncheck -pe" showed >some pretty severe table fragmentation, so based on current and >projected data volume, I recreated all the tables with the "EXTENT SIZE" >and "NEXT SIZE" options set and reloaded the data (I projected 12 months >of growth for the initial extent size). > >Everything seemed to be swell: The initial extents for the tables >totaled 980 Mb (in a 1.8 Gb chunk), the data reloaded fine, and all our >processes picked up right where they left off without complaint. > >What I don't understand is that since our re-load I've noticed some >strange errors while trying to run some relatively simple queries. For >example: > > -208 Memory allocation failed during query processing. > ... and ... > -566 Cannot initiate sort. > Check disk space. Check if PSORT_DBTEMP is set in the user environment. Run onstat -d and check the rootdbs has free space. Check DBSPACETEMP in onconfig file and the user environment. Check in onconfig file that OPTCOMPIND=0... >I've never even SEEN these errors before, and they now occur >sporadically in procedures that until recently worked just fine every >time! Is this some very strange coincidence that I should try to ignore, >or did I forget to do something critical in server configuration when I >set up the extents? These errors are NOT reproducible: a procedure works >fine time and time again, and then spits out one of these errors for no >apparent reason. > >What did I forget to do? What do I need to reconfigure? > >Thanks for your time, > >Jay > > >Online Workgroup Server Version 7.20.UC5 >INFORMIX-4GL Version 6.05.UD1 >SCO OpenServer 5.0 on Pentium II 233, 128 Mb RAM, 8Gb HD space > -- 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