Re: Sun OS 4.03 -- Informix locking problems

Path: emory!ogicse!unmvax!uokmax!occrsh!abcom!mlh From: mlh@abcom.ATT.COM (XXXX ) Newsgroups: comp.databases.informix Keywords: locking problems Message-ID: <2492@abcom.ATT.COM> Date: 15 Oct 91 16:17:17 GMT References: <1991Oct11.211736.21158@mks.com> Organization: AT&T(IMS-DPO), Aurora, Colorado Posted: Tue Oct 15 09:17:17 1991 In article <1991Oct11.211736.21158@mks.com>, john@mks.com (John Postma) writes: > Has anyone out there run into problems with Informix only allowing 64 > row level locks between a begin and commit, causing a run-time error > on the 65th row. We are running Informix .03 SE, using SUN OS 4.03 and > the problem occurs in a commercial package (FOURGEN Accounting). I have > come across the problem with in-house code, but usually have implemented > some type of work-around by locking the entire table to be used. Our port > of Informix uses the .lok files for locking. If there is anyone out there > who has run into a similar problem, what have you done to alleviate the > problem?? Any suggestions would be greatly appreciated.... John, We had the same problem with Informix 2.10 under Unix UTS 2.0 (SYS V for Amdahls) when one of our users attempted to lock several hundred thousand individual rows. Our tier three support told us that it had something to do with a lack of shared memory resources and that the Kernal could be re- tuned or the user could lock the entire table, which would only take a single resource. Not much help is it? Have you tried calling Informix to see if there is a tuning parameter which can be changed to allow you to lock more than 64 rows? Mark Hampton AT&T Denver Data Center