Re: Sysprocplan locking and Stored Procs Recompiling

In article <01bd2d04$ec1d3c60$8e110280@gzeal.nigas.com>, Gary Zeal <garyz@zealinc.com> writes >Running Informix 7 Online. > >Our application (written in SQLWindows 5.0.2) uses quite a few stored >procedures. Users are getting locked up and it seems to be due to locks >being held on the sysprocplan table. All tables have a "R"ow locklevel and >all views have a "B"ase locklevel. > >We run an update statistics on Sunday evening each week. > >When we query the "created" column in sysprocplan we find that many of the >values in this column show the current date which to me seems that the >procedures are getting either recompiled or a new execution plan during the >day. > >How do stored procedures get either recompiled or get a new execution plan >aside from a create or an update statistics? > They don't. Someone must be doing update stats. Unless they involve temp tables - this was a bug that was fixed in 5.03. I doubt it exists even in early 7.x releases.. >This problem is driving us nuts! Any help would be greatly appreciated > >Thanks in advance -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care