Oninit® Archive
Results for “onstat -g ras”
Unable to initiliaze informix instance
Hi, Sorry I am sending the mail again because I found that the attachment reached to you will not be in proper format. I have installed informix 7.31 on MP-RAS 3.02 (NCR S 1600 machine, with 2GB RAM) . But I am not initialize my informix instance using "oninit -i" command if i …
Re: _temptable filling up rootdbs
Hi, It seems no one has replied to your question yet .... The _temptable is an Internal temp table which Informix creates if AUTOINDEX path is chosen by the index. I had encountered a similar situation at a customer site where we found that somehow the engine wasn't using the in…
Re: Assert Failed: No Exception Handler / IDS 9.40.TC2E1
At 14:34 14/11/2003, Obnoxio The Clown wrote: >Thank you for that useful addition to my disk usage. > >-- >Ciao, >The Obnoxious One > >"Ogni uomo mi guarda come se fossi una testa di cazzo" Hi, Sorry, I apoligize for the stuff which is quite unreadable . Please, just drop it.…
Assert Failed: No Exception Handler / IDS 9.40.TC2E1
--=====================_7719780==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Hi, This is the output I have after my engine stops when I try restart it. Please, can someone explain me what's going wrong and the way to solve the case ? Hereby are some info…
RE: oncheck -me
It was mentioned as a way of getting more options to the onstat command (and boy do you get some more !!) but not in the context of oncheck. -> -----Original Message----- -> From: Paul Watson [mailto:paul@oninit.com] -> Sent: Wednesday, October 22, 2003 9:20 AM -> To: informix-l…
Re: -640 : QPlan sanity failure (2139.3).
--0__=88BBE731DFC2607B8f9e8a93df938690918c88BBE731DFC2607B Content-type: text/plain; charset=US-ASCII Did you migrate/upgrade recently ??? I've seen this error when upgrades/migrations happen. I would suggest dropping distributions and re-running update statistics for the tables…
Re: Problems with Shared Memory
U r limited to 50 connections in all ... if you are using SHM connections ... are the users spawning more than one connection to the engine when they run the program ... I would suggest increasing the number of connections to say 100 to see if it works or not ... onstat -g ses a…
Re: If You have an option to move from 7.3 to 9.3 or 9.4. Which one you
Everything is getting larger ... what about the counters used by onstat? In 7.31, I see the read and write counters roll-over each week. "Rajib Sarkar" <rsarkar@us.ibm.com> wrote in message news:bjlabp$sdv$1@terabinaries.xmission.com... > > > > > > 9.4 .. since > a) 2 GB chunk l…
Re: Re: CKPT REQ - Blocked:CKPT
No .. don't do that ... I would suggest bouncing the SECONDARY and seeing if both servers sync up or not ... otherwise you'll have to do the physical restore to re-establish HDR again from scratch ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management…
Re: Re: CKPT REQ - Blocked:CKPT
Rajib, I have the same problem when I restored my latest backup to the Primary. Can I just kill this user session that has the flag -X? Thanks fo your help. P.S. I can ping my secondary so my network connection seems to be good. Originally posted by Rajib Sarkar > This means…
Re: CKPT REQ - Blocked:CKPT
This means that the instance is waiting on a CHECKPOINT to complete. From the info..it looks like an HDR pair where the Primary is waiting for the Checkpoint to complete. check the onstat -u output and look for flags -X- on any of the sessions, which means this session is in a c…
Re: oninit -s and cpu utilization
There is a problem with 7.30 of keeping the wrong part of an index page in memory. Run onstat -P and check if btree percentage is very high. If so run onstat -R and check in the MEDHIGH and HIGH columns are greater than the MEDLOW and LOW columns. If so then run onstat -B and gr…
Re: Problem in Windows NT - Please help...
I've seen similar problems with service pack 4 and 7.31tc2, but sp3 w/7.31tc2 has been very stable for us. Informix has been unable to reproduce our problem so we're stuck on sp3 for the moment. Since it works I can't complain about much other than the time it takes to rebuild …
Problem in Windows NT - Please help...
I�m having some problems with my machine. I have Informix 7.30 TC5 installed on Windows NT 4.0 Service Pack 3. The error described on the configuration file ocurred 7 times in the last 10 days, and we don�t know what�s happening. I hope somebody can help us. Thanks in advance. --…
Re: Question: Online 7.14 not shutting dwn completly
In article <r9fV1.100$yU.305044@newse1.midsouth.rr.com>, Carlos Bolden <cbolden1@midsouth.rr.com> writes >Hi All, > > I have a problem. We have a system at work ( NCR 3555 running Informix >ODS 7.14, TOPEND 02.02.02.00 with a serious application built for it. 186gig >of datas…
Question: Online 7.14 not shutting dwn completly
Hi All, I have a problem. We have a system at work ( NCR 3555 running Informix ODS 7.14, TOPEND 02.02.02.00 with a serious application built for it. 186gig of dataspace mirrored, and in need of some serious DB maintenance, 2 gig of ram and 16 pentium 133 processors, running…
Re: Informix 7.13 "eating" memory
In article <01bbcbf4$d80537e0$2186e4ce@pc33.csfi.com>, Paul Leskinen <paul@csfi.com> writes >I was hoping that someone out there has encountered this problem: > >We have an online transaction-processing application that stays resident >and processes financial transactions using I…
Re: Informix 7.13 "eating" memory
Paul Leskinen wrote: > > I was hoping that someone out there has encountered this problem: > > We have an online transaction-processing application that stays resident > and processes financial transactions using Informix. The problem is that > Informix Online keeps allocating m…
Re: Informix 7.13 "eating" memory
Paul Leskinen (paul@csfi.com) wrote: : I was hoping that someone out there has encountered this problem: : We have an online transaction-processing application that stays resident : and processes financial transactions using Informix. The problem is that : Informix Online keeps…