PDQ questions

Posted in 1998

Pons Roca, Isidre — Wed, 4 Nov 1998 11:17:13 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi all. Some questions about de PQD. I have the above producs: Informix ODS Ver 7.24.UC2-1 Informix I4GL Ver 6.05.UD2 This products are running on some Sun platforms with Solaris 2.4 The questions are: a) The ODS Administration manual (Ver 7.2) say in chapter 18: "Online uses the PDQ Priority value of a query to determine when to use PDQ to proces a query in parallel" I set the environment variable PDQPRIORITY to 25 for a especial user but the PDQ do Nothing, why? (I have fragmentation and resources asigned to PDQ). b) how i can set the PDQPRIORITY from a 4gl program? I try to do with let a="SET PDQPRIORITY 25" prepare s_a from a execute s_a The program abort with de error -410. Aditional information: My Online instance is a mix from a DDSS and a OLTP Thanks in advance. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------