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

Jay Hannah <jay@qsmint.com> offerred: +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). +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. At the least, I would update stats for all stored procedures, as well as the altered tables. -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)