Re: **MEMORY FAULT***HELP?!****
In article <3m3ppc$pb4@cssun.mathcs.emory.edu>, jvemo@cyberspace.com says most eloquently... > >At 02:18 PM 4/4/95 GMT, Roshanak N. Cyrus wrote: >} >}/users/informix->tbcheck -pe perform2 >} >}WARNING:TBLSpace demo1:informix.t_cdedcde has more than 8 extents. >}WARNING:TBLSpace ifamperf:ifam.system_log has more than 8 extents. >}WARNING:TBLSpace st09:informix.t_cdedcde has more than 8 extents. >}WARNING:TBLSpace st09:informix.t_wks has more than 8 extents. >}WARNING:TBLSpace dba01:informix.t_acct has more than 8 extents. >}WARNING:TBLSpace dba01:informix.t_cust has more than 8 extents. >}WARNING:TBLSpace dba01:informix.t_stmtopt has more than 8 extents. >}WARNING:TBLSpace dba01:informix.t_stmtmag has more than 8 extents. >}WARNING:TBLSpace prog01:informix.t_optfchreq has more than 8 extents. >}WARNING:TBLSpace prog01:informix.t_wflhist has more than 8 extents. >}WARNING:TBLSpace st01:informix.t_cdedcde has more than 8 extents. >}WARNING:TBLSpace st01:informix.t_wflhist has more than 8 extents. >}WARNING:TBLSpace st04:informix.t_cdedcde has more than 8 extents. >}WARNING:TBLSpace st04:informix.t_wflhist has more than 8 extents. >}WARNING:TBLSpace st05:informix.t_wflhist has more than 8 extents. >}WARNING:TBLSpace train01:informix.t_wflhist has more than 8 extents. >} >} >}Memory fault(coredump) >} >}What do I have to do to the UNIX or INFORMIX config. to fix this problem? > >I believe I saw this problem at one point also. If I recall, I got around >the problem, >by increasing the SHMBASE in the config file. More often then not, the default >SHMEM base on the Sequent ports (my platform), has been too small, so when >memory is needed for sorting, it fails. Not very graceful error handling huh? > >Try increasing your SHMBASE, and try again. > >Jon >} >}robin >}Chemical Bank NYC >} >} >================================================================== >Jon Vemo Internet: jvemo@cyberspace.com >Bothell, WA USA >------------------------------------------------------------------ >Watch out for road-kill on the information superhighway....SPLAT!! >================================================================== > 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. Am I right Joe? -- \\\\|// (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 ========================================================================= ====