PSORT_NPROCS

Posted in 2011

CHUAN LU — Sat, 22 Oct 2011 00:35:33 — source: IIUG Forums & Mailing Lists

Hi, If I have a large box, lots of physical CPUs in the server, the client application run in another box, connected trhough TCPIP, I want to set environment PSORT_NPROCS, Is it being set in client or server side ?

↪ replying to CHUAN LU

rroussey@comcast.net — Sat, 22 Oct 2011 15:39:46 — source: IIUG Forums & Mailing Lists

You set it on the server side, start Online and the db engine will make use of it. Bob ----- Original Message ----- From: "CHUAN LU" <luchuan@cn.ibm.com> To: ids@iiug.org Sent: Friday, October 21, 2011 8:35:35 PM Subject: PSORT_NPROCS [25255] Hi, If I have a large box, lots of physical CPUs in the server, the client application run in another box, connected trhough TCPIP, I want to set environment PSORT_NPROCS, Is it being set in client or server side ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to rroussey@comcast.net

Art Kagel — Sun, 23 Oct 2011 02:04:31 — source: IIUG Forums & Mailing Lists

Client side also. If a client sets the PSORT_NPROCS it will override the server's setting for that client's sessions. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Oct 22, 2011 at 11:39 AM, rroussey@comcast.net <rroussey@comcast.net > wrote: > You set it on the server side, start Online and the db engine will make use > of > it. > > Bob > > ----- Original Message ----- > From: "CHUAN LU" <luchuan@cn.ibm.com> > To: ids@iiug.org > Sent: Friday, October 21, 2011 8:35:35 PM > Subject: PSORT_NPROCS [25255] > > Hi, > > If I have a large box, lots of physical CPUs in the server, the client > application run in another box, connected trhough TCPIP, I want to set > environment PSORT_NPROCS, Is it being set in client or server side ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba21219bdc14c604afedb96b

↪ replying to rroussey@comcast.net

Jopydo — Sun, 23 Oct 2011 08:31:32 — source: IIUG Forums & Mailing Lists

Hi, Have a look at performance guide, you will see the use of PSORT_NPROCS. It is not intended to be used at client side. Le 22/10/2011 17:39, rroussey@comcast.net a écrit : > You set it on the server side, start Online and the db engine will make use of > it. > > Bob > > ----- Original Message ----- > From: "CHUAN LU"<luchuan@cn.ibm.com> > To: ids@iiug.org > Sent: Friday, October 21, 2011 8:35:35 PM > Subject: PSORT_NPROCS [25255] > > Hi, > > If I have a large box, lots of physical CPUs in the server, the client > application run in another box, connected trhough TCPIP, I want to set > environment PSORT_NPROCS, Is it being set in client or server side ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >

↪ replying to Jopydo

Art Kagel — Sun, 23 Oct 2011 09:26:52 — source: IIUG Forums & Mailing Lists

Check the Guide to SQL Reference to see that it is also client side. Art On Oct 23, 2011 4:32 AM, "Jopydo" <jopydo@free.fr> wrote: > Hi, > > Have a look at performance guide, you will see the use of PSORT_NPROCS. > It is not intended to be used at client side. > > Le 22/10/2011 17:39, rroussey@comcast.net a écrit : > > You set it on the server side, start Online and the db engine will make > use > of > > it. > > > > Bob > > > > ----- Original Message ----- > > From: "CHUAN LU"<luchuan@cn.ibm.com> > > To: ids@iiug.org > > Sent: Friday, October 21, 2011 8:35:35 PM > > Subject: PSORT_NPROCS [25255] > > > > Hi, > > > > If I have a large box, lots of physical CPUs in the server, the client > > application run in another box, connected trhough TCPIP, I want to set > > environment PSORT_NPROCS, Is it being set in client or server side ? > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e868e98db4e04aff3e78a