Re: SRTxxx: the trouble with Tribbles?

WARNING: This post is based on vague recollections... From: yoda@dagobah.org (Jedi Master Yoda) > >INFORMIX-Universal Server Version 9.14.UC6 on SunOS 5.5.1 >Generic_103640-31 sun4u sparc SUNW,Ultra-2 > >The server has taken to creating hundreds of files in /tmp called things >like srt0105709_001 (where the number varies). Though the system is >short on physical memory, it has plenty of swap. Having searched the >documentation, Web, Usenet, IIUG and FAQs I can find nothing to explain >what they are. They are sort files. >The problem is that eventually (over a few days) the files fill up >/tmp completely and bring the machine to its knees. I'm guessing >that since /tmp is on a swap filesystem these files are some kind of >logical representation of the shared memory blocks that Informix is >allocating. Either way, I need to know how to stop these files being >created/shared memory being grabbed. Any ideas? You can't stop them from being grabbed, they get created every time Informix needs to do a disk sort. They can sometimes get left behind when the sort crashes. Is PSORT_DBTEMP set, or was it set at the time the server was started? If you unset it (and reboot the instance), the problem *might* go away. Check the date on the files, if they're older than today, you can probably just club them. The file name also (IIRC) is partly made up of the process number that created the file. You might also be able to use that to identify files that can be deleted. HTH. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com