Re: Priorities in Online?

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. Be creaful though as too high a PDQPRIORITY can really hog the machine. Also check your UNIX kernel parameters regarding semaphores/ sahred memory are set high enough. I once had a client who enabled PDQ on their development machine ( a 2 CPU Pryramid) and the machine froze solid. Eventually a Pyramid engineer was called in to investigate and discovered Informix was literally using 100% of both CPUs. Apparently they had hit a kernel limit to do with semaphores!! -- David Williams