• Date: Tuesday, February the 15th
• Time: 1.5 hour, 8:30 AM Pacific, 10:30 AM Central, 11:30 AM Eastern, 16:30 London, 17:30 Berlin/Paris
• Title: Enhanced Application Development with Informix 11.7
• Speaker: Jacques Roy (IBM)

You can register for the Informix webcast here

One large concurrency issue with sysprocplan had to do with automatic re-compilation of stored procedures. Automatic recompilation can be done for a variety of reason and many users are not aware that it even happens. The recompilation was done under the users current transaction which meant that until the users session committed or rolled-back their transaction the recompilation of this procedure held locks on sysprocplan. These locks prevented others from accessing an executing the procedure be compiled until the users transaction committed.