Re: Problem with SYSPROCPLAN

Posted in 1998

Mark D. Stock — Tue, 02 Jun 1998 15:19:55 +0200 — source: Informix-list mailing list archive (1991-1998)

Jerry Hamilton wrote: > > Help! > > 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. Run UPDATE STATISTICS for this procedure before you run it. If you get the same error, then add more locks by increasing the LOCKS configuration parameter. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+