Stored procedures locking behaviour

Posted in 1997

Peter Tashkoff — 8 May 1997 02:18:03 -0400 — source: Informix-list mailing list archive (1991-1998)

I have today downloaded Rafal Czerniawski's excellent article on Stored Procedures from the IIUG website. It mentions exclusive locking of system tables when creating and re-optimising SPs. This is not covered as far as I can tell in TFM. Does anyone know of where I can get more detail on this or alternatively provide the answers to the following questions? 1. What tables are locked during the create process. 2. What tables are locked during re-optimisation. 3. What table access is required to *run* an SP (without re-optimising.) Our current policy is to allow new or changed SPs to go live with an application level outage only. On reading Rafal's article I am wondering whether we have been lucky so far, and need to only put SPs live during a general database outage. TIA Peter Tashkoff <tashkop@zespri.co.nz> Zespri International Limited This posting may not be used by any party to vilify another. Standard disclaimers apply.