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/

We use PDQPRIORITY=HIGH export PDQPRIORITY for those users we wish to be able to run PDQ with it unset for normal use. -- Earle A Long (Senior Informix DBA) SINGLEPOINT UK LTD "Murat YILDIZ" <murat-y@usa.net> wrote in message news:93ms5c$5m7$1@nnrp1.deja.com... > I have these settings for PDQ: > > MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority > DS_MAX_QUERIES # Maximum number of decision support> queries > DS_TOTAL_MEMORY # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum number of decision support> scans > 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/ >

Note that PDQPRIORITY values of 0, 1 & 2 are special values. 0: No parallelism 1: Minimal parallelism (same as LOW) 2: Lowest setting that give full parallel features. See the Performance Tuning Guide and the Administrators Guide for details. Art S. Kagel Murat YILDIZ wrote: > > I have these settings for PDQ: > > MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority > DS_MAX_QUERIES # Maximum number of decision support> queries > DS_TOTAL_MEMORY # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum number of decision support> scans > 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/