Lcok iSsue on Sysproc plan catalog table

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/docview.wss?uid=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...@gmail.com> wrote: > 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