Re: can't fork on database server

In <5q2upd$ivk@cssun.mathcs.emory.edu> acustaf!clee@acustaf.acustaf.com (Chengteh Lee) writes: >We use SCO/Unix and informix se. We see the error >message very often. >SQL Error: Operating system cannot fork process for back end. >SQLCODE=[-1257] ISAM Error code=[11] >I suppose the back end means database server. >Please tell me how to fix this problem. Thanks! Best guess is that you are exceeding the kernel maximum for either system wide processes or "per user" processes. Run SCO's kernel configurator and look for these two variables. Use sar to get a feel for what you're currently running at, and to monitor the growth of some of the kernel tables. I haven't seen a problem with SCO 5.0.2 (as these things are dynamic), so if you're running less than version 5.0.0, you may want to think about upgrading. Bryan Tonnet batonnet@phase4.com.au -- Bryan Tonnet batonnet@phase4.com.au