Oninit&reg; Archive

"Martin Thole" <mth@o-b-s.de> wrote in message news:48e3667f$0$6617$9b4e6d93@newsspool3.arcor-online.net... > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual)…

IDS 11.5 licence question: virtual versus physical processors ?

Martin Thole

We are planning to migrate our database server to a VMware server. The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 cores), but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. How many processor licences are necessary ? Which database editons (…

Weird one

RALPH GENTRY

Sounds like it gets worse as you increase VP threads. Are there any threads waiting to run during this "timeout"? As the thread saturation goes up you have to wonder about the pcode running on the CPU(s). In a multi-cpu enviornment OS's may handle CPU instruction look-ahead in va…

Hardware advice please

R Rhodes

Hi all, I am looking for advice on what servers to buy to replace our existing informix db servers. We have to replace them, because they are dinosaurs and could pack up at any moment. Unfortunately I don't really have any idea what would be good to get as I've never been involve…

View thread info?

BART GROOT

Hi Experts, We use an informix database as database layer for an ERP application. We encounter high CPU usage of the informix server while the ERP application is hardly used (low number of active users). The high CPU load always starts at the same timepoint in the morning and en…

Blocked:CKPT

VIKAS HIVARKAR

Hello, Again the same issue , This time i have increased the number of CPU VP's to 8. but again facing this Blocked CKPT. Pls any advice would be helpfull.…

Analysis of activities during checkpoint.

Amitava

Hi Vartika, Please check this link. You can add but not drop virtual processors of the AIO, PIO, LIO, TLI, SHM, SOC, and STR classes. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad ref.doc/adref308.htm Thanks.. Amitava E - id : amitacha@in.ibm…

Re: CPU VP Issue

pokeyman76@yahoo.com

Try the following onconfig changes... VPCLASS cpu,num=4,noage,aff=0-3 This will turn on noage and affinity for your 4 cpu vps NETTYPE onsoctcp,1,600,NET FASTPOLL 1 Try using a NET VP instead of inline poll…

Re: CPU VP Issue

Floyd Wellershaus

Not a hundred percent sure, but theres a processor affinity setting that may be forcing only one cpu. Also, what threads are sitting ? Maybe the app is single threaded ? ----- Original Message ----- Subject: CPU VP Issue Date: Thu, May 15, 2008 20:28 From: "tgirsch" <tgirsch@NOS…

CPU VP Issue

tgirsch

I've got a puzzling CPU VP issue that I'm hoping someone else here has dealt with. I've got a dedicated database server running IDS 10.00.FC8 on a four-core RHEL Opteron server. We've configured four CPU VPs, one per core. There are almost always five to six threads sitting on…

Informix database virtualization

Martin Fuerderer

Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…

CPU-VP issue

MIKE MAGIE

Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…

how to balance CPU VP

roger@star2000.com.tw

I set onconfig parameter NUMCPUVPS 10 AFF_SPROC 2 AFF_NPROCS 10 and run ' onstat -g glo' vp pid class usercpu syscpu total 1 2863646 cpu 9598.41 149.49 9747.90 2 155844 adm 0.76 1.87 2.63 3 1962…

IDS 10.0

SAMUEL JAKABOWSKI

Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…

CPU Help

Demeis, Tony (MOH)

First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…

Physical Processor to Virtual processor mapping.

Thirugnanam,

Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…

Re: NETTYPE NET/CPU

david@smooth1.co.uk

On 25 Aug, 06:35, mohitanch...@gmail.com wrote: > On Aug 9, 6:50 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > > > On Aug 8, 8:57 pm, mohitanch...@gmail.com wrote: > > > > Version: IDS 10 > > > I'll leave you mostly with Jonathan's entries and just add a bit as > > we…

ids on Windows and cpu usage

CARL MEYER

IDS version 9.4 tc2 (Windows) Current Onconfig parameters that relate to these settings: MULTIPROCESSOR 1 #NUMCPUVPS 4 SINGLE_CPU_VP 0 #NOAGE 0 #AFF_SPROC 2 #AFF_NPROCS 8 #NUMAIOVPS VPCLASS cpu,num=3 Note sure what a PDQ is. Let me know more detail and I will forward. Cheers,…

Re: Cpu vp usage

jprenaut@yahoo.com

On Aug 17, 1:02 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Aug 17, 4:31 am, "malcolm.iiug" <mali...@btopenworld.com> wrote: > > > > > AIX 5.3 > > > IDS 10.00.UC5 > > > We have had reports of slow performance so I have been monitoring the > > system. When I check with o…

Cpu vp usage

malcolm.iiug

AIX 5.3 IDS 10.00.UC5 We have had reports of slow performance so I have been monitoring the system. When I check with onstat -g glo I see that the cpu vp usage is skewed towards the 1st cpu vp. In the latest example cpu vp 1 has used ~4000 cpu seconds, cpu vp 2 has used ~20…

NETTYPE NET/CPU

mohitanchlia@gmail.com

Version: IDS 10 I am trying to understand NETTYPE better so that we can configure our connections appropriately and perhaps make it more efficient. My questions is: 1. Is VP Class NET synonymous to OS's CPU and Vp Class CPU synonymous to oninit. 2. After reading about Vp Class …

Re: VPCLASS 'cpu' not enough physical procs for affinity

Frank Langelage

sdhaya wrote: > The following is the output of psrinfo in our Sun V890 ... > > # psrinfo > 0 on-line since 06/16/2007 15:09:23 > 2 on-line since 06/16/2007 15:09:19 > 16 on-line since 06/16/2007 15:09:23 > 18 on-line since 06/16/2007 15:09:23 > > Ple…

Re: TCP Listeners: Preferences?

Thomas J. Girsch

Art S. Kagel wrote: > The rule still applies. The CPU VPs are can't block on the sockets and > are too busy to poll effectively. Also the first few CPU VPs tend to > take all the work on themselves so the other VPs will tend to be > quiescent and will take time to awaken and s…

Re: Mapping cpuvp's to IBM virtual processors ....

Dave Thacker

On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…

Re: Mapping cpuvp's to IBM virtual processors on p

ART KAGEL,

Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…

Mapping cpuvp's to IBM virtual processors on pSeri

Dave Thacker

We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…

VP error

Demeis, Tony (MOH)

IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…

Re: NETTYPE's poll thread number

Pankrich Khanthasa-ard

Version of IDS from 9, number of max connection is number of poll threads multipy by user per thread e.g NETTYPE soctcp, 2,100, NET : Max connection is 2x100 = 200 So first you have to monitor number of user connections before fill the number in by command : onstat -u , onst…

NETTYPE's poll thread number

TBP

roger@star2000.com.tw wrote: > Hi, > My box has singel processor , NUMCPUVPS =1 . > A lot of user will access this server, maximum will be 1500 user > threads. > How shoud I set up the NETTYPE in onconfig file. > On informix's manual , says poll thread should not be greater …

CPU idles

> Hi, > > First: it is possible to set the NUMCPUVPS parameter to a > higher value than actual processors in the system. This > sometimes leads to better response times. (when you encounter > idle time on your CPU (using sar) and the number of active > threads is not decreasing).…

what are all the statistics i should collect for cpu perf

madh

Hi I am using .informix 7.33 on HP-ux 11.x what are all the things i have to do monitor the perf. for cpu utilization. now numcpuvps is 2. i plan it to increase it to 4. which part of the stats i have to see to for the improvement in performance. thanks in adv. madu…

cpu-vps and number of physical cpus

JACQUES LAPEIRE

Hi people, after following some training on Informix and installing some instances, I'm still confused about the NETTYPE parameter. Example : NETTYPE ipcshm,1,350,CPU This means 1 cpu-vp and maximum (hard limit) 350 connections via shared memory, right ? Now I have a cluster,…

RE: IDS 10.0 performance on RedHat

Alexey Sonkin

Neil, I think, that both data load (into unindexed table) and index build (which is actually a sequential scan from I/O standpoint) are more hungry for latency, then for parallelizm. Also, it is quite clear, why increasing number of CPU VP's impoves KAIO performance: IDS direct…

Re: VP memory cache (was IFX_FOLDVIEW)

david@smooth1.co.uk

Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…

CPU VP

Matyá¹ Radek

Hello, our customer has Sun Fire V890 with 4*UltraSparc IV. But this 4 processors looks for OS like 8 processors (for example mpstat). How many CPU VP can I use? 3 or 7? Thank you Radek Matyas…

HP-UX KAIOON

Marco Greco

Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…

Re: IDS Workgroup cpu limit

"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:ds75uf$976$1$8300dec7@news.demon.co.uk... > Neil Truby wrote: >> A potential customer asked me a question which I think raises a number of >> interesting points, and I'd like to see what others think. >> >> As you m…

Re: IDS Workgroup cpu limit

> -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Posted At: Thursday, February 02, 2006 8:14 AM > Posted To: comp.databases.informix > Conversation: IDS Workgroup cpu limit > Subject: Re: IDS Workgroup cpu limit > > > Neil Truby wrote: > > A potent…

IDS Workgroup cpu limit

Stefan.Gabriel@nylex.com.au

A potential customer asked me a question which I think raises a number of interesting points, and I'd like to see what others think. As you may know, the IDS 10 Workgroup Edition (WGE) software has a check now so that when it starts up it checks the setting for NUMCPUVPS and , i…

Re: cannot start with 4 AIO virtual processor

Guy Bowerman

On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …

Re: cannot start with 4 AIO virtual processor

informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…

Re: cannot start with 4 AIO virtual processor

Jaime Casanova

BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…

Re: cannot start with 4 AIO virtual processor

"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…

cannot start with 4 AIO virtual processor

Jaime Casanova

Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…

RE: MULTIPROCESSOR settings on a multiple CPU server with

Ford, Andrew G

>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…

FW: Informix versus Oracle Spatial

RollForward Wizard

This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…

Crash of the instance

Heinz Weitkamp

Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…

Posting from the Informix-list

Heinz Weitkamp

Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…

Informix MULTIPROCESSOR cannot be set to 1 after upgrade from AIX5.2ML02 to ML06

xiaolud

Hi there, I met a strange problem here. I have 13 database instanse in one 690 machine. Last week, I upgrade my OS from AIX5.2ML02 to ML06 as IBM suggest. After that I find there are two instanse cannot startup, and reporting the following error: 10:25:29 IBM Informix Dynamic Se…

Re: IDS 10 Download?

David Williams wrote: > By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS > and possibly even SINGLE_CPU_VP is depreciated? > > VPCLASS is the new way..sure I saw this in a ONCONFIG file > somewhere (9.40.UC5?) but IDS 10.0 has no mention of > VPCLASS and still has NUMCPUVP…

Re: IDS 10 Download?

David Williams wrote: > By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS > and possibly even SINGLE_CPU_VP is depreciated? > > VPCLASS is the new way..sure I saw this in a ONCONFIG file > somewhere (9.40.UC5?) but IDS 10.0 has no mention of > VPCLASS and still has NUMCPUVP…

Re: Single cpu vp woe

Andrew Hamm wrote: > Art S. Kagel wrote: > >>Andrew, that will only seem to happen when the other activity on the >>system is not CPU intensive, which is quite common. Most business >>applications are IO bound not CPU bound. > > > very true, and in the systems we play on, the co…

IDS 10 Download?

By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS and possibly even SINGLE_CPU_VP is depreciated? VPCLASS is the new way..sure I saw this in a ONCONFIG file somewhere (9.40.UC5?) but IDS 10.0 has no mention of VPCLASS and still has NUMCPUVPS etc!! Perhaps onconfig.std for …

RE: Single cpu vp woe

Mark

How much has he minimized it by doing that? Is he running workgroup server? That's pretty cheap in my books. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Neil Truby Sent: Wednesday, February 23, 2005 5:05 PM To:…

Re: Single cpu vp woe

Andrew Hamm

Art S. Kagel wrote: > > Andrew, I disagree. NOAGE has nothing to do with allowing IDS to > take over the "complete allocation of the cpu cycles" of one or more > processors. The reason for NOAGE is that some OSes (most > aggressively HPUX and less so Solaris) progressively redu…

Re: Single cpu vp woe

Andrew Hamm wrote: > Neil Truby wrote: > >>9.20 UC3 on Red Hat 7. >> >>This site is running the time series datablade in production on a 2- >>cpu box. It's all working fine. >> >>For reasons we needn't go into they want to move to a single cpu box. >>[ETC] Andrew, I disagree. N…

Re: Single cpu vp woe

Andrew Hamm

Neil Truby wrote: > 9.20 UC3 on Red Hat 7. > > This site is running the time series datablade in production on a 2- > cpu box. It's all working fine. > > For reasons we needn't go into they want to move to a single cpu box. > [ETC] Neil, you haven't mentioned the settings for NO…

Re: Single cpu vp woe

Richard Kofler

Neil Truby schrieb: > 9.20 UC3 on Red Hat 7. > > This site is running the time series datablade in production on a 2-cpu box. > It's all working fine. > > For reasons we needn't go into they want to move to a single cpu box. > They've set up an identical test server. When we run…

Single cpu vp woe

9.20 UC3 on Red Hat 7. This site is running the time series datablade in production on a 2-cpu box. It's all working fine. For reasons we needn't go into they want to move to a single cpu box. They've set up an identical test server. When we run the same programs with the live…

More CPUVPs than processors

Mark wrote: I've always found that for any CPU faster than about 400MHZ (~600 for x86 CPUS) you can run at least 2 CPU VPs per CPU. Now that CPUS are MUCH faster and multi-pipelined and multi-virtual CPU's, you can likely make that 3 or 4 or 5 times # physical CPUs. I think th…

Could not fork a virtual processor: errno = 12

HUGO PADILLA

Hello The past week I had a problem with a memory bank of my SUN450 with solaris 8 The problem is already fixed, but I try to rebuilt a secondary instance with HDR y it is no possible, the steps are the same i had used alltimes: onstape -s -L 0 in the primary server in stanard …

DB-Crash

Heinz Weitkamp

Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…

Consolidation servers

Lavoie, Diane

Hi, We are in the process of consolidating database servers. At this moment, each Production database has is own server with 2 or 4 CPU. The new server will hold from 3 to 5 databases, each server has 6 CPU. In the current config file of Informix, the parameter NUMCPUVPS is set…

RE: NUMCPUVPS on ultrasparc dual core architecture

Alexey Sonkin

8 or 7 -Alexey > -----Original Message----- > From: co4770@yahoo.com [mailto:co4770@yahoo.com] > > Hi, > > Can someone advise how to configure NUMCPUVPS for 4 processor > ultrasparc IV machine. At OS level it shows processors > 1,2,3,4,16,17,18,19 (8 processors because of dual…

NUMCPUVPS on ultrasparc dual core architecture

mak

Hi, Can someone advise how to configure NUMCPUVPS for 4 processor ultrasparc IV machine. At OS level it shows processors 1,2,3,4,16,17,18,19 (8 processors because of dual core architecture). regards…

CPU Binding

EDCEL BARCENA

Hello Everyone, I just wanted to clarify how does IDS determine the number of processors a UNIX box have? Our new server(Sun Fire E6900) uses the UltraSPARC IV processor, which is using the Chip Multithreading(CMT) technology. Through CMT, 20 additional virtual processors are sp…

How many physical processors we need to support 32K THREADS in IDS.

Julia M

Hi Team, Informix IDS supports upto 32K threads according to most IDS realease notes. My question is What sort of a machine you are looking at to support this many threads?? This came to my mind when considering max. num of threads(or connections that matter) that each CPU or NE…

Re: Unexpected Virtual Processor Termination - HELP!

On Tue, 18 May 2004 08:13:07 -0400, Joel wrote: Bounce both engines. Remote synonyms are usually more trouble than they are worth. Could be better to use ER to replicate the needed data on the other server in a separate local database and access it from there. Art S. Kagel >…

Unexpected Virtual Processor Termination - HELP!

Joel

We have two SCO-Unix servers, one runs our order entry and acct software, the other runs the warehouse/inventory control software. Each server has an Informix DB, IDS version 7.30 UC2. The inventory control DB uses synonyms to provide access to data in the order entry DB, and vi…

Setting up JVM on 9.30HC5, HP-UX 11i

Malc_p

Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…

Setting up JVM on IDS 9.30HC5, HP-UX 11i

Malc P

Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…

oninit process

Jay Aymond

They are from a variety of things: - CPU VP's - AIO VP's - TLI VP's - LIO VP's - PIO VP's - Misc. VP's You can do on onstat -g glo to see which type of VP is mapped to a Unix pid. "Ray Walsh" <raywsl@hotmail.com> wrote in message news:15aa6f7d.0404090611.ecf9044@posting.google…

RE: Virtual Processors and CPU-Load

Alexey Sonkin

Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…

RE: Virtual Processors and CPU-Load

Murray Wood (IList)

Dont post MIME Have you run the correct update stats? In Informix monitor users -- onstat -u the ready queue -- onstat -g rea the sqls -- onstat -g ses {session number} You need to determine which sessions or parts of the application are causing the load. With 200 users you…

Virtual Processors and CPU-Load

Markus Bschorer

Hi all, we are a little bit confused concerning the CPU-Load of our Informix-Database-Server. (9.4 UC3, RH9 2.4.20) We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at 99.9%! All tables and indexes (DBSpaces, Extents, ...) are optimized to the best of our knowledg…

Re: RES: Pentium 4 hyperthreading

Linux has support, IDS does not care whether the CPU is physical or a hyperthreaded virtual CPU. It will use it if you tell it to. Art S. Kagel Julio Cesar wrote: > Speaking on Affinity Processors, does anyone know if the IDS 9.40 has > support for this feature on Linux? > AF…

RE: Pentium 4 hyperthreading

Ronald Cole

Alexey Sonkin <alexeis@grandvirtual.com> writes: > With Xeon, I'm using NUMCPUVPS=8 on 4-CPU (real CPU's) > Linux box (2 GHz Xeons, 2MB L3 cache). Everything works fantastic. > > It's not clear to me, whether Linux process scheduling > takes into account that some CPU's are 'bett…

Reduce # of CPU: license cost

TOM ZUURBIER

IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…

Unexpected virtual processor termination

tajin couscous

Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…

Engine's re-setting

AndrÃ© Luiz Rufino

Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…

Re: NUMCPUVPS on a box having multiple Informix Instances

Michael Mueller

Why should one have more cpu vps that cpus and why does this have something to do with the cpu speed? Cpu vps should never block or sleep until they are really idle. If this holds, one vp can load one cpu 100%. If it doesn't hold it's a performance bug and you should talk to sup…

Re: NUMCPUVPS on a box having multiple Informix Instances

Michael Mueller

Setting MULTIPROCESSOR in a single cpu system is definitely not recommended because it creates performance problems. For a multiprocessor system with one cpu vp I am not sure. But I would rather not set it and set SINGLE_CPU_VP instead. This skips all multiprocessor latching code…

RE: NUMCPUVPS on a box having multiple Informix Instances

Start with 1 CPUVP (or 2) on each instance, but with MULTIPROCESSOR set. If/when one instance cannot keep up with the workload just add another CPUVP. When it has settled down and you know what resource each needs, affinitise each on their own CPU, if available on your platform.…

Re: NUMCPUVPS on a box having multiple Informix Instances

Chavan Koya

The instances will not be too busy. The processors speed is 250MHz. Thank you Chavan Koya ----- Original Message ----- From: "Jay Aymond" <jaymond@communitycoffee.com> To: <informix-list@iiug.org> Sent: Friday, May 23, 2003 2:59 PM Subject: Re: NUMCPUVPS on a box having multiple…

RE: NUMCPUVPS on a box having multiple Informix Instances

ART KAGEL, BLOOMBERG/ 65E 55TH

Start with the question .. How much CPU resource do you expect each instance to need? Similarly for the BUFFER resource. Here you can probably allocate more CPUVP's than CPU's, but someone may get starved if both instances hit maximum at the same time, or if you have AFFINITY s…

RE: NUMCPUVPS on a box having multiple Informix Instances

vivek.chaudhary@st.com

Could you give examples of kinds of CPUs that could be configured for more than one CPU VP per hardware CPU? thanks, Vivek > -----Original Message----- > From: jaymond [mailto:jaymond@communitycoffee.com] > Sent: Friday, May 23, 2003 1:00 PM > To: informix-list > Cc: jaymond >…

NUMCPUVPS on a box having multiple Informix Instances

Chavan

Hi All, The Informix recommandation for configuring NUMCPUVPS is equal to, or less than the number of physical CPU's in the box. I had to configure two instances on a box, which is having 6 cpu's. So what should be the NUMCPUVPS, is it 3 for each instance or 6 for each. F…

cpu time

EML

I've been observing a machine with IDS and application on same HP-UX platform. The machine has 8 cpu, Informix affinity to 2 processors and with numcpuvps=7. The total cpu time for 1cpu and 3cpu vp-classes are so much very very high compared to 4cpu-8cpu classes. Is there a way t…

Re: Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC

Uri

Hi 1) As for my experience if you have only DB on your server and you do not have large WAIT IO define all cpu to informix. If you have a lot of users and you are using NET VP check there cpu usage, maybe you should spare one or two cpu for them. 2) Probably the first SQL use i…

Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC

Reeves, Damion A

Hi, Not sure if anyone can shed some light on a couple of questions I have about Dynamic Server and NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC ? Firstly our setup: We are running a data replication setup (2 systems each running Dynamic Server 9.21-FC3x-1 on HP-UX 11.0). …

Shared mem connections and semaphores

oscar hernandez

HeadingDescriptionFormatvpThe virtual processor ID.DecpidThe system process ID for the process running this virtual processor.DecclassThe class of virtual processor.StrsemopsThe number of times this virtual procesor went idle and performed a semaphore operation to wait for work.D…

balancing virtual processors

Merrill, Douglas D.

How do I get the kio's to be more balanced? I'm on a Proliant 7000 4-cpu box using NT4.0. C:\\\\WINNT\\\\system32>onstat -g iov Informix Dynamic Server Version 7.31.TC2 -- On-Line -- Up 08:00:59 -- 1643008 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy …

Re: AW: NETTYPE

Dan, I've researched and tested this one to death long ago and it still holds. To explain. We originally went with the recommendations in the admin guide and had only one CPU listener for shared memory connections and a couple for TCP connections. Since most connections here are…

Re: AW: NETTYPE

dan.michaelis@verizon.com

Art, Help me understand why we never want to put TCP poll threads on CPU VP's. I might well agree that we'd not want to put any poll threads on CPU VP's, since we want CPU VP's pretty much exclusively doing CPU VP kind of stuff, rather than listening for connections. What I don'…

Informix Lockup (Wierd)

----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…

RE: # of instances per machine

Parker, Jack

I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…

RE: # of instances per machine

Parker, Jack

It depends. What version are you running? If version 5 then perhaps that might be a good rule. I would not consider running 7.x+ on less than 4 CPUs. It also depends on whether these instances will all be active at the same time, if they can swap out...... However. I am hig…

# of instances per machine

If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…

FW: what does lngspins mean?

Dirk Moolman

Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …

Listener threads and CPU VP imbalance

Andrew Hamm

Art, I saw in the FAQ that way back (11th Dec 1997) you wrote something about insufficient number of listener threads causing skewed CPU VP activity, and recommended increasing the number of listeners. Is this still a problem with the latest engines? Is there any way to see se…

CPU VP utilization

Nebojsa Sevo

I have 2 different servers. 1st - 1 CPU 155 MHz Pentium, 64 MB RAM, 1 HD 2nd - 1 CPU 300 MHz Pentium II, 64 MB RAM, 1 HD Both have IDS 7.2 but they have differences in Informix configuration. 1st 2nd NUMAIOVPS 3 1 CLEANERS 16 1 LRUS 16 8 Here are some outputs from onstat …

RE: 3 onconfig parameter questions, help

NUMCPUVPS - the number of Informix CPU processes. Increasing will allow Informix to use more CPU power. Decreasing - the converse. Keep as number of cpu's - 1. AFF_NPROCS = NUMCPUVPS always AFF_SPROC keep as 1. Unless you do not want CPU affinity, when both AFF parameters sh…

3 onconfig parameter questions, help

Have you tried another parameter change?: RTFM=ON <mr_potato_head@my-deja.com> wrote in message news:916inu$fss$1@nnrp1.deja.com... > Hi, > I have an E4500 running solaris 7 with 4 cpu's and running informix > 7.31. Can anyone explain to me the results of changing these 3 >…

Re: AFF_SPROC questions ..

From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >I have following parameters : > >NUMCPUVPS 4 >AFF_SPROC 0 >AFF_NPROCS 0 > >Now, does it mean that I am not using Processor affinity as AFF_NPROCS = >0 The above is correct. _____________________________________________________…

RE: Assert Failed: Unexpected virtual processor termination, pid

Woi Yew Fong

nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…

Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100

Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…

Assert Failed: Unexpected virtual processor termination, pid = 74

Woi Yew Fong

Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…

questions onstat -g

Impy

Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…

Best Config for DUAL CPU Informix Server?

Normally NUMCPUVPS should be at most #CPUS - 1. There has been some success configuring NUMCPUVPS as high as 2 * #CPUS on Sun Sparc platforms with CPUS AT LEAST 400MHZ or faster. On your box, and especially with only 21 CPUs I'd recommend leaving only one CPU VP. Art S. Kagel …

Re: checkpoint problem

Chuck Renaud

Comments below... >> Move to 7.31.UC5.. >No move, always at 7.31, just a restart I think he was suggesting an upgrade to UC5, which I concur with. >> >NETTYPE ipcshm,3,50,CPU # Configure poll thread(s) for nettype >> Good, these are set the right way around, tcp=NET sh…

SINGLE_CPU_VP

martyn.ayshford@orange.co.uk

If you have SMP with more than one CPU (not much of an SMP otherwise I guess) you need to set MULTIPROCESSOR to 1. If you have NUMCPUVPS set to a value greater than one, or you want to be able to increase it beyond 1 using onmode -p +1 cpu you should set SINGLE_CPU_VP to 0 other…

Informix 9.21 VPCLASS question

tchow@genuity.com

Hi everyone, We are in the process of migrating to Informix v9.21. In the Informix Administrator's Guide, it mentions that Informix sugguests to use VPCLASS parameter instead of AFF_SPROC, AFFNPROCS, NOAGE, NUMCPUVPS, and NUMAIOVPS parameters. Does anyone have any experience o…

VPCLASS 'cpu' not enough physical procs for affinity

CKGeier@nwc.edu

I upgraded our server to 4 processors, from 2. I set multiprocessor option to 1, numcpuvps to 3, nprocs to 3 and sproc to 1. At bootup I see the operating system recognizes 4 processors. In the log, upon startup of Informix I see: "VPCLASS 'cpu' not enough physical procs for aff…

Re: NUMCPUVPS

smooth1

Does this still apply using 7.31.UC4? Check the FAQ at www.smooth1.demon.co.uk martyn.ayshford@orange.co.uk wrote in message <8o1grh$j0t$1@nnrp1.deja.com>... >mmmmm > >In addtion to what the others said.... > >Are you running KAIO? > >If you are do the following > >echo "_ncols/…

Re: NUMCPUVPS

Rudy Fernandes

Masa wrote: > > Virtual processor summary: > > class vps usercpu syscpu total > > cpu 6 56820.59 10253.74 67074.33 > > aio 40 1144.83 2457.59 3602.42 > > lio 1 7.02 18.85 25.87 > > pio 1 …

Re: NUMCPUVPS

mmmmm In addtion to what the others said.... Are you running KAIO? If you are do the following echo "_ncols/D"|adb -k /stand/vmunix /dev/kmem If this going up at all be worried, if it's going up real fast be very worried. It measures the number of collisions ie the number o…

Re: NUMCPUVPS

I think that would be the CPU VP listener threads polling and spinning. Art S. Kagel Rudy Fernandes wrote: > > Wonder what's causing Informix's syscpu to be 4 times that of usercpu - > normally, its the reverse. Post onstat -c as well as the other onstat's > suggested. > > Rud…

NUMCPUVPS

Masa

We have a two server cluster environment. Another server is for Baan application and another is for Informix database. Informix version is 7.31 FC2. Both servers are HP N 4000 (6 CPU) with HP-UX 11.0. Now users are reported to us that application is getting slower. Application …

IDS 9.20 with a single cpu vp

Continuing my story about the whole of an IDS 9.20 instance being frozen out of 10-20 seconds on end by a single heavy-duty process: I have repeated my test (heavy duty program running in one session; dbaccess->table info on the other) on a v7.24 instance. I can confirm that th…

Re: Hardware upgrade and efficiency of Informix

From: "smooth1" <smooth1@iclway.co.uk> > >Obnoxio The Clown wrote in message <8m8ot2$7i8$1@news.xmission.com>... > > > >I'm up for a challenge: > > > >In your onconfig file, set: > > > >MULTIPROCESSOR 1 > >NUMCPUVPS 2 > >SINGLE_CPU_VP 0 > > > >That should help. > > > > Hmm! Don…

Re: Hardware upgrade and efficiency of Informix

smooth1

Obnoxio The Clown wrote in message <8m8ot2$7i8$1@news.xmission.com>... > >I'm up for a challenge: > >In your onconfig file, set: > >MULTIPROCESSOR 1 >NUMCPUVPS 2 >SINGLE_CPU_VP 0 > >That should help. > Hmm! Don't forget that a) The application might be a single threaded ser…

Re: (2) Poor Performance with 7.31.uc6

From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > >Obnoxio The Clown wrote: > > > A word to the wise: when you need to do your index rebuilds, set the > > following environment variables: > > > > PSORT_NPROCS=[2 * NUMCPUVPS] > > PDQPRIORITY=100 > > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 #…

Re: (2) Poor Performance with 7.31.uc6

Ty O'Kelly

Obnoxio The Clown wrote: > A word to the wise: when you need to do your index rebuilds, set the > following environment variables: > > PSORT_NPROCS=[2 * NUMCPUVPS] > PDQPRIORITY=100 > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesystems how will PDQPRIORITY=100 be aff…

About AIOs vp ...

"Manel Falcó i Aige" wrote: > > Hi, > Do the AIOs vp lunch treaths as CPUs vp do ? > According to onstat -g ath, #AIOs threaths seem to be equal to #AIOs > vp. I'm not sure of your question but let's give it a stab. If you are running KAIO turned on then there is exactly one …

Re: Oninit & Instance

Nick Kataria

Found in "onstat -g glo" Individual Virtual Processors Section -- Class CPU. Neil, Stephen & Edward, thanks for your help. Nick Kataria <kataria.nick@emeryworld.com> wrote in message news:8jdblp$c3e$1@news.cnf.com... > Hi All, > > If I have a process ID of an oninit process (fr…

Re: New Server- How to Optimise

Kirk Davis

Thanks, will give that a go, > NUMCPUVPS 3 > MULTIPROCESSOR 1 > SINGLE_CPU_VP 0 Are these in the informix.conf file?? Where do I increase the buffer? and what to? Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8iqbps$f1j$1@news.xmission.com... > > From: "Kirk D…

Performance Tweaking

AJ

I have an HP9000-800 series D270 two way running HPUX 11.0 and Informix 7.3 Dynamic Server. I also have 1 Gig of memory installed, 3x 600 meg swapspaces, 100000 BUFFERS, 63 LRUs, NUMCPUVP=2, SINGLE_CPU_VP = 0, and MULTIPROCESSOR=1 assigned in onconf.cars. My Bufwaits Ratio (BWR) …

Re: Setting VP parameters

From: "Vinod Bhansali" <iiug@hotmail.com> > >We have following settings in onconfig : >NUMCPUVPS 5 >AFF_SPROC >AFF_NPROCS > >Isn't it neccessary to bind the CPU VPs? > >What is your opinion? No it isn't necessary. On some platforms, it isn't even supported. Anyway, it doesn't bi…

CPU vps & affinity parms

Marat

MULTIPROCESSOR 1 (if server dedicated for DB) NUMCPUVPS 2 (there are recommendations NUMCPUVPS=#HWCPUS if #HWCPUS <=3) IMHO NUMCPUVPS 1 maybe would be better cause 2 CPU isn't 4,8 and more - overhead may be greater then benefit SINGLE_CPU_VP 0 - depends on NUMCPUVPS NOAGE 1 (if …

RE: CPU VP's

>Also I want ensure that only 4 physical CPU's are used (for everything >and there are 8 on the box) but I don't want to bind any process to a >certain CPU (I have already set the numcpuvps 4 but I also have 2 >aiovps) . If I use the parameter AFF_NPROCS - this specifies the num…

Re: CPU VP's

From: Bridget Reitsma <b.reitsma@auckland.ac.nz> > >What is the rule of thumb regarding the number of CPU VP's. One per CPU > >and not more than the total of CPU's on the machine? And how does this >tie in with 'a virtual processor is a piece of work for a CPU' Admin >Guide for…

CPU VP's

Bridget Reitsma

Hi What is the rule of thumb regarding the number of CPU VP's. One per CPU and not more than the total of CPU's on the machine? And how does this tie in with 'a virtual processor is a piece of work for a CPU' Admin Guide for Informix Dynamic Server pg 9-5. If my understandi…

Service name for Shared Mem connections

allenj

The idea was that you should always run shared memory connections thru CPU VP's and network/IP connections thru NET VP's, lest CPU VP 1 spend a lot of time spinning and generating LOTS of unnneeded system calls. As for monitoring CPU VP usage, I think an onstat -g glo would work…

KAIO in AIX

Art S. Kagel & Family

Andre Ngo wrote: > > In article <8b56nk$n5q$1@hyppo.gu.net>, > "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> wrote: > > Andre Ngo <andre@fiscal.org.jm> wrote in message [SNIP] > > Number of kio threads is equal to the number of CPU virtual > processors in > > IDS (NUMCPUVPS param in …

Re: Long checkpoints with no obvious cause

Watawinona

One sore thumb is the RA_THRESHOLD. Try 30 instead of 8. Also, the 1, 2 and 0 for multiprocessor, numcpuvps and single_cpu_vp. Nona…

CPUvps

Steven

Hi, Got the following on my IDS 7.24UC4X1 on HPUX10.20 (5 CPUs, 9 CPUvps) pri:informix 23> onstat -g glo|grep cpu class vps usercpu syscpu total cpu 9 192149.07 15658.73 207807.80 vp pid class usercpu …

Re: NETTYPE

> From: Gerson Finlev <gerson@informix.com> > > > >NUMCPUVPS 2 (You should never have more CPUvps that processors) > > > >-- > >Gerson Finlev, Performance Engineering, i.informix Sorry disagree this used to be the case but with the faster processors e.g. 450M Sparcs y…

Re: NETTYPE

From: Gerson Finlev <gerson@informix.com> > >NUMCPUVPS 2 (You should never have more CPUvps that processors) > >-- >Gerson Finlev, Performance Engineering, i.informix Well, here's me picking a fight with someone from Informix, and a performance engineer, no less! I ag…

KAIO: HP-UX 10.20 / IDS 7.24

Sergey Turin

Environment HP-UX 10.20 with latest patch bundle installed (very important) Informix Dynamic Server 7.24UC4X3 KAIO is on for at least 2 years Performance increase appr.25% Server 2 CPU's (single CPU VP though) Data size 8G, OLTP apps Model K220…

when informix-server down ?

Andreas Lommel wrote: > > Hi,- I think it`s better when I bring the informix db-server from time > to time down and start the server new. My question: Can I see when > it`s the right time (memory, ..) PLATFORM and VERSION info? There should be no need to bounce the engine perio…

Processor Affinity on a 2 CPU HP9000

kagel@bloomberg.net

In article <943353689.1230.0.nnrp-02.d4e45b75@news.demon.co.uk>, "Paul Wheeler" <paul.wheeler@leaderflushshapland.co.uk> wrote: > We are running HP-UX 10.20 on an HP9000 with version 7.22 of Informix Online > Dynamic Server. > > We currently are running the server with processo…

Re: Hanging CPU VP

Willem Roos

If i were you i'd bite the bullet and upgrade your OS to UW 7.1 + patches and upgrade IDS to 7.30UC10 or 7.31.UCx that has fixed defect #115327 (that thing about index pages in the cache i.s.o. data pages). Your best bet would be to get rid of UW altogether, you're better off wi…

Hanging CPU VP

Andrew Bland

Problem: Hanging CPU VP Hardware: Fujitsu M754i 4 x Pentium Pro 200 1.5Gb RAM 22 x 4Gb Hard Drives (11 For Mirror) OS: UnixWare 2.1.3 (spit spit spit) Engine: IDS 7.23UC1 I'm after a deeper understanding of our current problem. The problem is that on occassion 1 of our 3 CPU VPs…

Re: Long spins or onstst -g spi. Need any information.

From: "Shulzhenko Vasyl" <vasilis@softline.kiev.ua> > >�� , �� , �� , �� >�� >�� :) > >�� , �� CPU VP � �� >�� . �� (CPU VP) �� …

RE: Assert Failed: Unexpected virtual processor termination

COOPER, Joseph

> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtu…

Assert Failed: Unexpected virtual processor termination

michael martin

Hi gurus, IUS Version 9.14.UC6 O/S = HP-UX 10.2 Way back in August before I stumbled across this list IUS crashed and the online.log showed: "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" closely followed by: "Assert Failed: Unexpected virtual processor termin…

Re: Poor performance for a $750,000 box

Mike Segel

"Art S. Kagel" wrote: > It > started when I noticed that 90% of the CPU time my IDS engines were using > was being used by CPU VP #1 and that the CPU that I had pinned that VP to > was running at 98% ALL the time. Uhm why not turn off processor affinity? Then see what happens…

RE: KAIO on Sun and CPU question

dianne.pendleton@autodesk.com wrote: > > Another related question. > > This server has 2 cpu's. Following Informix's guidelines, I have the > database set up as a single-processor server. This server is only used for > one application, Remedy. There is only one database. > Wha…

Posting from the Informix-list

Andrew Ford wrote: > > One question about CPU VP's. > > We are running 2 400Mhz processors on HP UNIZ IDS 7.31.FC2. I have read in the newsgroups that some people have seen an increase in performance by having 2 CPU VP's per real CPU. I did this a few weeks ago and I have notic…

Re: Setting NUMCPUVPS

From: Webber Valerie H <Valerie.H.Webber@m1.irs.gov> > >Can you set NUMCPUVPS = physical number of CPUs? > >We have 4 CPUs but were told that NUMCPUVPS should be 1 less than the >physical number. Are there any risks at setting it to the actual number of >CPUs? I would make a wit…

Setting NUMCPUVPS

Webber Valerie H

Can you set NUMCPUVPS = physical number of CPUs? We have 4 CPUs but were told that NUMCPUVPS should be 1 less than the physical number. Are there any risks at setting it to the actual number of CPUs? Thanks in advance.... :) Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 7…

onstat -g iov

Gordon Hooker

KAIO threads run on the CPU VP - you may want to add more CPU VP's if that is feasable for your installation. Regards Gordon Pramod Dhumal wrote: > > Hi users, > > Is it possible to configure the number of kio vps shown by "onstat -g iov" > > Thankx > > ________________________…

RE: NUMCPUVPS question

Doug This is a "it depends upon what else is running on your server" question. If NUMCPUVPS is the number of CPU's, then it is possible that Informix could gain short term control of all CPU's, starving other processes (particularly OS) on the system. If you have 2-4 CPU's then …

NUMCPUVPS question

Doug Agnew

Simple question, but possibly an answer to our performance problems: What would be the possible effects of having NUMCPUVPS equal the number of physical CPUs in a database server?? I contend that this would cause the other oninit processes (the server side of the connected clie…

Question about IDS scalabiltiy

Carlson@WHSmith

NUMCPUVPS = (physical CPUs) - 1 Informix can utilize any number of CPUs that have been defined within the ONCONFIG file. John Carlson Informix DBA WHSmith USA Carlos Bolden wrote: > > What does ( how many processors ) can Informix ( IDS 7.3 ) scale to for > optimum processing.…

Memory Usage on Informix 7.24

LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…

Informix 7.3 on NT Slow when replication across WAN

Jason Chuang

Hi, I have recently setup a Informix Replication server from Informix 7.3 running on Solaris 2.6 to a new Single PII 450 processor box running NT SP3 (256 MB Mem). When replication starts the processor sits at 100% for up to 20 mins Even though There were only 3 entries in the t…

Re[2]: CPU or NET VP Class ??

Vandana R. Chadha

My problem is associated with this : When I use tlitcp for CPU VPs, then from my client machine, I can connect once to the database, and then if I try again, cannot connect. Hence I used shared memory for the NET VP and tcp for CPU VP. Which going by thi…

Re: CPU or NET VP Class ??

Lyzander Marantal wrote: > > In article <924603658.18749.1.nnrp-06.c2dec9bf@news.demon.co.uk>, > "Sean Kelsey" <seank@teepee.demon.co.uk> wrote: > > Good morning Informixers. > > > > So, okay, if we change the VP class to NET, will this not slow things down > > significantly fo…

Re: NET or CPU VP Class

Arun Shastry

Sean Kelsey wrote: > Good morning Informixers. > > We have been going through a series of conversations with Informix technical > support and I thought I would like to test all you DBA's out there as to > what the general consensus is regarding the VP class that the soctcp poll …

Re: CPU or NET VP Class ??

Lyzander Marantal

In article <924603658.18749.1.nnrp-06.c2dec9bf@news.demon.co.uk>, "Sean Kelsey" <seank@teepee.demon.co.uk> wrote: > Good morning Informixers. > > So, okay, if we change the VP class to NET, will this not slow things down > significantly for all user connections ? Can anyone poi…

CPU or NET VP Class ??

Sean Kelsey

Good morning Informixers. We have been going through a series of conversations with Informix technical support and I thought I would like to test all you DBA's out there as to what the general consensus is regarding the VP class that the soctcp poll thread should run on. We are…

NET or CPU VP Class

Sean Kelsey

Good morning Informixers. We have been going through a series of conversations with Informix technical support and I thought I would like to test all you DBA's out there as to what the general consensus is regarding the VP class that the soctcp poll thread should run on. We are…

HP, KAIO and statistics. What's wrong ?

Sadagopan, Sathish, CFCTR

Carlson@WHSmith wrote: > > It used to be a 1-to-1 relationship between CPU VPs and KAIO threads. > Could there be a slight change to the engine architecture to allow a fwe > 'extras' out there? I never fully understood why the 1-to-1 existed > anyway. Soneone posted a bug # thi…

RE: Processor affinity

Stephen Faehn

Yes, its possible to determine which physical CPU's the VP's run on. We are running Sun Solaris as our O/S and it looks like you might be also. Using the pbind command, I can list which physical CPU's process are bound to. Then, using onstat -g sch, get the pid's of the oninit pr…

Processor affinity

Hi, Is it possible to determine which physical CPU's the VP's run on. I have 6cpu vp's running on an 8 processor machine,with CPU vp affinity. The message log reads " Can't affinity VP 1 to phy proc 0 errno 4,Can't affinity VP 3 to phy proc 0 errno 62...." errno 2 is "interrupt…

Multiprocessor IDS on Linux?

Curt van den Heuvel

The release for IDS 7.30/Linux state that NUMCPUVPS is limited to 1 as the kernel does not support MP architecture. This seems to be contradicted by the Linux kernel notes, which state that Intel MP 1.1 and 1.4 are supported by Kernel 2.0.36. Does anyone know if a multiprocessor …

Re: VP & Actual CPU Usage

Sean Kelsey wrote: > > Informix DS 7.24.UC7 on HP 9000/899 servers running HP-UX 11.x > 6 physical CPUs > 5 configured CPU VP's > > Is there a way of determining exactly how busy a physical CPU is processing > CPU VP requests ?? > > The -g glo option gives me how busy the CPU VP'…

RE: NUMCPUVPS entry in onconfig.gic

Marichamy, Udaykumar

As per Informix documentation, on a 2 processor system, you may do a benchmark to determine whether NUMCPUVPS should be 1 or 2. "The number of CPU vps should match the number of physical CPUs on the server if MULTIPROCESSOR is set to "Y" and process affinitization is not used. I…

NUMCPUVPS entry in onconfig.gic

sampath aravamudhan

We are going to load Informix ODS 7.3 on DEC ALPHA 4000 Server with 2 processors. What should be the NUMCPUVPS entry in this case?. Informix recommends this value to be one less than the total no of processors. When we are running on a single processor machine, the entry is 1 in …

NUMCPUVPS entry in onconfig.gic

sampath aravamudhan

We are going to load Informix ODS 7.3 on DEC ALPHA 4000 Server with 2 processors. What should be the NUMCPUVPS entry in this case?. Informix recommends this value to be one less than the total no of processors. When we are running on a single processor machine, the entry is 1 in …

NUMCPUVPS > 0, AFFINITY not set

zandy@my-dejanews.com

Hi everyone, One of our servers here has NUMCPUVPS set to 2 but AFF_SPROC and AFF_NPROCS are set to 0 (zero). What do you think are the implications of this setting? Environment: Informix 7.12 UC3 Solaris 2.51 w/ 4 CPUS Thanks, Zandy -----------== Posted via Deja News, The D…

NUMCPUVPS on 4 CPU Sun Hardware

zandy@my-dejanews.com

Hi everyone! I was wondering how many CPU VPs to allocate on a 4 CPU Sun Hardware. I've read somewhere that some Operating Systems use a particular CPU for interrupts. Is Solaris such an OS? Anyway, my question is: Should I allot 3 or 4 CPU VPs? TIA, Zandy -----------== Pos…

Help needed: onsoctcp on Linux

Marc Mielke wrote: > > Hi, > > I do have problems getting Informix IDS to startup when > network connectivity related entries are present in 'sqlhosts'. > > Apreciating any help.. I believe that you need a NETTYPE entry specifying that CPU VP be used to listen to TCP connections…

Performance degraded after detaching indexes / fragmentation

Steven Hauser

Possibly you have hit the limits of your little SMP (4 CPU?). Or if you got them, jack NUMCPUVPS up and check the parallel processing parameters in the ONCONFIG. Time for more CPUs. Fragmentation splits up stuff so more parallelization can happen. but it won't happen if you do…

Re: checkpoint time > 15 sec.

In article <36963598.4B7D@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >may become a larger issue there also. Because of the algorithm that >selects LRUs it is certainly possible for all four CPU VPs to hash to >the same LRU on their first attempt causing 3 bufwaits…

Re: IDS & Workgroup Edition

Andrea

John H. Frantz wrote in message <366D3928.E7586C67@rl.is>... >I'm finding it hard to determine what the essential differences in >functionality are between plain IDS and the Workgroup Edition. I've >gathered the following information from various sources, but I'm not >sure if it'…

Informix Perf - NCR

Dave McNight

Using Online Dynamic Server 7.30 UC5 - we are trying to decide if the database server will perform better using 12 - 166 MHZ processors versus 16 - 90 MHZ processor boards on an NCR 3555 running MP-RAS 3.02 with 2 GB RAM. Does ODS perform better with more processors, howbeit slow…

Re: IDS Workgroup Edition

June Tong

David Williams wrote: > No fragmentation. No PDQ. can only be used on up to 2 CPUS > (or 4 RISC - may be the other way around). > > I think single CPU VP only as well...although the 2/4 bit above is > from the packaging and seems to contradict this?? No, it doesn't. Th…

RE: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'nam

Bernstein, Rick

My Informix On-line Dynamic Server (7.2) classroom material dated 01-97 states: "Only one protocol can run a poll thread on a CPU VP." Has this restriction been removed in IDS 7.3? -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, October…

Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?

> >From: dengelsen@my-dejanews.com > > > >Informix (7.23) produced the following error in the message Log File: > > > >CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads > started on > >NET VP's. > > > >What does this message mean? > >What must I do to solve it? It…

Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?

babak bayati

Hi Detmar, What's your plattform? --babak >From: dengelsen@my-dejanews.com >To: informix-list@iiug.org >Subject: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......? >Date: Mon, 26 Oct 1998 16:48:48 GMT >Reply-To: dengelsen@my-dejanews.com > >Hello, > >Informi…

Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?

dengelsen@my-dejanews.com

dengelsen@my-dejanews.com wrote: > > Hello, > > Informix (7.23) produced the following error in the message Log File: > > CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on > NET VP's. > > What does this message mean? You have requested that your poll th…

What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?

Hello, Informix (7.23) produced the following error in the message Log File: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on NET VP's. What does this message mean? What must I do to solve it? Thanks for the help Greetings, Ditmar den Engelsen --…

Re: about virtual processors

WF Software

> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …

Re: about virtual processors

Greg Moye

Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …

Re: about virtual processors

Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…

Re: about virtual processors

Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…

Re: about virtual processors

Bloomberg L.P

For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…

about virtual processors

Yan Zhu

hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…

IFMXCPUVPPRIORITY

Sadagopan, Sathish

Hi, What does this parameter 'IFMXCPUVPPRIORITY' do ? Sounds as though it sets a priority for the CPU vp's. Could someone explain in detail please. (ODS7.14 on NCR's MP-RAS) TIA Sathish Sadagopan…

I/O Q length

Sadagopan, Sathish

Hi, If the I/O queue length is large for a system using KAIO and all raw devices which parameters need examination ? ('-g ioq') - The CPU vp queues (for KAIO) are showing large 'maxlen' values. TIA Sathish Sadagopan…

Re: Dynamically adding shared memory segs

Carlson@WHSmith

Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …

Re: CPU vp total time

Normand Bedard wrote: > > Hi, > We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. > We have Informix 7.23 on Solaris 2.4. After running the command "onstat > -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run > the command again an…

CPU vp total time

Normand Bedard

Hi, We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. We have Informix 7.23 on Solaris 2.4. After running the command "onstat -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run the command again and get 161535.23. 161668.46 - 161535.23 =…

Re: NUMCPUVPs,ONINIT

In article <6nqntp$qad$1@news.xmission.com>, Sadagopan, Sathish <sadagop0458@att.com> writes > >Hi, >Two questions. >1) Values AFF_NPROCS,AFF_SPROC,NUMCPUVPS have been set to take >advantage of 6 cpu's.Now, when two of the cpu's are unavailable due to h/w >failure.What happens to…

NUMCPUVPs,ONINIT

Sadagopan, Sathish

Hi, Two questions. 1) Values AFF_NPROCS,AFF_SPROC,NUMCPUVPS have been set to take advantage of 6 cpu's.Now, when two of the cpu's are unavailable due to h/w failure.What happens to processor affinity ? "glo" option still shows 6cpu vp's running. 2) What are the activities that o…

Re: cpu and sessid

Zeljan Silje wrote: [SNIP] > At some moments system slow down significaly. I track it down with > iostat which shows no disk activities, but 90-95% user cpu time. I found > that this cpu time is consumed by oninit process. My question is: how > can I find sessid which is using mo…

Re: VIR Datablade configuration question

"Art S. Kagel" <kagel@bloomberg.net> offerred: +David Buttrick wrote: +> > I'd like to be able to have both: + +> > VPCLASS vir,num=1 and +> > SINGLE_CPU_VP 1 + +> > in the same onconfig file, but the server carps: +Single CPU VP means just that, but your datablade want…

Re: VIR Datablade configuration question

David Buttrick wrote: > > I should add that: > > IUS 9.13 under IRIX 6.4 on Origin 200/256MB RAM/4*4GB Disks > > > > > I'd like to be able to have both: > > VPCLASS vir,num=1 and > > SINGLE_CPU_VP 1 > > in the same onconfig file, but the server carps: > > cannot use …

Re: Virtual Processors

Jason Harris

I had the same problem. It happens with big queries and you cant stop it really. The VP usually uses what it needs. The best option is to turn NOAGE off, so that the processes age and allow the OS some use of the CPU. Rgds, Jason On Mon, 08 Jun 1998 11:46:55 GMT, darren@syste…

RE: Virtual Processors

mosserp@wellsfargo.com

Darren, You might check your NOAGE and AFF_SPROC / AFF_NPROCS settings, and then see what your release notes say about those parameters. If this is just occurring when you run specific programs, what is the PDQ_PRIORITY that you are using when you run them? HTH. Paul Mosser O…

Re: Virtual Processors

Arun Shastry

You need to send us some more info. Is this a SMP box? How many CPU's? What applications are causing the problem? CPU bound Informix engine is not necessarily a bad thing, but if the entire system is slowing down then you need to tune a few things. What to tune depends on wha…

Re: Virtual Processors

Joe Lumbley

darren@systeam.co.uk wrote: : I have a problem with a customer's site with a CPU virtual processor which : seems to be running out of control. It occours when I run one or two : programs, the CPU VP is taking about 90% of the system CPU time, and therefore : bring the system to a…

Virtual Processors

darren@systeam.co.uk

I have a problem with a customer's site with a CPU virtual processor which seems to be running out of control. It occours when I run one or two programs, the CPU VP is taking about 90% of the system CPU time, and therefore bring the system to a general go slow. The Informix engi…

Re: Novice needs tuning help!

Also sprach David Williams <djw@smooth1.demon.co.uk> : : Is this a single cpu machine? How fast is the cpu? : Also if NUMCPUVPS=1 set SINGLE_CPU_VP to 1. : :NOAGE 0 # Process aging : : Try setting this to 1 : :AFF_SPROC 0 # Affinity …

Re: AIO virtual processor

Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …

AIO virtual processor

dwillem@ibm.net

Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …

Re: slow performance

Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …

Re: Read Cache, NUMCPUVPS

Mickey Mestel

jeff, : Can someone explain what happened here? Are the numbers : "rolling over"? yup. it rolled over. no problems. do an onstat -z to zero out the profiles if you don't want to look at those negative numbers. it would be nice if this was fixed, as there is no reason that…

Re: NUMCPUVPS settings for a four-processor server

Bill Border wrote: + We have found that in the case of systems with very fast CPU's that + there are times that you need to set NUMCPUVPS to more than the number + of physical CPU's. We have a T600 with 10 CPU's where we configure + 15 CPU VP's and we still cannot drive the al…

Re: Read Cache, NUMCPUVPS

In article <6cunjh$ird$1@nnrp1.dejanews.com>, jeff.w.mcclure@ameritech.com writes >Hi, > >I'm relatively new to Informix and have two >questions that I need answers to. > >Sparc 20 running Solaris 2.4 >Informix ODS 7.11.UC1 > >First: >I checked the instance profile last night (on…

Re: Read Cache, NUMCPUVPS

jeff.w.mcclure@ameritech.com wrote: > > Hi, > [cutting] > > Second: > Since this is a development machine, we decided to bounce > the instance. Great! I wanted to check out the effects > of adding a second cpu vp. This is a multiprocessor (2) > machine! I set NUMCPUVPS to 2, M…

Re: Read Cache, NUMCPUVPS

jeff.w.mcclure@ameritech.com

jeff.w.mcclure@ameritech.com wrote: > > Hi, > > I'm relatively new to Informix and have two > questions that I need answers to. > > Sparc 20 running Solaris 2.4 > Informix ODS 7.11.UC1 > > First: > I checked the instance profile last night (onstat -p) > and all looked great. dsk…

Read Cache, NUMCPUVPS

Hi, I'm relatively new to Informix and have two questions that I need answers to. Sparc 20 running Solaris 2.4 Informix ODS 7.11.UC1 First: I checked the instance profile last night (onstat -p) and all looked great. dskreads, pagreads were both very low, Buffreads was very hi…

Re: NUMCPUVPS settings for a four-processor server

In article <6ck1q1$p40@drn.newsguy.com>, Neil Truby <?@?.?> writes >I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes >of memory and 4CPUs. One server is heavily-used and performance is optimal, the >other is lightly used. > >I am planning to set u…

Re: NUMCPUVPS settings for a four-processor server

Bill Border

We have found that in the case of systems with very fast CPU's that there are times that you need to set NUMCPUVPS to more than the number of physical CPU's. We have a T600 with 10 CPU's where we configure 15 CPU VP's and we still cannot drive the all CPU's to 100% busy. Whe…

Re: NUMCPUVPS settings for a four-processor server

Michael Segel

Gee, This goes back to what I was saying. When tuning a system, you shouldn't rely on the number of CPUs a system has. It doesn't matter. You have one proc stack, and one memory pool. -Mikey Bill Border wrote: > > We have found that in the case of systems with very fast CPU'…

NUMCPUVPS settings for a four-processor server

Neil

I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes of memory and 4CPUs. One server is heavily-used and performance is optimal, the other is lightly used. I am planning to set up the heavily-used server with NUMCPUVPS=3 (one less than the actual num…

waiting for SEM

Deepa Sankaranarayan

Hi I am running oncheck -cD and cI on my sap dbs and they take ages to complete. Its a 2 cpu box and I've configured Informix for 2 cpus. (NUMCPUVPS, MULTIPROCESSOR). glanceplus shows that the process is waiting for SEM. What needs to be changed? TIA Deepa…

Re: NUMCPUVPs and number of physicial processors

sujata_soman_at_omm-la2-infotech-001@internet.omm.com

In article <19980110014000.UAA07693@ladder02.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >conflicts occuring at the OS level. By increasing the number of CPUVPS, there >is a higher probability that the CPUVP process will go into a block state and >raise it's priority. Thi…

Re: NUMCPUVPs and number of physicial processors

SaTriGuy

> > We are migrating our Informix 7.23 systems from a SUN 2000 with >14 processors (88 Mhz) to a SUN 6000 with 10 processors (250 Mhz). In >our current configuration, we have : > >NUMCPUVPS = 12 >CLEANERS = 12 >LRUS = 12 > > We do not use processor affinity. > > The system is pr…

Re: NUMCPUVPs and number of physicial processors

Greg Moye

Well, keep in mind Informix can't burn 10 CPU's worth of cycles unless it has 10 CPUVP's. Heck, consider the extreme case of a Sun E10000 domain, that you might dynamically add or remove CPU's from. I'd probably set CPUVP's to the most I thought that domain would ever see. If …

Re: NUMCPUVPs and number of physicial processors

Dave Otto

On the Sun architecture, it is generally a good idea to have the CPUVPs <= CPUs. Informix recommends that you use a number that is a multiple (or factor) of the number of DBspaces. -d "May, James" wrote in message <695pub$rui@cssun.mathcs.emory.edu>... >Gurus, > > We are migra…

NUMCPUVPs and number of physicial processors

"May, James"

Gurus, We are migrating our Informix 7.23 systems from a SUN 2000 with 14 processors (88 Mhz) to a SUN 6000 with 10 processors (250 Mhz). In our current configuration, we have : NUMCPUVPS = 12 CLEANERS = 12 LRUS = 12 We do not use processor affinity. The system is primari…

Re: Serious problem with dbimport

Felix Koshy Mathews

Barry Leb wrote: > <snip> > memory and 2 cpus. The OS is HPUX 9.04. The disks are the HP versions <snip> Hi-Barry, If your machine have only 2 cpus and you have NUMCPUVPS set to 2, then your performance could be affected. That could be the reason why your dbimport is taking…

Re: Questions on INFORMIX 7.13 and CPU VPs

Ernesto Hern�ndez-Novich

sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > 1. Is it true that we can configure only one NETTYPE connection on the > CPU VP ? Currently, both my NETTYPE connections ( SOC and SHM ) are > configured on CPU VPs. If my assumption is true, does INFOR…

Questions on INFORMIX 7.13 and CPU VPs

Hi everybody, Some more questions for everybody. Feel free to answer . I have a lot of questions on CPU VPs and performance. Here goes: some background info: OS -AIX 4.1 Informix : 7.13 UC1 Number of CPUs - 8 1. Is it true that we can co…

Re: gfd virtual processor class...

June - sounds reasonable, thanks. I'll have to count tomorrow & see if they jive. Greg (from my alter ego at home...) June Tong wrote: > > : I was looking through the output of "onstat -g ioq", and it occurs to me > : I don't have a clue what VP type "gfd" is (see snippet belo…

Re: Cannot fork a virtual processor

Mark D. Stock wrote: > > Enigma wrote: > > > > Hi, > > My informix ODS went down when I tried to put it to online. I'm > > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > > online.log is > > Cannot fork a virtual processor errno=12. > > This hap…

Re: Cannot fork a virtual processor

Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…

Re: gfd virtual processor class...

June Tong

: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…

Cannot fork a virtual processor

Enigma

Hi, My informix ODS went down when I tried to put it to online. I'm running a informix 7.14 on a IBM AIX 4.2 machine. The error in the online.log is Cannot fork a virtual processor errno=12. This happens only intermittently. It seems to indicate there is insuffici…

Re: Cannot fork a virtual processor

Mike Segel

Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…

gfd virtual processor class...

Greg Moye

I was looking through the output of "onstat -g ioq", and it occurs to me I don't have a clue what VP type "gfd" is (see snippet below). Can anybody clue me in?? plsaphp1:informix 1> onstat -g ioq INFORMIX-OnLine Version 7.21.UD3 -- On-Line -- Up 26 days 06:59:37 -- 175552 K…

Re: Informix crashing UNIX on HP

Jeff Kalchik

On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" <mdstock@informix.com> wrote: >Silvester_Valiente@tnt.com.au wrote: >> >> Has anyone had an experience where Informix 7.23 UC4 caused Unix to >> Panic and shutdown. >> >> We are experiencing the problem when the virtual portion…

HOWTO:Calc. a user-fee for cpu vp cpu-time

Heckers

I have to monitor the system performance and turned on the 'acct'-system to see who is using all the cpu-time. It is the cpu-vp that uses most of the cpu-time. Is there a way to find out how much cpu-time a session (user) needed? I took a look at the administrator guide and the …

HPUX 10.20-7.22 Restore problems

SailF3

We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…

Re: NUMCPUVPS and Fragments

Since one scan thread tends to be associated with one fragment, I would (for maximum performance anyway) go with lots of fragments, and let the thread dispatching algorithm sort 'em out. If the threads aren't there, the work can't get done, so load em up I say... Remember, you…

NUMCPUVPS and Fragments

Paul Drake

On page 2-11 of the Informix Performance Guide Manual (Ver. 7.2), it states that "queries perform best when the number of scan threads is a multiple (or factor) of the number of CPU VPs". It then gives the example of having 6 CPU VPs, and a table with 10 fragments, and suggestin…

Re: Informix 5 Performance Issues

"Billy Wheeler"

Remember - YMMV, etc: On 16 Apr 97 at 17:04, Phantom173 wrote: > We have been told by a consultant that a move to Informix 7 would > benefit us because (a) Informix 7 would reduce the number of connects > (and therefore processes) associated with the elephants, and (b) it > wou…

Re: Informix performance on 1, 2 or 4 processors??

"Ron M. Flannery"

At 12:54 AM 4/13/97 GMT, Irwin Goldstein wrote: }Kerry Lyall <kalyall@concentric.net> wrote in article }<5im68n$spr@chronicle.concentric.net>... }> Please Help! I am getting conflicting answers. }> }> HP and Informix say performance on 2 processors (1 for OS & 1 for DB) }> is f…

Re: Tuning CPUVPS/AIOVPS

In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…

Re: NUMCPUVPS

Barry Leb

Edward Bidinotto <edbid@cobe.com> wrote: >I've been getting some wierd errors when running oncheck -cI against a >17mil row table. >I've dropped, recreated the table/indexes but continue to get the >following errors. >"could not check rowids and perform data <=> index check >"…

Re: NUMCPUVPS

Ed - I'm not intimately familiar with HP, but both your engine and OS release sound pretty old. I'd get as current as possible first, then pursue the problems. At that point, you should be able to run with NUMCPUVPS = physical processors. If you can't its a bug - beat on Info…

NUMCPUVPS

Edward Bidinotto

I've been getting some wierd errors when running oncheck -cI against a 17mil row table. I've dropped, recreated the table/indexes but continue to get the following errors. "could not check rowids and perform data <=> index check "unknown error message 0" We are running 7.11uc1…

Re: Performance / Internal Q's -- Online 7.2

This is a multi-part message in MIME format. --------------24681CC654CE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit jimlenahan@aol.com wrote: > > I have a 4way HP Kclass machine as server connected to a pair of HP > G class machines. On th…

Re: Performance / Internal Q's -- Online 7.2

Sergei V. Melihov

Hello, jimlenahan@aol.com wrote: > > Greetings: > > A few questions on performance and internals on this beast: > I never have had a possibility to run such a big system, sorry. But: > I have a 4way HP Kclass machine as server connected to a pair of HP > G class mac…

Performance / Internal Q's -- Online 7.2

jimlenahan@aol.com

Greetings: A few questions on performance and internals on this beast: I have a 4way HP Kclass machine as server connected to a pair of HP G class machines. On the G's are up to 500 users. The K server is configured with 4 net VP's with 250 threads each. However, …

Re: MULTIPROCESSOR OPTION 7.13

Srirama Sundararajan Rajagopalan

In article <327fa20d.27552573@news.netline.net>, Allen Jantzen <allenj@ndr.com> writes >The Informix DSA Administrators Guide, version 7.1, page 10-18 says > >"On some two-processor computers, you should only run one CPU virtual >processor because the overhead of synchronizing th…

Re: MULTIPROCESSOR OPTION 7.13

Paulo Nunes

In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…

Re: MULTIPROCESSOR OPTION 7.13

Tracy Nedd

Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…

MULTIPROCESSOR OPTION 7.13

Allen Jantzen

The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…

Re: Query Retrieval

Nils Myklebust

Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…

Query Retrieval

Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…

Re: multithread in INFORMIX, how?

Chao Y. Din

Saeed Talebbeik wrote: > > I have heard repeatedly that on machines with two CPU's The performance > actually degrades if you have 2 or more cpu VP's. So you are o.k with > one CPU vp running and setting MULTIPROCESSOR parameter to false. > We have completely different experienc…

Re: 2 CPU VP's

Mark D Stock

Juan R. Guzman wrote: > With only 2 cpu's you should set you setting for multprocessor to 0 (single cpu). > Informix recommends to only set this to 1 if you have a minimum of 4. This IS the recommendation, but as I said in a recent post, some platforms perform well with the numb…

Re: 2 CPU VP's

Go for it. We do it on a 2 CPU Sparc 1000 w/ 2 CPU's and it works a lot better than with one CPUVP. You're the perfect candidate for this since there's nothing else going on, still, with only one CPUVP, only one Physical processor can be doing the heavy work. I don't know abou…

Re: 2 CPU VP's

Juan R. Guzman

Chao Y. Din wrote: > > Juan R. Guzman wrote: > > > > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > > been thinking of incrementing the amount of CPU VP's from one to two. I don't > > use the server for anything else other that for the Informi…

Re: 2 CPU VP's

Chao Y. Din

Mark D Stock wrote: > > Juan R. Guzman wrote: > > With only 2 cpu's you should set you setting for multprocessor to 0 (single cpu). > > Informix recommends to only set this to 1 if you have a minimum of 4. > > This IS the recommendation, but as I said in a recent post, some platf…

Re: 2 CPU VP's

Chao Y. Din

Juan R. Guzman wrote: > > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > been thinking of incrementing the amount of CPU VP's from one to two. I don't > use the server for anything else other that for the Informix application. Any > feedback…

Re: 2 CPU VP's

Mark D Stock

Juan R. Guzman wrote: > > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > been thinking of incrementing the amount of CPU VP's from one to two. I don't > use the server for anything else other that for the Informix application. Any > feedback…

Re: 2 CPU VP's

In article <31E262D8.20DC@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have >been thinking of incrementing the amount of CPU VP's from one to two. I don't >use the server for anything els…

Re: 2 CPU VP's

Alexander J. Oss

Juan R. Guzman wrote: > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > been thinking of incrementing the amount of CPU VP's from one to two. I don't > use the server for anything else other that for the Informix application. Any > feedback f…

2 CPU VP's

Juan R. Guzman

I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have been thinking of incrementing the amount of CPU VP's from one to two. I don't use the server for anything else other that for the Informix application. Any feedback from who has played with this b…

lastest compare against oracle

frank zimmermann

can anyone provide some new information on the rdbms wars between informix and oracle. I know oracle blasts informix for the poor performance, transaction logging, record locking mechanisms and informix touts the performance gains on the methodology for using threads instead of p…

HP K200 and Online 7

Jose da Fonseca

We are experiencing SEVERE performance problems trying to upgrade from Online 5 to Online 7. Online 7 runs about 400 percent slower than Online 5 up until +- 400 processes. (Confirmed by Informix S.A). Online 7 performance never degraded even when the load went above 400 process…

Re: unexpected virtual processor termination

Cheryl Kendricks

This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…

Re: unexpected virtual processor termination

Cheryl Kendricks

Sounds like someone issued a Kill -9, while it was holding locks? Anyway I suggest you turn on your montoring program/script (if you do not have one, I got one to watch engine and another one to watch user's) and see what processes are actually occuring at that time. If you want …

unexpected virtual processor termination

SauliusRaudys

We use Online 7.11 on IBM RS6000 AIX 4.xx (32 MB RAM) for development tasks. Often, while 4GL program is being compiled, Online shuts down. In online.log file one writes: "unexpected virtual processor termination, attempting to bring system down". This virtual processor is msc. …

Re: Controlling those Nasty CPU VP's

Bob Thompson

Mike - It looks like you'll have to look elsewhere for the answer if you want to win that lunch :-) - Bob -…

Re: Controlling those Nasty CPU VP's

Bob Thompson

Mike - You got no replies yet. You might have to look elsewhere for the info you need to win that free lunch :-) - Bob -…

Controlling those Nasty CPU VP's

Mike Di Pietro

Platform=HP-UX 9.01 Informix 7.11 UC1 How can you control a session thread in a CPU VP from monopolizing the system CPU? We had a single thread take about 90% of the CPU while performing an update.…

How many instances .... ?

Anjan Chakraborty

What might happen regarding performance degradation suppose if I have a 6 CPU machine with sufficient memory and running 4 Informix7.1 instances configured as follows: instance_one : 1 CPU VP instance_two : 1 CPU VP instance_three : 3 CPU VP instance_four : 5 CPU VP ? …

How many Instances .... ?

Anjan Chakraborty

What might happen regarding performance degradation suppose if I have a 6 CPU machine with sufficient memory and running 4 Informix7.1 instances configured as follows: instance_one : 1 CPU VP instance_two : 1 CPUVP instance_three : 3 CPU VP instance_four : 5 CPU VP ? E…

<No Subject Supplied>

>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …

How do I .... ?

Anjan Chakraborty

I am getting very high chunk writes and almost 0 LRU writes against onstat -F and high duration against onstat -m. How do I solve this problem ? I have CKPTINTVAL=300,NUMAIOVPS=20,CLEANERS=6,LRU_MAX_WRITE=20, LRU_MIN_WRITE=10,LRUS=8,BUFFERS=60000,PHYSFILE=60000, MULTIPROCESSOR=1…

Re: processes sspawned by 7.1

Dority

>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…

Re: processes sspawned by 7.1

Billski

Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …

Re: Informix dual processor scalability

Sally Woolrich

In article <DJ6CHK.5zx@dsbc.icl.co.uk> smb@oasis.icl.co.uk "Stuart Britt" writes: > Using Informix on 1 processor we achieve good performance. If we switch to > 2 processors, then our performance actually degrades. We have been given > some advice on tuning the system for dual…

Re: Informix dual processor scalability

Billy Wheeler

According to my rusty memory, the reason for this is something about the overhead necessary to handle multiple processors only being overwhelmed by the performance increase after three processors. So you should tune as tho' you only have a single processor... :-( HTH. }Does any…

Re: Informix dual processor scalability