Re: problemas con SYSPROCPLAN

scottishpoet wrote: > 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 Look for massive GRANT/REVOKE instructions... It changes the table version and will cause procedure re-optimization. Regards.