Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
John Carlson — — source: Informix-list mailing list archive (1991-1998)
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 skiponstat -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 strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.