URGENT: Sysprocplan lock error - sqlcode=-211, ISAM=-144

["Shulzhenko Vasyl" <vasilis@softline.kiev.ua>]

>Hi All,
>
> I used to run Update statistics for procedure <procname> daily, due to
>locking of sysprocplan records
> I am running it once a week.
>
>I found that sysprocplan for (around 130) stored procedures are updated
>daily.
>when is the sysprocplan table updated for a stored procedure other than the
>following
>reasons ? :-
>
>1. when the procedure is created
>2. tables used within the procedure is altered.
>3. when update statistics for procedure is run.
>
>
>In Techinfo product defects knowledge database there were some bugs which
>mentioned that
>string concatenation or  using opague datatypes in where clause can cause
>the procplan to be
>updated every time the stored procedure  is run.
>
>We are using IUS9.14UC2 on solaris 2.6
>
>
>Venky
>
>
>
>
>
>
>
>*** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ***