Re[4]: Update Statistics Speedup Help???

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable You can also put global settings for some environment variables in=20 $INFORMIXDIR/etc/informix=2Erc=2E This is like a /etc/profile for Informix=2E Works in 7=2E2x, possibly in 7=2E1x=2E Davin ______________________________ Reply Separator ____________________________= _____ Subject: Re: Re[2]: Update Statistics Speedup Help??? Author: MIME {kagel@ns1=2Ebloomberg=2Ecom} at INTERNET Date: 27/01/98 17:13 On Tue, 27 Jan 1998 david=2Eashby@workcover=2Ensw=2Egov=2Eau wrote: =20 >=20 > Art, > =20 > Can you put the PSORT_NPROCS parameter in the onconfig for all=20 > sessions to pick up? =20 No=2E =20 > If not how do you get all sessions to use it? =20 Put it in /etc/profile=2E =20 > If it is added to the general login profile is it picked up by a=20 > client server connection? =20 In Informix 7 many environment variables are transmitted as part of the=20 connection process=2E I do not know for certain if the PSORT_ parameters=20 are transmitted=2E On second thought they must be, remember in V7 the=20 user's process (and therefore environment) are not directly known by the=20 database processes in the same way that the V5 sqlturbo process inherited=20 it so it MUST be included in the connection handshaking even for a local=20 client=2E However, if you set them for the engine's environment before=20 running oninit that environment should become the default=2E =20 Art S=2E Kagel, kagel@bloomberg=2Ecom =20 =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--