PSORT_NPROCS
CHUAN LU asked whether PSORT_NPROCS is set on the client or server. Bob said the server. Art Kagel said the client too, as a client setting overrides the server for its sessions. Jopydo said the performance guide does not intend client use, and Art pointed to the Guide to SQL Reference showing it is also client side.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 ?
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.
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
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. > > >
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