Re: Stored Procedure Problem

Bill Weaver wrote: > > I'm having periodic problems with a stored procedure. This stored procedure is > called from a PowerBuilder application. 90+% of the time it works fine. However > on occasion it will just hang and never return a value to the calling client > program causing it to also hang. Any ideas why this would work most of the time > and not work at others? The only pattern I've been able to see is that it seems > to hang at peak access periods. Their tends to be 2x during the day that not > only is the database heavily utilized but also the functions that would call this > stored procedure. If it has something to do with this peak in access, what can I > configure to give it more resources during these peak times? Any help would be > greatly appreciated! > -------------------------------------------------------- > Name: Bill Weaver > E-mail: Bill Weaver <billw@fscorp.com> > Date: 03/17/98 > Time: 13:26:55 > > This message was sent by Z-Mail Pro - from NetManage > NetManage - delivers Standards Based IntraNet Solutions > -------------------------------------------------------- Could be the bug Tech Support sent me in a version 7.14 SE patch to fix another bug. The sysprocauth table gets locked when some stored procedures are called. If you do a SELECT that calls a SP and then try again before COMMITting to unlock you can get it. COMMIT before all calls to SPL fixes most of the problems (but gives you plenty of others!) Is error logging switched on? 4GL can diagnose this easily, dunno about PB> (I haven't had a version with both bugs removed yet.) -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/