RE: PDQ Woes

PDQPRIORITY sets the amount of PDQ resources that will be used by a query. When you set it to 75 it means that it will use 75 percent of PDQ resources (Memory, Threads, etc.). When you run onstat -u you saw multiple threads not multiple sessions. If you run onstat -g sql <sid> for the main session you'll even see the types of threads being used by the session. When you set PDQPRIORITY to 10, obviously it uses less resources, so the lesser number of threads per session. You can set the PDQ parameters in the configuration file, but doing so would require that you shutdown the database. You can set the PDQ parameters dynamically by using onmode. But this will be in effect as long as the database instance is OnLine. ------Original Message------ From: Brett Geer <brett@brabys.co.za> To: "informix-list@iiug.org" <informix-list@iiug.org> Sent: February 16, 2001 6:50:17 AM GMT Subject: PDQ Woes OK, so a user job has been running now (we joke not), 2 days on one little select, ok its lots of data. So I kill it, my box was grinding. I run it with MAX PDQ at 10, it crawls, my box crawls. I set PDQPRIORITY=75 (I know, but I'm the admin and no-ones gonna say nuttin). Then it rocks with speed, but onstat -u | grep brett suddenly show 21 connections from the SAME terminal. Any ideas? Set the PDQ down and poof, one connection brett -- ----------------------------------------------------------------- Brett's 13th law of UNIX administration... The 13th sucks, we'll skip this one ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me of a long forgotten rhyme... the Rhyme of the Ancient Sysadmin # ps -ef | kill -9 `awk '/albatross/{print $2}'` ----------------------------------------------------------------- ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup