Re: Bizzare sqlerror codes

->From: uunet!mediatech.COM!patrice (Patrice Badger) ->Subject: Bizzare sqlerror codes ->Date: Tue, 28 Apr 92 11:25:13 CDT ->Message-Id: <9204281125.aa02992@mtcdev.mediatech.COM> ->X-Informix-List-Id: <list.1113> -> ->I put a multiple user order entry system on line 4 weeks ago. Since then I've ->started getting very strange errors that didn't show up in testing. (Do they ->ever?) I'm getting a mixed bag of -> -> -46 Protocol family not supported -> -113 The file is locked -> -242 could not open database table -> -311 Cannot open system catalog -> ->The -113 and -242 errors happen on tables that are "read only" reference tables. ->Therefore, I can't figure out why the entire table would be locked. What could ->make it impossible to open the system catalog? I don't even have error -46 ->in my Informix manual. What is it? -> ->I suspect that these errors are only a symptom of some other problem. ->Unfortunately, I can't figure out what to even look for |-(. Any ideas from ->out in netland? The occurence of these errors are increasing in frequency and ->I need all the help I can get. -> ->BTW: I am running Informix 4.0 and SCO UNIX 3.2 on a Compaq SystemPro/486 You need to read some of the documentation in the release directory provided with the Informix software. You don't say so, but you are using Standard Engine. On BSD machines, error -46 is as printed above, and error -79 is "No record locks available". On System V machines, the error number -46 should be translated as "No record locks available". All these problem clearly point to a requirement to reconfigure the kernel with an increased number of locks. How many you actually need depends on the workload; I would double the exsiting number, and keep doing so until the problem went away. If feeling very virtuous, I might then back off the last figure -- more likely, I'd be too busy on the next job to do more than be thankful that the problem's gone away. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>