Re: Informix: Ulimit Problems on SCO UNix

In article <3bg7nh$jad@blackice.winternet.com> geoff@winternet.com (Geoff Kuchera) writes: >From: geoff@winternet.com (Geoff Kuchera) >Subject: Informix: Ulimit Problems on SCO UNix >Date: 29 Nov 1994 21:50:40 GMT >The Problem: We are running into a Ulimit problem using the Informix SE >engine V4.00.UG2. We have a database that is currently sitting at the >1.07 gig barrier which is sco's standard ULIMIT. >We can't add rows to this database from ISQL or home grown 4gl's they >blow up with a file to large error. < this would be the reason for >suspecting the ULIMIT> >We have rebuild the kernel on the system to have a standard ULIMIT of >4194303 which comes out to around 2.2gig max file size.. I can create >files with no problem on the system that are larger than a gig. I suspect >that either Informix has a compiled in ULIMIT or SCO's write function is >specially broken for informix... ;-)... There is a hard limit and a soft limit. It is very possible that you increased the hard limit when you rebuilt the kernel, but that the soft limit was not affected. Look at your man pages for "ksh" or "csh" or possibly "sh". There is a command called ulimit or limit that is built-in to the shell. Try executing this in the script that starts informix to determine the current ulimit (redirecting output to a file). If you determine that the soft limit needs to be raised. This command will set the soft limit as well. >If anyone has insites on this problem I would appreciate a responce.... >Thanks in advance.. If you need more information let me know.. >ps. The file systems are 2 gig each.. with nothing else on them.. >Thanks... > Geoff Kuchera > geoff@winternet.com