Hi,

In my application, we are constantly facing one issue :

We get the SQL exception that " cannot read sysproc plan catalog table". It
says some other user has locked the table.

As per my understanding, thsi tabel is used by Informix to update query plan
of all stored procedure. Can anyone help me how to get rid of this issue.

Thanks and Regards,
Meenu

Hi,

Did you run update statistics for procedure?

This URL can help you:
http://www-01.ibm.com/support/docvie...id=swg21079720

If you are working on version 7 and the problem persists verify if
your stored proceduer cache size is enough (onstat -g prc).


Vagner

On 23 jun, 01:21, meenu sharma <meenu.thapli... (AT) gmail (DOT) com> wrote:

On Jun 23, 12:21*am, meenu sharma <meenu.thapli... (AT) gmail (DOT) com> wrote:
Meenu,

For this to happen the most likely cause is this:

1. stored procedures drop and created temp tables inside the sproc
2. the said sprocs are called within transactions.

sproc has a dependency list of all tables/views it uses. so if any
of them changed after the sproc was last compiled, it forces a new
recompile
of sproc. Dropping/creating a sproc always triggers a new recompile
and recompiling informix locks sysprocplan.

executing sproc within a transaction makes it worse since the lock is
not released
until the transaction commits which can take as long as your
application demands.