SQL Error Code: -211

Hi, I have encounter below error while application is running on my informix 7.31.UD6 (solaris 8). When the below error happen, it slow down the application. As a workaround, i have to turn off the application service,run update stat and start back the application service. In long run, this is not a plan, so please share your experty. SQL Error Code: -211 SQL State: IX000 SQL Message: Cannot read system catalog (sysprocplan). (-144)ISAM error: key value locked Rick

Hi, I am not sure if this is applicable to you, however; The last time I experienced this error, I resolved it by de-normalising one of the stored procedures. We found that calling a stored procedure from within a frequently used stored procedure agrivated the problem. We embedded the code from the called stored procedure into the calling stored procedure and the problem went away. Hope that this helps Regards Mark -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CHEE KHUAN LEONG Sent: 23 March 2009 05:10 AM To: ids@iiug.org Subject: SQL Error Code: -211 [15274] Hi, I have encounter below error while application is running on my informix 7.31.UD6 (solaris 8). When the below error happen, it slow down the application. As a workaround, i have to turn off the application service,run update stat and start back the application service. In long run, this is not a plan, so please share your experty. SQL Error Code: -211 SQL State: IX000 SQL Message: Cannot read system catalog (sysprocplan). (-144)ISAM error: key value locked Rick **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ================== Please read our Email Disclaimer : http://www.thefuelgroup.com/disclaimer.html

Hi Mark, Thanks for the recommendation. Well, I am not sure whether the problem is trigger by application or not? But i will get application support to check against their code. Rick

Hello, i had this error when there was a null in the data and the store procedure can´t resolved this. Changed the null for spaces or zero and Worked fine. Regards Susana -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Mark Tyrer Enviado el: Lunes, 23 de Marzo de 2009 03:54 a.m. Para: ids@iiug.org Asunto: RE: SQL Error Code: -211 [15276] Hi, I am not sure if this is applicable to you, however; The last time I experienced this error, I resolved it by de-normalising one of the stored procedures. We found that calling a stored procedure from within a frequently used stored procedure agrivated the problem. We embedded the code from the called stored procedure into the calling stored procedure and the problem went away. Hope that this helps Regards Mark -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CHEE KHUAN LEONG Sent: 23 March 2009 05:10 AM To: ids@iiug.org Subject: SQL Error Code: -211 [15274] Hi, I have encounter below error while application is running on my informix 7.31.UD6 (solaris 8). When the below error happen, it slow down the application. As a workaround, i have to turn off the application service,run update stat and start back the application service. In long run, this is not a plan, so please share your experty. SQL Error Code: -211 SQL State: IX000 SQL Message: Cannot read system catalog (sysprocplan). (-144)ISAM error: key value locked Rick **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ================== Please read our Email Disclaimer : http://www.thefuelgroup.com/disclaimer.html **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Hi there!!! I have in the production environment more than 5.000 Stored procedures. Sometimes, i had this error, and i fixed executing "UPDATE STATISTICS FOR PROCEDURE". I hope it is helpful to you. Alberto. T··· Systems do Brasil Ltda Alberto Romeu Pessonio Filho IBM Informix Certified System Administrator V7 IBM Certified Managing and Optimizing Informix Databases V7 DBA Informix/DB2 UDB/SQLServer/Oracle F: 55+11-4347-5475 / 2184-2751 email: alberto.pessonio@ts3.com.br Internet: www.t-systems.com.br -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Susana Barea Enviada em: segunda-feira, 23 de Março de 2009 8:36 Para: ids@iiug.org Assunto: RE: SQL Error Code: -211 [15278] Hello, i had this error when there was a null in the data and the store procedure can´t resolved this. Changed the null for spaces or zero and Worked fine. Regards Susana -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Mark Tyrer Enviado el: Lunes, 23 de Marzo de 2009 03:54 a.m. Para: ids@iiug.org Asunto: RE: SQL Error Code: -211 [15276] Hi, I am not sure if this is applicable to you, however; The last time I experienced this error, I resolved it by de-normalising one of the stored procedures. We found that calling a stored procedure from within a frequently used stored procedure agrivated the problem. We embedded the code from the called stored procedure into the calling stored procedure and the problem went away. Hope that this helps Regards Mark -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of CHEE KHUAN LEONG Sent: 23 March 2009 05:10 AM To: ids@iiug.org Subject: SQL Error Code: -211 [15274] Hi, I have encounter below error while application is running on my informix 7.31.UD6 (solaris 8). When the below error happen, it slow down the application. As a workaround, i have to turn off the application service,run update stat and start back the application service. In long run, this is not a plan, so please share your experty. SQL Error Code: -211 SQL State: IX000 SQL Message: Cannot read system catalog (sysprocplan). (-144)ISAM error: key value locked Rick **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ================== Please read our Email Disclaimer : http://www.thefuelgroup.com/disclaimer.html **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

This is to everyone: PLEASE QUOTE THE POSTING OR REPLY THAT YOU ARE REPLYING TO SO EVERYONE KNOWS WHAT THE *(&#$ YOU ARE TALKING ABOUT! Many of us follow these forums using email and we DO NOT save the posts, so there is no other thread to follow than the quoted text in the replies. In this case, for example, I have no idea whose recommendation you are thankful for. If you were saying "EUREKA that worked!" it would not help anyone else with the same problem if the future. If the post you are replying to is lengthy, then SNIP it to its essentials retaining enough that a reader will be able to figure out what your reply means and add <SNIP> in there to indicate that there was more text deleted so a curious browser with a similar problem can follow the thread. Every emailer and newsreader has a setting that quotes the message you are replying to if you tick it off. If you really are unable to find that checkoff, at least cut and paste the text. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 23, 2009 at 3:33 AM, CHEE KHUAN LEONG <cloudlck@hotmail.com>wrote: > Hi Mark, > Thanks for the recommendation. Well, I am not sure whether the problem is > trigger by application or not? But i will get application support to check > against their code. > > Rick > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016364ef3c4c1201b0465cb2b05