Re: problemas con SYSPROCPLAN

Hmm problems with SYSPROCPLAN? difficult as your mail is not in english but there is a feature of informix that if you change the "version number" of a table that is used in stored procedure you need to reoptimisethe SQL in the Stored procedure. If you don't do that manually then the next time the Stored procedure that needs optimised executes it will reoptimies itself. If that is within a transaction, the lock on sysproclan will last till the transaction is committed. so, you need to figure out what has updated the version number of the table 1/ have you altered the table in anway? 2/ have you run update statistics on the table? 3/ Some older version of client SDK/iConnect run an update stats without you knowning so make sure you ahe the latest SDK ? iConnect "Dooku Maul" <in4mixperu@hotmail.com> wrote in message news:<ckmbuk$pln$1@news.xmission.com>... > Hi all > > En los ultimos dias se me presentaron problemas de BLOQUEOS con la tabla > SYSPROCPLAN. Quisiera conocer las causas de estos bloqueos y la > recomendacion para evitarlos. > > saludos > > _________________________________________________________________ > Charla con tus amigos en l'nea mediante MSN Messenger: > http://messenger.latam.msn.com/ > > sending to informix-list