Re: **MEMORY FAULT***HELP?!****
In article <3mbl54$4m3@cssun.mathcs.emory.edu>, naomi@anasazi.com says most eloquently... ( Tim Schaefer wrote this: ) >} > >} Also recalculate your extents via the recalculation formulas INFORMIX >} provides, unload and create a schema of the ones with more than 8 >} extents, drop them, recreate them, reload them. If the amount of data >} is too large you can also adjust the NEXT extents instead of the >} recreation method. >} >Setting the next extent will only change the size of the next extent needed. >It wont do anything about the existing number of extents. > >> Naomi Walker (aka N7FSA) | naomi@anasazi.com > | Phoenix, Arizona > ---------------------------------------------------------------------- > It's almost impossible to overestimate the unimportance of most things. You're right...I shoulda clarified my answer. I was implying that in the event the person couldn't unload the data to some place equal to the size of the table, in an unload file, they could at least adjust the NEXT extents until they find some way to clean up the >8 extented tables. And as long as I'm responding, 4.00 extent calculations can be found in the 4.00 On-Line Programmer's Manual, page 51. I admit to using them for 5.01 without getting into trouble, as I could not find the 5.01 variation on this. The 5.01 Data Base Admin Guide covers a lot of good ground, but I did not see the extent calcs--maybe I wan't looking in the right place. Anyway fix your extents soon... :-) And if someone would be kind enough to let me know where those 5.0 extent calcs are I'd be most grateful. ( Can't seem to find Joe's book when I need it! :-) -- \\\\|// (o o) ==============================---o00--(_)--00o---============================ Tim Schaefer tschaefe@gate.net The Computer Business Company, Inc. http://www.gate.net/~tschaefe Coconut Creek, FL, USA INX_UTIL Tool Kit is now shareware Ub...eh...Now, see, who gets to ask the questions here? --Ross Perot =============================================================================