Re: Priorities in Online?

Posted in 1996

Dan Jatnieks — 14 Jun 1996 23:17:41 -0700 — source: Informix-list mailing list archive (1991-1998)

I thought you must have a multiprocessor machine in order to use PDQPRIORITY. Is that nor true?? In article <jAzqDMAanwvxEwhr@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <148.100696@deckard.hb.north.de>, Patrick Preuss ><ppr@deckard.hb.north.de> writes >> >>Hi, >> >>is there any way to prioritize a SQL-request? We have a C/S-environment >>with Windows-clients and an Online 7.12 server, running OLTP and >>reporting-queries in parallel. It would be nice if we could >>schedule the reports with a lower prio than the transactions. >> > > Yes you could use the SET PDQPRIORITY <integer> statement with PDQ > enabled to give higher priority to specific queries. > > Set the PDQPRIORITY in your ONCONFIG file to 0 and MAXPDQPRIORITY to > 100. Then use the SET PDQPRIORITY <integer> statement within the > reports to increase their priority. > -- -- dan jatnieks Siemens Rolm Communications Inc. dan.jatnieks@siemensrolm.com http://www.siemensrolm.com/