Oninit® Archive
Results for “onstat -g iov”
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 ------------------------------…
DIRECT I/O (KAIO) Disabled in RHEL 9
Boycho: Just a note on your comment that "when I see more than 1 AIO VP I feel uncomfortable". Note that the AIO VPs handle all flat file IO that is not under DIRECT_IO. That includes: The message log The console log Audit files af file output SET EXPLAIN output and a handful of …
flags (onstat -g ses)
Hello - Yes , the flags showed no waiting for Lock or for another ressource - PDQ is set to 10% - 20 vp CPU with eff around 50% - mpstat shows no cpu with 100%, but i will run it again at different times onstat -g glo Individual virtual processors: vp pid class usercpu syscpu tot…
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…
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…
High CPU IO Wait
Hi, We are having recently having some CPU IO Wait issues. The CPU IO Wait value stays arount 15% . I've also noticed that CPU Eff is very low: IBM Informix Dynamic Server Version 12.10.FC7 -- On-Line -- Up 231 days 02:25:26 -- 5343628 Kbytes MT global info: sessions threads vp…
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…
IDS AIX to RHEL/Intel
Linux runs Informix well. Just note the following caviats: - You need to test DIRECT_IO versus RAW as the specific configuration can affect IO performance on Linux. - Same with configuring Kernel Asynchronous IO at the OS level. Without tuning it may not perform well and DIRE…
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Slow Bulk Loading problem
Hi this is the result of onstat -g glo MT global info: sessions threads vps lngspins time 3 34 9 0 93014 sched calls thread switches yield 0 yield n yield forever total: 448381298 447128835 2435982 2300468 228252272 per sec: 0 0 0 0 0 Virtual processor summary: class vps userc…
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…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Efficiency of the Informix Virtual Processors
Hi Jason, No Affinity. The configuration what we work the lasts months is 2 CPU VPs for each CORE (where have 4 smt), so... 50% of the virtual AIX CPUs. My change is exactly over this, I try work with 1 CPU VPs for 1 CORE CPU, but I not seen effect over the efficient (onstat -g …
Monitoring IDS Load
For load/strees testing - versus normal performance monitoring - I would concentrate on the stats displayed by onstat -D, onstat -p (including calculating the basic metrics - BR, BTR, and RAU), onstat -g iov, onstat -g iof, onstat -g ppf, onstat -g seg as well as operating perfor…
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 …
Informix doesn`t start
Ok, Hope i wont put a lot of trash. ol_ids.log 14:10:33 Action: Please notify IBM Informix Technical Support. 14:10:33 stack trace for pid 1312 written to C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.404cf29 14:10:47 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.…
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
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…
onstat -g glo: cpu efficiency
I am a bit concerned over what onstat -g glo is reporting regarding eff for the three cpuvp's , they are avg in the mid 60's. Other instances in our client's landscape have all three much closer to 100% (however those instances are no where near as heavily loaded as this one). C…
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.…
Is KAIO in use
KAIO is not a VP but a thread running on the CPU VP. You can see the KAIO threads using onstat -g ath onstat -g glo shows the list of all of the VPs running in your instance. onstat -g iov does not show the actual VPs; only the thread names running on VPs performing IO (kio, a…
Physical Log Size
Metrics look good. More buffers will probably help a bot more as s BTR over 6 is ok but bit high, so try increasing buffers again. The RAU is over 100 because you got the formula from an old post where I did it backwards. Divide the used by the sum of the other RA values. Art O…
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…
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…
SQL running too slow in IDS 9.4
Hi All, This has been asked again and again.. I'm curious how can i tell that i need to do the ff: 1. Update statistics -- this just been executed during the weekend, 5 days now. 2. How can i identify what causes excessive memory use? i did onstat -g mem, onstat -g iov for virt…
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
Yes, NULAIOVPS was replaced by VPCLASS aio..., but it still works if you use it instead. If both are present VPCLASS aio takes precedence. Anyway, from your onstat -g iov output it looks like the windows version of Informix is using the KAIO threads for IO even for cooked filesys…
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_…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Seeing one oninit working hard while others are no
Database server: Database:/home/informix>onstat -g glo IBM Informix Dynamic Server Version 11.50.FC3 -- On-Line -- Up 4 days 09:51:55 -- 6104464 Kbytes MT global info: sessions threads vps lngspins 692 850 22 117863 sched calls thread switches yield 0 yield n yield forever to…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
Re: a little help with query.
No it's not, it's in it's own dbspace. I tried however ( on a test server ), to drop the index and create it without any "in" clause, so that it would follow the fragmentation of the table. That didn't buy me any performance gains. ----- Original Message ----- From: "david@smoo…
RE: a little help with query.
So about 84k records in the table match that profile_token. Not very unique. The query didn't run any faster when I removed the not null clause. So I guess this is a disk type performance issue. My onstat -g iov has the inverted pyramid. Don't know why else it would take so long…
HDR (crash recovery)
If you run in ASYNC mode, then HDR will not send the HDR log buffers un= til either the HDR buffer is full or the age of the buffer reaches the age = of DRINTERVAL. In order to ensure that the transaction reaches the secondary as part o= f the commit, you must 1) use unbuffered …
Long Spins
Hi, The IBM IDS document says: "To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features." But wait for other to advice you, I'm sure the IDS guru's will suggest you a so…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Buffer Turnover Ratio (BTR)
The Remaining outputs are as follows onstat d IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:38:41 -- 1548288 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 11c65c028 1 0x40001 1 2 2048 N B informix rootdbs_05 1…
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…
onstat -g iov
No doubt the real answer is RTFM. But, can anyone give me or point me to a good description of the i/o -wakeup ratio, and why 0.5 is "good"?: onstat -g iov -r 5 IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 81 days 06:27:37 -- 46892464 Kbytes AIO I/…
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…
Re: Raw Disk still preferred for 11.5?
Superboer wrote: > Hello Fernando, > > does DIRECT_IO bypasses the filesystem cache??? using cooked can kill > performance because linux/unix is being hit > (to) hard. Yes, but look for further comments below. > one example is do a restore on char mode raw dev and cooked spec…
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…
Re: Long checkpoints
askel wrote: > Obnoxio, > > Thank you for the advice. It doesn't seem to be dangerous but could > you tell me how do I reverse the effect of executing that command or > how do I check what is the currently used value? We do have backups > but restoring the database is last thing …
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…
load distribution to kio vps
IDS: 11.10.FC2 I am seeing slow performance and when I look at onstat -g iov I see that out of 28 kio vp only 2 are super busy. Below is the snapshot (first 2 have 107 and 136 io/s): kio 0 i 107.7 27388858 15142656 12246202 0 45203359 0.6 0 0 kio 1 s 13…
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…
Urgent help requested
If multiple instances try and kill -9 on pid for cpu: $onstat -g glo IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 08:22:30 -- 165984 Kbytes MT global info: sessions threads vps lngspins 0 24 12 5 sched calls thread switches yield 0 yield n yield forever tota…
onstat -g rea almot 100 queue there !!!
>Yes, you've got it. You are correct, your chunks certainly do look like >they are RAW and so KAIO should be working for you, but, as I said, it's >not. Your onstat -g iov output does not show any kio threads running. KAIO >is on by default on all platforms except HPUX (because H…
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: help with slow archive please
we have had some network issues. The sars don't look different or excessive. We are doing a full archive every night, and the database hasn't grown much since last week, so that's not it. I am trying to be able to intrpret the onstat -g stq so that I can hopefully see if the tap…
Re: help with slow archive please
On 21/05/2008, Floyd Wellershaus <floyd@fwellers.com> wrote: > Hi, > Doing onbar archive to Tivoli 5.3 with IDS 10.0.UC5 on aix5.3, to a 3490 > tape library. > > All of the sudden our archives are taking much longer. Don't see why, and > am trying to Troubleshoot. Our onstat -g …
help with slow archive please
Hi, Doing onbar archive to Tivoli 5.3 with IDS 10.0.UC5 on aix5.3, to a 3490 tape library. All of the sudden our archives are taking much longer. Don't see why, and am trying to Troubleshoot. Our onstat -g iov is looking good. I remember that there is an onstat -g stq, that wil…
Informix database virtualization
Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
Re: long checkpoint duration
Hi Floyd, tell me what onstat -C shows you? Also onstat -C hot |wc -l would be nice as well. One of the bigger culprits in the old days was the btcleaner thread since it has to clean indices for the who instance, and the current defaults help make the btscanner thread just as b…
Re: long checkpoint duration
Floyd Wellershaus wrote: > Hi, > The age old question I guess. But our checkpoint durations are > consistently near 20seconds. > > ids10.0 fc5 on ibm p570 running aix 5.3 7 cpus 41g ram. > ckptintvl is 300, I am considering halving that. > We have 128 lru's and 128 cleaners > A…
long checkpoint duration
How many partitions are being accessed? Lots of partitions will cause the checkpoint to slow because they have to be flushed out. Have you thought about moving to Cheetah? The non-blocking checkpoint for heavy oltp systems will remove this problem. Customers moving to Cheetah ha…
checkpoints Excessively slow
KAIO: out of OS resources, errno = 11, pid = 20801 You have some problems with Kernel Asynchronous I/O... Check in the /usr/include/errno.h to see what is the error 11 and contact your system administrator in order to looking for error messages in the system logs. ____________…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Re: long checkpoints
On Nov 21, 10:23 pm, TBP <TheBigPot...@NotHere.Co.Uk> wrote: > Art S. Kagel wrote: > > On Nov 21, 8:46 am, Apostrof <abdullah.ako...@gmail.com> wrote: > > <Previous post SNIPPED> > >> Hi Art, > > > Hi, > > > Your server's healthy overall. Metrics look good: > > > BR = 3.68 > > B…
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…
HDR or storage remote mirroring, which is better?
On 7 31 , 1 14 , "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Alexey Sonkin" <alex...@cidc.com> wrote in message > > news:mailman.543.1185857557.13675.informix-list@iiug.org... > > >> Another consideration: > > The database can span across many storage processors in a single…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
HDR performance to remote site with IDS 10
MIKE SLAUGHTER said: > > We have tried our first IDS HDR pair over a remote link with both servers > connected over a 2Mb/s link with a latency of around 10ms. Replication is > set > asynchronously. Data is being loaded into few tables only from an old SE > db > that the new inst…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
configuration problem
Hi, see the Machine Specific Notes in $INFORMIXDIR/release/en_us/0333/... It has (among other things) the following info for you: ------------------------------------------------------------------ ... 3. The IBM Informix Dynamic Server requires that the drivers for - Portable …
RE: - RE: Informix Java problems [8755] - Bayesian
I am just executing the jvpcontrol function, to monitor my Java stored procedure. Regards, Kenneth Penza Systems Engineer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailp…
Re: KAIO Question [8766]
Art, I did have our Techs configure one raw dbspace/chunk that I added within the instance to see if that made a difference, but it did not. -John -----Original Message----- >From: "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> >Sent: Mar 30, 2007 7:56 AM >To: ids@iiu…
Re: KAIO Question [8763]
Art, I agree, and having checked for the env variable "KAIO_OFF=1", made sure it was removed from the .profile, and confirmed I do not see it set anywhere else. I have bounced the engine, and confirmed it does not exist, but still do not see the KIO thread. Do I need to do som…
KAIO Question
IDS AIO VPs do NOT use OS Asynch IO facilities, they simulate asynch IO for cooked chunks. If you use RAW chunks there should be only a few aio vps configures and onstat -g iov will show one kio thread for each CPU VP. The only way you would not see KIO threads if all of your chu…
KAIO Question
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 DEV box with min and max AIX AIO 5, and 180 respectively, and it is…
Informix Java problems
People, I am running Informix 10.00.UC3W2 with Java on RHEL3. We are experiencing a problem that a Java UDR starts working and randomly it stops executing and the only way to get it working again is to restart the database server. Further to this I have executed onstat -g glo t…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
IDS and kaio on RHEL
10.0FCx and FC6 on RHEL 4 Be careful when installing IDS FCwhatever on very new versions of RHEL AS 4. The newest versions have the libaio module libaio-0.3.105-2 Trying to runIDS kaio with this gives: 17:43:04 libaio.so.1: cannot open shared object file: No such file or dir…
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…
Re: Pls help to tune my informix engine .. thanks
Henry wrote: > Hi gurus: > > I am using IBM Informix Dynamic Server Version 9.40.FC7 under a 6 CPUs > HP-UX server. > There are 57 dbspaces with a total of 85 chunks. > The informix engine is running very slow recently. > I was not sure whether it is the result of poor tuning or …
raw device on suse10.1
ruediger.papke@t-online.de wrote: > Hi, > > i did some simple tests because of the performance of different file > systems and raw device under suse linux 10.1 (uname -a: 2.6.13-4-smp) > and ids10.00.UC4. > > I was not able to bind a block-device to a raw device with the > raw-co…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: speed up onspaces utility
"Yunyao (Frank) Qu" <Yunyao.Qu@noaa.gov> wrote in message news:mailman.544.1158950128.20706.informix-list@iiug.org... > Art and Neil, > > It took about 20 minutes to initialize a 10 Gig dbspace. > > I just talked to SysAdmin. He thinks that the stripped raw disks may > be th…
ISD 10.UC5 installing on AIX 5.3
HI, We installed IDS 10 UC5 on AIX5.3. onstat -version: Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 oslevel: 5.3.0.0 My que…
ISD 10.UC5 installing on AIX 5.3
HI, We installed IDS 10 UC5 on AIX5.3. onstat -version: Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 oslevel: 5.3.0.0 My question is, to enable AI…
ISD 10.UC5 installing on AIX 5.3
HI, We installed IDS 10 UC5 on AIX5.3. onstat -version: Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 oslevel: 5.3.0.0 My question is, to enable AI…
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…
Upgrading server - Do i need to change config ?
"F. LACROIX" <soft @ datacolfrance.com> wrote in message news:44bf5959$0$891$ba4acef3@news.orange.fr... > Hello, > > I was running IDS 7.31 on a quite old PIII 800 with 1Go RAM, my boss > agreed few days ago to replace this old server by a brand new one ... an > HP Proliant ML350…
Informix KAIO Error
TBP, I done the steps that you sent me (set KAIOON=1 and install asyncdsk), but the error still the same What can I do to solve this problem ? Tks, Regards, Eduardo TBP escreveu: > cboccio@yahoo.com.br wrote: > > Hi people !! > > > > I have a problem with Informix 7.31 wit…
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…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
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/…
HP-UX KAIOON
I try to run Informix with async. kernel io on a HP Itanium 4 Processor Box running HP-UX 11v2 with Raw Devices. After all configuration steps no kio's showing in "onstat -g iov": IBM Informix Dynamic Server Version 10.00.FC4 -- On-Line -- Up 00:00:18 -- 5702588 Kbytes AIO …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: cannot start with 4 AIO virtual processor
On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …
Re: cannot start with 4 AIO virtual processor
informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…
Re: cannot start with 4 AIO virtual processor
BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…
Re: cannot start with 4 AIO virtual processor
"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…
cannot start with 4 AIO virtual processor
Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…
RE: MULTIPROCESSOR settings on a multiple CPU server with
>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…
FW: Informix versus Oracle Spatial
This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Crash of the instance
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Posting from the Informix-list
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Re: IDS 10 erratic run times
<david@smooth1.co.uk> wrote in message news:1127598536.808774.302800@g14g2000cwa.googlegroups.com... > > > 1. Try running onmode -F before each run (free shared memory > segments/blocks and general tidy up memory > structures). Could do, but never do before a non-kaio run at it …
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
IDS 9.4 install problem
never mind - I needed to change Asynchronous I/O from "defined" to "available". Thanks to those who already replied! -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of Danny Wright Sent: Tuesday, June 14, 2005 3:17 PM To: i…
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…
bad performance on delete
On Informix 7.23, when deleting records on large tables it goes very slow. What should we change to get better performance? $ onstat -p INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 01:06:01 -- 130680 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bu…
bad performance on delete
On Informix 7.23, when deleting records on large tables it goes very slow. What should we change to get better performance? $ onstat -p INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 01:06:01 -- 130680 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bu…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com wrote: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also updated. > When I tried to look in to the I/O activity, I could find that kio is > having maxl…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com wrote: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also updated. > When I tried to look in to the I/O activity, I could find that kio is > having maxl…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com said: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also > updated. But are they taking the *correct* index paths? I've had this exact problem, possibly…
Re: Informix Performance Issues
Anirudh Chitnis via DBMonster.com said: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also > updated. But are they taking the *correct* index paths? I've had this exact problem, possibly…
Re: Informix Performance Issues
"Anirudh Chitnis via DBMonster.com" <forum@DBMonster.com> wrote in message news:4d71b87ec26b42cbba3bfa8ae42593e7@DBMonster.com... > All, > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also…
Informix Performance Issues
"Anirudh Chitnis via DBMonster.com" <forum@DBMonster.com> wrote in message news:4d71b87ec26b42cbba3bfa8ae42593e7@DBMonster.com... > All, > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also…
Re: raw devices in linux (O_DIRECT)
Martin Fuerderer escribi�: > Hi, > > in your Machine Specific Notes you should see something like this: > > ------------------------------------------------------- > 3. Kernel Asynchronous I/O (KAIO) > > Asynchronous I/O is supported by the official Linux kernel since > vers…
Re: raw devices in linux (O_DIRECT)
Martin Fuerderer escribi�: > Hi, > > in your Machine Specific Notes you should see something like this: > > ------------------------------------------------------- > 3. Kernel Asynchronous I/O (KAIO) > > Asynchronous I/O is supported by the official Linux kernel since > vers…
Re: raw devices in linux (O_DIRECT)
Hi, in your Machine Specific Notes you should see something like this: ------------------------------------------------------- 3. Kernel Asynchronous I/O (KAIO) Asynchronous I/O is supported by the official Linux kernel since version 2.6.x. IBM Informix Dynamic Server…
Re: raw devices in linux (O_DIRECT)
Hi, in your Machine Specific Notes you should see something like this: ------------------------------------------------------- 3. Kernel Asynchronous I/O (KAIO) Asynchronous I/O is supported by the official Linux kernel since version 2.6.x. IBM Informix Dynamic Server…
Re: raw devices in linux (O_DIRECT)
Hi Sandor: Without the library libaio I got 08:32:46 libaio.so.1: cannot open shared object file: No such file or directory 08:32:46 Please install libaio package. See machine notes. 08:32:46 Warning: Kernel Asynchronous I/O is disabled. After installing the library and lea…
Re: raw devices in linux (O_DIRECT)
Hi Sandor: Without the library libaio I got 08:32:46 libaio.so.1: cannot open shared object file: No such file or directory 08:32:46 Please install libaio package. See machine notes. 08:32:46 Warning: Kernel Asynchronous I/O is disabled. After installing the library and lea…
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…
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…
Monitoring CPU usage
Dear All, I am using IDS 7.3 on RS-6000 p-Series with AIX. I have two hardware processors in my server machine, but in onconfig file I found : MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, l…
Re: oninit process
No am running 1 instance on the server. Am trying to improve the performance of the data base server. Would like to know of how to increase the AIO reads/ writes and also the number of records per second. Kindly provide me with some information in this regards. On Wed, 9 Feb 20…
oninit Prcess in Linux Environment,
Hi Arvind, As with many software questions, the answer is "it depends". It sounds like you don't have much understanding of the IDS architecture or design, so your first step needs to be to read the IDS Administrator's Guide. If you don't have a copy, you can download it from ht…
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…
Re: Performance Issues
[cutting] > > NUMAIOVPS 6 # Number of IO vps > > Then monitor onstat -g iov. If there are more than one AIO VP with an > io/wup column value less than 1.0 you can drop some. If there are NO > AIO VPs with io/wup less than 1.0 you need to add more. Add two a…
Re: Performance Issues
Roger Cariah wrote: Here's what I see: NETTYPE ipcshm,1,30,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,5,25,CPU # Configure poll thread(s) for nettype You should never use CPU VPs for TCP listeners (ignore the manual). Also shared memory listeners…
Re: Fatal error in ADM VP at mt.c:12239
Here is another part of the af file: ===========------------- - - - - - - /home/informix/bin/onstat -F: IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 1 days 20:14:49 -- 2549264 Kbytes Fg Writes LRU Writes Chunk Writes 0 8396195 30928…
CPU Binding
Hello Everyone, I just wanted to clarify how does IDS determine the number of processors a UNIX box have? Our new server(Sun Fire E6900) uses the UltraSPARC IV processor, which is using the Chip Multithreading(CMT) technology. Through CMT, 20 additional virtual processors are sp…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Cooked vs RAW
Hi, in general "Informix"-jargon, "cooked" refers to chunks in the OS's filesystem. This means that for I/O to the filesystem the OS will do some buffering. How much buffering there is may be configurable (i.e. how much memory is used for the buffers). On the IDS side this kind …
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…
RE: Questionable IDS 9.21 performance on HP-UX v11.11
Jason, I think You are having a pure disk bottleneck. For some reason, your server is having HUGE database read and write activity more then 50 disk operations/sec average (I think, including calm night hours) Most of your writes are LRU writes; that means, there is contention…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: oninit processes are huge
onstat -g Informix Dynamic Server Version 7.31.UC4 -- On-Line -- Up 7 days 00:30:25 -- 501440 Kbytes MT global info: sessions threads vps lngspins 5 56 12 0 sched calls thread switches yield 0 yield n yield forever total: 258468…
ONCONFIG for 9.40 offered for comment
On Wed, 16 Jun 2004 01:01:12 -0400, Neil Truby wrote: Neil, I'd recommend the following: > 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…
RE: thank you IBM
See below... "Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message news:caj34l$lpd$1@news.xmission.com... > > > > > -----Original Message----- > > From: Madison Pruet [mailto:mpruet@comcast.net] > > > > What is described by the 'victim' in the Admin Guide is the same as a…
Re: NUMAIOVPS setting
On Tue, 01 Jun 2004 04:13:53 -0400, Richard Spitz wrote: OK, a bit of clarity and apology. IFF you are running on a single CPU system with a single CPU VP then you cannot physically get an io/wup value < 1.0. However, if you add a second CPU VP on a P4 or higher (due to the vir…
Re: NUMAIOVPS setting
On Tue, 25 May 2004 08:51:20 -0400, Reinhard Habichtsberg wrote: > Art S. Kagel wrote: >> Once you have a running system, run onstat -g iov, as Madison suggests. If >> there are a few aio VPs with io/wkup less than 1.0 then you are OK. If >> there are many such you can reduce …
Re: NUMAIOVPS setting
Art S. Kagel wrote: > Once you have a running system, run onstat -g > iov, as Madison suggests. If there are a few aio VPs with io/wkup less than > 1.0 then you are OK. If there are many such you can reduce them, but check > across a peak load first. If there are none with io/…
NUMAIOVPS setting
"Bent_Andy" <abent@aetinc.com> wrote in message news:c8t3f0$jj3$1@terabinaries.xmission.com... > > HP-UX 11.11 - 7.31.fd5 - Baan IVc4 (OLTP) > > I have a question about numaiovps. Our current setting is 52 and we > have 68 chunks. Notes from a performance class say if onstat -g…
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…
Re: BUFFERS! Arghhh!!! Please help before I do something silly!
back in the buffers, If your are going to increase buffers I would recommedn increasing LRUS to 256 or 512. esteban.- "Andrew Hamm" <ahamm@mail.com> wrote in message news:<c6n0uj$dlr36$1@ID-79573.news.uni-berlin.de>... > sumGirl wrote: > > I am confused. I posted last week with …
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: Long checkpoints on AIX/IDS7.31/IBM Shark
Thank you TBP, Dave & Alex for you suggestions, I have duly increased my LRUS to 128, and CLEANERS & NUMAIOVPS after looking at onstat -g iov and checking the io/wup column. We've found the culprit which affects all hosts connected to the same Shark (and there are quite a few) …
BUFFERS! Arghhh!!! Please help before I do something silly!
sumGirl wrote: > I am confused. I posted last week with questions about how I should > tweak my onconfig after I added memory to my RS6000 (from 4 gig to 8 > gig). One of the comments that really stuck with me and in the > responses many folks agreed with was that I should "up my…
high buffer wait ratio
Andrew Hamm wrote: > > What's the output of > onstat -g iov | head -7 WRONG!!! I mean, what's the output of: onstat -g iof onstat -g iov onstat -F | head -7…
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…
Do I need more KIO's
can you post the onstat -g iov and onstat -g ioq Tugger wrote: > > Paul Watson wrote: > > > Whats the io/wup from onstat -g iov, if it's less than one then > > I'd leave it alone > > > > Tugger wrote: > > > >>Looking for advice: > >> > >>Users are complaining of slow system > >>…
RE: Virtual Processors and CPU-Load
Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…
RE: Virtual Processors and CPU-Load
Dont post MIME Have you run the correct update stats? In Informix monitor users -- onstat -u the ready queue -- onstat -g rea the sqls -- onstat -g ses {session number} You need to determine which sessions or parts of the application are causing the load. With 200 users you…
Virtual Processors and CPU-Load
Hi all, we are a little bit confused concerning the CPU-Load of our Informix-Database-Server. (9.4 UC3, RH9 2.4.20) We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at 99.9%! All tables and indexes (DBSpaces, Extents, ...) are optimized to the best of our knowledg…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Intermittent Performance Problem - What does oninit do?
On Fri, 12 Mar 2004 12:36:43 -0500, Joel wrote: > Here's the info you requested Art. If you need more, please let me know. > > Thanks for the help. > > Joel <SNIP> Snipped it all as it's hard to read anyway. Looks like you are suffering from buffer and/or LRU queue contention.…
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…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Reduce # of CPU: license cost
IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Puzzling performance issue?
Eric wrote: > > Hardware is comprised of 2x112 Mhz with 512 RAM. > > ---------------------------------------------------------------------- > ------ Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up > 4 days 08:15:53 -- 473136 Kbytes Not just maybe, but definitely th…
Re: K AIO
LSM is not used It is a Compaq HSG80 cabinet with 18, 36 or 72GB disk in RAID 0+1 in combination with a Compaq ES40. Told was that there would be only a minor difference between Advfs and RAW solution for our datbase, so we choose Advfs Since we came from a DS20E dual processo…
RE: K AIO
You must use raw disk to use KAIO. You should see 25% approx speed improvement. What disks are you using? Are you using LSM ? Colin Bull c.bull@videonetworks.com > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf …
K AIO
Hi, Is K AIO of any use when the db is on advfs files? (Runinng 7.31 on Tru64 5.1b) How can it be activated? (onstat -g iov doesn't show any kio)…
Engine's re-setting
Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…
Re: High lngspins - IDS 9.30 UC2
Thanks to Simmons, Mark and Obnoxio. We are running UPD STATS every night by a cron job. So I don't think UPD STATS would be a potential issue. I will be posting onstat -g spi and other onstat soon as advised by Obnoxio. Hari "Hari Gupta" <hariog@yahoo.com> wrote in message news…
Re: High lngspins - IDS 9.30 UC2
Hmm, well my first inclination would be to recommend that you update statistics, if you have not done so already. You may well be right that the sequential scans were an issue before the upgrade, but I would not rule out that the optimizer is making different [not always good] c…
High lngspins - IDS 9.30 UC2
Hi All, We have recently upgraded IDS 9.21UC3 to IDS 9.30 UC3 on RHL 7.3 (Kernel - 2.4.18-27.7.xbigmem). Platform - Dell PE6600 - Quard Xeon, dual channel, 8GB RAM - HT. Channel-A has 8 72 GB mirror & stripped and Channel-B has got 8 36 GB mirror & stripped. I have been keeping…
Tunning
On Mon, 29 Sep 2003 04:21:53 -0400, J.M.Rodriguez wrote: > My server is running on a HPUX ver. 11, use KIO and have over 100 concurrent > users. Normally it works well, but there are punctual moments in that which > the system goes very loaded. I see the processes oninit that co…
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…
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: Bad performance
Put the following into /etc/rc.local test with /sbin/hdparm -t /dev/hda and /sbin/hdparm -T /dev/hda /sbin/hdparm -c1 -d1 /dev/hda .... /dev/hdb .... /dev/hdc It will get a tremedous speedup on ide drives, because you have activated 32 bit and dma mode. It off on d…
Re: Bad performance
You need to look at your SQL and how it is being optimised. Without that there is nothing useful about the diagnostics you posted. Andy "R�diger M�hl" <ruediger.maehl@web.de> wrote in message news:<Xns939D664E7CD70ruedigermaehlwebde@193.101.67.2>... > Hi folks, > > we have …
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???…
Re: Bad performance
R�diger M�hl wrote: > Hi folks, > > we have three servers running Linux (SLES7) and > Informix 9.30 (2x) and 9.21 (1x). A developer > has run a script against 9.21 and it worked > fine and performantly. Now running it against > the 9.30ies shows a very bad performance. > > H…
Re: Bad performance
Rüdiger Mähl wrote: > Hi folks, > > we have three servers running Linux (SLES7) and > Informix 9.30 (2x) and 9.21 (1x). A developer > has run a script against 9.21 and it worked > fine and performantly. Now running it against > the 9.30ies shows a very bad performance. > > Has so…
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…
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…
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 …
Installing IDS 7.24 on AIX 4.2.1.0 / RS 6000
You're problem is related to the Kernel AIO. If you read the release not, you will see that you have to run the command /usr/sbin/mkdev -l aio0. With this command, you need to run it every time you reboot your system. Or you can do a permanent change with smit or smitty : 1. To …
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…
Installing IDS 7.30.UC7-1
Have you configured Asynchronous I/O ? you could do this by running the command mkdev -l aio0 Adam Hanel <hanela@billings.k12.mt.us> wrote in message news:3a847980@news.in-tch.com... > Hi All, > > Im trying to install IDS 7.30.UC7-1, on an IBM RS6000 running AIX 4.3. > > after I…
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 …
Re: Batch tuning...
Sorry, last message incomplete. I'd agree with most of what William Rice said, but I'd bump BUFFERS up way higher to get your cache rate up; say 200,000. With 4GBYtes of memory you can afford it. Also, look to upgrading to v7.31 or v9.2x. Aside from anything else, you will be…
KAIO ands "onstat -g iov" output
In article <BD256.50944$_h.347139@NewsReader>, "Earle A Long" <earle@btclick.com> wrote: > RTFM .... "Performance Guide, Configuration Parameters and Environment > Variables That Affect CPU Utilization, NUMAIOVPS" :- > If your operating system supports KAIO, the CPU VPs make I/…
CPU VP utilization
I have 2 different servers. 1st - 1 CPU 155 MHz Pentium, 64 MB RAM, 1 HD 2nd - 1 CPU 300 MHz Pentium II, 64 MB RAM, 1 HD Both have IDS 7.2 but they have differences in Informix configuration. 1st 2nd NUMAIOVPS 3 1 CLEANERS 16 1 LRUS 16 8 Here are some outputs from onstat …
Re: Page cleaners and raids
Mark D. Stock wrote in message <91bm23$d5q$1@news.xmission.com>... > >Andrew Hamm wrote: >> >> On that subject, (and sorry to diverge from what you may understand, Debbie) >> can someone clear up a question I've been wanting to ask? With the >> split-reads offered by Informix mir…
oninit -s at statup?
Hi, Every times after i startup the Hardware, SGI, i noticed that there are quite a number of oninit -s process start running at the background when i do a ps -ef. Same thing when the database go online. What is the oninit -s for? Will these oninit slow down the performance? What…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
You've heard it all before, cont.
I'm posting some other onstat commands that may help. Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 3 days 09:44:13 -- 2545024 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 261671478 74154240 9591835411 97.27 55502789 5144…
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: onstat -g iov
From: "Neil Truby" <ntruby@netcomuk.co.uk> > > > Have one AIO with less that 1 io/wup. Keep adding until this happens. > >... or you blow some critical system table parameter related to the number >of processes! Well, you *are* running on HP. :-> >Obnoxio The Clown <obnoxio@hot…
Re: onstat -g iov
From: mgimbert8769@my-deja.com > >I have INFORMIX 7.24.UC7 and I will like to known means of columns >wakeups and io/wup in onstat -g iov command > >AIO I/O vps: >class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup > msc 0 i 0.0 17106 0 0 …
onstat -g iov
I have INFORMIX 7.24.UC7 and I will like to known means of columns wakeups and io/wup in onstat -g iov command AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup msc 0 i 0.0 17106 0 0 0 16804 1.0 aio 0 i 13.4 …
no clu in linux download
I've also tried the same version. In release notes Informix states that IDS version for Linux have some shortcomings: - no asynchronous I/O kernel, no Enterprise Replication, no support for GUI console and sth. more (I do not remember - RTFM) Robert Sosnowski U�ytkownik <bmccre…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Slow Performance on IDS 7.30
Hi Art, I suppose that the Bufwaits Ration you mentioned is a calculated value. I want to check our system. How is it done? Thanks Art S. Kagel <kagel@bloomberg.net> wrote in message news:39A6B13B.DC42449C@bloomberg.net... > First Jason please do not post MIME/HTMP, this is a …
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 …
Regading to io/wup
"Manel Falcó i Aige" wrote: > > Where you saw anything about the chunk #5 ?? > by onstat -g iov ? -> gfd 5 0 167 751870 743427 8443 0 The onstat -g ioq you posted. Also look at onstat -D & onstat -g iof. > I know, I know the more machine the better ... ;o) > but…
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…
About AIOs vp ...
"Manel Falcó i Aige" wrote: > > Hi, > Do the AIOs vp lunch treaths as CPUs vp do ? > According to onstat -g ath, #AIOs threaths seem to be equal to #AIOs > vp. I'm not sure of your question but let's give it a stab. If you are running KAIO turned on then there is exactly one …
RE: KAIO IDS7.30FC5 on Tru64/DU4.0D
Cy, Have have a couple of huge instances (2GB BUFFERS, 250+ chunks) on DEC/Compaq Alpha and we cured our KAIO problems with these values for the rt subsystem in sysconfigtab: rt: aio-max-num = 32768 aio-max-percent = 10 aio-max-retry = 128 aio-t…
Re: KAIO IDS7.30FC5 on Tru64/DU4.0D
From: "Dewhurst, Cy" <cy.dewhurst@rbch-tr.swest.nhs.uk> > >Can anybody tell me the relationship between BUFFERS/LRUs/CLEANERS and >kernel asynchronous I/O queues? > >I'm getting errors in the online log: > >KAIO: out of OS resources Check your release notes. I know that for HP-U…
KAIO IDS7.30FC5 on Tru64/DU4.0D
Can anybody tell me the relationship between BUFFERS/LRUs/CLEANERS and kernel asynchronous I/O queues? I'm getting errors in the online log: KAIO: out of OS resources after upping the number of BUFFERS, (and accordingly LRUs and CLEANERS). Rather than reduce the values to thei…
HADR Asynchronous performance
O/S: HP-UX 10.20 ENG: IDS 7.24.UC4X3 WAN: 1Mbit ATM (pan-european) I am looking to set-up a wide area HADR replication pair between two European countries over a 1Mbit WAN. I need to configure the replication such that the performance impact to the primary server is at an ab…
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…
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…
More info on onstat -g ???
Please see http://www.informix.com/answers/english/docs/73ids/4354.pdf look for utilities at the end of index. Dennis. Wu <wuyf@maxis.net.my> wrote in message news:8gcreo$988$1@news.xmission.com... > > Hi, > > Where can I get more information on the onstat -g ??? command ?…
oninit
albert wrote: > > hi, > our project has recently chosen informix as backend database on sco unix > platform but we all new to it. When we start informix, it seems that there > is a oninit parent forking 9 oninit children and they consumes a lot of > resources(view from sar). Actu…
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…
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…
Re: HP-UX 10.20, IDS7.31 and KAIO problem
I have the same problem with Kaio and hp-ux 10.20. Contacting with HP, tells : "the kernel asynchronous i/o is implemented , but don't work fine with this version of op. (Perhaps hp-ux 11 ??). JC.…
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: poor (?) perf on NT
From: Stephen_Murray@agsea.com > >I am running a batch process on INFORMIX 7.31TC2 running on NT4.0 >Enterprise SP5 and IBM NetFinity >with 4 CPU and 4G RAM. This same process (called batch1) used to run on a >2-CPU no-name-brand system. >The run time on both systems is 2 hours …
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Contention on a table
ibogorad@yahoo.com wrote: > > Folks, > > I broke my head over this one. > So, I have this table in a third party application. The table has row > level locking, contains around 400000 rows of 220 bytes each. > > The way it behaves under the load is unique to this table only, the …
Re: NOAGE on hpux
From: "Craig A. Sharp" <csharp2a@earthlink.net> > >I am the Unix Administrator for my company. We currently run an >Informix database server on an HP9000 system running hpux 10.2. >I have been asked to install the patch that provides the NOAGE parameter >for Informix. > >Current…
Re: Database performance
From: Paul Jazwierski <uszko@earthlink.net> > >Yet another performance question: > >Here is an output of the command: onstat -g wai >which prints out all waiting and sleeping threads. It is consistently >this length. Question: >Is it normal to have this many sleeping and waiting …
Differences between Online 5 and 7
jose cipres wrote: > > I have to write 4 o 5 remarks about the most relevant > differences between Informix Online version 5.05 UC1 and > Informix Online version 7.24. > > I know that one different is teh possibility about fragment > tables, but I think there are more. > > Could …
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…
Few (shorter :-)) questions
Hi, I'm interested is there something wrong with configuration (based on onstat results). First, it is Ultra Sparc computer, with 4 processors (1 processor has affinity set). onstat -g glo gives this output: >>Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 15 days 2…
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…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, =?iso-8859-2?Q?Piotr_Wr=F3blewski?= <ptrwrb@kki.net.pl> wrote: > I am running IDS 7.30.UC2 server on HP-UX10.20. > The machine is a single-processor G50 uccupied by about 30 users, > so the 7.30 server does not run as fast as On…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
>My statistics for G50 says, that millions of disk writes go through 'aio', but >when we compare 'onstat -g iov' with 'onstat -g iof', the sum of disk writes >(-g iof) is nearly equal the count of 'kio' disk writes (-g iov), >and similarly for disk reads. There is bug in Informi…
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…
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, it really depends on how much load you put on your database. If it's basically a single user sytem I would definitely stick to on CPU VP. In any case - it should be either one of the following parameter sets: NUMCPUVPS 2 MULTIPROCESSOR 1 SINGLE_CPU_VP 0 or (probably b…
Re: CPU usage problems when using KAIO in V7.3? on SINIX.
From: mike@inftec.be (Mike Aerts) > >The database is located on raw devices in which case Informix >uses kernel asynchronous I/O by default. >The problem I try to describe only occurs when I have an SQL-statement >that needs to read a large number of rows and only find a few matc…
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…
Re: KAIO with Solaris 2.6
I've got to ask. please don't be insulted, are you 100% sure that you are using raw devices?? Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678729 www.wfsoftware.com/informix # If you broke it, hide the evidence >>> Francois Baligant <francois@be.euro.net> 09/…
Re: KAIO with Solaris 2.6
Maybe an onstat -g iov and onstat -g iof can help... bladnoch.root 11 / # onstat -g iov Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 15:18:52 -- 1089344 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors msc 0 i …
25594 error
I have been receiving the following error in a 4gl program that prints shipping extract labels in a grocery warehouse. -25594 Shared Memory client failed to alert OnLine server for service. Memory corruption usually causes this problem, or the operating …
KAIO with Solaris 2.6
From what I have understand, KAIO is off by default. The release note of my Informix (7.30UC5) running on a Solaris 2.6 (SunOS 5.6 Generic_105181-11 sun4u sparc SUNW,Ultra-250) tells me KAIO is supported. I have several raw devices but also some cooked files. (raw devices …
Re: Linux4GL
In article <37E7CB1A.CCA6CB89@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Howard Soper wrote: >> >> Can someone tell me which library rpm's need to be installed to be able to >> use Informix 4GL (C4gl or r4gl with custom runner ). > >That depends on which Linux rel…
Re: informix parameters in onconfig file
pankaj wrote: > > Hi , > > Not an Informix Expert but your NUMAIOVPS seems somewhat low. Informix > recommends NUMAIOVPS (2 + number of disks used for online). > Then monitor length of aio queues. onstat -g ioq [Original message SNIPPED] Pankaj, If you have Kernel Asynchronou…
Re: Linux4GL
Howard Soper wrote: > > Can someone tell me which library rpm's need to be installed to be able to > use Informix 4GL (C4gl or r4gl with custom runner ). That depends on which Linux release you have. For some you need nothing. For others, using the egcs compiler, you need the g…
Cook device vs Raw device
Lloyd AJ Wilson wrote in message ... >Hi Matthew, > >When using cooked files you are basically stuck with the overhead of the OS. >The overhead of the OS downgrades performance with Dynamic server mostly due >to the fact that it needs to use the OS in order to store and retrieve …
KAIO Environment Variables
Hi family, Since I am managing an HP-UX machine (IDS 7.23) I am well motivated to look into disabling kernel-based asynchronous disk I/O (KAIO). We have had some assert failures that, accoring to some posts in this forum, may be avoidable if the engine avoids KAIO. I just got …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Help Requested: Error 25592 Installing SE 7.24 on AIX 4
Informix SE Version: 7.24UC7 AIX Version: 4.3.2 I have just installed Informix on this box. When I try to bring up sqlexecd I get error 25592 "Communications service not supported by network driver" I am trying to start the process as root. My environment variables look like …
Performance problem
Arvind Sharma wrote: > > Hi all, > Thanks to Art and Jonathan for all their help. We were able to > complete our project and move to production. But we found one problem > there. The system seems to be very slow whenever it accesses DB. It used > to work fine in the test envi…
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.…
Tuning Informix 7.2.4
Webber Valerie H wrote: > > Hi All, > > Can anyone take a look at the ONCONFIG file and the output of ONSTAT -P, > ONSTAT -M and part of ONSTAT-G and make some tuning recommendations. This is > running 7.2.4 on a Pyramid UNIX machine with 512M of memory, 4 CPUs and a > 12K line …
Re: onstat -g iov
Pramod Dhumal wrote: > > Hi users, > > Is it possible to configure the number of kio vps shown by "onstat -g iov" Those are not VPs, but threads, as shown in: onstat -g ath |grep kaio One KAIO thread is run on each CPU VP, so the only way to change the number is to change the…
RE: onstat -g iov
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_01BED94E.A49304D0 Content-Type: text/plain If I understand your question correctly, its the NUMCPUVPS in your $ONCONFIG.…
onstat -g iov
Hi users, Is it possible to configure the number of kio vps shown by "onstat -g iov" Thankx ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
What mean NUMAIOVPS
Hi Pascal, With the NUMAIOVPS config paramater you can define how much Asynchronuous I/O Virtual Processors (= processes) you want to have. With more then one AIO VP you can read/write to several disks in parrallel. If this parameter isn't set Informix defines 2 AIO VP's for eve…
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: On line engine won't start
Are you running on AIX? From IDS_7.3 release notes: Kernel AIO is supported on this platform. For KAIO to work, the AIO driver needs to be configured into the AIX system. AIO can be configured as given in 1. above. If AIO is not configured, oninit will report the following erro…
Re: Performance problems
In article <3756CBFE.B27DB9E0@bloomberg.net>, kagel@bloomberg.net wrote: > [ ... snip ... ] > for any busy chunks, with the number of LRUS as a minimum. So if you > increase LRUS to 32 use AIOVPS of 32 otherwise at least 14. Monitor > onstat -g iov at least one or two of th…
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
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…
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…
Re: Number of oninit processes
mperrior@my-dejanews.com wrote: > > In article <7gm8ig$5vn$1@news.xmission.com>, > Willaert Doris <doris.willaert@suzuki.be> wrote: > > > > Online 7.3 UC6 on RS6000 AIX 4.2.1 (390) > > > > I have 3 instances running on this system. For the first system I have 12 > > oninit proc…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
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…
The ready queue Full but Unix not busy
We are experiencing an engine go-slows with all queries take much longer than they should. The ready queue (onstat -g rea) constantly shows 10+ threads, but Unix is only 30% busy (no waiting on IO) ? Can anyone explain the lngspins column ? Geoffrey.poole@ogs.co.uk <mailto:Geoffr…
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: Cached reads too low
Here's the stuff I got from Tech Support: ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- -- >ere is a performance bug which affects Informix on HP/UX with kernel >AIO specif…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
HP, KAIO and statistics. What's wrong ?
I have 2-processor SUN and 2VP: Virtual processor summary: class vps usercpu syscpu total cpu 2 40.46 1.46 41.92 aio 1 0.03 0.14 0.17 tli 1 0.12 0.31 0.43 lio 1 0.0…
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…
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…
Excessive number of oninit processes
Tauren Mills wrote: > > I have an Informix Online Workgroup Server 7.12.UC1 with 7 very small > databases running on Solaris 2.5.1 (Sparc). > > When the database starts up, it spawns 25 oninit processes that each use up Note: The oninit processes uses shared libraries. The don't…
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…
RE: onstat -g sch , Busy Waits ?
According to "Informix, DBA Survival Guide" by Joe Lumbley, on page 260, Monitoring Virtual Processors, "When a CPU VP does not have a thread to run, the process performs a 'busywait' . This is a loop of instructions designed to wait a short time". So comparing CPU VP Number 3, …
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…
Re: MORE RAM - BIG CONTROLLER CACHE / DB ON RAW - DB ON FS
Willem Roos wrote: > > Greg wrote: > > > > [...] Staged / asynchronous writes are about > > all controller memory is good for (and it's *really* great for that...) > > What are staged / asynchronous writes, and why is it the only thing > controller memory is good for? > > -- > /*…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Re: kaio question
> 1. how do I know informix is using kaio instead of aiovp? When you bring the engine up, there's usually an entry in the message log indicating that KAIO is in use. You can also do an onstat command and see if there are any kaio threads in use. onstat -u or onstat -g ath …
checkpoint time > 15 sec.
michael wallace wrote: > > I am currently running informix 7.3 on an IBM S70 with 2GB men and 4 > CPU's, and 10 mirrored ssa 4.5 GB disks. > CHKPTINVL 300 > LRU 8 > LRU_MIN_DIRTY 2 > LRU_MAX_DIRTY 3 > PAGE_CLEANERS 4 Recommendatations are hard without more info li…
Use memory better
vmstat is the place to start. If you are not seing anything under the "pi" column, then you probably can increase memory usage. However, I sense that your main goal is to improve performance. Hate to say it, but before I decided that I needed to increase memory utilization, I'…
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…
HP-UX Kernel AIO
Informix 7.24.UC5 on HP-UX 11 We hope to implement Kernel AIO on our HP/800 box running HP-UX 11 but have a few questions. The ONLINE_7.2 documentation says that KAIO is available but mentions patches that appear to be for version 10.01 & 10.10. The ONLINE_7.2 document says:- =…
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: Question about onstat -g iov
In article <364A2076.6B785D07@informix.com>, Jacques P Renaut <jrenaut@informix.com> writes > >Hmm, I've never actually noticed that but this is what I'd guess is happening. >The msc vp is used mainly used when users connect to the system to do >password lookups and such. The me…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: Question about onstat -g iov
Carlos Bolden wrote: > I have a question: > > I was watching system activiy via onstat -g iov and here I s what I was > seeing > [snip] > If you look you can see the msc io thread is wakeing up and doing nothing. > Is it that there is nothing to do or just waking up and not doin…
Question about onstat -g iov
I have a question: I was watching system activiy via onstat -g iov and here I s what I was seeing AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup kio 0 i 36.7 1416204 1057863 358341 0 1245645 1.1 kio 1 s 34.9 134598…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Kernel Asynchronous IO on HP-UX
KAIO on HP-UX can bring a good performance increase (~10%) or, under certain conditions, can result in a severe (30-100%) decrease in disk IO speed. Informix and HP continually tweak their respective code lines to get the most out of each system, which sometimes results in issue…
Re: Kernel Asynchronous IO on HP-UX
Here is the real story behind Informix/HP KAIO over the years. It so long so those of you that make it to the end I have include some HP Kaio tuning tips. There have been three different version of HP KAIO over the years which are basically the same except their polling medthods…
Re: Kernel Asynchronous IO on HP-UX
Defect 92132 is one such reported problem: It reads thus: HP KAIO HAS A SIGNIFICANT I/O BOTTLENECK WHICH CAN CAUSE 30% TO 75% IN PERFORMANCE The general symptom of the problem is that HP KAIO (native kernel async I/O) is *much* slower than Informix AIO. The impact is anywhere f…
Re: about virtual processors
> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: about virtual processors
Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …
Re: about virtual processors
Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Re: about virtual processors
Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: about virtual processors
For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
about virtual processors
hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…
RE: TUNING:aio parameters on AIX
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_01BDE27C.E95DF374 Content-Type: text/plain; charset="iso-8859-1" I always read but never post to this forum, however t…
Re: I/O Q length
Sadagopan, Sathish wrote: > > Hi, > If the I/O queue length is large for a system using KAIO and all raw devices > which parameters need examination ? > ('-g ioq') - The CPU vp queues (for KAIO) are showing large 'maxlen' values. My suggestion? Disable KAIO and return to AIO VP…
Re: TUNING:aio parameters on AIX
Art S. Kagel wrote: > > Dave Thacker wrote: > > > > Platform: IBM Rs/6000 J30 AIX V4.1.5 > > Engine Online DSA 7.23 > > > > From much reading of vmstat, iostat, and xmperf we appear to be I/0 bound > > on our production machine. > > While investigating the problem I came a…
Re: Informix 7.1 on Digital UNIX - raw or cooked?
On Mon, 14 Sep 1998 14:11:19 -0400, "mail" <jcubero@iag.net> wrote: > >I am running Informix 7.1 on Digital UNIX 4.0, and getting ready to set up a >new dB with 8 gB of RAID-1 disk space. My question is whether I'm better >off using raw or cooked devices. I've heard that Digit…
Re: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
Re: Informix tuning
"Mark D. Stock" <mdstock@informix.com> offerred: +Having said all that, there is nothing wrong with forcing a checkpoint +every minute, but then you must expect your write cache figures to +suffer accordingly. Considering the current (and long time) checkpoint behavior of blocki…
Re: CPU vp total time
Normand Bedard wrote: > > Hi, > We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. > We have Informix 7.23 on Solaris 2.4. After running the command "onstat > -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run > the command again an…
CPU vp total time
Hi, We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. We have Informix 7.23 on Solaris 2.4. After running the command "onstat -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run the command again and get 161535.23. 161668.46 - 161535.23 =…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: Just to know
Goldy Magaly Pastor Murillo wrote: > > Hi.. > I'm migrating from Online 5.0 to DS 7.23 and monitoring the status of the > users I found that in DS 7.23 reportes wait with the address of the latch > waiting.. but in 5.0 this doesn't happend .. what is the meaning en 7.3.. ??? > > …
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: 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: checkpoint duration
Try these: 1. Increase the size of the physical log to eliminate checkpoints triggered by that being 75% full 2. Increase the NUMAIOVPS until you see the IO operations performed by the AIO VP's in onstat -g iov gradually reducing (usually one to two orders of magnitude) 3…
Re: checkpoint duration
Willie L. Meeks wrote: > > I have a serious problem with checkpoint duration which cause my posting > process to almost double in duration because of the amount of time wasted > on checkpoints. Here is a a sample of the duration take directly from the snip.... > Regards, > > Will…
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: 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: 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: +…
query about benchmark
Hi, when I obtained the following information from the benchmark function of Informix OnLine XPS 7.1. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ********************************************************** c6p11sum60.lst = results of hwonstat script while …
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: LRU Parameters
Also sprach "Scott Kolaya" <skolaya1@nycap.rr.com> : :Values of: : :LRU_MAX_DIRTY 3 :LRU_MIN_DIRTY 2 : :are commonly used for OLTP processing to decrease the length of a :checkpoint. How long are your checkpoints taking? They should be very :short with those values, …
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: slow performance
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: onstat -g ioq ??
On Wed, 28 Jan 1998, Jeremy Hawkey wrote: > I 'm sorry to be such a peasent, but does this mean; looking at the > activity on these gfd's I need to add another AIO vp or not. In the > manual it says if maxlen or len is high add another aio, I think it is > referring only to the…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Using Informix Online on SCO with KAIO
Paul Mahoney wrote: > We have just installed Informix Online 7.23 on a SCO 5.0.2 system > and have enabled KAIO (Kernel Asynchronous I/O). > > While testing, Informix fell over and the following message was logged > in /usr/adm/message: > > CPU3: CONFIG: aio_breakup -s AIO requ…
Using Informix Online on SCO with KAIO
We have just installed Informix Online 7.23 on a SCO 5.0.2 system and have enabled KAIO (Kernel Asynchronous I/O). While testing, Informix fell over and the following message was logged in /usr/adm/message: CPU3: CONFIG: aio_breakup -s AIO request table overflow (NAIOREQ …
Re: chekcpoints, BUFFER settings, and optimization
In article <348F1333.4F79@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >David Williams wrote: >> >> In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca >> <inf@dpx20.growela.pt> writes > >> >} In article <881611278.1353908229@dejanews.com>, >> >} jneuge…
Re: chekcpoints, BUFFER settings, and optimization
David Williams wrote: > > In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca > <inf@dpx20.growela.pt> writes > >} In article <881611278.1353908229@dejanews.com>, > >} jneugebauer@ameritrade.com writes > >[...] > >David Williams writes > >[...] > >} ># Shared Memor…
Re: AIO vs KAIO
David MacAllister wrote: > > Hi Folks! > > I understand that KAIO has better performance over AOI when doing retrieves > from a database. > Could someone provide figures, ie how much faster KAIO is over AIO It is not the improvement for individual queries for KAIO (and there is …
oninit processes
System: AIX 4.2 ODS : 7.14 UD1 No of CPU : 1 Chunks : all raw devices. Hi, I'm just puzzled by the no of oninit processes when on-line starts up. It seems these oninit processes are related to the NUMAIOVPS onconfig parameter. By default , the NUMAIOVPS is left blank, w…
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…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: "lazy"stored procedures-- WARNING: LONG MESSAGE
In article <5mmpum$2jq@cssun.mathcs.emory.edu>, Oscar Goldes <ogolde@impsat1.com.ar> writes > >------ =_NextPart_000_01BC6CEB.02CFABD0 >Content-Type: text/plain; charset="us-ascii" >Content-Transfer-Encoding: 7bit > > > >-----Mensaje original----- >De: Denham.M@amstr.com [SMTP…
RE: "lazy"stored procedures-- WARNING: LONG MESSAGE
------ =_NextPart_000_01BC6CEB.02CFABD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit -----Mensaje original----- De: Denham.M@amstr.com [SMTP:Denham.M@amstr.com] Enviado el: Wednesday, May 28, 1997 9:00 PM Para: ogolde@impsat1.com.ar CC: informix-l…
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: problems with Informix shared libs under AIX 4.2
In article <858802764.4957@dejanews.com>, rasta-man@usa.net writes >I've been having some shared lib problems under AIX 4.2, Informix 7.22 >UC1. I talked to the tech support at Informix and they were able to >resolve my problem with oninit. I was getting the following: > >inform…
Re: Tuning CPUVPS/AIOVPS
In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…
Tuning CPUVPS/AIOVPS
On 7.11 if you run ONSTAT -G SCH What does the busy waits column mean? Is 0 a good number for AIO or CPU VP's? Does it mean that there are sufficent AIO or CPU vp's and nothing is waiting or is it just the opposite saying that all of the VP's are being used up and you need more…
SMI: VP level I/O stats - 7.2
I need to obtain VP level I/O statistics (like reads, writes, buffer reads, buffer writes, etc.) from 7.2 online via SMI. These pieces of information are avilable from onstat with -g iov and -g iob options. Tech support hasn't been a successful option so far! Any help or pointe…
Re: SMI: VP level stats
In article <58ser5$e3j@bigboote.WPI.EDU>, Arun K Shastry <aruns@owl.WPI.EDU> writes >I'm interested in getting VP level I/O statistics >like reads, writes, buffer reads, and buffer writes. >These are avilable via onstat with -g iob and -g iov, >however I need to get at them via …
SMI: VP level stats
I'm interested in getting VP level I/O statistics like reads, writes, buffer reads, and buffer writes. These are avilable via onstat with -g iob and -g iov, however I need to get at them via SMI.…
Re: Online V7 and Parallel Queries
In article <329b4022.18982794@news.dircon.co.uk>, Jeremy Russell <jeremyr@dircon.co.uk> writes >jeremyr@dircon.co.uk (Jeremy Russell) wrote: > >>Is it true that PDQ, parallel queries in OnLine V7.x will use both >>primary chunks and mirror chunks to retrieve data concurrently whe…
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…
Re: raw devices - general questions
David Williams wrote: [clip] > Sort of Informix can not access any part of the drive beyond the 2 > gigabyte limit. This is because it uses the lseek() system call which > only allow you to move to a postion up to 2 gigabytes into the drive. > > Therefore you need to use a Lo…
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…
KAIO on HP 10.0 -Reply
John: We are on an HP9000/800 running HP-UX 10.01 and INFORMIX-OnLine Version 7.13.UC1 In $INFORMIXDIR/release/ONLINE_7.1 ... 3. Kernel Asynchronous I/O (KAIO) is supported on this platform. However it is DISABLED by default. To enable KAIO set the environment varia…
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…
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 …
Re: processes sspawned by 7.1
>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…
Re: processes sspawned by 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …
Re: KAIO clarification.
bruce, : - Everything I have read in the manuals and in Suto's book : indicates that we should not set NUMAIOVPS if we are using : KAIO (Kernel Asynchronous IO). that seems to be true. if you are using kaio, you only need a few aiovps. the kaio's do asynchronous i/o throu…
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…
Re: Raw is SUPPERIOR
Lots of food for thought here were to start... Well first I completely agree with you that raw space is more secure for transactions. However Decision Support is not concerned with transactions unless it resides on the same box (in our case we do not have transaction processing …
HELP: 7.1 DB Engine performance (not an easy one)
Hi there. We have recently moved from Online 5.02 to 7.1 on an SCO OSR5 platform. Everything works beautifully for a few hours, an then, suddenly, for no apparent reason, the DB engine slows down dramatically. By "dramatically," I mean the new performance is less than 10% of t…
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 …
101945-32 (Solaris 2.4 latest kernel jumbo patch) busts Informix 7.1
Watch out. After we installed Sun recommended patch 101945-32 for Solaris 2.4 (sparc), our Informix server (7.10.UC1) crashed in a big way: a bus error. This was on a 2-processor Sparc. Our workaround was to revert to Sun patch 102020-07's /kernel/sys/kaio and /usr/lib/libaio.…
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?…
Re: Keeping clean pages in shared memory
Raj Gopalakrishna writes: |> Page Cleaners and Checkpoints definitely influence cache flushing. |> By setting a low value for LRU_MIN_DIRTY, you cause excessive page |> cleaning activity. This may not be a good idea as it effectively reduces |> the effectiveness and size of the …
Re: Why several oninit processes in ver 6.0?
In article: <3eke1u$65f@eos.ap.org> malhotra@eos.ap.org (Rajesh N. Malhotra) writes: > > > Informix Gurus, > > When we initialize Informix 6.0 using the oninit (or the tbinit) > command, there are seven processes started. Any reason why so many? At > present we are using Online…
Re: Can this be done?
On 16 Nov 1994, Martin Allred wrote: > I was thinking, so look out. Can OnLine use a RAM-disk for the primary > database storage and put the mirror on a real disk? This should allow > for some serious speed improvements while keeping some integrity due > to the mirror of the dat…
Re: does SUN DB excelerator work? how?
We are currently using DBE 1.3, SunOS 4.1.3, and Informix On-line. The DBE product impoves virtual memory, improves aysnchronous I/O, and increases the number of file descriptors. The asynchronous I/O enhancements reduce CPU overhead for asynchronous disk I/O for raw partitions…
Re: Raw I/O vs files (was Re: Raw partitions / cooked files)
In <2506@coyote.UUCP> gainer@slowmo.almaden.ibm.com (P. Gainer) writes: >In a recent append, lparsons@exlog.com (Lee Parsons) writes... [stuff deleted] >And this is what I am curious about. What are the "small" perf gains? >Are they worth the expense of avoiding the filesystem…