Oninit® Archive
Results for “AFF_NPROCS”
Network tuning advice needed
On Oct 9, 10:59 am, Tom <tlow...@munis.com> wrote: > Greetings All, > > I am looking for some advice on a new (to me) configuration. Up until > now, we have always had our engine running on the same server as our > application. That has now changed. We now have a setup with the >…
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Art, Here are differences that make sense between the primary and RSS, 236,238c236 < NETTYPE onsoctcp,50,220,NET --- > NETTYPE onsoctcp,40,220,NET 243,245c241 < NUMFDSERVERS 8 --- > NUMFDSERVERS 4 2…
DIRECT I/O (KAIO) Disabled in RHEL 9
Yes. Endeed KAIO class vcpu is related to the number of VPCLASS of type cpu you have. In my case just for testing VPCLASS cpu,num=1 Let me say that Informix will use AIO for every chunk which its size is not multiple of disk sector size (even if mapped to a mdadm RAID). So, for 4…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
How many aio/KAIO
Hello All When using KAIO, what is recommended for vpclass CPU and AIO please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
Informix and Hyper-threading
Hi Paul, It would be interesting to know how you are measuring whether it is a good thing. Do you go by the efficiency metric reported by 'onstat -g glo' or other metrics? Do you use processor affinity at all and, if so, how do you configure it? I guess two Informix CPU VPs being…
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
IDS 12.10.FC8 AIX 7.1 VPCLASS autotune=1
I am seeing the following in the ONCONFIG. VPCLASS cpu,num=12,noage,autotune=1 VPCLASS aio,num=2,noage,autotune=1 I don't see autotune documented. Is this not the same as: AUTO_AIOVPS 1 Don't see any AUTO_CPUVPS Thanks Kernoal…
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.…
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…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
Re: RE: onstat -g glo: cpu efficiency
We have an IBM Power 750 (Power 7+) with 16 cores defined running SMT so that the cores appears to the OS as 64 cores. We have 54 VPCLASS cpu Our average efficiency looks to be in the low 60% range. We are experience about 80 lngspins per day with an peek connections of about …
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…
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Mutex logs on logical log flip
Thanks. We already knew from Marco Greco, ex of IBM, that the handling of this in 11.70 is vastly imrpoved. This is the last large customer resisting that move. VPCLASS CPU,NUM=230 # VPCLASS CPU - CPU #T5 Migration NETTYPE tlitcp,11,800,NET ... are the settings. The server has …
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)…
upgrade from 11.70.FC4 to 12.10.FC4 onconf questio
HPUX 11.31 (11vi3) HP BL870c from 11.70.FC4 to 12.10.FC4 I'm testing our ERP upgrade to IDS 12.1 on our test server and after running the upgrade and checking the differences in the old and new onconf file I got a question or two. The new onconf doesn't have a VPCLASS aio setti…
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…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
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…
VPCLASS parameter
Can someone please tell me what the VPCLASS parameter should be for my instance. Following is the environment details. IDS 11.70.FC8W1 VPCLASS cpu,num=4,noage CPU info: 6 PA-RISC 8800 processors (1.1 GHz, 64 MB) CPU version 10 12 logical processors (2 per socket) Thanks…
Root db space fills up
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
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…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
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?…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
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.…
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
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…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
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,…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
Efficiency of the Informix Virtual Processors
Hi Cesar, It may seem odd, but I have found that Informix works better with SMT if you use affinity. Otherwise, SMT tries to push every thread of one oninit processes to a different logical processor. We want them all to stay on the same one, setting processor affinity does that…
CPU informix
See the vpclass entry for class cpu in the onconfig file. Art Sent from my Galaxy S®IIILICU GARCIA <licu99@gmail.com> wrote:how to configure CPU with informix. For example, if i have 1 CPU with 4 cores and i want to assign only 2 cores. What is the correct parameter on onconfig…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
Innovator-C Edition now down to 1 CORE
Tested the limits and found the following: IBM Informix Dynamic Server Version 11.70.FC5IE -- On-Line -- Up 00:00:12 -- 165604 Kbytes 10:28:46 Warning: The IBM IDS Innovator-C Edition license restriction limits the number of CPUs on this machine to 4. The number of the CPU VPs …
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
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 …
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
koi -1 display from onstat -g iov (11.50.FC8)
Where is the -1 for the koi vpclass coming from in the output of the onstat -g iov command, ex: AIO I/O vps: class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops fifo 12 0 i 0.0 0 0 0 0 0 0.0 0 0 kio -1 0 i 3.8 209628 207709 1919 0 444439 0.5 0 0 An…
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.…
ontape -p/r with changed ROOTPATH
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
RE: NETTYPE "CPU" vs "NET"
Just a quick answer for only one aspect: On Tue, Mar 1, 2011 at 1:24 PM, Tristan Ball <tristanb@pronto.com.au> wrote: > Results from "Step 4", with various combinations of settings: > > VPCLASS cpu,num=4,noage > soctcp,2,10,CPU 500/sec > soctcp,2,10,NET 640/sec > > VPCLASS cpu,…
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
See the Administrator's Reference for a full description of all documented ONCONFIG variables. That said, VPCLASS has been around since 9.40 and replaces several other parameters which may finally have been deprecated in 11.50 IB. It replaces NUMCPUVPS, NOAGE, AFF_NPROCS, AFF_SPR…
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…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Hello All
One more thing, in the old days we were told when using KAIO to set the NUMAIOVPS to 2. So should I also have this: VPCLASS aio,num=2,noage > I have a question about the VPCLASS variable. If I want a KAIO, > using 2 CPUs and my connections are socket connects through TCPIP > po…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
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…
optimum usage of resources
One more thing : In the IDS 9.4 documentation I find that NUMAIOVPS (and other parameters) have been replaced with VPCLASS parameter.…
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: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
soctcppoll and soctcplst
OK, thanks very much One more question Once I set the number of soctcplst (NUMCPUVPS) and soctcppoll (NETTYPE) How I realize if the number of soctcppoll threads is too low or too high ? The same for soctcplst…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
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_…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
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…
Tunning CPU VPS and Processor Affinity
Hi everybody! I'm planning a migration from HP PA-RISC model RP3440 (4CPU X 2core) with IDS 11.10 FC2 in HP-UX 11.10 to Dell PowerEdge Server R710 (2 Sockets Xeon 2.93GHz X 4Core with 2 threads per core - HyperThread) using IDS 11.50 FC5 in Linux RHEL 5. My question is: How ca…
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…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
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…
VPCLASS Notation, pros?
Hi. I want to know if replacing former NUMCPUVPS, AFF_SPROCS, and so on for VPCLASS in IDS 10 brings any advantage in terms of better performance or avoiding malfunction. Admin guide just says "you should" (p. 6-13) and warns against using both notations at once. Thanks i…
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…
configure vpclass on multicore systems (solaris)
Hi, I have a doubt on what the optimal onconfig VPCLASS parameter should be on multicore systems. For example, on a Sun M4000 server, with 4 physical CPUs and 4 cores per CPU, when you issue an uname -X to get the number of CPUs, I get: lafeoriclu1-[PROD]-(dbpoc):~ $ uname -X | g…
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…
Correlation between NETTYPE and VPCLASS
Hello, Is there any correlation between the values of the following two parameters VPCLASS NETTYPE I mean if the value of numcpus is 6 in VPCLASS i.e VPCLASS cpu,num=6,aff=17-22,noage, then is it necessary that the value of NETTYPE should be somewhat like the following NETTY…
How to enable/disable noage
Hi, This is how we defined the VPCLASS in ONCONFIG file. VPCLASS cpu,num=16,aff=0-15,noage How we can activate/deactivate the aging for a VPCLASS. We try to initialize the server by eliminating "noage" and without eliminating "noage" in the VPCLASS but in both cases we didn't g…
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…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
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…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
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 (…
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…
IDS 11 Effective Affinity Value Problem? - Resent
Hi, It looks like the cut and past that I used in my previous e-mail created a lot of extraneous characters.? So, I have resent my e-mail. I am testing IDS 11.10.FC2W2 on an HP-UX Itanium server with 32 CPUs [milti-core CPUs].? When I use the sysmaster database and look at reco…
IDS 11.1 Effective Affinity Value Problem?
Hi, =C2=A0 I am testing IDS 11.10.FC2W2 on an HP-UX Itanium platform with 32 multi-core= CPUs.=C2=A0 When I query the sysmaster database and look at records in sysc= onfig or syscfgtab for AFF_NPROCS I see a value of 22 for the original value= and 38 for the effective value (cf…
Multi Processor Performance (example myimport)
Hi Tim, I assume you are using IDS10 or more. Setting multiprocessor to 1 is right thing. Have you set VPCLASS? Please find more info below how you can set vpclass and enable more physical cpu for clients. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=…
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…
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
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.1140.1211265848.20610.informix-list@iiug.org... > > tgirsch said: >> pokeyman76@yahoo.com wrote: >> > VPCLASS cpu,num=4,noage,aff=0-3 >> > This will turn on noage and affinity f…
Re: CPU VP Issue
Floyd Wellershaus wrote: > 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 ? > We haven't set processor affinity, although we've toyed with that idea. Not…
Help With Affinit Parameter
Sorry Mr Kagel again a typo this time i am pasting the o/p of mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt idl 0 16 1 88 15 6 414 6 21 35 0 846 1 1 0 98 1 7 1 75 42 34 334 4 28 24 0 224 2 1 0 98 2 6 1 76 2916 72 321 4 20 23 0 198 1 1 0 98 3 15 1 86 …
Re: IDS Error - VP Notify
11.10 isn't up to FC6 yet, so I assume you meant 10.00. Of course it's possible that your issue is not the same one as the existing APAR -- all we know right now is that the same message appears in online.log, but the causes might be different. The existing APAR 36846548 says: …
Re: how much cpu does Informix use
Art S. Kagel (Oninit) wrote: > Floyd Wellershaus wrote: [cutting] >> >> First question: Am I correct that only the cpuvps are directly tied to >> the physical cpus? Or do I need to be counting all of the vps ? > > That depends. If you are using a version before 9.40 (don't rem…
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 (…
Onbar and LTAPEDEV
I don't know about onbar. But, ontape picks up tape parameter changes made via onmonitor without needing a restart of the instance. However, I'd strongly recommend backing up your onconfig before hand and checking for diffs when your done. In some versions, onmonitor has been fou…
CPU-VP issue
We have the following: IBM Informix Dynamic Server Version 10.00.FC6 HP-UX om4db1 B.11.11 U 9000/800 4126011100 unlimited-user license 3 duel core 1-gig PA-RISC procs 12 gig memory We were attempting to tune our system and changed the following: from VPCLASS cpu,num=5,noage to V…
Re: RE: Informix 10.0 FC4 & Solaris 10
Hi, Thanks for the responses. We are not currently dealing with the images but with the relationship between Informix 10.0 FC4 and Solaris 10.0. The IDS 7.31 system which maintains the images will be replaced by this new system. We are stress testing this new box to get the bes…
how to balance CPU VP
roger@star2000.com.tw wrote: > 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…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
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…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
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
Wow, that's a lot of dbspaces. The good news, they're fairly small. As far as the # of AIO virtual processors, you'll have to watch disk performance. I can tell you that 2 AIO virtual procs may not be enough. I would try incrementing the number of AIO VP's by 20's each time you t…
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…
NOAGE Depreciated
Thanks Art. So, if someone is not using VPCLASS but using NUMCPUVPS, NUMAIOVPS, AFF_SPROC, and AFF_NPROCS parameters separately, he/she should use use NOAGE then. Isn't it? Can you or someone please help me with my second query please? Appreciated your dedication towards commun…
ids on Windows and cpu usage
IDS version 9.4 tc2 (Windows) Current Onconfig parameters that relate to these settings: MULTIPROCESSOR 1 #NUMCPUVPS 4 SINGLE_CPU_VP 0 #NOAGE 0 #AFF_SPROC 2 #AFF_NPROCS 8 #NUMAIOVPS VPCLASS cpu,num=3 Note sure what a PDQ is. Let me know more detail and I will forward. Cheers,…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
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: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
Re: VPCLASS 'cpu' not enough physical procs for affinity
On Jun 23, 12:54 pm, Frank Langelage <f...@lafr.de> wrote: > sdhaya wrote: > > The following is the output of psrinfo in our Sun V890 ... > > > # psrinfo > > 0 on-line since 06/16/2007 15:09:23 > > 2 on-line since 06/16/2007 15:09:19 > > 16 on-line since 06…
VPCLASS 'cpu' not enough physical procs for affinity
On Jun 22, 11:26 am, Superboer <superbo...@t-online.de> wrote: > you could try: > > AFF_SPROC 0 # Affinity start processor > > Superboer. Will try and let you know... Thanks Dhaya…
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.…
Question on ownership of oninit
I seem to agree with Art's 10 year-old comment (see below) -- basically, if Informix instance is started by root, oninit processes will be owned by root; if started as Informix then they will be owned by Informix. However, at this environment, oninit processes are always owned b…
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…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
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…
KAIO Question
On 29 Mar, 22:20, John <john_hib...@earthlink.net> wrote: > To any AIX / IDS gurus out there, > > Background: > > We are running IDS 10.00 FC4 on AIX 5.2 TL8. We have been having some AIO issues with two boxes (each is a 390 with 8 cpu's), one dev and one prod. We tuned the D…
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…
Affinity
Andreas Legner wrote: > What do you mean to achieve by AFF_SPROC 17 ? With AFF_NPROCS 7 you'd > need 25 cpus in your machine. > > Did you mean AFF_SPROC 1 rather? > No SUN numbers processors according to which hardware slot their system board is plugged into. In his case CPU #1…
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: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
PVU - half a license?
On Feb 1, 7:03 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > I don't believe that you can use processor affinity and and NUMCPUVPS to > qualify for sub-capacity licesning. I believe that you have to use an > apporved virtualisation technology to physically isolate the cpus …
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…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
Re: NETTYPE's poll thread number
Version of IDS from 9, number of max connection is number of poll threads multipy by user per thread e.g NETTYPE soctcp, 2,100, NET : Max connection is 2x100 = 200 So first you have to monitor number of user connections before fill the number in by command : onstat -u , onst…
NETTYPE's poll thread number
roger@star2000.com.tw wrote: > Hi, > My box has singel processor , NUMCPUVPS =1 . > A lot of user will access this server, maximum will be 1500 user > threads. > How shoud I set up the NETTYPE in onconfig file. > On informix's manual , says poll thread should not be greater …
CPU idles
> Hi, > > First: it is possible to set the NUMCPUVPS parameter to a > higher value than actual processors in the system. This > sometimes leads to better response times. (when you encounter > idle time on your CPU (using sar) and the number of active > threads is not decreasing).…
what are all the statistics i should collect for cpu perf
Hi I am using .informix 7.33 on HP-ux 11.x what are all the things i have to do monitor the perf. for cpu utilization. now numcpuvps is 2. i plan it to increase it to 4. which part of the stats i have to see to for the improvement in performance. thanks in adv. madu…
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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…
NUMAIOVPS/VPCLASS
Apologies for asking this question but I've searched through the CDI archive and can't find it. Recently I read something about a config parameter (possibly undocumented) to do with an AIO setting when using cooked files instead of raw chunks. I though I read it on this forum bu…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
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: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
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?…
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/…
EXTSHMADD New shared memory parameter?
Jacob wrote: > Hi family. > > In configuring a new server, I noticed a parameter I have not noticed > before: EXTSHMADD > > I'm trying to figure out from the "Administrator's Reference" exactly > what is the functional difference between SHMADD and EXTSHMADD. The > text reads: > …
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
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: IDS Workgroup cpu limit
"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:ds75uf$976$1$8300dec7@news.demon.co.uk... > Neil Truby wrote: >> A potential customer asked me a question which I think raises a number of >> interesting points, and I'd like to see what others think. >> >> As you m…
Re: IDS Workgroup cpu limit
> -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Posted At: Thursday, February 02, 2006 8:14 AM > Posted To: comp.databases.informix > Conversation: IDS Workgroup cpu limit > Subject: Re: IDS Workgroup cpu limit > > > Neil Truby wrote: > > A potent…
IDS Workgroup cpu limit
A potential customer asked me a question which I think raises a number of interesting points, and I'd like to see what others think. As you may know, the IDS 10 Workgroup Edition (WGE) software has a check now so that when it starts up it checks the setting for NUMCPUVPS and , i…
Re: 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…
IDS and Sun
No but do you have one going spare I can play on? I would be aware of the limitations of Hyperthreaded Processors and IDS that I vaguely remember someone posting here. Database are about data movement (including into/out of the CPU package). Perhaps ensuring CPU VPS are spread…
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: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
Re: Upgrading from 9.21 to 10 planning
Migration on same box? Check the migration Guide... http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.mig.doc/mig31.htm It looks like you can go 9.21 -> 10.0 And http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.mig.doc/mig60.htm …
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…
Upgrading from 9.21 to 10 planning
We are finally upgrading from 9.21 (ugh) to 10. I am starting to plan the upgrade now. What pitfalls should I watch out for? What new settings and features should I investigate. We run Alphas on tru64, if it makes any difference (which it probably does). What about the new VPCLA…
processor affinity
I am running two instances on a QA server. Can I use processor affinity for both instances if they copy my production instance? Production has 8 processors and 6 virt cpus. RedHat AS3 Linux, IDS 10.00.UC3 Bob Roussey robert.roussey@spiritair.com…
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
Hello Guy, thanks, I could not find the vpclass parameter error. EXECUTE PROCEDURE sqlj.install_jar ('file:E:\\program\\informix\\jar\\ninesync.jar', 'ninesync_jar', 1); 9498: Incorrect path to JAR file specified: (java.io.FileNotFoundException: \\tmp\\coffee.informix.ninesync_…
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\…
Re: sqlj.install problem
You didn't answer these questions: What is the exact OS and version? e.g. "XP Professional Service Pack 2" What is the IDS version (output from onstat -V)? Can you run onstat -d to confirm you have an sbspace? But from the values you pasted it looks like you're quoting "onconfig…
sqlj.install problem
Maroon wrote: > Hello all > I am quite new in the informix database. When i was trying to > install java jar file in the informix, i get the following error. > > EXECUTE PROCEDURE sqlj.install_jar > # ^ > # 9799: User Defined Routine (…
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.…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
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…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
Informix MULTIPROCESSOR cannot be set to 1 after upgrade from AIX5.2ML02 to ML06
Hi there, I met a strange problem here. I have 13 database instanse in one 690 machine. Last week, I upgrade my OS from AIX5.2ML02 to ML06 as IBM suggest. After that I find there are two instanse cannot startup, and reporting the following error: 10:25:29 IBM Informix Dynamic Se…
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
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…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG par…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
IDS 10 on REDHAT 4 AS
I can not affinity processors with IDS 10 on REDHAT 4 AS (2.6 kernel) message is "can't affinity VP1 to phys proc 0" The same configuration of IDS 10 on REDHAT 3 AS (2.4 kernel) works fine Is this REDHAT or IDS bug?…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
Need help!! Sql to Informix Migration
Not a lot of buffers for starters, this looks like an 'out-of-box' config, grab the performance guide, have a quick read and the use pf most the parameters will 'as if by magic' become clearer [cutting] > > SERVERNUM 1 # Unique id corresponding to a server > …
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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 …
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…
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…
Consolidation servers
Hi, We are in the process of consolidating database servers. At this moment, each Production database has is own server with 2 or 4 CPU. The new server will hold from 3 to 5 databases, each server has 6 CPU. In the current config file of Informix, the parameter NUMCPUVPS is set…
RE: NUMCPUVPS on ultrasparc dual core architecture
8 or 7 -Alexey > -----Original Message----- > From: co4770@yahoo.com [mailto:co4770@yahoo.com] > > Hi, > > Can someone advise how to configure NUMCPUVPS for 4 processor > ultrasparc IV machine. At OS level it shows processors > 1,2,3,4,16,17,18,19 (8 processors because of dual…
NUMCPUVPS on ultrasparc dual core architecture
Hi, Can someone advise how to configure NUMCPUVPS for 4 processor ultrasparc IV machine. At OS level it shows processors 1,2,3,4,16,17,18,19 (8 processors because of dual core architecture). regards…
CPU Binding
EDCEL BARCENA wrote: > 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 additiona…
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'?…
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: Extra lines added to ONCONFIG by onparams - B169031
Malcolm Weallans <malcolm.iiug@btopenworld.com> wrote: >We are experiencing a phenomenon whereby extra lines >are being added to the ONCONFIG file. After these >lines have been added we are unable to use onparams >again or to start IDS again until we delete the extra >lines. Th…
RE: Extra lines added to ONCONFIG by onparams
malcolm weallans > We are experiencing a phenomenon whereby extra lines are > being added to the ONCONFIG file. After these lines have > been added we are unable to use onparams again or to start > IDS again until we delete the extra lines. The extra lines > are copies of the…
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: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
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…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
Re: ONCONFIG for 9.40 offered for comment
Andrew Hamm wrote: > > AFF_ works well on HP - try 1,3 and make sure the other engines have > NOAGE=0 and AFF_ =0 Ooooo - everyone should read appendix D of 9.40 Admin Reference. Looks like AFF_ parameters are being obsoleted, and a new VCLASS statement is available to pin more …
ONCONFIG for 9.40 offered for comment
Neil Truby wrote: > 9.40 FC3W2 on HP-UX 11.11 > The server has 6 cpus and 6G of RAM. > 3 other, small, IDS 9.40 instances run on the server, and one small > 7.31. kaio is enabled. > > Just put 9.40 live, and it's running about 5-10% more slowly on some > key processes. This refle…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
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…
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
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.…
Re: Performance advice
sumGirl wrote: > NETTYPE soctcp,2,150,CPU > NETTYPE ipcshm,2,150,NET CPU processes don't do soctcp very well, and NET processes don't do ipcshm very well. swap this to NETTYPE soctcp,2,150,NET NETTYPE ipcshm,2,150,CPU > RESIDENT 0 …
high buffer wait ratio
miyaki wrote: > Hi all, > > My users are complaining the database slowness. I > noticed that the buffer wait ratio at my database is > quite high, around 58% and LRU contention is at 3.29%. Don't jump in and attack LRU queues, because there's a few things here which really stand…
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…
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…
Re: onunload / onload filesize issues
On Thu, 18 Mar 2004 05:39:42 -0500, Geezer From Freezer wrote: > "Art S. Kagel" wrote: >> >> On Tue, 16 Mar 2004 06:37:34 -0500, Geezer From Freezer wrote: >> >> > I've noticed that onunload will not create a file bigger than the 2Gb >> > file limit. >> > (i.e. its not largefile…
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: Informix, PHP, Apache
Does phpinfo() say --with-informix? Thomas Ronayne wrote: > I've managed to get myself completely confused. Can anyone tell me what > to set and where in httpd.conf and php.ini so PHP can connect to an > Informix data base (an example would be most helpful)? I'm running > Slack…
Informix, PHP, Apache
I've managed to get myself completely confused. Can anyone tell me what to set and where in httpd.conf and php.ini so PHP can connect to an Informix data base (an example would be most helpful)? I'm running Slackware 9.1, Apache 1.3.29, PHP 4.3.4, Informix 7.30.UC5. My onconfig …
VPCLASS entries in onconfig when adding logs
Hi, I've got a strange problem. IDS 9.30 UC1 (or UC2) on Solaris 8 I install IDS (using ids_install) and creates an instance. Add a new dbs for logs. I move the physical logs to this dbs, restarts. Everything is fine. I then add a logical log: onparams -a -d logdbs .. but addit…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
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…
RES: Pentium 4 hyperthreading
Speaking on Affinity Processors, does anyone know if the IDS 9.40 has support for this feature on Linux? AFAIK IDS 7.31 doesn't. I'm using NUMCPUVPS=4 with 2 XEON Processors and it work fantastic. If I configure a single cpu environment my systems loses performances. The Hypert…
RE: Pentium 4 hyperthreading
Alexey Sonkin <alexeis@grandvirtual.com> writes: > With Xeon, I'm using NUMCPUVPS=8 on 4-CPU (real CPU's) > Linux box (2 GHz Xeons, 2MB L3 cache). Everything works fantastic. > > It's not clear to me, whether Linux process scheduling > takes into account that some CPU's are 'bett…
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
The Question that has to be asked of IBM. Do they charge like Oracle for every CPU in the system or do they charge for what the database is defined to use. Oracle requires hard partitioning or you have to pay for all of the CPU's in the system no matter what your software if con…
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…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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
Thanks to everyone, I send the onconfig file's portion about the memory and processores: about the processor: MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one N…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
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…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
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…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
Re: NUMCPUVPS on a box having multiple Informix Instances
Why should one have more cpu vps that cpus and why does this have something to do with the cpu speed? Cpu vps should never block or sleep until they are really idle. If this holds, one vp can load one cpu 100%. If it doesn't hold it's a performance bug and you should talk to sup…
Re: NUMCPUVPS on a box having multiple Informix Instances
Setting MULTIPROCESSOR in a single cpu system is definitely not recommended because it creates performance problems. For a multiprocessor system with one cpu vp I am not sure. But I would rather not set it and set SINGLE_CPU_VP instead. This skips all multiprocessor latching code…
RE: NUMCPUVPS on a box having multiple Informix Instances
Start with 1 CPUVP (or 2) on each instance, but with MULTIPROCESSOR set. If/when one instance cannot keep up with the workload just add another CPUVP. When it has settled down and you know what resource each needs, affinitise each on their own CPU, if available on your platform.…
Re: NUMCPUVPS on a box having multiple Informix Instances
The instances will not be too busy. The processors speed is 250MHz. Thank you Chavan Koya ----- Original Message ----- From: "Jay Aymond" <jaymond@communitycoffee.com> To: <informix-list@iiug.org> Sent: Friday, May 23, 2003 2:59 PM Subject: Re: NUMCPUVPS on a box having multiple…
RE: NUMCPUVPS on a box having multiple Informix Instances
Start with the question .. How much CPU resource do you expect each instance to need? Similarly for the BUFFER resource. Here you can probably allocate more CPUVP's than CPU's, but someone may get starved if both instances hit maximum at the same time, or if you have AFFINITY s…
RE: NUMCPUVPS on a box having multiple Informix Instances
Could you give examples of kinds of CPUs that could be configured for more than one CPU VP per hardware CPU? thanks, Vivek > -----Original Message----- > From: jaymond [mailto:jaymond@communitycoffee.com] > Sent: Friday, May 23, 2003 1:00 PM > To: informix-list > Cc: jaymond >…
NUMCPUVPS on a box having multiple Informix Instances
Hi All, The Informix recommandation for configuring NUMCPUVPS is equal to, or less than the number of physical CPU's in the box. I had to configure two instances on a box, which is having 6 cpu's. So what should be the NUMCPUVPS, is it 3 for each instance or 6 for each. F…
cpu time
I've been observing a machine with IDS and application on same HP-UX platform. The machine has 8 cpu, Informix affinity to 2 processors and with numcpuvps=7. The total cpu time for 1cpu and 3cpu vp-classes are so much very very high compared to 4cpu-8cpu classes. Is there a way t…
Re: Bloody ERP schema
Oxow wrote: > Hi! > > We changed Informix version from 7.30 to 7.31.FD2X1 on AIX 4.3.3 and > after > that we have regonised some performance problems. > > DBSERVERNAME sapshm # Name of default database server > DBSERVERALIASES saptcp # List of alternate dbservernames …
Re: Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC
Hi 1) As for my experience if you have only DB on your server and you do not have large WAIT IO define all cpu to informix. If you have a lot of users and you are using NET VP check there cpu usage, maybe you should spare one or two cpu for them. 2) Probably the first SQL use i…
Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC
Hi, Not sure if anyone can shed some light on a couple of questions I have about Dynamic Server and NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC ? Firstly our setup: We are running a data replication setup (2 systems each running Dynamic Server 9.21-FC3x-1 on HP-UX 11.0). …
Shared mem connections and semaphores
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…
Help adding new CPU
We have IDS 9.21 UC 6 Running on Solaris 2.6 on an Enterprise 4500 Sun box Had 4 cpu and 4 gig memory. Added 4 CPU and 4 gig memory. I have upped the numCPUvps onconfig from 4 to 7 (also tried VPCLASS cpu,num=7) I have upped the nettype field from tlitcp,4,50,CPU to tlitcp,7,50…
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 …
NETTYPE
I would just like to clarify on the setting of NETTYPE on the ONCONFIG. Can I put several NETTYPEs on the one file, like: NETTYPE ipcshm,3,,CPU NETTYPE soctcp,,20,NET because I use the DBSERVERNAME and the DBSERVERALIASES with different connections? I wasn't so clear to me in t…
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 …
Processor Affinity
On 18th Aug 1998 kagel@bloomberg.net (Art S. Kagel) wrote:- There can be great benefit. Sometimes, on some systems (especially Numa architecture systems), there are performance gains above those achieved by the ONINIT affinity parameters to be had be affining the VPs yourself. I …
RE: 3 onconfig parameter questions, help
NUMCPUVPS - the number of Informix CPU processes. Increasing will allow Informix to use more CPU power. Decreasing - the converse. Keep as number of cpu's - 1. AFF_NPROCS = NUMCPUVPS always AFF_SPROC keep as 1. Unless you do not want CPU affinity, when both AFF parameters sh…
3 onconfig parameter questions, help
Have you tried another parameter change?: RTFM=ON <mr_potato_head@my-deja.com> wrote in message news:916inu$fss$1@nnrp1.deja.com... > Hi, > I have an E4500 running solaris 7 with 4 cpu's and running informix > 7.31. Can anyone explain to me the results of changing these 3 >…
Re: procesor affinity and data replication
edem wrote: > > Can i set procesor affinity on secondary server in data replication > pair? > When I set AFF_SPROC and AFF_NPROCS, after reboot there is no > information about affinity in logfile (usually on standard server > information is after "On-line" message, but on seconda…
procesor affinity and data replication
Can i set procesor affinity on secondary server in data replication pair? When I set AFF_SPROC and AFF_NPROCS, after reboot there is no information about affinity in logfile (usually on standard server information is after "On-line" message, but on secondary there is of course no…
Re: AFF_SPROC questions ..
In article <90gs85$fot$1@news.xmission.com>, Sinha, Niraj <niraj.sinha@BondBook.com> writes > >Hi Guys, > >I have following parameters : > >NUMCPUVPS 4 >AFF_SPROC 0 >AFF_NPROCS 0 > AFF_NPROCS = the number of processor which you are using processor affinity on. In this case 0 s…
Re: AFF_SPROC questions ..
From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >I have following parameters : > >NUMCPUVPS 4 >AFF_SPROC 0 >AFF_NPROCS 0 > >Now, does it mean that I am not using Processor affinity as AFF_NPROCS = >0 The above is correct. _____________________________________________________…
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:…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
Re: affinity process problem
My box does the same, stress about it not. Aside from that, , cpu_state is not a command I've ever heard of, what package is it in? brett samir BADAOUI wrote: > > Hi, > please how can I know that I am using affinity process in my server (in the > informix side). > my config var…
RE: affinity process problem
Does your Informix release support the AFF_SPROC and AFF_NPROCS parameters on AIX? From: http://www.informix.com/informix/resource/pubs/ids/0731uc6/ibm0731m.txt ================================= MACHINE SPECIFIC NOTES …
affinity process problem
Hi, please how can I know that I am using affinity process in my server (in the informix side). my config variables AFF_SPROC and AFF_NPROCS are positionned to respectivly 1 and 2. but I get the following message in the log file : VPCLASS 'cpu' not enough physical procs for affin…
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…
RE: question for affinity (AFF_NPROCS,AFF_SPROCS)
From $INFORMIXDIR/release/en_us/0333/IDS_7.3 on AIX: 7. The Processor Affinity feature (ONCONFIG variables AFF_SPROC, AFF_NPROCS) that allows the pinning of CPU VPs to physical processors in a multi-cpu configuration is NOT supported in this release. On AIX 4.2.1, the b…
question for affinity (AFF_NPROCS,AFF_SPROCS)
hi gurus, I am using informix 7.30 under AIX 4.3.2 and under HP-UX, how can I know if my systems support the use off the configuration variables AFF_NPROCS et AFF_SPROCS ? thinks a lot _________________________________________________________________________ Get Your Private, Fre…
Re: server 2000, cpu affinity problem
From: <tfhkcyt2000@taifuji.com> > >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 > …
RE: server 2000, cpu affinity problem
You are telling INFORMIX use 4 CPU's start at processor 1, the second processor. But you told INFORMIX to use only 1 CPU "NUMCPUVPS=1" out of 4 available. So set NUMCPUVPS=3 {4 for DDS} AFF_SPROC=1 {If the OS supports it, else = 0} AFF_NPROCS=3 {If the OS supports it, else = 0} …
server 2000, cpu affinity problem
Small note. Linux is not supports 'processors affinity' (even for latest kernel ), so setting AFF_SPROC and AFF_NPROCS , will not have effect. See IDS2000 release notes for Linux. Good luck. Sergey. <tfhkcyt2000@taifuji.com> ����� � ���������:8tdj5c$alb1@imsp212.netvigator.…
Best Config for DUAL CPU Informix Server?
Normally NUMCPUVPS should be at most #CPUS - 1. There has been some success configuring NUMCPUVPS as high as 2 * #CPUS on Sun Sparc platforms with CPUS AT LEAST 400MHZ or faster. On your box, and especially with only 21 CPUs I'd recommend leaving only one CPU VP. Art S. Kagel …
Re: checkpoint problem
Comments below... >> Move to 7.31.UC5.. >No move, always at 7.31, just a restart I think he was suggesting an upgrade to UC5, which I concur with. >> >NETTYPE ipcshm,3,50,CPU # Configure poll thread(s) for nettype >> Good, these are set the right way around, tcp=NET sh…
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
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…
Re: Several instances of IDS 7.3X
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? MULTIPROCESSOR 1 # 0 …
Re: Several instances of IDS 7.3X
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? MULTIPROCESSOR 1 # 0 …
SINGLE_CPU_VP
If you have SMP with more than one CPU (not much of an SMP otherwise I guess) you need to set MULTIPROCESSOR to 1. If you have NUMCPUVPS set to a value greater than one, or you want to be able to increase it beyond 1 using onmode -p +1 cpu you should set SINGLE_CPU_VP to 0 other…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? 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 …
performance with very active threads
I forgot to include my onconfig file. From a posting i read the other day, I can see there a few things I can do the next time I restart the engine: unset TBLSPACE_STATS and reduce my PHYSFILE size. PHYSDBS rootdbs PHYSFILE 10000 LOGFILES 21 LOGSIZE …
Informix 9.21 VPCLASS question
Hi everyone, We are in the process of migrating to Informix v9.21. In the Informix Administrator's Guide, it mentions that Informix sugguests to use VPCLASS parameter instead of AFF_SPROC, AFFNPROCS, NOAGE, NUMCPUVPS, and NUMAIOVPS parameters. Does anyone have any experience o…
VPCLASS 'cpu' not enough physical procs for affinity
I upgraded our server to 4 processors, from 2. I set multiprocessor option to 1, numcpuvps to 3, nprocs to 3 and sproc to 1. At bootup I see the operating system recognizes 4 processors. In the log, upon startup of Informix I see: "VPCLASS 'cpu' not enough physical procs for aff…
Re: NUMCPUVPS
Does this still apply using 7.31.UC4? Check the FAQ at www.smooth1.demon.co.uk martyn.ayshford@orange.co.uk wrote in message <8o1grh$j0t$1@nnrp1.deja.com>... >mmmmm > >In addtion to what the others said.... > >Are you running KAIO? > >If you are do the following > >echo "_ncols/…
Re: NUMCPUVPS
Masa wrote: > > Virtual processor summary: > > class vps usercpu syscpu total > > cpu 6 56820.59 10253.74 67074.33 > > aio 40 1144.83 2457.59 3602.42 > > lio 1 7.02 18.85 25.87 > > pio 1 …
Re: NUMCPUVPS
mmmmm In addtion to what the others said.... Are you running KAIO? If you are do the following echo "_ncols/D"|adb -k /stand/vmunix /dev/kmem If this going up at all be worried, if it's going up real fast be very worried. It measures the number of collisions ie the number o…
Re: NUMCPUVPS
I think that would be the CPU VP listener threads polling and spinning. Art S. Kagel Rudy Fernandes wrote: > > Wonder what's causing Informix's syscpu to be 4 times that of usercpu - > normally, its the reverse. Post onstat -c as well as the other onstat's > suggested. > > Rud…
NUMCPUVPS
We have a two server cluster environment. Another server is for Baan application and another is for Informix database. Informix version is 7.31 FC2. Both servers are HP N 4000 (6 CPU) with HP-UX 11.0. Now users are reported to us that application is getting slower. Application …
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
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…
Re: (2) Poor Performance with 7.31.uc6
From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > >Obnoxio The Clown wrote: > > > A word to the wise: when you need to do your index rebuilds, set the > > following environment variables: > > > > PSORT_NPROCS=[2 * NUMCPUVPS] > > PDQPRIORITY=100 > > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 #…
Re: (2) Poor Performance with 7.31.uc6
Obnoxio The Clown wrote: > A word to the wise: when you need to do your index rebuilds, set the > following environment variables: > > PSORT_NPROCS=[2 * NUMCPUVPS] > PDQPRIORITY=100 > PSORT_DBTEMP=/tmp1:/tmp2:/tmp3 # i.e., 3 temporary filesystems how will PDQPRIORITY=100 be aff…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
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: 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
Thanks, will give that a go, > NUMCPUVPS 3 > MULTIPROCESSOR 1 > SINGLE_CPU_VP 0 Are these in the informix.conf file?? Where do I increase the buffer? and what to? Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8iqbps$f1j$1@news.xmission.com... > > From: "Kirk D…
Performance Tweaking
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) …
Number of LRUs, Cleaners & Buffers
I'm running informix 7.30 UC6 on a 4cpu Server (the engine is db- and app-server, 3 cpus are affinated, AFF_NPROCS=3), acutally I have 8 LRU-Queues and 4 cleaners. In a statement from Art S.Kagel I read that "If bufwaits exceeds 7% of (pagreads + bufwrits) you are probably suffer…
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…
Re: Setting VP parameters
From: "Vinod Bhansali" <iiug@hotmail.com> > >We have following settings in onconfig : >NUMCPUVPS 5 >AFF_SPROC >AFF_NPROCS > >Isn't it neccessary to bind the CPU VPs? > >What is your opinion? No it isn't necessary. On some platforms, it isn't even supported. Anyway, it doesn't bi…
CPU vps & affinity parms
MULTIPROCESSOR 1 (if server dedicated for DB) NUMCPUVPS 2 (there are recommendations NUMCPUVPS=#HWCPUS if #HWCPUS <=3) IMHO NUMCPUVPS 1 maybe would be better cause 2 CPU isn't 4,8 and more - overhead may be greater then benefit SINGLE_CPU_VP 0 - depends on NUMCPUVPS NOAGE 1 (if …
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…
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…
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
KAIO in AIX
Andre Ngo wrote: > > In article <8b56nk$n5q$1@hyppo.gu.net>, > "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> wrote: > > Andre Ngo <andre@fiscal.org.jm> wrote in message [SNIP] > > Number of kio threads is equal to the number of CPU virtual > processors in > > IDS (NUMCPUVPS param in …
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…
Re: Long checkpoints with no obvious cause
One sore thumb is the RA_THRESHOLD. Try 30 instead of 8. Also, the 1, 2 and 0 for multiprocessor, numcpuvps and single_cpu_vp. Nona…
Re: AFF_SPROC + AFF_NPROCS
D.Penfold@Libertel.nl wrote: > > Does anyone out there have any warnings/advice re: setting the above > parameters? You really need to supply your platform, engine version, etc. details. Different platforms display different characteristics. You could then get some actual experi…
RE: AFF_SPROC + AFF_NPROCS
Dominic, My particular experiences has seen a significant performance improvement at all the sites I've set the AFF's parameters. I set AFF_SPROC to 1 rather than 0 - just in case there are special requirements for the first CPU and AFF_NPROCS to one less than the total number. I…
Re: AFF_SPROC + AFF_NPROCS
From: D.Penfold@Libertel.nl > >Does anyone out there have any warnings/advice re: setting the above >parameters? I'm administering a system at the moment that has 6 cpus, and Sometimes they don't work. :-) >NUMCPUVPS set to 5, but neither of the AFF parameters are set. onstat -…
RE: AFF_SPROC + AFF_NPROCS
You did not state your platform. These parameters are not supported on all platforms. Their use should reduce UNIX overhead caused by context switching. They should not cause workload to be spread over different CPU VPs. Spreading NETTYPE connections over all CPUs can help to sp…
AFF_NPROCS + AFF-SPROC any advice out there?
Does anyone out there have any warnings/advice re: setting the above parameters? I'm administering a system at the moment that has 6 cpus, and NUMCPUVPS set to 5, but neither of the AFF parameters are set. onstat -g glo shows very uneven cpu vp activity, and top shows very uneven…
AFF_SPROC + AFF_NPROCS
Does anyone out there have any warnings/advice re: setting the above parameters? I'm administering a system at the moment that has 6 cpus, and NUMCPUVPS set to 5, but neither of the AFF parameters are set. onstat -g glo shows very uneven cpu vp activity, and top shows very uneven…
Re: NETTYPE
> From: Gerson Finlev <gerson@informix.com> > > > >NUMCPUVPS 2 (You should never have more CPUvps that processors) > > > >-- > >Gerson Finlev, Performance Engineering, i.informix Sorry disagree this used to be the case but with the faster processors e.g. 450M Sparcs y…
Re: NETTYPE
From: Gerson Finlev <gerson@informix.com> > >NUMCPUVPS 2 (You should never have more CPUvps that processors) > >-- >Gerson Finlev, Performance Engineering, i.informix Well, here's me picking a fight with someone from Informix, and a performance engineer, no less! I ag…
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…
NETTYPE
Pablo Herrero Fernández wrote: > > Hello everybody. > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next > values in ONCONFIG: > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype Make the above: NETTYPE soctcp,2,250,NET # 2 listene…
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…
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 …
Bug 104328 ? Bug 121447 ?
In article <81j41o$ch7$1@news.xmission.com>, michael martin <michael_martin@komatsu.co.jp> writes > >Hi list, > >Here I go again. > >My question is: Has anyone encountered Bugs 104328 and/or 121447 >and if so what is the fix ? > Not encountered but I belive they are fixed in 7.…
Processor Affinity on a 2 CPU HP9000
Is processor affinity supported in v7.22 on HP-UX 10.20? It is in v7.24, but wasn't in (I think) v7.13. Running v7.24 on HP-UX 10.20 on an HP9000 with 2 processors, and noticing long ready queues with onstat -g, I got good performance improvements by adding a second cpu vp (in …
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…
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: 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: Processor Affinity Sun 4500
Juan Ventua wrote: > Hello everybody!!! > > I have to configure two sun machine with following characteristics: > 2 sun 4500 > Solaris 2.6 > 12 cpus per 4500 > 12 gig memory per 4500 > 8 instances (4 instance per 4500) > Informix Universal Server 9.14 > > In your experience. I …
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
Processor Affinity Sun 4500
Hello everybody!!! I have to configure two sun machine with following characteristics: 2 sun 4500 Solaris 2.6 12 cpus per 4500 12 gig memory per 4500 8 instances (4 instance per 4500) Informix Universal Server 9.14 In your experience. I should configure binding CPU VP's to pro…
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: KAIO on Sun and CPU question
dianne.pendleton@autodesk.com wrote: > > Another related question. > > This server has 2 cpu's. Following Informix's guidelines, I have the > database set up as a single-processor server. This server is only used for > one application, Remedy. There is only one database. > Wha…
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…
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…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
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…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
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…
Re: Setting NUMCPUVPS
From: Webber Valerie H <Valerie.H.Webber@m1.irs.gov> > >Can you set NUMCPUVPS = physical number of CPUs? > >We have 4 CPUs but were told that NUMCPUVPS should be 1 less than the >physical number. Are there any risks at setting it to the actual number of >CPUs? I would make a wit…
Setting NUMCPUVPS
Can you set NUMCPUVPS = physical number of CPUs? We have 4 CPUs but were told that NUMCPUVPS should be 1 less than the physical number. Are there any risks at setting it to the actual number of CPUs? Thanks in advance.... :) Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 7…
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.…
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…
Re: Affinity
FYI.. On Solaris, if one want to use O/S Process binding then do following - onstat -g sch will give you the pid of CPU VP - Use "pbind -b" command to assign the pid of CPU VP to specfic CPU which you can collect from "mpstat" command. - Also if you want to see that your CPU …
Affinity
Hi , I am looking more information about the use of affinity. I have a Sun 2.6 with 14 cpus and the definition listed below. Does anybody can help where I can learn more about it ? Thanks in advance, fred > NOAGE 1 # Process aging > AFF_SPROC 0 …
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…
RE: NUMCPUVPS question
Doug This is a "it depends upon what else is running on your server" question. If NUMCPUVPS is the number of CPU's, then it is possible that Informix could gain short term control of all CPU's, starving other processes (particularly OS) on the system. If you have 2-4 CPU's then …
NUMCPUVPS question
Simple question, but possibly an answer to our performance problems: What would be the possible effects of having NUMCPUVPS equal the number of physical CPUs in a database server?? I contend that this would cause the other oninit processes (the server side of the connected clie…
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.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
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…
Question about IDS scalabiltiy
NUMCPUVPS = (physical CPUs) - 1 Informix can utilize any number of CPUs that have been defined within the ONCONFIG file. John Carlson Informix DBA WHSmith USA Carlos Bolden wrote: > > What does ( how many processors ) can Informix ( IDS 7.3 ) scale to for > optimum processing.…
Memory Usage on Informix 7.24
LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…
V7.31 Processor Affinity
Can someone please give me some definitive info on processor affinity. We are running IDS V7.31 on HP-UX 10.20. Database of 440 tables, mainly OLTP, some DSS-type queries, 4GL applications running on the same machine as the DB server, all raw disk, fragmentation by expression use…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
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…
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: INFORMIX and utilization of system resources on HP-UX 10.20
Vic Goldberg wrote: > > Without doing an exhaustive analysis, I've noticed a number of problems with your onconfig. > > NOAGE 1 # Process aging > AFF_SPROC 2 # Affinity start processor > AFF_NPROCS 2 # Affinity number…
Re: Re[4]: Long checkpoints (LRU_xxx_DIRTY/LRUS)--NETTYPE va
Hi, > Thanks already for your recommendations ! Further details follow : > > PHYSICAL LOG OVERFLOW : > ------------------------ > We never have checkpoints caused by the physical log being 75% full as > our physical log is so big (250M). Physical log overfl…
Re: Re[2]: Long checkpoints (LRU_xxx_DIRTY/LRUS)--NETTYPE values
> Our physical log is 250 MB, which is quite big (but I want to avoid > physical log overflows by all means). The value for LOGBUFF is 128. Hm. I've never heard of a _physical_ log overflow. I take it then that you never have the physical log kick off a checkpoint? Perh…
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…
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…
Multiprocessor IDS on Linux?
The release for IDS 7.30/Linux state that NUMCPUVPS is limited to 1 as the kernel does not support MP architecture. This seems to be contradicted by the Linux kernel notes, which state that Intel MP 1.1 and 1.4 are supported by Kernel 2.0.36. Does anyone know if a multiprocessor …
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
RE: Processor Affinity
On AIX you can set processor affinity with the bindprocessor command. We run a script at start-up time to accomplish it. -----Original Message----- From: David Meyer [mailto:dmeyer9@email.msn.com] Sent: Wednesday, February 17, 1999 23:51 To: informix-list@iiug.org Subject: Re: P…
Re: Processor Affinity
Mike, I tried to do this on an AIX system and it did not support it. I found out that some versions of Solaris did. My experience is that this is more of a programming capability. Where you can kick off threaded processes and bind them to a processor. Because of this (for so…
Re: Processor Affinity
Mike Segel wrote: > Processor Affinity isn't a good idea. > It defeats the purpose of SMP and while some may say its the greatest > thing since sliced bread, its like stored proceedures. Use it when > necessary. > The question is really one of scheduling. > Does SunOS (Solaris)…
RE: NUMCPUVPS entry in onconfig.gic
As per Informix documentation, on a 2 processor system, you may do a benchmark to determine whether NUMCPUVPS should be 1 or 2. "The number of CPU vps should match the number of physical CPUs on the server if MULTIPROCESSOR is set to "Y" and process affinitization is not used. I…
Re: Processor Affinity
Mike Segel wrote: > > Processor Affinity isn't a good idea. > It defeats the purpose of SMP and while some may say its the greatest > thing since sliced bread, its like stored proceedures. Use it when > necessary. Care to elaborate, and answer a long unanswered question: How doe…
NUMCPUVPS entry in onconfig.gic
We are going to load Informix ODS 7.3 on DEC ALPHA 4000 Server with 2 processors. What should be the NUMCPUVPS entry in this case?. Informix recommends this value to be one less than the total no of processors. When we are running on a single processor machine, the entry is 1 in …
NUMCPUVPS entry in onconfig.gic
We are going to load Informix ODS 7.3 on DEC ALPHA 4000 Server with 2 processors. What should be the NUMCPUVPS entry in this case?. Informix recommends this value to be one less than the total no of processors. When we are running on a single processor machine, the entry is 1 in …
NUMCPUVPS > 0, AFFINITY not set
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…
Processor Affinity
Does anyone have any experience and recommendations regarding the use of processor affinity for a multi-cpu Sun E6500 database server supporting a high traffic web site running IDS 7.30UC3. I have heard arguments for and against its use where I am attempting to reduce or elimina…
Performance Tuning
zandy@skyinet.net wrote: [snip] I just picked some "obvious" things and you should know (as others pointed to) that tuning can't be done in this quick and dirty way. > BUFFERS 1000 BUFFERS is dirty low! If vmstat shows free memory increase BUFFERS. If the machine runs…
NUMCPUVPS on 4 CPU Sun Hardware
Hi everyone! I was wondering how many CPU VPs to allocate on a 4 CPU Sun Hardware. I've read somewhere that some Operating Systems use a particular CPU for interrupts. Is Solaris such an OS? Anyway, my question is: Should I allot 3 or 4 CPU VPs? TIA, Zandy -----------== Pos…
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…
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
Performance degraded after detaching indexes / fragmentation
Possibly you have hit the limits of your little SMP (4 CPU?). Or if you got them, jack NUMCPUVPS up and check the parallel processing parameters in the ONCONFIG. Time for more CPUs. Fragmentation splits up stuff so more parallelization can happen. but it won't happen if you do…
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…
Informix Perf - NCR
Using Online Dynamic Server 7.30 UC5 - we are trying to decide if the database server will perform better using 12 - 166 MHZ processors versus 16 - 90 MHZ processor boards on an NCR 3555 running MP-RAS 3.02 with 2 GB RAM. Does ODS perform better with more processors, howbeit slow…
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 …
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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 'nam
My Informix On-line Dynamic Server (7.2) classroom material dated 01-97 states: "Only one protocol can run a poll thread on a CPU VP." Has this restriction been removed in IDS 7.3? -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, October…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
> >From: dengelsen@my-dejanews.com > > > >Informix (7.23) produced the following error in the message Log File: > > > >CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads > started on > >NET VP's. > > > >What does this message mean? > >What must I do to solve it? It…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
Hi Detmar, What's your plattform? --babak >From: dengelsen@my-dejanews.com >To: informix-list@iiug.org >Subject: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......? >Date: Mon, 26 Oct 1998 16:48:48 GMT >Reply-To: dengelsen@my-dejanews.com > >Hello, > >Informi…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
dengelsen@my-dejanews.com wrote: > > Hello, > > Informix (7.23) produced the following error in the message Log File: > > CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on > NET VP's. > > What does this message mean? You have requested that your poll th…
What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
Hello, Informix (7.23) produced the following error in the message Log File: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on NET VP's. What does this message mean? What must I do to solve it? Thanks for the help Greetings, Ditmar den Engelsen --…
Re: Best database for web backend on Linux?
In article <70tntl$ftl$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: >There are 2 main ways that systems use multiple CPUs to speed query >performance. The 2 main methods are spearheaded by Sybase and Oracle. >Sybase forms data affinity to a processor, while oracle defaul…
Re: Best database for web backend on Linux?
There are 2 main ways that systems use multiple CPUs to speed query performance. The 2 main methods are spearheaded by Sybase and Oracle. Sybase forms data affinity to a processor, while oracle defaults to using a queue, such that all processors can perform parts of a query in p…
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…
hp-ux VCPU Bind processors. Does this work ?
Hi, I am running hp-ux 10.20 with Informix 7.24UC6 I have used the bindprocessor comand on RS6000s before to pin VCPUs to processors before with great success ( Thanks Art K ! ) Processor affinity is not supported on hp-ux 10.20. Is this because hp-ux cannot pin processes…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
Re: processor affinity
jblatz@worldnet.att.net wrote: > > Our Unix machine has 4 processors. According to the release notes for Online > ver 7.24, my operating system supports Affinity. However, when I set the > affinity parameter in the onconfig file to anything but 0 (I forget the exact > name of t…
processor affinity
Our Unix machine has 4 processors. According to the release notes for Online ver 7.24, my operating system supports Affinity. However, when I set the affinity parameter in the onconfig file to anything but 0 (I forget the exact name of the parameter), I get a message in the onl…
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…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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…
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? > …
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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…
Re: NUMCPUVPs,ONINIT
In article <6nqntp$qad$1@news.xmission.com>, Sadagopan, Sathish <sadagop0458@att.com> writes > >Hi, >Two questions. >1) Values AFF_NPROCS,AFF_SPROC,NUMCPUVPS have been set to take >advantage of 6 cpu's.Now, when two of the cpu's are unavailable due to h/w >failure.What happens to…
NUMCPUVPs,ONINIT
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: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
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: 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!
In article <3572124d.141336500@news>, David Kosenko <dkosenko@monmouth.com> writes >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 #…
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: +…
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…
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…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: slow performance
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …
Re: raw Vs kernel aio
David Williams wrote: > In article <01bd537d$be79c270$bb3c2ba0@prn100-02-682e>, Bloomberg L.P > <LOGIN_ID@bloomberg.com> writes > >David Williams <djw@smooth1.demon.co.uk> wrote in article > ><NXzCuMAuFDE1Ewdv@smooth1.demon.co.uk>... > >> In article <350CE08F.44902F25@email.mot…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
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: Read Cache, NUMCPUVPS
jeff, : Can someone explain what happened here? Are the numbers : "rolling over"? yup. it rolled over. no problems. do an onstat -z to zero out the profiles if you don't want to look at those negative numbers. it would be nice if this was fixed, as there is no reason that…
Re: NUMCPUVPS settings for a four-processor server
Bill Border wrote: + We have found that in the case of systems with very fast CPU's that + there are times that you need to set NUMCPUVPS to more than the number + of physical CPU's. We have a T600 with 10 CPU's where we configure + 15 CPU VP's and we still cannot drive the al…
Re: Read Cache, NUMCPUVPS
In article <6cunjh$ird$1@nnrp1.dejanews.com>, jeff.w.mcclure@ameritech.com writes >Hi, > >I'm relatively new to Informix and have two >questions that I need answers to. > >Sparc 20 running Solaris 2.4 >Informix ODS 7.11.UC1 > >First: >I checked the instance profile last night (on…
Re: Read Cache, NUMCPUVPS
jeff.w.mcclure@ameritech.com wrote: > > Hi, > [cutting] > > Second: > Since this is a development machine, we decided to bounce > the instance. Great! I wanted to check out the effects > of adding a second cpu vp. This is a multiprocessor (2) > machine! I set NUMCPUVPS to 2, M…
Re: Read Cache, NUMCPUVPS
jeff.w.mcclure@ameritech.com wrote: > > Hi, > > I'm relatively new to Informix and have two > questions that I need answers to. > > Sparc 20 running Solaris 2.4 > Informix ODS 7.11.UC1 > > First: > I checked the instance profile last night (onstat -p) > and all looked great. dsk…
Read Cache, NUMCPUVPS
Hi, I'm relatively new to Informix and have two questions that I need answers to. Sparc 20 running Solaris 2.4 Informix ODS 7.11.UC1 First: I checked the instance profile last night (onstat -p) and all looked great. dskreads, pagreads were both very low, Buffreads was very hi…
Re: NUMCPUVPS settings for a four-processor server
In article <6ck1q1$p40@drn.newsguy.com>, Neil Truby <?@?.?> writes >I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes >of memory and 4CPUs. One server is heavily-used and performance is optimal, the >other is lightly used. > >I am planning to set u…
Re: NUMCPUVPS settings for a four-processor server
We have found that in the case of systems with very fast CPU's that there are times that you need to set NUMCPUVPS to more than the number of physical CPU's. We have a T600 with 10 CPU's where we configure 15 CPU VP's and we still cannot drive the all CPU's to 100% busy. Whe…
Re: NUMCPUVPS settings for a four-processor server
Gee, This goes back to what I was saying. When tuning a system, you shouldn't rely on the number of CPUs a system has. It doesn't matter. You have one proc stack, and one memory pool. -Mikey Bill Border wrote: > > We have found that in the case of systems with very fast CPU'…
NUMCPUVPS settings for a four-processor server
I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes of memory and 4CPUs. One server is heavily-used and performance is optimal, the other is lightly used. I am planning to set up the heavily-used server with NUMCPUVPS=3 (one less than the actual num…
waiting for SEM
Hi I am running oncheck -cD and cI on my sap dbs and they take ages to complete. Its a 2 cpu box and I've configured Informix for 2 cpus. (NUMCPUVPS, MULTIPROCESSOR). glanceplus shows that the process is waiting for SEM. What needs to be changed? TIA Deepa…
Re: 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…
Re: KAIO
rt wrote: > > Whats the real story on KAIO and HP 10.20. Most posts list better > performance with KAIO. When post report decreased performance it > usually is fixed by correcting the configuration. Is there a split > camp on KAIO?? The concensus is that KAIO is better than AIO …
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…
Re: NUMCPUVPs and number of physicial processors
In article <19980110014000.UAA07693@ladder02.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >conflicts occuring at the OS level. By increasing the number of CPUVPS, there >is a higher probability that the CPUVP process will go into a block state and >raise it's priority. Thi…
Re: NUMCPUVPs and number of physicial processors
> > We are migrating our Informix 7.23 systems from a SUN 2000 with >14 processors (88 Mhz) to a SUN 6000 with 10 processors (250 Mhz). In >our current configuration, we have : > >NUMCPUVPS = 12 >CLEANERS = 12 >LRUS = 12 > > We do not use processor affinity. > > The system is pr…
Re: NUMCPUVPs and number of physicial processors
Well, keep in mind Informix can't burn 10 CPU's worth of cycles unless it has 10 CPUVP's. Heck, consider the extreme case of a Sun E10000 domain, that you might dynamically add or remove CPU's from. I'd probably set CPUVP's to the most I thought that domain would ever see. If …
Re: NUMCPUVPs and number of physicial processors
On the Sun architecture, it is generally a good idea to have the CPUVPs <= CPUs. Informix recommends that you use a number that is a multiple (or factor) of the number of DBspaces. -d "May, James" wrote in message <695pub$rui@cssun.mathcs.emory.edu>... >Gurus, > > We are migra…
NUMCPUVPs and number of physicial processors
Gurus, We are migrating our Informix 7.23 systems from a SUN 2000 with 14 processors (88 Mhz) to a SUN 6000 with 10 processors (250 Mhz). In our current configuration, we have : NUMCPUVPS = 12 CLEANERS = 12 LRUS = 12 We do not use processor affinity. The system is primari…
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
Barry Leb wrote: > <snip> > memory and 2 cpus. The OS is HPUX 9.04. The disks are the HP versions <snip> Hi-Barry, If your machine have only 2 cpus and you have NUMCPUVPS set to 2, then your performance could be affected. That could be the reason why your dbimport is taking…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Re: Major performance problems with Informix Online
On Sat, 25 Oct 1997 09:36:44 +0100, David Williams <djw@smooth1.demon.co.uk> wrote: ... cut ... >>>2. NUMCPUVPS looked ok, even low, I've heard use (CPUs - 1) as the rule? >> >> If your computer have something else to do except to run the >>database you should leave som…
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…
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…
Dual Instances
We have an RS/6000 4-CPU SMP machine running AIX 4.1.4 and Informix version 7.12.UC2. We also have another RS/6000 machine (single processor) running AIX 3.2.5 and Informix version 5.02.UC9. What we'd like to do is to upgrade our version 5.02 to 5.08 and install it as another ins…
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…
Two Instances on Multiple CPU Machine
Hi , I have a quick couple of questions. We have a SUN machine with SUNOS having 4 CPUs. There is already one instance of Informix(7.2x) up-and-running which uses 2 cpus (1 and 2) by setting AFF_SPROC etc and all other parameters. The second instance of Informix has been config…
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…
Re: Informix and NOAGE
Saeed Talebbeik wrote: > > Both NOAGE and processor affinity can boost the performance. > However look into the machine notes of your platform to see if these two > features are really supported. Apparently on HPUX NOAGE is supported. > > I suggest to experiment with NOAGE and se…
Re: What is the best platform for Informix 7.x?
David Williams wrote: > > In article <33bbe71d.24655512@gate.idg.no>, Nils Myklebust > <Nils.Myklebust@idg.no> writes > >Michael Silver <michael.silver@telequestcorp.com> wrote: > > > >:What is the best platform for Informix Online? We currently run on HP-UX > >:10.01, and have …
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…
What is the best platform for Informix 7.x?
What is the best platform for Informix Online? We currently run on HP-UX 10.01, and have a ton problems. HP has problems with shared memory, aging, and processor affinity. Sun has been recommended since Informix development is done on Sun, and then ported over to other platfor…
Re: OnLine DS installation
In article <5lsk1k$p82@cssun.mathcs.emory.edu>, "Walter S. Tyszka" <walt@wst.b30.ingr.com> writes >} When having two instances of OnLine DS running on same machine will I >} have to edit the onconfig parameters that deal w/shared memory(SHMBASE >} etc.)? Yes you will need two …
Re: OnLine DS installation
} When having two instances of OnLine DS running on same machine will I } have to edit the onconfig parameters that deal w/shared memory(SHMBASE } etc.)? } Also when dealing w/processor affinity and multiple instances of OnLine } Should I set AFF_SPROC 0 for on instance and 1 for…
OnLine DS installation
When having two instances of OnLine DS running on same machine will I have to edit the onconfig parameters that deal w/shared memory(SHMBASE etc.)? Also when dealing w/processor affinity and multiple instances of OnLine Should I set AFF_SPROC 0 for on instance and 1 for the other…
Re: Checkpoint duration increase with 7.22.UC1
In article <5lak28$ssn@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: Checkpoint duration increase with 7.22.UC1
In article <5kq94e$o4q@cssun.mathcs.emory.edu>, Kernoal Stephens <kernoals@earthlink.net> writes >I recently upgraded from 7.13.UC2 to 7.22.UC1. > >With 7.13.UC2 my checkpoint duration was averaging 4.5 seconds. >I used the same onconfig settings with 7.22.UC1 and my average >che…
Re: NUMCPUVPS and Fragments
Since one scan thread tends to be associated with one fragment, I would (for maximum performance anyway) go with lots of fragments, and let the thread dispatching algorithm sort 'em out. If the threads aren't there, the work can't get done, so load em up I say... Remember, you…
NUMCPUVPS and Fragments
On page 2-11 of the Informix Performance Guide Manual (Ver. 7.2), it states that "queries perform best when the number of scan threads is a multiple (or factor) of the number of CPU VPs". It then gives the example of having 6 CPU VPs, and a table with 10 fragments, and suggestin…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
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: SCO Unix and Informix 7 Performance
Kai Shen wrote: > > Hi all, > > we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine > is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB > (plus duplexed). The system is mainly used as OLTP (80%), our onconfig > says: > MULTIPROCESSOR 1 …
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: SCO Unix and Informix 7 Performance
In article <334E8ADA.6CFD@ccmail.acer.de>, Kai Shen <kai_shen@ccmail.acer.de> writes >Hi all, > >we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine >is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB >(plus duplexed). The system is mainly use…
SCO Unix and Informix 7 Performance
Hi all, we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB (plus duplexed). The system is mainly used as OLTP (80%), our onconfig says: MULTIPROCESSOR 1 NUMCPUVPS 1 LOCKS 300000 BUFFERS …
Re: Informix 7.22 pdq questions and ONBAR problems
On 9 Apr 97 at 1:21, markc@osem.co.il wrote: > 1) Performance with PDQ > So far the only solution is I run informix with only 2 out 3 cpus > leaving one for unix work, but this is a great waste as the unix work > only needs about 20% of one cpu and not all of one. Or to only en…
Re: Processor Affinity
Laurence E. White wrote: > > Sean, > > If your HP is strictly a database server, I would try 4 or perhaps even 5 > CPU VPs. > Larry > > P.S. I have not seen the use of Affinity improve performance anyway. In fact, I don't think affinity is supported under HP-UX Ian…
Re: NUMCPUVPS
Edward Bidinotto <edbid@cobe.com> wrote: >I've been getting some wierd errors when running oncheck -cI against a >17mil row table. >I've dropped, recreated the table/indexes but continue to get the >following errors. >"could not check rowids and perform data <=> index check >"…
Re: Processor Affinity
Hi there, the only real problem I have had is when there are system calls within SPL triggers etc. The system calls are also affinitied to the processor where they were generated. This can basically leave real spare capacity on the other processors. ESQL/C programs can usuall…
Re: NUMCPUVPS
Ed - I'm not intimately familiar with HP, but both your engine and OS release sound pretty old. I'd get as current as possible first, then pursue the problems. At that point, you should be able to run with NUMCPUVPS = physical processors. If you can't its a bug - beat on Info…
NUMCPUVPS
I've been getting some wierd errors when running oncheck -cI against a 17mil row table. I've dropped, recreated the table/indexes but continue to get the following errors. "could not check rowids and perform data <=> index check "unknown error message 0" We are running 7.11uc1…
Processor Affinity
Sean, If your HP is strictly a database server, I would try 4 or perhaps even 5 CPU VPs. Larry P.S. I have not seen the use of Affinity improve performance anyway.…
Re: Processor Affinity
We are running 7.21 on HP-UX, and although it does not support processor affinity per the 'documentation', we had an Informix rep give us some code that actually binds a certain process to a specific processor. When we tried this, we had 6 processors and were running 3 CPU VP's.…
Re: Processor Affinity
David Williams wrote: > > In article <5daceu$sun@cssun.mathcs.emory.edu>, Jon C Vemo > <jvemo@cyberspace.com> writes > >At 08:52 AM 2/5/97 -0500, Steve Romankiw wrote: > > >>Below are setting taken from my onconfig: > >># > >># Our Sun server has four processors > > Sounds like…
Re: Processor Affinity
In article <5daceu$sun@cssun.mathcs.emory.edu>, Jon C Vemo <jvemo@cyberspace.com> writes >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 th…
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…
Processor Affinity
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 week, we will be jumping to over 300 concurrent users. …
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
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: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
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: 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
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…
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: 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: 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. …
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
How do I .... ?
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. …
Processor Affinity prob on 2cpu SparcServer
hi, i've recently found a bug in the 7.1X online server, and want to know if anyone else has run across this. it has been listed as a bug with support, but i don't know what kind of time frame to expect a fix here. on the sparcserver 20, there are two slots for cpus. you ca…
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?…
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…