Re: PDQ PRIORITY idling threads ( Informix 7.3 TC2/1 ?)

In article <6ml99e$n4u$1@news.xmission.com>, Alexander V.Didytch <unknown.thegreat@usa.net> writes > >Hi ! > >Here is the problem: > >I have the stored proc. with SET PDQ PRIORITY HIGH; inside it; >when I'm run it everything is fine, and onstat -u gives me a lot of >thread with the same SID. that relates to that procedure >but when the procedure. finished its work onstat -u give's me the same >pictures >on threads ! (In 7.2x it always gives me exactly one). > What does onstat -g ath give? >Even when i'm run SET PDQ PRIORITY LOW; and run some query (I'm using >SQL Editor 3.0) >the onstat -u doesn't change. Does it mean that those processes that >are linked to PDQ workout >are idling and eats my server resources even after all PDQ HIGH >statements (PDQ is stated inside procedure, >so it has effect only inside that proc) is finished ? > Sounds like it has not finished. Does it return >1 row? Possibly the threads are to do with something else. another procedure/trigger/query that is called. >BTW. Right now I can't say what TC I'm using -- onstat -V gives TC2, >while all release documents in >release dir states TC1 and systables gives TC1 too. Could some one told >me what TC I'm using ? And TC2, onstat -V is correct. >is there any other way that scanning systables to see the right answer >in SQL ? > Nope. >Sincerely, Alexander >-- All opinions are my own and not those of my employer. -- >| >| Alexander V.Didytch Kyiv, Ukraine, unknown.thegreat@usa.net >| >-- >The professor rapped on his desk and shouted: "Gentlemen, order!" >The entire class yelled: "BEER!!!" > -- 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