RE: PDQ_PRIORITY parameter!

In order to utilize PDQ, you either need to set PDQPRIORITY in either your SQL (or 4GL) or your environment. In SQL: set PDQPRIORITY <some_value> In environment (UNIX presumed): export PDQPRIORITY=<some_value> John Carlson Informix Database Administrator EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 -----Original Message----- From: Murat YILDIZ [mailto:murat-y@usa.net] Sent: Friday, January 12, 2001 7:09 AM To: informix-list@iiug.org Subject: PDQ_PRIORITY parameter! I have these settings for PDQ: MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority DS_MAX_QUERIES # Maximum number of decision supportqueries DS_TOTAL_MEMORY # Decision support memory (Kbytes) DS_MAX_SCANS 1048576 # Maximum number of decision supportscans DATASKIP off # List of dbspaces to skip onstat -g mgm output: Informix Dynamic Server Version 7.31.FC7 -- On-Line -- Up 2 days 00:41:20 -- 1307232 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 4 DS_MAX_SCANS: 1048576 DS_TOTAL_MEMORY: 512 KB Queries: Active Ready Maximum 0 0 4 Memory: Total Free Quantum (KB) 512 512 128 Scans: Total Free Quantum 1048576 1048576 1 Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit) Gate 1 Gate 2 Gate 3 Gate 4 Gate 5 (Queue Length) 0 0 0 0 0 Active Queries: None Ready Queries: None Free Resource Average # Minimum # -------------- --------------- --------- Memory 0.0 +- 0.0 64 Scans 0.0 +- 0.0 1048576 Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 0.0 +- 0.0 0 0 Ready 0.0 +- 0.0 0 0 Resource/Lock Cycle Prevention count: 0 I haven't seen any PDQ.What does this mean now.Should I change PDQ parameters or is there no need?How can I make queries running in parallel?Thanks... Sent via Deja.com http://www.deja.com/