IDS Forum

Re: Seeing one oninit working hard while others ar

Posted By: Madison Pruet
Date: Thursday, 8 October 2009, at 4:01 p.m.

In Response To: Seeing one oninit working hard while others are no (Knox, Ernest)

It'd make more sense to look at onstat -g glo than ps -ef. That way w=
e
can see the function of each of the oninit processes to determine if
anything is really out of line.

M.P.

=

From: "Knox, Ernest" <Ernest.Knox@searshc.com> =

=

To: ids@iiug.org =

=

Date: 10/08/2009 02:57 PM =

=

Subject: Seeing one oninit working hard while others ar.... [1744=
5]

=

Sent by: ids-bounces@iiug.org =

=

I think we are running into a condition where only one virtual processo=
r
is trying to do a majority of the work on a remote server via synonyms.=

When you look at all the oninit modules running on the remote server, i=
t
looks like only one is really taxed:

ps -ef |grep oninit

hds 303146 1007698 0 11:27:08 pts/0 0:00 grep oninit

informix 332022 1327236 3 03:11:49 - 4:37 oninit -s

informix 339984 1327236 0 03:11:50 - 0:01 oninit -s

informix 573444 1327236 0 03:11:53 - 0:00 oninit -s

informix 663766 1327236 0 03:11:54 - 0:57 oninit -s

informix 729146 1327236 0 03:11:55 - 0:00 oninit -s

informix 938176 1327236 0 03:11:51 - 0:15 oninit -s

informix 962686 1327236 84 03:11:52 - 164:32 oninit -s

informix 1032288 1327236 0 03:11:54 - 0:27 oninit -s

informix 1101972 1327236 0 03:11:49 - 0:01 oninit -s

informix 1327236 1499276 0 03:11:49 - 0:01 oninit -s

informix 1380472 1327236 0 03:11:53 - 0:00 oninit -s

informix 1388604 1327236 0 03:11:54 - 0:23 oninit -s

informix 1400916 1327236 0 03:11:53 - 0:02 oninit -s

informix 1454178 1327236 0 03:11:54 - 0:21 oninit -s

informix 1499276 1 4 03:11:48 - 8:35 oninit -s

from 11.5

Running Poll Threads on CPU or Network Virtual Processors

Poll threads can run either on CPU virtual processors or on network
virtual processors. In general, and particularly on a single-processor
computer, poll threads run more efficiently on CPU virtual processors.
This might not be true, however, on a multiprocessor computer with a
large number of remote clients.

The NETTYPE parameter has an optional entry, called vp class, that
allows you to specify either CPU or NET, for CPU or network
virtual-processor classes, respectively.

If you do not specify a virtual processor class for the
interface/protocol combination (poll threads) associated with the
DBSERVERNAME variable, the class defaults to CPU. The database server
assumes that the interface/protocol combination associated with
DBSERVERNAME is the primary interface/protocol combination and that it
should be the most efficient.

For other interface/protocol combinations, if no vp class is specified,=

the default is NET.

While the database server is in online mode, you cannot drop a CPU
virtual processor that is running a poll thread.

Note: You should carefully distinguish between poll threads for network=

connections and poll threads for shared memory connections, which shoul=
d
run one per CPU virtual processor. TCP connections should only be in
network virtual processors, and you should only have the minimum needed=

to maintain responsiveness. Shared memory connections should only be in=

CPU virtual processors and should run in every CPU virtual processor.

I revise my suggestion for crusher (goal is to handle most connections
possible)

How many CPUs are assigned to Informix on Crusher? VPCLASS
cpu,num=3D2,noage so I'll say 2 physical 4 virtual?

With that in mind:

NETTYPE ipcshm,4,50,CPU <- have shared memory polling on every
virtual cpu

NETTYPE soctcp,3,350,NET <-

LISTEN_TIMEOUT 60

MAX_INCOMPLETE_CONNECTIONS 1024

FASTPOLL 1

Excerpt from Informix group:

Also I notice that your shared memory NETTYPE only specifies one
listener poll
thread, shared memory listeners should always be run in ALL CPU VPs for=

best
responsiveness and to keep CPU VP#1 (which handles the first poll
thread) from
running flat out and taking 90% of the work for itself.

What do you think?

This is IDS 11.50.UC3 remote server and 11.50.FC3 database server on OS=

AIX 6.1.

The remote server has synonyms pointing to the database server database=

tables.

We are using COOKED files also.

Thanks,

*******************************************************************

Ernie Knox

IT Database Administrator Specialist

Sears Holdings

3333 Beverly Rd., B4-266A

Hoffman Estates, IL. 60179

Office: (847) 286-5735

Email: Ernest.Knox@searshc.com

Blackberry: 2244650553@messaging.sprintpcs.com
<mailto:2244650553@messaging.sprintpcs.com>

Page via Skytel: 2244650553@sprint.skytel.com
<mailto:2244650553@sprint.skytel.com>

Informix or MySQL Primary: 9110210@skytel.com
<mailto:9110210@skytel.com>

Informix or MySQL Secondary: 7276872@skytel.com
<mailto:7276872@skytel.com>

" Yes we can make a Change! "

" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS=
!
"

" Lets not forget - GO Pistons and Red Wings! "

GSU

*******************************************************************

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• Seeing one oninit working hard while others are no
  Knox, Ernest -- Thursday, 8 October 2009, at 3:55 p.m.
  • Re: Seeing one oninit working hard while others ar
    Madison Pruet -- Thursday, 8 October 2009, at 4:01 p.m.
    • RE: Seeing one oninit working hard while other....
      Knox, Ernest -- Thursday, 8 October 2009, at 4:53 p.m.
      • RE: Seeing one oninit working hard while other....
        Madison Pruet -- Friday, 9 October 2009, at 9:31 a.m.
      • Re: RE: Seeing one oninit working hard while other
        JACQUES RENAUT -- Friday, 9 October 2009, at 10:35 a.m.
        • Re: RE: Seeing one oninit working hard while o....
          Art Kagel -- Sunday, 11 October 2009, at 7:23 p.m.
          • RE: RE: Seeing one oninit working hard while o....
            Knox, Ernest -- Sunday, 11 October 2009, at 7:26 p.m.
            • RE: RE: Seeing one oninit working hard while o....
              Knox, Ernest -- Sunday, 11 October 2009, at 7:42 p.m.
              • Re: RE: Seeing one oninit working hard while o....
                Art Kagel -- Monday, 12 October 2009, at 11:40 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.