Oninit® Archive
Results for “SINGLE_CPU_VP”
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
thread soctcplst in ready state
Original post: Hi, Environment: Informix 11.70.FC8W1 HP-UX 11.31 Today a large number of errors -25582 and -27001 have been reported on one of our instances. In the online log: listener-thread: err = -25582: oserr = 0: errstr = from <host.domain> to server <informixserver> :…
12.10.xC12
Ben: That CPU VP license metric is currently ONLY available from HCL on a subscription basis (so pay monthly or annually but don't actually own the software), not from IBM.…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Threat : swth:sbt_subclass_lpgsrc_ol_796
Platform : AIX 7 Informix version: 11.70.FC7W3XC Config : 1 primary, 1 secondary and 4 RSS Note : We do turn on the large page on AIX level I run onstat -g rea -r 1 and occasionally see the threat name swth:sbt_subclass_lpgsrc_ol_796 Questions: 1) What is this thread and the p…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Hyper threading
Art I'm interested in your comments "You need about 500MHZ of cpu cycles per CPU VP so for a 4GHZ processor you should be able to run 6-8 CPU VPs per core with positive performance gains from the 6th, 7th, & 8th VP. " My simple understanding, based on documentation is "On sys…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
memory thread ... VIP status ?
memory. see below. Ready threads: tid tcb rstcb prty status vp-class name 137 7000001c4ded0f0 7000001c1feffe8 3 ready 12cpu* memory 232 7000001c8ac2028 7000001c8484b70 1 ready 24cpu sqlexec 237 7000001c8c935a0 7000001c8487488 1 ready 14cpu sqlexec 241 7000001c8e0a620 7000001c84…
11.5FC7WE x PROCS AFFINITY
Here is it, Art MULTIPROCESSOR 1VPCLASS cpu,num=3,noageVP_MEMORY_CACHE_KB 0SINGLE_CPU_VP 0 > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: 11.5FC7WE x PROCS AFFINITY [34716] > Date: Wed, 25 Feb 2015 11:40:50 -0500 > > Post the VPCLASS cpu entry from your ONCONFIG f…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
onstat -g ath
In the vp-class column of onstat -g ath output, some of the entries has an asterisk appended (i.e. 1cpu*). What does that signify?…
The server did not respond within 5 seconds
We have 16 CPU VP's…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
a problem with backup a logical logs
Hello, Yesterday I have a problem with the backup the logical logs and I attached the information that I got from Informix: Can anyone help me to find the problem in order to void this in the future? Any help will be welcome Regards Muthana Here is the information I get from …
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Efficiency of the Informix Virtual Processors
Dear All, IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix) No other instance running on this machine. I was reading a post by john on http://www.jfmiii.com/informix/?p=194 It say that if the efficiency drops below 80% (onstat -g glo output) then there seems to …
sysadmin setup incomplete in IDS 11.5 Windows XP
This is the output of onstat -g ath onstat -g ath | grep dbScheduler gives no output IBM Informix Dynamic Server Version 11.50.TC9DE -- On-Line -- Up 00:42:22 -- 78208 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 103da970 0 1 IO Idle 3lio* lio vp 0 3 103f4210 0 1 …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
drop CPU VPs....
Hi Martin, Few minutes after post this email here, I discovery exactly what you said, I just check which is the last CPU VP with "onstat -g glo" , use the "onstat -g cpu" to found all sessions what running more over it and killed only this session with more cpu utilization.. then…
VPCLASS cpu on sun/oracle M4000 machine
Hello, I have an IDS 11.50.FC6 instance on an M4000 oracle server with 4 CPUs with 4 cores * 2 threads each. The OS (Solaris 10) 'sees' a total of 32 CPUs. The thing is, I'm trying to tune the cpu VPCLASS onconfig parameter so that this instance is able to use more CPU power, but…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
SINGLE_CPU_VP config query
HPUX HP-UX wuasp132 B.11.23 IBM Informix Dynamic Server Version 11.50.FC6 I am curiuos why the following recommendation would be made to set following option to 1 cpu vp. Epecially if running on multi cpu system Is there less overhead with it being set to 0 ? SINGLE_CPU_VP - Opt…
Fatal error in ADM VP at mt.c
I've the following messages in online.log of an 9.40.FC9 informix dataserver : 17:52:55 Fatal error in ADM VP at mt.c:12703 17:52:55 Unexpected virtual processor termination, pid = 1466506, exit = 0x90009 17:52:55 invoke_alarm(): /bin/sh -c '/bases/informix/pcampcam/admin/ontap…
VPCLASS parameter
Hello, you could get those information from the Information Center page: http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.adref.doc/id s_adr_0189.htm?resultof=%22%56%50%43%4c%41%53%53%22%20%22%76%70%63%6c%61%73%73%2 2%20 Best regards. Em 12/01/2011 10:47, TR…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Re: Configuration changes for additional processors
Nope, you've got it nailed. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any o…
Connections blocked - Connect Timeout Expired
Correction (zero NET VPS after changing VPCLASS to cpu); With; NETTYPE soctcp,7,350,NET VPCLASS net,num=7,noage Results in; 7 Network VP, and 1 CPU VP. With; NETTYPE soctcp,7,350,NET VPCLASS cpu,num=7,noage Results in; 0 Network VP and 7 CPU VP!…
Re: NET or CPU VP and how many?
On 28 Apr, 21:09, Frank Langelage <fr...@lafr.de> wrote: > IBM recommends to use NET VPs for onsoctcp/ontlitcp and CPU VPs for > onipcshm. So does Art. > But what about onipcstr on Unix? > > The recommendation is not platform specific, so the use of NET VPs for > network connecti…
NET or CPU VP and how many?
IBM recommends to use NET VPs for onsoctcp/ontlitcp and CPU VPs for onipcshm. So does Art. But what about onipcstr on Unix? The recommendation is not platform specific, so the use of NET VPs for network connections is probably true for Unix and Windows. What about onipcnmp on Wi…
Slow responses from remote application server
On 28.04.10 07:19, PAUL RIDDING wrote: > Hoping somebody might have some ideas regarding some response issues we are > having. Let me set the scene. > > Database (IDS10) running on a Sun Sparc M5000 server with 8 Quad Core CPUs and > 32G of memory. > > Approx 2000 concurrent sess…
why so many informix threads on idle systems ?
here is the onstat -g ath BM Informix Dynamic Server Version 11.10.FC3 -- On-Line -- Up 01:09:50 -- 123912 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 c0000000ae5ca9a8 0 1 IO Idle 3lio* lio vp 0 3 c0000000ae5ebc88 0 1 IO Idle 4pio* pio vp 0 4 c0000000ae60d450 0 1 …
Initialization of Java virtual processor failed
when trying to install a java udr i'm getting the following nessage: 9444: Initialization of Java virtual processor failed: (cannot create gc file) Can anyone help? Here is the statment: execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar", "env_…
error 25588 app. process can't connect server
Thank you Mr. S. Kagel, your opinions are helpful and I will try it out. By the way, may I know is the number of NET VP depending on parameter in NUMCPUVPS? For example: "NUMCPUVPS=1" means up to 1 CPU VP is supported, can I have additional NETTYPE with 1 or more NET VP? If yes…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor 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, it looks like only one is really taxed: ps -ef |grep oninit hd…
session versus VP
Hello, On Informix 10.00 FC6 I have a cpu VP among 3 which is overloaded. I would like to know which session(s) are using the cpu in this VP. Any tricks ? Many thanks for your advices. Bernard Caillet…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
Long Spins
Hi, The IBM IDS document says: "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." But wait for other to advice you, I'm sure the IDS guru's will suggest you a so…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
IDS 7.31 Solaris8 - Long Checkpoints
More LRUS (suggest 128) more CLEANERS (also 128) and lower LRI_MIN/MAX_DIRTY values (suggest 2/1 instead of 5/2). Another option: Upgrade to IDS 11.50 which finally has non-blocking checkpoints and autonomic checkpoint tuning. Art On Mon, Mar 16, 2009 at 11:26 AM, KURT VAN GOM…
Re: MSC virtual-processor class too loaded aft....
Hi, first of all, thank you very much John and Jacques for your answers. The IDS engine allocated another vp msc (I supose due to the high load of the first one). I have tried without success (at the moment) to catch operations that msc vp is doing with the following command: …
MSC virtual-processor class too loaded after migra
Hi, After migration our DWH from IDS 10FC9 to IDS 11.5FC3 (Under SLES 10 SP2) I found that msc vp class (Miscelaneous System Call) are too loaded, as you can see in the following onstats: Can anybody tell me the reason, or can point me to the correct documentation to understand…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
Re: IDS 11.5 licence question: virtual versus physical processors ?
Martin Thole wrote: > 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 neces…
Re: IDS 11.5 licence question: virtual versus physical processors ?
"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 ?
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
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…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Hardware advice please
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
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
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.
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…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: CPU VP Issue
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
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
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
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
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
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…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
IDS 10.0
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
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.
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
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…
Re: Cpu vp usage
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
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
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 …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS on Solaris(spark server)Multiprocessor Setup
On 10/04/07, OMER KHAN <oskhan@i2cinc.com> wrote: > Hello All, > > I want to set up IDS 10.0(FC4)instance on Sun Spark server, which has one 24 > core processor. So i am not sure how should i give the multiprocessor settings > in the onconfig files parameters related to that inst…
Re: TCP Listeners: Preferences?
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…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
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
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
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…
Re: oninit startup failure
MFLD wrote: > In response to Guy, > > Some asked details about my case: > > Is this the first time you've tried initializing after installation or > is this an existing instance which has just stopped working? > ---> It is the first time I initialize the server > > How much physi…
VP error
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…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
cpu-vps and number of physical cpus
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,…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
RE: IDS 10.0 performance on RedHat
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)
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…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
CPU VP
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…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
HP-UX KAIOON
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…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: cannot start with 4 AIO virtual processor
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
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
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
>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…
MULTIPROCESSOR settings on a multiple CPU server with
Is it a must to set MULTIPROCESSOR to 1 on a multiple CPU server even if you only using 1 CPUVP and SINGLE_CPU_VP is set to 1? Some posts on c.d.i say yes, some say no and the IDS docs do not give a concrete answer. Also, it has been said that when configuring ipcshm poll threa…
Re: sqlj.install problem
Hello Guy, I have been set the SINGLE_CPU_VP 0 and VPCLASS jvp,num=1. the context switch error have been solve. Now I am finding a new error. The code is;- execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/JDBC.jar", "jdbc_jar", 0); The error is: I…
Re: sqlj.install problem
>>You could try two things. >> >>1. Make sure SINGLE_CPU_VP is set to 0 in the onconfig file. >>2. Try changing the VPCLASS parameter to: VPCLASS jvp,num=1 > I could not find the vpclass parameter error. I don't understand your answer. Did you check the SINGLE_CPU_VP oncon…
Re: sqlj.install problem
Maroon, You could try two things. 1. Make sure SINGLE_CPU_VP is set to 0 in the onconfig file. 2. Try changing the VPCLASS parameter to: VPCLASS jvp,num=1 After checking 1. and changing 2. restart IDS and try again. If still no luck, try the examples in %INFORMIXDIR%\\extend\…
FW: Informix versus Oracle Spatial
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…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Crash of the instance
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
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…
Re: Strange Lockups on IDS 7.31.UD8
The "I/O bad request chunk 4095" message could be due to a corrupted index pointing to a nonexistent chunk. In any case, if oncheck -cDI confirms a bad index, drop and recreate the index. "Anthony" <anthony@zoraptera.com> wrote in message news:1124228243.115539.65000@g47g2000cwa…
Re: Strange Lockups on IDS 7.31.UD8
in a 'normal' running env you should not get index corruption followed by an engine crash..... Sounds like you are hitting a bug or may have hardware problems what is in /db0/tmp/af.482edd9 i guess a pagedump.... I/O bad request chunk 4095 -->> max chunks is 2048.... so either…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
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…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
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
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
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…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Single cpu vp woe
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
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
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
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…
CPU utilization
Steven Weiss wrote: > Hi, > > We've got a W2000 machine running IDS 9.4 with 2 CPUs and the following > ONCONFIG settings: > > MULTIPROCESSOR 0 > NUMCPUVPS 1 > SINGLE_CPU_VP 0 > > if any query is run with no-one else using the machine and you use task > manager to view …
CPU Binding
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…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Config for new live system
"Davorin Kremenjas" <davorin.kremenjas@inet.hr> wrote in message news:cie5jj$8lk$1@bagan.srce.hr... > I suppose I won't be much of a help but I'll try... > > > ROOTOFFSET 0 # Offset of root dbspace into device > > We had problems on Solaris 9 with zero offset. …
How many physical processors we need to support 32K THREADS in IDS.
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…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: DB Server Alias
abanero@supereva.it (Abanero) wrote in message news:<ad9fb198.0405270320.7bc98fd5@posting.google.com>... > Hi All, > > I have the following issue: > > I need to connect the same instance through 2 IP addresses, i read in > this newsgroup that there is a variable in ONCONFIG file …
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!
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
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
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…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
oninit process
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
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
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
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: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
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: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Affinity in IDS 2000 under Windows Server 2000
Please, I need some help about an issue: I have a machine with 2 processors and a IDS 2000 installed on it. But I need to share the processing of Informix over 2 processors. But all the time that I change the MULTIPROCESSOR, NUMCPUVPS, SINGLE_CPU_VP, NOAGE, AFF_SPROC, AFF_NPROC…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Reduce # of CPU: license cost
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Unexpected virtual processor termination
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…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Engine's re-setting
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: VPCLASS 'cpu' not enough physical procs for affinity
"kh teoh" <khteoh2001@yahoo.com> wrote: > I'm running IDS 9.30.UC2 on Redhat 7.1 in HP Netserver LXr8500 PIII > Xeon-700. The server has 4 processors. In my onconfig file I've the > following settings :- > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for > multi-…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
VPCLASS 'cpu' not enough physical procs for affinity
khteoh2001@yahoo.com (kh teoh) writes: > I'm running IDS 9.30.UC2 on Redhat 7.1 in HP Netserver LXr8500 PIII > Xeon-700. The server has 4 processors. In my onconfig file I've the > following settings :- > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for > multi-…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Informix under Linux - real crap !
> Please take a look to the article below how to install 9.40 on different > Linux distributions. As far as I know KAIO is not available in the official > sources of Linux 2.4.x kernels. But configuring multiprocessor in $ONCONFIG KAIO Patches are available since RedHat 7.1/7…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
NUMCPUVPS on a box having multiple Informix Instances
It depends ... How busy will each of the instances be? Will the instances be busy at the same times? What is the CPU speed of the processors? On some of the faster CPU's, you can actually get increased performance by having more that one CPU VP per hardware CPU. "Chavan" <ch…
cpu time
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…
Shared mem connections and semaphores
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…
Re: onconfig.ows - MULTIPROCESSOR
Setting it to 0 can improve overall system performance as then when a VP encounters a latched resource it will suspend the current thread and wait for it to be cleared. With MULTIPROCESSOR on the VP will spin for a while before suspending on the assumption that the latch may belo…
balancing virtual processors
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
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
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
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?
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
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
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 …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Assert Failed: Unexpected virtual processor termination, pid
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
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
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…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
server 2000, cpu affinity problem
Hello, I installed Informix Dynamic Server 2000 in Red Hat 6.2 4 cpu intel server, after oninit , I inspected /usr/informix/etc/online.log found there are error message for cpu affinity the message is 11:14:11 On-Line Mode 11:14:11 VPCLASS 'cpu'…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Several instances of IDS 7.3X
Ty O'Kelly wrote: > > What role (if any) do parameters concerning multi-processor systems play in > multiple residency? If both onconfig files contain the following values (for a > dual processor system) will there be any kind of contention between the two > instances? > > MULTI…
SINGLE_CPU_VP
Hi, We have a SMP machine with linux Suse 6.4 kernel 2.2.14. Does SINGLE_CPU_VP must be 0 or 1 ? What is the meaning of this variable ? Thank in advance.…
Re: Performance goes down - help please!
I also just noticed that you have NOAGE set to zero (0) which is a real NO-NO on Solaris which is very aggressive about aging long running processes. Set NOAGE 1. Also suggesting: RESIDENT -1 (or 1) LBU_PRESERVE 1 Art S. Kagel Serge Moisseyev wrote: [SNIP] > RESIDENT …
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: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
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
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…
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 …
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Performance Issues
From: "Kirk Davis" <kirk@kirkdavis.co.uk> > >As my earlier post, we have just upgraded our Informix Dynamic Server 7.3 >hardware to a 4 * 550mhz Xeon with 1024mb RAM.. The platform was previously >a single 200mhz >Pentium wth 256mb RAM. > >As suggested, I have set the following t…
Performance Issues
Kirk Davis wrote: > > As my earlier post, we have just upgraded our Informix Dynamic Server 7.3 > hardware to a 4 * 550mhz Xeon with 1024mb RAM.. The platform was previously > a single 200mhz > Pentium wth 256mb RAM. > > As suggested, I have set the following to optimise performa…
Re: Oninit & Instance
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
If you need to ask this you really really really need to go on a course or at least read a manual Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # forever www.wfsoftware.com # …
Re: New Server- How to Optimise
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…
Re: Performance Tweaking
From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: "AJ" <aj@acck.edu> >> >>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, …
Re: Performance Tweaking
From: "AJ" <aj@acck.edu> > >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 oncon…
Performance Tweaking
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) …
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
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
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
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…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
informix on Linux dual-processor machines
Diego wrote: > lets do a poll here, anyone who is running IDS 7.30 on linux dual-processor > machine raise his hand, by mail, pls. Peter's mail was shocking. To install > or not to install IDS 7.30 with this hw, Hamlet. > > Regards. Diego Mezzera. > > ----- Mensaje original ----…
CPUvps
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 …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
KAIO: HP-UX 10.20 / IDS 7.24
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…
Linux: Error -25580, System Error Occured in Network Function
Thank you. I already have the settings below, and I will also try playing with the number of network VPs. I'll see if I can find UC10 and install it too. In article <38844C5B.6D1C3B1A@transcom.de>, Peter.Eckhardt@transcom.de says... > >Hi Dwight, > >it is Informix. Upgrading t…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
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…
Exception MT_EX_OS ??
> > Error in the logfile: > > 09:59:34 Assert Failed: No Exception Handler > 09:59:34 Informix Dynamic Server Version 7.31.UC4 > 09:59:34 Who: Session(2, informix@, 0, 0) > Thread(8, soctcppoll, 0, 1) > File: mtex.c Line: 446 > 09:59:34 Resul…
How to Take advantage of a multi-processor system using informix?
"S. Martins" wrote: > > How to Take advantage of a multi-processor system using informix? > Do I have to make some special configuration in the Informix Database Engine > to achieve the best performance from a dual processor system? If you only have two processors then IDS does …
Processor Affinity on a 2 CPU HP9000
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…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Re: Hanging CPU VP
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
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…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
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
> 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
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: Long spins or onstst -g spi. Need any information.
Eugene Nechayev <4new@my-deja.com> wrote in message news:80bvko$so0$1@nnrp1.deja.com... > Art and William thanks for your responses > > Now it's more clear, and after Art's explaining line by line > my onstat -g spi output it's more understandable and useful for me > than after r…
Re: Poor performance for a $750,000 box
"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…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
NT 7.30 Performance
<gmurad@unimedsp.com.br> wrote in message news:7tirgg$k5o$1@news.xmission.com... > > Hi Folks! Hi there ! > > We intend to run a small DatawareHouse on a NT Compaq Machine; it is > still with one Pentium III Processor, 256 Mb RAM; about 30 users running an > ERP Soft, and …
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
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…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Performance Tuning Informix 7.22 UC3
Looks good to me except that NOAGE should be 1 on HPUX for best performance. Engine processes are essentially long running processes and as such HPUX will lower the priority of the oninit's more and more over time without NOAGE set. You can probably get away wit using 3 CPU VPs…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
onstat -g iov
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 > > ________________________…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Performance problem with simple query
Willaert Doris wrote: > > AIX 4.2.1 > Online 7.3 UD6 > > This weekend we converted our database from version 5 to version 7.3. We > have noticed the following problem trying to execute the following select : > The estimated cost is to high. (The select takes 26 secs) We have run …
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…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
48 oninit processes, when informix started
In article <7g1u90$9o9$1@news.xmission.com>, xuejinw@shubertorg.com wrote: > > Hello: > > We are running Informix Dynamic Server Version 7.30.FC4. recently we > noticed that when the system was rebooted, 48 oninit processes were started. > That is a lot. Could not figur…
Informix 7.3 on NT Slow when replication across WAN
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 ??
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
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 ??
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 ??
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
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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
HP, KAIO and statistics. What's wrong ?
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…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
RE: Processor affinity
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…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
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…
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'…
NUMCPUVPS > 0, AFFINITY not set
The NUMCPUVPS value indicates the number of CPU VP's that are started up at run time. As you are running 4 CPU machine, 2 CPU VP's is not a problem. AFF_SPROC & AFF_NPROCS only come into effect if processor affinity is supported on your platform. It 'pins' a CPU VP to a physical…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
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…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
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…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: IDS & Workgroup Edition
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'…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: IDS Workgroup Edition
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…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
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…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: about virtual processors
> > 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' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: about virtual processors
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: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
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…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: about virtual processors
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…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
about virtual processors
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
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
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
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
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: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
NUMCPUVPs,ONINIT
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: shared memory ininitialization problem
Informix-Admnistrator wrote: > > Greetings! > > We're in trouble because we can't initialize shared memory. What might > be the problem? > > Here is an excerpt from the error log, showing the different types of > error messages we have got so far: [SNIP] > we removed the process…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
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: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
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: VIR Datablade configuration question
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 single cpu VP with custom VP. Adn the e…
Re: Virtual Processors
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
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
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
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
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
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 …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: LRU Parameters
On Mon, 20 Apr 1998 13:43:20 +0100, "Jo�o Carvalho" <joao.s.carvalho@mail.telepac.pt> wrote: >Hi all ! > >I've got a doubt and I would like to know if someone can answer it: > >In a dual processor IBM 6000 with AIX 4.2.1, 250Mb RAM and >running Informix 7.24 UC1, I found those v…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: LRU Parameters
Values of: LRU_MAX_DIRTY 3 LRU_MIN_DIRTY 2 are commonly used for OLTP processing to decrease the length of a checkpoint. How long are your checkpoints taking? They should be very short with those values, but your write cache will suffer. Scott Kolaya Jo�o Carvalh…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
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] > …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
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
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 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…
Re: waiting for SEM
Looks like Waiting for SEM is misleading. I have a few servers and on some oncheck runs much much faster than the others. For eg on my single cpu server it takes 4 hours on my multiple cpu it takes 14. I ran glance on the 'faster' ones and found that they are also waiting for S…
Re: waiting for SEM
According to Elizabeth Suto's book: if you set the MULTIPROCESSOR to 1, this alters the OnLine system to use spin locks for threads. Thread spin locks keep threads from being put on a sleep or wait queue while waiting a very short time for a resource. IF you set SINGLE_CPU_VP t…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Serious problem with dbimport
Felix Koshy Mathews wrote: } 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 …
Re: Questions on INFORMIX 7.13 and CPU VPs
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: ODS 7.23UC5 and HP-UX 10.10
In article <3455fd6d.323789390@news.usr.com>, Jeff Kalchik <jkalchik@spam-me-not.usr.com> writes >Hi all, > >I'm in the process of bringing up an Informix engine (7.23UC5) on an >HP9000 K420 (HP-UX 10.10, 2 processors, 1 gb RAM, Model 20 RAID >ARRAY). Aside from an shmat error (…
ODS 7.23UC5 and HP-UX 10.10
Hi all, I'm in the process of bringing up an Informix engine (7.23UC5) on an HP9000 K420 (HP-UX 10.10, 2 processors, 1 gb RAM, Model 20 RAID ARRAY). Aside from an shmat error (which I may have solved with Informix Tech Support, increase SHMMAX), this has been going rather well.…
Re: Runaway dbaccess process
Ron, I've experienced this kind of thing also on my SCO 3.2.4.2 box but with users making a sockets connection to sqlexecd and to online. Somehow when they exit, even in an orderly fashion from their workstation, the sqlexec process is still running as reported by ps and by…
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...
: 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…
Runaway dbaccess process
On our current application, users start dbaccess and sometimes disconnect without properly exiting (turning off terminal, etc.). The dbaccess process hangs and proceeds to take over ALL of CPU 1 or 2. When I do a top or sar, one of the CPUs is pegged by the dbaccess process! I…
Cannot fork a virtual processor
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
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...
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
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
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 …
Re: Online 7.x on IBM uni-processor
Bill & David, What about the SINGLE_CPU_VP parameter in the onconfig file? I was told you should also set this to a 1 on a single CPU machine to reduce the number of mutex calls. Doug On 3 Sep 1997 10:43:24 -0400, ennis@ssax.com (Bill Ennis) wrote: }Informix version 7 and lat…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
HPUX 10.20-7.22 Restore problems
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…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Informix 5 Performance Issues
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??
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: OnLine 7.13 performance problems - comments please?
Neil Truby <ntruby@netcomuk.co.uk> wrote: :My explanation to the users is that the machine, which consistently shows :0% idle CPU, is simply overwhelmed by the application (which is :bought-in, so we can't tune it). When one of our customers machine sometimes show 0% or near 0% …
Re: Installing Online 6 on SCO Unix: Network down
In article <331B4E15.2C2A@acer.de>, Kai Shen <shen@acer.de> writes >Hi all, > >we are installing Online 6.0 on SCO OS 5.0.1 When taking Online to >Quiescent or online mode we get the warning "Network down", and online >gets incredibly slow. We think it is a shared memory configur…
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: Processor Affinity
At 08:52 AM 2/5/97 -0500, Steve Romankiw wrote: >Our Sun 4000 server supports processor affinity. Because Sun supports >this option, I have configured our On-Line instance to recognize this >option. Our present user count is low, roughly 50 concurrent users. >Beginning next wee…
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
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
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
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
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
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
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
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?
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: multithread in INFORMIX, how?
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. Informix engine starting from version 6.x is a multi-threaded engine. I…
Re: multithread in INFORMIX, how?
> We are using Informix V.7 aand dual cpu HP machine. We have 700 stored > procedures currently stay on database server, and we still using single thread. > We are thinking using multithread to increase performance, can anyone there > can show us how to do it? Is this so calle…
Re: 2 CPU VP's
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
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
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
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
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
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
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
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
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…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: 2 or 4 cpu's running Informix OnLine 7.xx
In article <319139FE.200C@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> wrote: >Scott Ratliff wrote: >> >> dkabrbwj@e-mail.com wrote: >>snip..... >> No, that is not true. What is true is that the engine will run slower >> on a two processor machine if you set MULTIPROCESSOR to…
Re: 2 or 4 cpu's running Informix OnLine 7.xx
My 2 cents: I have a Hp T500 and a k400 which each have two cpus. I found better performance and throughput configuring Informix with 2 cpu vps. I'm still waiting with my fingers crossed, to see the negative effects of running this way. Tracy Nedd Banctec, ASD } } …
Re: 2 or 4 cpu's running Informix OnLine 7.xx
Scott Ratliff wrote: > > dkabrbwj@e-mail.com wrote: >snip..... > No, that is not true. What is true is that the engine will run slower > on a two processor machine if you set MULTIPROCESSOR to 1 (true) and > SINGLE_CPU_VP to 0 (false) than if you had set MULTIPROCESSOR to 0 (fal…
Re: 2 or 4 cpu's running Informix OnLine 7.xx
dkabrbwj@e-mail.com wrote: : Hello out there || : We are planning an upgrad of our UNIX/AIX. It is an upgrade on hardware : as well as software. From AIX 3.2.5 to AIX 4.1.4, from Informix 4.10 SE : to Informix 7.xx OnLine Dynamic Server. About Informix, does any one Good luck. …
Re: unexpected virtual processor termination
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: OnLine 7.X performance - R U satisfied?
Mickey Mestel wrote: > my # > or ready threads jumps between 2 and 6, Try for an average of zero > my checkpoints are averaging 1 > - 4 seconcds, things like this. In a later post you mention wide extremes in checkpoint duration. There are at least two known bugs that Informix…
Re: unexpected virtual processor termination
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
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: HP Performance problem
In article <4jotj4$n5@aztec.co.za>, Storm Software <storm@aztec.co.za> wrote: >We have exactly the same problem, with exactly the same configuration. >HP and Informix both know about this and I think it is time for one of >them to come clean. > >Several users who have also suffer…
Re: System tuning
Jon McNeill sez: > We recently encountered similar sounding performance problems using > Informix 7.11UC2X?? on a HP K400 with 2 processors and 1280M (!) of RAM. > We had almost 99% cache hits, with still extremely sluggish performance. Our > final performance tuning victory cam…
Re: System tuning
Jon McNeill sez: > We recently encountered similar sounding performance problems using > Informix 7.11UC2X?? on a HP K400 with 2 processors and 1280M (!) of RAM. > We had almost 99% cache hits, with still extremely sluggish performance. Our > final performance tuning victory cam…
Re: System tuning
In article <4ivh5r$guu@cssun.mathcs.emory.edu>, Informix Sysadmin <informix@asl3.asl-labs.bc.ca> wrote: > >This is on a system that has between 20-35 informix users, 128Mb RAM, >2x88100 CPU's running DG/UX5.4R3.10 The database is on 5x1Gb RAID5 >disks. Does it seem immediately o…
Re: Controlling those Nasty CPU VP's
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
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
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 .... ?
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 .... ?
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 …
<No Subject Supplied>
>I have a query that is returning 1791 rows which consists of a 3-way >join. I have attach a copy of the 3 tables with the query and a copy >of sqexplain.out. I have run the query on an HP h70-2 CPU 9.04 and >HP T500-2 CPU box from Dbaccess using Informix 7.11 UC1. The query >run…
Re: How do I .... ?
In article <4cmnor$ki2@cssun.mathcs.emory.edu> 1689@MN.LAWSON.lawson.com (Anjan Chakraborty) writes: > >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,NUM…
Re: How do I .... ?
Anjan Chakraborty (1689@MN.LAWSON.lawson.com) wrote: : 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, : LR…
Re: How do I .... ?
Anjan Chakraborty wrote: > > 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,BUFFE…
How do I .... ?
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
>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
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
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
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
Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processor…
Re: Informix dual processor scalability
: smb@oasis.icl.co.uk (Stuart Britt) writes: : Does anyone have any info on the following problem? We are using Informix : version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP : machines. : : Using Informix on 1 processor we achieve good performance. If we…
Informix dual processor scalability
Does anyone have any info on the following problem? We are using Informix version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP machines. Using Informix on 1 processor we achieve good performance. If we switch to 2 processors, then our performance actually degra…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…