Re: Informix and PDQ

settler@hobbes.dbintellect.com (Jeff Craig) wrote: :}>BTW, just for the record, PDQPRIORITY needs to be set at the SQL level, :}>not at the engine level. I've seen things get quite scary when :}>PDQPRIORITY is set in the ONCONFIG file. :}> :}>Anyone else out there have tidbits? reminders? experiences? warnings? :}> :}>John Carlson :}>Informix DBA :}>WH Smith Inc. :}>Any of my ideas are mine alone and not necessarily those of my company. :It would be nice if third-party products, such as BusinessObjects, :allowed you to pass through PDQPRIORITY, but they do not, nor does :I-Connect. Therefore, you may be forced to set it globally in order :to gain its benefits. Note that as of Informix 7.2x, the PDQPRIORITY :parameter in onconfig is obsolete, so global setting is accomplished :via informix.rc file. Also, if you are running Informix 7.2x on :Silicon Graphics IRIX 6.2, and you are running NUMCPUVPs > 1, and :PDQPRIORITY is > 1, you will get incorrect results if the SQL :contains count(distinct columnname). If you do not use I-Connect, but a real ODBC driver instead, you can have that driver set PDQPRIORITY on a session level basis. It can be set automatically by the driver each time you connect to the database. I think this can even be done based on the application you are running (like access rights can), but I haven't checked the documentation for that. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org