onstat -g tpf - 100's of millions of lock requests.

Howdy Anybody struck a problem with threads in selects spinning on the CPU and = generating hundreds of millions of lock requests when viewed from onstat = -g tpf? Anyone know just what is these lockrequests? IE, in what situation they = are created. Syslocks shows zero locks on the tables concerned. oncheck -cI shows indexes to be OK.Updating stats makes no difference. It even hapens with temporary tables. onmode -z sessid *does* work, but the users kind=27ve complain. Help Peter Tashkoff <tashkop=40iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World=27s Finest =20