Re: DBA problems

On Thu, 15 Apr 1999, Madison Pruet wrote: > Which system file is full? Are you using /tmp as your swap file? If so then > what you might be seing is that you are unable to aquire shared memory segments > because there is insufficent swap space. > > Shevkar, Mukund wrote: > > > Following is an excerpt of the online.log > > 10:31:16 Checkpoint Completed: duration was 5 seconds. > > 10:31:27 Assert Failed: Internal Error - Segmentation Violation > > 10:31:27 Who:Session(14058, lcheyne@Zeus, 9409, 184863008) > > Thread(14565, sqlexec, b02e4f0, 1) > > 10:31:27 Results: OnLine must abort > > 10:31:27 Action: Reinitialize shared memory > > 10:31:27 See Also: /tmp/af.38e5226e > > 10:31:28 rsinit.c, line 9217, thread 14565, proc id 270, Segmentation> > Violation Can also be that your temp db space is not activated, or is too small. Informix will default to /tmp if it is not allocated a temp db. I recently had this problem with /tmp filling up. When I looked in the config file, the tempdbs was commented out. You should have a couple of temp db's in a decent sized system. John