Re: Problem with SYSPROCPLAN

On 1 Jun 98 at 10:11, Jerry Hamilton wrote: > I have an application developer who has just written a stored > procedure that is 17 printed pages long. It's major big. > Everything it is executed I get the following message: > > SQL ERROR (-312) Cannot update system catalog (sysprocplan), > [ISAMerror -134:ISAM error: no more locks] > > I'm confused about the locks. Is Informix complaining about the > locks on the user tables or the locks in sysprocplan. It's complaining about a shortage of locks overall. I assume you're using a variant of OnLine. In your tbconfig or onconfig file, you will find a parameter called NUMLOCKS (or something like that). Make this value larger until the problem goes away... :-) HTH. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________