Oninit® Archive
Results for “onstat -g cpu”
What is the load on an individual listener or sqlexec thread?
this help at all ? The CPU time shown for a thread is updated each time the thread yields and is based on the change in clock time since the thread last started. For threads such as the poll threads, which spend the majority of their time in an OS call such as s…
Segfault since CSDK 4.50.FC10 with LVARCHAR and CLIENT_LOCALE different from DB_LOCALE
I will open another thread for ifx_var_init() usage. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
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 ------------------------------…
ESQL/C conversion error with CLVCHARPTRTYPE
Hello Andreas! Thanks for your answer. I will open another thread for the new issue one of a customer has detected. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
onstat -g ses returns "Changing data structure forced command termination"
HI, I was asking about: " there is a couple of other onstat output problems with changing structure ( onstat -g top session cpu|bwr|bfw, onstat -g top sessmem gro which I observed) or incorrect output (onstat -x). We asked to fix as well." Do we have APARs for these? ------------…
restore through STDIO
Hello. Unless you are trying to create an RSS node on your cluster, I don't see any benefits in using zip/unzip. 1-huge cpu consumption in a serialized method. 2-your network link should be already a high speed to accomodate your primary load for HDR replication. 3-if you are dea…
IFX 14.10xc8 Updatable RSS and CPU Usage
Hello, In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds onstat -z; onstat -g cpu | grep smx IBM Informix Dynamic Server Version 14.10.…
flags (onstat -g ses)
OK, to track locks, latches, or waits, start be determining the thread address(es) for the session of interest with onstat -u. That's the first column in the onstat -u report. You can filter on session id in the third column: onstat -u |fgrep 14123 46bf98a0 ---P--- 14123 in…
Slow Running Query
If like multiple rows , then how can be checked which thread id we need to compare ? Regards Amit P ------------------------------ AMIT PATEL ------------------------------…
Informix NUMA shared memory access
> memory of a single NUMA node is too small Well, as with everything in performance you need to figure what is your primary bottleneck first. When your "working set" does not fit in memory (Informix buffer pool) then, most likely, your workload will be I/O bound and the effect of…
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…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
High CPU Utilization
We have two environments which are the "same" that are both running Informix 12.10. The databases are replicated. One of the servers is experiencing extremely high cpu utilization. The cpu utilization started to increase in the middle of September. It is now nearly running at cap…
blocked records
Use "onstat -k" for threads holding locks and "onstat -u|grep L" for sessions waiting for a lock…
Bufferpool configuration
Hi, a recent thread titled "BUFFERPOOL Configuration" dealt with most of these issues. Ben.…
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…
Using complete CPU core instead thread
Hi, is it possible to configure informix to use the whole core per VP instead of only one thread using affinity ? Let's say that now we have cpu=6,aff=(0-5),noage Condidering that there are 2 threads per core, if I configure informix to use only one thread per core, would it use …
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…
how to give IP based grants in Informix
informix version is 12.10. i want to bind grants with user IP. ( grant select to user@IP) because i assigned a role to a user and that user gave his password to other colleagues. now simultaneously, many users are login from same username, and As DBA it is difficult for me to tra…
sid vs pid
Thanks. I thought the process ID was for a DBMS process. I probably had process confused with thread.…
Chunk symbolic links
It's rootdbs. Issue is solved, there was a problem with the link file. This thread can be closed. Thank you.…
Re: RE: onstat -g glo: cpu efficiency
We have an IBM Power 750 (Power 7+) with 16 cores defined running SMT so that the cores appears to the OS as 64 cores. We have 54 VPCLASS cpu Our average efficiency looks to be in the low 60% range. We are experience about 80 lngspins per day with an peek connections of about …
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
IDS 11.5 - Mystery improvement in performance
The timing of the "miracle" raised one flag for me, and it was sort of addressed in the question about other processes, but Saturday evening would suggest a period of minimal usage on your servers and networks. Are you using shared memory or TCP connections for these processes? …
Execute SQL statements in parallel (esqlc)
Thank you John & Sathyanesh for the quick responses. I will take a look at the writing the esql/c thread routines. Regards, Steve…
Mutex logs on logical log flip
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } That would be my analysis... Sent from Yahoo Mail for iPad On Monday, February 29, 2016, 6:46 PM, NEIL TRUBY <ne…
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)…
Re: RE: Which session is using the most cpu resour
since 11.50 there is also an onstat available for that purpose - onstat -g cpu…
Hyper threading
IDS 12.10.fc5 IDS 9.40.fc5 Aix 6 and 7 We have just moved our Informix systems to a Power 8 system ... previously we were on a Power 7. I remember something from last years conference about Hyper threading ... and if it should be used or not ... but I don't remember .. nor can I …
opentable memory leak
Original post: No AUTOINDEX as far as I can tell. Turning off PDQ avoids the issue and I can live with this until permanent fix is found. Thanks, Andrew Response: It's a APAR in 12.10.xC5. APAR IT09544. The description talks about auto-index path, but the real trigger is an…
cpuvp efficiency AIX 7.1/IDS 11.5.FC8
Mark: As I understand it, the efficiency is a ratio of time spent by the CPU VPs in processing server threads against total CPU time which would include polling, spinning, etc. In theory the higher the efficiency the fewer cycles are being wasted. Some use it to determine whethe…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
memory thread ... VIP status ?
Jacques, pretty much spot on... it does run often but as you state does not consume a lot of cycles. this is over 60 seconds: iter 'onstat -g cpu | grep memory ' 60 137 memory 8cpu* 03/05 12:50:11 378.2938 66475974 sle eping forever 137 memory 8cpu* 03/05 12:51:11 378.4646 665…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
onstat -g ath
In the vp-class column of onstat -g ath output, some of the entries has an asterisk appended (i.e. 1cpu*). What does that signify?…
btscanner running v/s ready
Thank you Art. I believe the active (running) threads also don't run too long, they just get captured by the monitoring as a coincidence. I will monitor for the behaviour that you explained to ensure the active threads of btscanner don't run too long.…
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,…
Monitor CPU usage by Informix session
Original Post: We had a situation where an Informix session brought the production Instance down to its knees. We restarted the instance and it happened a second time. Here are the server details: HP-UX uxprod1 B.11.31 U ia64, IBM Informix Dynamic Server Version 11.70.FC5, HDR c…
Sequences & Locks
Hello We hit a table extensively (and with multi threaded) for a next key value to be returned and of course it is running into deadlocks, etc. We are looking to move this to sequences - are there locks involved with sequences in a multi threading scenario? thanks tom…
Efficiency of the Informix Virtual Processors
Does anyone know if enabling KAIO will cause a drop in CPU VP efficiency in the onstat -g glo output? Seems to make sense since previously the AIO VPs would have been doing all of the IO waiting and if you switch to KAIO the kaio threads will run on the CPU VPs and the waiting t…
Threading in Informix 4GL
Hi, in the context of: Informix 4GL 7.50 Without C/Java procedures. Without RUN external program. Can i EXECUTE a prepared statement (an insert) whitout waiting for the result or the error, like doing it in other thread. There is an insert in a table for statistic/logging p…
sysadmin setup incomplete in IDS 11.5 Windows XP
This is the output of onstat -g ath onstat -g ath | grep dbScheduler gives no output IBM Informix Dynamic Server Version 11.50.TC9DE -- On-Line -- Up 00:42:22 -- 78208 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 103da970 0 1 IO Idle 3lio* lio vp 0 3 103f4210 0 1 …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
drop CPU VPs....
Hi Martin, Few minutes after post this email here, I discovery exactly what you said, I just check which is the last CPU VP with "onstat -g glo" , use the "onstat -g cpu" to found all sessions what running more over it and killed only this session with more cpu utilization.. then…
ifx versus POWER7 - SMT4
Hi, We have here IFX 11.50 FC8 running over a new machines, AIX 6.1, Power7 Machine (p740), 16 core option (2 socket, 8 cores each), configured with LPAR. I need some reference, official preferentially about what is better configuration to Informix. Monitoring this machines, I…
informixdb & threading?
Has anyone used informixdb [1] (to acccess an Informix engine) with threading? Even if I allocate separate connections local to the threads the application immediately seg-faults or dies with a massive stack trace. [1] <http://informixdb.sourceforge.net/> Python 2.7, openSUSE 1…
Mutex wait
Hello All, IDS 11.50.FC8W2 on HP-Unix Reposting this issue as I did not got any response for my earlier thread and yesterday we again saw a near outage due to mutex waits in the database. We experinced some dip in our performance(load jobs) and while checking the user I saw qu…
Mutex wait
Hello All, IDS 11.50.FC8W2 on HP-Unix We experinced some dip in our performance(load jobs) and while checking the user I saw quite many sessions with S- flag indicating these were waiting on mutex. I checked in onstat -g ath and found the following different waits: 8815514 c00…
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…
Performance Issues
Hello John & All, Thanks for your findings and suggestions: We have increase the memory allocated to informix by 20% VP_MEMORY_CACHE_KB 100000 FASTPOLL 1 The cpuvps are now spining equally, I have not yet changed the NETTYPE as you have suggested but planning to do the same…
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…
infos about waitstates
On 18 Jul., 09:07, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi, > > I'm searching for detailled informations about waitstates and how to > interpret them and how to react. > > Examples: > > buf ready > > aio > > mt yield n > > running > > buffer > > m…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Single threaded vs. Multi threaded
Wow, it's been a while since I worked on Informix 5 :-) In Informix, Version 5, UNIX controlled everything. For each user that connected, a process was created and UNIX controlled process switching. This is a single-threaded architecture model. Due to the size of servers back wh…
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…
Scheduler Error
I did end up having to restart the server in order for the AUS Refresh task to run. Now, the real problem is that the dbworker threads failed again (after about half of the update statistics statements) with the following message in the log: 22:07:25 SCHAPI: thread dbWorker1 tas…
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…
proper way to create rawdevices in Red Hat Enterprise 5.5
This is unnecessary and will quite possibly be slower. See other recent thread: https://groups.google.com/group/comp.databases.informix/browse_thread/thread/61a4908ebbadb977 Regards, Doug Lawry…
Re: KEY PERFORMANCE METRICS
onstat -g iof will give you IO/sec average per chunk file. The total IO/sec for all chunks is more difficult. It will be somewhere between the average of those averages and the total of all of them. Transactions per second you will be better off getting from your applications.…
Re: nsf.lock mutex wait
On 3 Oct, 18:20, Cesar Inacio Martins <cesar_inacio_mart...@yahoo.com.br> wrote: > Hi, > > IFX 11.50 FC5W4 HPUX > > With some frequency I identify sessions waiting for the nsf.lock mutex . > This wait occur into "sendsocket" function (onstat -g stk) > What I already read about t…
nsf.lock mutex wait
Hi, IFX 11.50 FC5W4 HPUX With some frequency I identify sessions waiting for the nsf.lock mutex . This wait occur into "sendsocket" function (onstat -g stk) What I already read about this wait mutex, can occur when have more than 1 cpu vps. In this case we have 12 cpus. This …
nsf.lock mutex wait
Hi, IFX 11.50 FC5W4 HPUX With some frequency I identify sessions waiting for the nsf.lock mutex . This wait occur into "sendsocket" function (onstat -g stk) What I already read about this wait mutex, can occur when have more than 1 cpu vps. In this case we have 12 cpus. Thi…
Memory Management
oh..also think around 300 threads connected to this database.…
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
> sorry actually I wanted to ask "How do i make use of more Processor > Resources" Increase the workload? Informix will use your CPU resources if it needs to. You could add a million CPUVPs and get CPU utilization up to 100% because more work is being done to coordinate these m…
Help on VP cache tunning
You have two different onstat options below which show two completely different types of information. The onstat -g glo show about the cpu utilization. In fact that the las= t column is Efficiency which is quite low. This column gives you an idea of how well Informix and the ope…
Connections blocked - Connect Timeout Expired
LOOKS LIKE WE HAVE A BUG!!! With; NETTYPE soctcp,7,350,NET VPCLASS net,num=7,noage Results in; 7 Network VP, and 1 CPU VP. With; NETTYPE soctcp,7,350,NET VPCLASS cpu,num=7,noage We are back to where we started; Results in; 1 Network VP and 7 CPU VP! 'onstat -g glo' was used …
thread bp_priosweep
what exactly does this thread? have something with LRUs priority??? Is it tunable? $ onstat -u IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34 -- 915248 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites .... 5c06ad0 Y--P--D…
System.FormatException with CSDK 3.50 TC4DE
Changing the Thread's CurrentCulture to Invariant Culture fix this: System.Threading.Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; Ty.…
Buffer Waiting ( onstat -l )
The number of times that threads (sessions) had to wait to obtain a buffer. It's measure of system concurrency.…
soctcppoll and soctcplst
Hi, What is the difference between a thread called soctcppoll and soctcplst ? I'm confused with the output of onstat -g ath…
why so many informix threads on idle systems ?
here is the onstat -g ath BM Informix Dynamic Server Version 11.10.FC3 -- On-Line -- Up 01:09:50 -- 123912 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 c0000000ae5ca9a8 0 1 IO Idle 3lio* lio vp 0 3 c0000000ae5ebc88 0 1 IO Idle 4pio* pio vp 0 4 c0000000ae60d450 0 1 …
Re: performance improvements for dbimport?
On 10.03.10 18:53, Art Kagel wrote: > Recommendations: > * Adjust config > o VPCLASS cpu,num=6,noage > o BUFFERPOOL > size=2K,buffers=1000000,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0 > + Make sure that CLEANERS is at least a…
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_…
IDS random slow down
Jumping in here... I am guessing the diagnostics you posted were ran when the engine was in its slow state right? I'd like to see a few things: 1) What is the sqlexec thread that is running actually doing? You can get this information by looking at, in your diagnostics, the on…
User thread
I'm using Informix 11.5 developer edition and some Windows services are acusing an ODBC error (Cannot create user thread). Informix is installed on Windows. What can I do to fix up this problem?…
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…
Re: Delay in commands returning
On 22 Oct, 00:49, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Andrew Clarke" <acla...@civica.com.au> wrote in message > > news:mailman.199.1256165950.6236.informix-list@iiug.org...>> what about startup times of simple things like vi? > > Ligthening-fast > > Is it a machine di…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor is trying to do a majority of the work on a remote server via synonyms. When you look at all the oninit modules running on the remote server, it looks like only one is really taxed: ps -ef |grep oninit hd…
Physical CPU Statistics
Hello, We are using SunOS 5.10 Generic_125100-09 sun4v sparc SUNW, Sun-Fire-T200 machine. That is 6 Core with 4 threads/Core machine on which multiple IDS instances are running and each instance is using separate threads of each core. Is it possible for us to find out that which…
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…
how to force disconnect user threads?
How can I force disconnect user threads from Informix IDS? Thanks.…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
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…
Question about the status of the thread
Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.…
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 …
Checkpoint Duration
Well, when I used 'top' command to monitor server utilization, CPU idle went down to 2.8% and it kept swinging up and down. I thought maybe it was because the transactions were overloaded but then, I have no idea what caused that to happen because the transaction process was as s…
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…
Mutex documentaion
Neil Truby wrote: > I've a "slow performance" issue at a customer site. PMR 55561,001,866 > refers. > > When we have the problem - symptom being high server cpu, persistently > long ready queue etc - we notice slcommon_ct mutexes listed when we type > in onstat -g lmx. > > Does …
Determining instance's oninits
red_valsen@yahoo.com wrote: > I have 3 informixservers running on a single host. One of the > instances has experienced an assertion failure and is now > unresponsive, so I'd like to kill its oninit processes and attempt to > restart it. But running onstat -g ses only reports a…
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…
Shared Disk Server and partitioned tables
I have a 250 gig database with an ugly mix of OLTP and OLAP processes. The ugly sales comparision queries do a HUGE amount of summing, comparing, calculating on the fly. They are very CPU intensive. The CPU can be pegged at 100% for hours while the disk utilization is around 20 t…
LTAPEDEV to /dev/null from onmonitor
Kindly Ignore this as another thread is open with same content.…
syspools
>IDS11.10 UC2, AIX 5.3 > >Run the following query on syspools, and attached the partial result list. > >po_name "mt" occupied much of the memory. > >what "mt" means? what is the major jobs of "mt"? > >Thanks, Frank I belive the "mt" stands for Multi-Thread. That pool would be us…
Re: sqldetach not returning
> What is the stack for the thread calling sqldetach and the output of > onstat -g stk <tid> for the corresponding IDS thread? i´ll try to collect this information when the problem happens again.…
listener-thread: err = -27001
Hi, Guys, Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 We repeatedly receive the following error msg in online log, 19:43:34 listener-thread: err = -27001: oserr = 0: errstr…
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: threads still running?
If the routine contains a query sufficient complex to benefit from parallelism or from fragment elimination and you wanted those options to be always available to any user no matter what their current PDQPRIORITY is. This problem is why my dostats utility resets PDQPRIORITY to z…
RE: threads still running?
Thanks.I see now that that was the problem. The script that updates stats had set pdqpriority 80 at top and never change it before it updated stats for 'routine'. What would be an example of "routines that are known to require PDQPRIORITY set" ? I mean what type of task would th…
threads still running?
This involves ids9.4.tc2 on windows 2000 server. I have been trying to find out why so many connections are open on a server that has at most 20 users on it and the onstat -u may show something like: 2053 active, 2688 total, 2648 maximum concurrent. If I do "onstat -g ses" an…
IDS crashes when Sun reporting tool "Explorer" is
Hardware Sun 2900 8 Dual core CPU's OS is Solaris 10 IDS is 9.4.FC9 Has any one had issues in running the Sun Explorer Utility is run crashing the IDS engine?? It throws "Asset Failed: semop: errno = 36" messages to online log then crashes. Bruce Simms Data Base Services TALX …
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…
b-tree scanner tuning and expected behavior
On the instance that now has a 'normal' CPU usage, I stopped the single one that was running and started 8 threads with: onmode -C start 8 onmode -C threshold 2000 That's it; now, the filtered output from onstat -g ath is: juanclu1-[PROD]-(db1):~ $ onstat -g ath | grep btscann 72…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
Hi Experts, We use an informix database as database layer for an ERP application. We encounter high CPU usage of the informix server while the ERP application is hardly used (low number of active users). The high CPU load always starts at the same timepoint in the morning and en…
onstat -g rea almot 100 queue there !!!
Dear All... I've a IDS 7.31 in a RHEL 3 server , with 4 dual core cpu there , I set cpuvps to 8 and NETTYPE ipcshm,1,20,CPU soctcp,8,30,NET , and onstat -g ses | wc -l showes 220 ... I have noticed that top showes cpus' idle are about 30%~35% , and onstat -g rea showes about 80…
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.…
IDS 9.4 multithread help with new hardware
I am looking at a Sun cool thread server to replace a Sun v880 server that is going back on a lease soon. My interest in the cool thread server is power/heat reduction. We have a small computer room that has maxed out our air conditioning. I am being told the cool thread server…
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 (…
how much cpu does Informix use
IDS10 on AIX 5.3. Sorry if this has been asked before, but I still don't have a satisfactory answer. We are trying to determine exactly how much percentage of our system cpu, that Informix is using through time. This is proving to be a difficult task, because sar doesn't provide …
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
how to balance CPU VP
I set onconfig parameter NUMCPUVPS 10 AFF_SPROC 2 AFF_NPROCS 10 and run ' onstat -g glo' vp pid class usercpu syscpu total 1 2863646 cpu 9598.41 149.49 9747.90 2 155844 adm 0.76 1.87 2.63 3 1962…
Informix thread working with a index
Hi all, I was trying to monitor an internal informix thread. I get a table with 8 million records. I do between 1000 and 5000 insert to this table daily. Every night I update statistics to whole database. There is a thread that it gets a session id but I can't see what it's doi…
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…
Maximum concurrent users threads
Can someone tell me the formula that produces the maximum concurrent number portion of the onstat -u command? Is this based on what is defined in NETTYPE? ----------------------------------------- This message and any attachments may contain confidential information or trade sec…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…
Listener-Thread Error 25571
Today we saw hundreds of lines in our message log with the following error. The database pretty much came to a halt and nobody could connect or do any work. Only bouncing the engine cleared up this issue. 17:15:47 listener-thread: err = -25571: oserr = 0: errstr = : Cannot cr…
Re: IDS on a Mac?
I thought the title of the thread was "IDS on Mac OSX". Why don't you just create a new thread and move all the Oracle vs. Informix and all the personal bashing over there????…
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
Re: NETTYPE NET/CPU
> Read more about NETTYPE and have few more questions: > > 1. What determines the polling cycle of poll thread having class of > CPU VP. You mentioned it polls only periodically. What does it do when > it's not polling ? A poll thread running on a cpu vp will poll at a minimum o…
Cpu vp usage
AIX 5.3 IDS 10.00.UC5 We have had reports of slow performance so I have been monitoring the system. When I check with onstat -g glo I see that the cpu vp usage is skewed towards the 1st cpu vp. In the latest example cpu vp 1 has used ~4000 cpu seconds, cpu vp 2 has used ~20…
BAR_MAX_BACKUP - not spawning parallel threads
Version : 10 We are running onbar -b -l with BAR_MAX_BACKUP = 4 and BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process I just see one onbar_d process. I was expecting atleast 4 processes. Why is it just spawning one process. Is it because our SHMTOTAL is 0.…
Re: NETTYPE NET/CPU
On Aug 9, 12:10 pm, Mark Jamison <maj...@yahoo.com> wrote: > ----- Original Message ---- > > Makes it more clear. However, I have few more questions: > > >1. If an application runs on the same box as Informix then does it > >connect through socket or uses shared memory directly. …
NETTYPE NET/CPU
Version: IDS 10 I am trying to understand NETTYPE better so that we can configure our connections appropriately and perhaps make it more efficient. My questions is: 1. Is VP Class NET synonymous to OS's CPU and Vp Class CPU synonymous to oninit. 2. After reading about Vp Class …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: VPCLASS 'cpu' not enough physical procs for affinity
The following is the output of psrinfo in our Sun V890 ... # psrinfo 0 on-line since 06/16/2007 15:09:23 2 on-line since 06/16/2007 15:09:19 16 on-line since 06/16/2007 15:09:23 18 on-line since 06/16/2007 15:09:23 Please advise the value.. Dhaya …
VPCLASS 'cpu' not enough physical procs for affinity
On Jun 22, 4:21 am, sdhaya <dhaya.sni...@gmail.com> wrote: > Hi, > > I keep seeing this message "VPCLASS 'cpu' not enough physical procs > for affinity" in the "online.log". We are running our application in a > Sun V890 Server with 4CPU , 16GB RAM using "Informix Version > 10.…
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…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
Re: Anybody seen a very fast wild cat out there?
FInally, AUTO_AIOVPS is not explained that well. "the database server |automatically increases the number of AIO VPS and flusher threads when the |server detects that AIO VPs are not keeping up with the I/O workload" What threshold determines this? Couldn't adding more and mor…
IDS is busy all the time
Hi, I need a hint. Maybe somebody has had the same or a similar problem: We have an IDS 10 Server which has been running with a load of about 15 % until some days ago. Suddenly (without a config change), the load is > 50 % all the time. We shut down the engine and the load went…
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…
Thread Migration Statistics
Hi, onstat -g sch gives two informations: VP Scheduler Stats and Thread Migration Statistics. I'm looking for any information about Thread Migration Statistics. Does anyone know what is it about? What does it mean: 'steal-at steal-sc idlvp-at idlvp-sc inl-polls Q-ln'? I couldn't…
NETTYPE's poll thread number
Hi, My box has singel processor , NUMCPUVPS =1 . A lot of user will access this server, maximum will be 1500 user threads. How shoud I set up the NETTYPE in onconfig file. On informix's manual , says poll thread should not be greater than NUMCPUVPS . and user thread can no…
Holy Sh
So maybe the "marketing blitz" you referred to in your other thread is starting to roll out?…
Re: Question about CPU utilization
Jï¿œrg Rï¿œschenschmidt schrieb: > Hi, > > I have question about CPU utilization. My system is a HP UX 11.11 with > IDS 10.00.FC5. I heard once IDS is well configured if you have > usercpu/syscpu relation of >= 4 in onstat -p. > > Today I checked my instance and I found a relatio…
Re: Question about CPU utilization
Jï¿œrg Rï¿œschenschmidt wrote: > Hi, > > I have question about CPU utilization. My system is a HP UX 11.11 with > IDS 10.00.FC5. I heard once IDS is well configured if you have > usercpu/syscpu relation of >= 4 in onstat -p. > > Today I checked my instance and I found a relation …
Re: Question about CPU utilization
As with every rule, there are exceptions. The 4 to 1 ratio applies to many types of systems under various loads. However, the socket connections on HP are expense (they eat a lot of CPU). Move it to the CPU VP and use the new FASTPOLL capability and you will reduce context sw…
Re: Question about CPU utilization
Do I read this correctly that your socket pollers are consuming large amounts of cpu cycles, with a high fraction of system time, and still the IDS instance isn't really busy? I'd try to get some stack information of these VPs: $ for i in $(onstat -g glo|awk '/ soc / {print $1…
Re: Question about CPU utilization
Do I read this correctly that your socket pollers are consuming large amounts of cpu cycles, with a high fraction of system time, and still the IDS instance isn't really busy? I'd try to get some stack information of these VPs: $ for i in $(onstat -g glo|awk '/ soc / {print $1…
Question about CPU utilization
Hi, I have question about CPU utilization. My system is a HP UX 11.11 with IDS 10.00.FC5. I heard once IDS is well configured if you have usercpu/syscpu relation of >= 4 in onstat -p. Today I checked my instance and I found a relation of 2 only. My conclusion : There is somethi…
listener-thread: err = -25573
IDS 10.00.FC4 Solaris 10 New server, New Database Database has been up for 6 days. Received this error last night: 08:36:56 listener-thread: err = -25573: oserr = 13: errstr = : Network driver cannot accept a connection on the port. System error = 13. 08:36:57 listener: poll ret…
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…
To change extent and next size of huge table
TQ, disk space is a problem. We will try once we got the disk will update the thread then. Thanks again. Regards. Shani…
query using cpu
Floyd Wellershaus wrote: > Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost instantly ? Not pdq, just a query, on a non fragged table. > > It is doing multiple sequential scans of the…
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…
which query consumes much CPU ?
Cristiano Torres wrote: > we are using Informix 9.4 UC2 with Linux, but anytime the database server show (TOP) column idle 5%. > > > How can I know which session a lot of CPU in my database ? I've got my suspicions. Please post your ONCONFIG file, onstat -g ses output, and th…
Re: Find a query using very CPU
If you can find such a process in OS enviroment with Tool2, you may also do the same. 1. find the process (onstat -g ses , or using SMI db) 2. find it with Tool2 On 7/6/06, Cristiano Torres <cristiano@wpd.com.br> wrote: > > > Hello, > > someone know How can I find query usin…
sporadic listener-thread errors
Hello, we are seeing listener-thread errors sporadically (once or twice a day): OS: HPUX 11.11 IDS: 9.40FC7W3 Error messages in the message log on server side: listener-thread: err = -25580: oserr = -1: errstr = : System error occurred in network function OR listener-thread: e…
Re: VP memory cache (was IFX_FOLDVIEW)
Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…
Initialising Informix
My file settings are as follows SERVICES srvr0001 8001/tcp #Informix port sqlhosts ok_srvr onipcshm 10.0.6.2 ipcs0000 ok_tcp onsoctcp 10.0.6.2 srvr0001 onconfig DBSERVERNAME ok_srvr # Name of…
Maximum number of extends
http://groups.google.de/group/comp.databases.informix/browse_thread/thread/c8d12b3def081d8b/6181761f44b780de…
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?…
onstat -g ath
It means that the thread is waiting on the condition. netnorm (network= normal). That meand that the thread is waiting for somthing to be sent= from the client. = "Marco Schwarz" = <marco.schwarz@ro = lmail.net> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = …
Re: Informix session VS 'oninit' CPU usage
Thanx everybody for the feedback. Unfortunately I cannot use the SET EXPLAIN as Ben suggested since the executed statements are encapsulated inside an application that is executed by the users. However, I will try to mix what you suggested with other suggestions for the same kin…
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/…
Re: Thoughts on Logical Log use requested
malcolm weallans wrote: > You miss the point entirely. > Well, (tongue in cheek) use "WITH NO LOG" (because this is the Logical > Log use thread)! > > Not enough potato EEEEEEEEEEEEEE Actually, I didn't miss the point, I just felt that the thread was regarding logical log usage …
HP-UX KAIOON
Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
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: ontape vs onbar
I did some short tests to backup 600MB data (1 dbspace) with onbar/ism and ontape. Used onconfig.std except TAPEBLK 1024. 1. Debian Linux 3.1, 4 x Pentium3 900MHz, 4GB RAM: time onbar -b -L 0 0.55user 6.27system 0:15.02elapsed 45%CPU (0avgtext+0avgdata 0maxresident)k 0inputs+0ou…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: one Performance question AIX 4.3, informix 7.31ud4
Rulesh Felix wrote (in HTML) > we have a 2 CPU, 1GB mem, informix 7.31ud4, AIX 4.3 machine hosting 3 production databases >with following sizes > db1 - 58 GB > db2 - 6 GB > db3 - 2 GB > At the moment all the 3 databases are in the same instance. > CPU utilization is on an ave…
RE: one Performance question AIX 4.3, informix 7.31ud4
Rulesh Felix wrote (in HTML) > we have a 2 CPU, 1GB mem, informix 7.31ud4, AIX 4.3 machine hosting 3 production databases >with following sizes > db1 - 58 GB > db2 - 6 GB > db3 - 2 GB > At the moment all the 3 databases are in the same instance. > CPU utilization is on an ave…
Join threads
Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.…
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…
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…
many threads for process ?
We are running a batch process, and when monitoring it, I see a huge amount of threads associated with it, and most of them are waiting. One of the tables in the query is fragmented, but it only has 10 fragments, so I wouldn't expect to see more than 10 scan threads. Any ideas ? …
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
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…
DRINTERVAL
It would be interested to know which threads are running that are consuming so much cpu (onstat -g act) and what are they doing (onstat -g stk <tid>). You could try some profiling of the oninit as well to gather more info. On the other hand maybe this cpu usage is not a bad sig…
CPU utilization
Hi, We've got a W2000 machine running IDS 9.4 with 2 CPUs and the following ONCONFIG settings: MULTIPROCESSOR 0 NUMCPUVPS 1 SINGLE_CPU_VP 0 if any query is run with no-one else using the machine and you use task manager to view the CPU utilization. CPU utilization on…
AW: Too many open files to the master oninit process
pls. see your previous thread :-)…
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…
Re: Problem with ER
Heinz, You are seeing Bug 144544. Please contact tech support on this problem. "Heinz Weitkamp" <heinz.weitkamp@westfleisch.de> wrote in message news:<cjukts$n7q$1@news.xmission.com>... > Hi all, > > IDS 7.31.UD4; SCO 3.2 5.0.6 > > 7 Server with update everywhere in ER. > > On…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
How many physical processors we need to support 32K THREADS in IDS.
Hi Team, Informix IDS supports upto 32K threads according to most IDS realease notes. My question is What sort of a machine you are looking at to support this many threads?? This came to my mind when considering max. num of threads(or connections that matter) that each CPU or NE…
Re: psort used ?
"Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:<ZaLZc.234545$qp1.12220489@phobos.telenet-ops.be>... > Hello everybody, > > I enabled the psort_nprocs and set it too 8. > Is there any way I can monitor the psorts ? I want to know if they are > effectively used. >…
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: how release threads?
This is a multi-part message in MIME format. --------------020301030302090906080606 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Well, at least I have discovered what status await_MC%d in onstat -g con (or onstat -g wai) of thread means…
Re: how release threads?
make sure when you update statistics for procedure you set pdq to 0...the stored procedures that help facilitatemay be mutltithreading if you do not and the thread count will increase until evetually you get an exception error which might crash the engine.…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
Onbar uses sqlexec threads or???
Hi all, Onbar questions regarding the buffer cache..... (I'm using IDS 7.31.FD6X3 on Sun Solaris 64 bit, with Veritas Netbackup for Onbar) My onconfig : BUFFERS 800000 BAR_MAX_BACKUP 12 BAR_RETRY 2 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 Would this be ? : 800,000 buffers * …
CPUs utilization
Hi, I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are assigned to Informix DB (because of limitation of using IDS Workgroup ED). I observe that doing off business hour and nobody logon the system. I run a big sql report then run UNIX command "mpstat 2 100" it show …
Re: Multiple user threads
On Thu, 15 Jul 2004 11:58:49 -0400, Bjorn De Waele wrote: PDQ threads assigned to a session usually are not released. The session keeps them assigned in case they are needed again. I suppose this cuts overhead in heavily PDQ dependent sessions. It should be harmless. However…
Multiple user threads
Hello everybody, we're using version 9.40.T7 Our max_pdqpriority is 100. Right now, I see much this behaviour with onstat -u. Informix creates plenty of user threads. If I set with the max_pdqpriority with onmode -D to 0. Then I get a single user session which shows me sometim…
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…
Which session is using the most cpu resouce?
Henry, Sorry this response is so delayed; been a little busy. I'll also apologize for not being able to answer it completely, but I've got some direction for you. The way that I look at this is to use "top" or "glance" or "ps" to determine which oninit process is at the top of …
listener-thread: err = -408
Dear Sir, I found error in online.log when i type in shell command the following onstat �m Thu May 27 08:06:29 2004 08:06:29 listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. Then I use the finderr to get more informa…
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…
Re: Output of onstat -g glo versus vpprof
You and me both, the onstat reference used is taken from an IBM document by Troy Hewitt (??), I've found a number of discrepancies/errors and fixed/added items as I've found them. I believe the documentation is wrong and the cpu is reported on seconds. This is based on the onsta…
Setting up JVM on 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…
Setting up JVM on IDS 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list sending to informix-list…
I added memory - now what should I change in onconfig to take advantage of it?
sumGirl wrote: replies have gone to your other posting - better let this thread die...…
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…
listener-thread: err = -25572
Sometimes on Win2000, when I stop the IDS, it will not restart with a reboot. The message in the log says: 13:48:06 IBM Informix Dynamic Server Version 9.40.TC2 13:48:06 listener-thread: err = -25572: oserr = 48: errstr = : Network driver cannot bind a name to the port. Syste…
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: multi thread - Informix
That's a very old version of the CSDK, not a particularly buggy one that I remember though. The thing to be careful of in using ESQL/C with multi-threaded apps is that only one thread can use a particular connection to the server at a time. In order for multiple threads to shar…
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…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
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…
multi thread - Informix
Dear All, We have a multi thread C++ program. The threads fetch data (with prepared cursor) from an Informix DB parallel, but we got coredump (not always) The operating system is: ReliantUNIX-Y 5.45 B2005 RM600 4/768 R4000. We uses the following packages: PKGINST: SIthread…
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…
Fw: Informix thread management
I suppose I deserve this for switching machines and not correctly updating my mail account. cheers j. ----- Original Message ----- From: "Jack Parker" <jack.parker4@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <informix-list@iiug.org> Sent: Tuesday, January 06, 20…
Re: Informix thread management
Thanks Jack, I've read your article now and it's certainly quite informative. I'm still not clear on exactly what DS memory stores and what it allows you to do, and how come parallelisation is still able to happen on the system I am currently working on where IDS 7.3 has default…
Threads waiting on buffers (TWOB)
Well, Once again, our company is faced with the "threads waiting on buffers" (TWOB) issue. At a certain point, a ton of threads suddenly start waiting on a specific buffer (they show 'B' in the first flag of onstat -u). Onstat -X shows that they're almost all waiting on the same…
Re: Informix thread management
Thanks you Norton for shutting that down. cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "Jack Parker" <vze2qjg5@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <in…
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.…
Re: Informix thread management
OK, but on the other hand I *have* seen very small queries get blocked when for some inexplicable reason IDS calculated a DS_MAX_QUERIES of 6, which is a mystery in itself. (They haven't set the DS values in the onconfig, but according to the calculation in the manual it should b…
Re: Informix thread management
Thanks for a most informative post Art - as ever. On the site I'm on at the moment users often connect with PDQPRIORITY=HIGH and I'm sure I've seen several run at the same time and not get blocked. They just don't seem to get to do much in the way of parallel processing - though…
RE: What do session statuses mean?
Wait master consumer. eg. a scan thread waiting for a consumer thread like a sort thread, join thread etc. Regards, Bill > -----Original Message----- > From: andykent.bristol@virgin.net [SMTP:andykent.bristol@virgin.net] > Sent: Monday, December 15, 2003 4:43 AM > To: informix-…
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…
Re: Informix thread management
--0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: multipart/alternative; Boundary="1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E" --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: text/plain; charset=US-ASCII Content-tran…
Informix thread management
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi All, I have fragmented my database & now want to use the parallel database feature of Inform…
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…
listener-thread err -930
Hi Folks: I've just got a listener-thread err -930 on a new instance I put up last Friday. This box is in my test bed and is not critical but I would like to know why when I load data from my production server on this test server then shutdown Informix it generates this -930 er…
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?
Random thoughts: Given an uptime of 4 days, you appear to have clocked quite a bit of user cpu time. If your hardware assessment is correct, a 2-way 112mhz processor, aren't you pretty cpu-bound? What does your AIX level statistics tell you about overall cpu utilization? Quit…
Listener-thread errors
We are running IDS 7.31.UD5 on SCO OpenServer 5.0.5. We have a recurring problem when approaching 128 active user threads. We begin to see the following in our logs: 11:00:28 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. At …
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 /…
Threads waiting on buffers
Ok, so Informix tech support and I haven't been able to figure this one out. I'm hoping someone else is familiar with this problem and knows how to fix it. Every now and then, often while we are experiencing peak load, but not necessarily, our Informix engine gets into a state w…
JDBC thread hogs processor while query executes.
I'm developing a mutli-threaded Java application on Linux and am finding that when I execute an sql statement the thread that executes the statement just waits for JDBC to return with the results, and does not give up the processor to let other threads have a go while it is waiti…
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…
CPUVP overloaded but physical CPU only 50% used
Since you can add and remove virtual CPU's with the onmode command, you could try it and see if the physical CPU goes up and the number of ready threads goes down. We have a Sun V880 with 4 900 MHz CPU's and run with the number of virtual CPU's equal to the number of physical CP…
Re: Stored Procedure Performance
Joe, If you can do the following to obtain a stack trace of the server thread I might be able to tell you more: Use onstat -g ath to look at the state of the thread (Repeat it a couple of times to get an impression of any changes in state). If the state is running and you are …
A Sleeping Thread - Or is it?
I am running an update statement on a single-cpu configured HP box w/ IDS 9.30FC2. The thread says that it is sleeping (Forever), yet the the update statement is working it's way thru the table. It wakes up once in a while, says it's running, then goes back to sleep. There is cur…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: disk utilization HIGH
You need to start with the OS utilities and work down to the application. Some guidlines: using native UNIX tools (I know SUN not HP-UX) iostat, vxstat, mpstat and top. With iostat you can determine the disks getting hit. If you are on smart storage like EMC you will need to …
disk utilization HIGH
our production system (informix 9.21 on HP-UNIX ver 11.00) is running nearly 100% for disk utilization for long periods of time (and sometimes 100% for CPU) when looking at GLANCE. does anyone have some suggestions on commands/tools to get "behind the scenes" and try to decipher …
cpu time
----- Original Message ----- From: "EML" <edmund.lajara@nokia.com> To: <ids@iiug.org> Sent: Tuesday, May 20, 2003 13:46 Subject: cpu time [1180] > I've been observing a machine with IDS and application on same HP-UX platform. The machine has 8 cpu, Informix affinity to 2 process…
No thread isolation-- Unusual or Common?
Just had an experience in which a user attempted to run a very long SQL query. ("Long" in the sense that just to view the text of the query required about a dozen screens when looking at it with onstat) The SQL involved over 170 tables and UNION ALLs. However, the selectivity …
NETTYPE
I get the following error occasionally on my IDS7.3 box: 10:29:28 listener-thread: err = -25573: oserr = 72: errstr = : Network driver cannot accept a connection on the port. System error = 72. I talked with IBM and they had me run onstat -u which yielded ~1000 maximum concurren…
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…
new scan threads
I was tuning my informix with the onconfig and env variables, when I saw the output of onstat -g ses <sesid> with something like this: tid name rstcb flags curstk status 78 sqlexec b154a5b4 ---P--- 67400 b154a5b4 sleeping(secs: 3) 112 scan_1.0 b1553554 ------- 68296 b1553554 run…
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 …
Informix Lockup (Wierd)
----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…
RE: # of instances per machine
I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…
exchange thread?
hello, can anyone explain me what is an exchange thread ? and the concept behind it. bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
RE: How I can determine if my CPU VPs are starved of CPU !
Hi Rudy, I'm just looking at my old e-mails. I'm getting complaints that our system is slow. In your e-mail below you use the formula - (usercpu + syscpu) / (seconds * numcpus) OR ACTUALLY b / (a * numcpus) Is numcpus the physical number of cpus or the number of virtual cpus …
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…
Nettype
Tony Woods schrieb: > > Hello all, > > NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype > NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype > > Does the above setting mean that 3 poll threads will handle 384 connections > or each of th…
# of instances per machine
If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…
FW: what does lngspins mean?
Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …
Processor Affinity
DG provides, if asked, an unsupported utility to set the affinity of a process to a CPU or CPU group. Sun likely has such from their advanced support group. Art S. Kagel Stefan Weideneder wrote: > > Hi, > > I'm almost sure our friend "Art" has a list for all > Operating System…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
How I can determine if my CPU VPs are starved of CPU !
Hi All , I am newbie here and as an administrator. How I can determine if I have configured enough CPU VPs , or my hardware cannot support this CPU load exerted by server ( other than looking at CPU utilization) . Thanks in advance . Regards, V…
Re: KAIO ands "onstat -g iov" output
Earle A Long 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/O requests > directly to the file instead of the operating-system buf…
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 …
Linux performance
John, are you using Linux RAID? It beats hell out of the CPUS! Faster than a speeding bullet but it gets that speed by sucking up all the CPU cycles it can get. Linux built in software RAID is only really good for configuring a dedicated fileserver not for any machine that nee…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
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…
IDS 9.20 with a single cpu vp
Madison Pruet wrote in message <39A02422.21A0A67D@home.com>... >It is rather difficult to get the stack for a running thread. > >smooth1 wrote: > True, I was just thinking of using a supported method (onstat -g stk) rather than an undocumented one (kill -7 of cpu vp)! E…
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…
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…
OWS Control Center Win9x - HP-UX
hello we have a hp9000 box running Online Workgroup Server 7.20. I want to setup the admin-tools but anything i try it doesn't work. Please can anyone here help me to setup the content's of the files $INFORMIXDIR/etc/sqlhosts $INFORMIXDIR/etc/osahosts and the corresponding en…
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: [ifxmaillist] Performance IDS - IBM F50
Henrique There could be a number of reasons. It could be application, informix configuration ... Is it OLTP or batch? Are you running the update stats as described on the Release notes? List you onconfig Reset the stats (onstat -z) before a time when you expect performance i…
threads and informix ...
Hi all, I have an application which creates multiple threads and tries to connect to a database . The command to compile the application is -> > esql -e -g -thread <filename> When I use the -thread option the message displayed is -- esql: When using -thread, the THRE…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Max number of connection?
Hi, my name is Darko. My system: OS SCO OpenServer 5.0.4 IDS 7.30 UC2 When a number of threads come to "magic number of 112" the system rejects the next thread. Somtimes it hangs IDS. In online.log I found err 27001. I tried to rise a number of pool threads and listner threads…
Re: CPUvps
Steven wrote: > > Hi, > > Got the following on my IDS 7.24UC4X1 on HPUX10.20 (5 CPUs, 9 CPUvps) That's a ratio, if my maths is up to it, of 2 VPs to 1 CPU!!! > pri:informix 23> onstat -g glo|grep cpu > class vps usercpu syscpu total > cpu 9 …
CPUvps
Hi, Got the following on my IDS 7.24UC4X1 on HPUX10.20 (5 CPUs, 9 CPUvps) pri:informix 23> onstat -g glo|grep cpu class vps usercpu syscpu total cpu 9 192149.07 15658.73 207807.80 vp pid class usercpu …
Multi-threading. Where would I find the DCE libraries?
Andy Lennard wrote: > > Hi all, > > I'm trying to go multi-threaded, but where would I find the DCE > libraries for Solaris2.6? I do not think that ESQL/C uses DCE threads on Solaris. I believe that it uses either the POSIX or Sun thread library based on a commandline parameter…
Re: oninit -s and cpu utilization
rom: michele.orcutt@windmere.com > >Unfortuately or fortunately the index bug does not seem to be the problem. > >Please find attached the results of onstat -a. And how. :-) Nothing major there that I could see, I therefore reckon it might be an index or SQL problem. >My favor…
Re: oninit -s and cpu utilization
From: michele.orcutt@Windmere.com > >Hello. My system is very slow, it's running ncr mp-ras unix 3.02 and >informix >ids 7.30. >One thing that struck me is I have several oninit processes that have cpu >time's >in the >hundreds of minutes, this strikes me as high. The system/engi…
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…
oninit -s and cpu utilization
Hello. My system is very slow, it's running ncr mp-ras unix 3.02 and informix ids 7.30. One thing that struck me is I have several oninit processes that have cpu time's in the hundreds of minutes, this strikes me as high. The system/engine was bounced on Wed so its only been up f…
RE: Finding CPU hogs
Look at onstat -u and note the user processes that are running. Particularly note the users with large numbers of read and write activity. If you want more, then onstat -g ses {sess-id} to find the sql they are running. If a repeat says the same sql , then you likely have an ap…
Finding CPU hogs
Is there any way to determine which user session might be causing oninit to hog the CPU? Can any of the onstat -g commands help?…
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…
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…
Receiving "Changing data structure forced command termination." from onstat!
Thanks Sanjeev. Unfortunately, fuser didn't show anything. A note of clarification, onstat (-g ses, -g ath, and others) will show a number of threads prior to giving error message: "Changing data structure forced command termination." Anyone other ideas? Anyone else seen thi…
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: CPU Time slices, technotes.
What timeslice value is recommended for HP-UX 10.20? The default is 10 ticks. Ticks are 10ms each, so effectively the default is 100ms or 1/10s, same as the Sun default. HP 10.20 comes with a parameter template called "database server" (or something similar) which, among other…
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…
Re: Poor performance for a $750,000 box
Mike Segel wrote: > > "Art S. Kagel" wrote: > > > It > > started when I noticed that 90% of the CPU time my IDS engines were using > > was being used by CPU VP #1 and that the CPU that I had pinned that VP to > > was running at 98% ALL the time. > > Uhm why not turn off process…
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…
Poor performance for a $750,000 box
Heiko Giesselmann wrote: > > "Art S. Kagel" wrote: > > > Heiko Giesselmann wrote: > > [Mainly good recommendations SNIPPED] > > > * There are 11 CPU VPs - therefore I assume that most R/3 sessions connect > > > remotely. In this case you should have the TCP/IP poll thread…
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…
CPU VPs & logical buffer util. & read ahead util.
Hi All, Hoping someone can give me some pointers regarding my config. Thanks in advance. HP K460 4 CPUS 4Gb Memory 2 instances of Informix OnLine 2 Baan instances 150+ users connecting via 6 client servers (HP K460s) All Baan connections are made via socket connections. We ha…
Posting from the Informix-list
Andrew Ford wrote: > > One question about CPU VP's. > > We are running 2 400Mhz processors on HP UNIZ IDS 7.31.FC2. I have read in the newsgroups that some people have seen an increase in performance by having 2 CPU VP's per real CPU. I did this a few weeks ago and I have notic…
IDS on Mandrake 2.2
Hi, I installed IDS 7.3 (the CD from the Informix Conference) on my Mandrake 2.2.9-19mdk Linux. I cannot get soc connections working! I do have entries in sqlhosts, /etc/services, DSERVERBALIASES parameter is set properly etc. The only anomaly I noticed is that onstat -g glo o…
Compiling with thread libs
Platform : Solaris 2.6 INFORMIX IDS/UD Version 9.14 UC6-1 INFORMIX LIBASF LIBRARY Version 7.24.UC8 INFORMIX-Connect Version 2.20.UC1 INFORMIX EMBEDDED SQL for C Version 7.24.UC8 INFORMIX LIBGEN LIBRARY Version 7.24.UC8 INFORMIX-Universal Server Version 9.14.UC6 INFORMIX LIBOS LI…
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…
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.…
Does the Informix (not Intersolv) ODBC driver support threads and thread safety?
Hi all, I'm looking at whether the 2.8 and 3.3 Informix ODBC drivers (the ones I heard Informix built themselves) support threads, and if so, are they thread safe. Ciao Fuzzy :-)…
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…
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.…
oninit trace to user
Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA js…
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…
Raid 0 or Fragmentation?
>I wouldn't call that a I/O bottleneck. It seems more a CPU bottleneck. >If i'm right speeding up disk access won't help you. The NT Performance Monitor, shows the disk read time of that specific disk at 100%, most of the time. >Assuming you already tried to increase buffers an…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Serious performance issues
Bill, How many tli poll threads are you running? If a tli poll thread runs on a cpuvp it will generate semops and busy waits like you see on vp 7. Look at the NETTYPE parameter. BTW. I know you are a Sequent/Informix user from previous posts. What revs are you running and ho…
RE: Serious performance issues
What is the effect of the application / database redesign? You dont say what hardware configuration, OS, Informix versions .... If IDS, have you run update statistics medium? Do you now have the right indexes for the new application? Can you trace a slow sql from onstat -g se…
Serious performance issues
In the past few weeks, we went through a major upgrade of our database where we completely redesigned a large portion of the database structure, migrated the data, and updated the applications. Since that period, we've had serious performance problems. We went from a system tha…
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…
ODBC /performance
I am currently using SCO SQL retriever to access informix SE from a win95 client using a delphi written application. When the application is reading a large number of records 300,000 it is painfully slow, the Unix server HPUX10.20 performance dips only by 10% when retrieving the …
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: Capturing SQL
Javier Puente wrote: > > You can access this information by making : > 1.- onstat -u To get the session conection id > 2.- With the sessionid you can trace SQL tasks by doing > onstat -g sql sessioid > EX: > onstat -u |grep myuser > > ---Supposing that sessionid is…
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) …
Multi-thread capability and non-threaded applications ...
I'm working on a UNIX/Solaris system, and we're just about to move to a version of Informix (7.33 [?]) that supports each individual thread having its own connection to the database, which is something we really want our applications to have. Unfortunately, we link into librarie…
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…
How do I monitor a checkpoint thread?
I've been reading a lot lately about the debate over whether to run the soc poll threads on CPU or NET vp's. Art Kagel's argument for NET discusses the possiblity of the checkpoint thread hogging CPUVP #1 unless there are no page cleaners available. Is there a way to see the ch…
The ready queue Full but Unix not busy
Just a thought! I notice that you have 3 CPU VPs running. If the server has 8-10 cpus, you would get ~ 30% utilization at the server level under the conditions you have mentioned. You would also find that, if you drill down to the individual cpu utilizations, 3 of them would be a…
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…
INFORMIX and utilization of system resources on HP-UX 10.20
Without doing an exhaustive analysis, I've noticed a number of problems with your onconfig. 1) Your processor configurations is really confused: MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu…
PDQ
I noticed a performance decrease instead of a performance increase when using PDQ with creating indexes. The create indexes are done one/with: * Informix 7.23.UC6 on Solaria 2.5.1. * System: SUN E4000 with 6 CPU's and 5.3 GB internal memory. * Informix has four CPU, NO…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
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…
Multi-threading
We are using what I think is an older version of Informix (our manuals say version 7.2). Currently, I'm tyring to use informix-esql/c to interface a multi-threaded server with our Informix database. I'm having a great deal of trouble and - after spelunking through the manuals - I…
RE: onstat & vmstat CPU measurements
If you are using Sun kit these number aren't accurate due to the kernel not monitoring usage correctly. Also ps, mpstat and vmstat calculate CPU usage differently Paul Watson -----Original Message----- From: John Shepherd [mailto:johnshepherd@iname.com] Sent: 08 March 1999 21:…
onstat & vmstat CPU measurements
Greetings, I'm trying to calibrate CPU utilisation on our system using onstat, "ps -el" (both updated before and after a test job) and vmstat (updated every second). onstat's view of CPU utilisation appears to be pretty much consistent with that reported by "ps -el", but these a…
Re: VP & Actual CPU Usage
Sean Kelsey wrote: > > Informix DS 7.24.UC7 on HP 9000/899 servers running HP-UX 11.x > 6 physical CPUs > 5 configured CPU VP's > > Is there a way of determining exactly how busy a physical CPU is processing > CPU VP requests ?? > > The -g glo option gives me how busy the CPU VP'…
Re: CPU Utilization
Lyzander Marantal wrote: > Hi! > > What Unix command do I need to execute > to be able to know the utlization of my CPUs. > > TIA, > Zandy > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start…
Re: CPU Utilization
/usr/openwin/bin/perfmeter & top as well as ps -ef, vmstat, iostat Just off the 'top' of my head... Lyzander Marantal wrote in message <7ai324$4bh$1@nnrp1.dejanews.com>... :Hi! : :What Unix command do I need to execute :to be able to know the utlization of my CPUs. : :TIA, :Zandy…
Multi-threaded client ?
Is it possible to make a informix client that is multi-threaded process ? In other words, one unix process can act as multiple clients for Informix server with many threads ? Thanks in advance, from Eunsook.…
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…
Threads - Urgent
Hi all, We have an application using Informix esql/c. From my program, I query a table in another database using scroll cursor. After processing the data, I close and free the cursor, but the user thread is still maintained for the program, till I exit from the program. I woul…
Re: Performance on HP unix
Ahmad Ramzi Salleh <ramzi@telekom.com.my> wrote: > > Hi, > I'm running New Era 2.20 for end-user and using Informix 7.13 on HP-UX > 10.01. > Can anyone tell me how to identify which session take up CPU resources > because > sometimes when ever I issue top command on unix, %CPU g…
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…
Performance on HP unix
Hi, I'm running New Era 2.20 for end-user and using Informix 7.13 on HP-UX 10.01. Can anyone tell me how to identify which session take up CPU resources because sometimes when ever I issue top command on unix, %CPU goes as high as 90% for oninit command and CPU idle percentange d…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
thread safe version of informix 4gl
Does anyone know if there exists a thread safe version of informix 4gl. Thanks. William…
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…
Poll threads
A quick question. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ibm1 infmx_service3 And the onconfig file has the following DBSERVERALIASES and NETTYPE entries: …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
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: ODS 7.23 on HP-UX - SYSTEM HANG - URGENT
mperrior@my-dejanews.com wrote: > > We are running 3 ODS 7.23 instance on an HP-UX 10.20 2-processor system and > recently we are getting system hangs. The load average shoots up inexorably > whilst the CPU idle times show > 90%! No processes are showing a CPU usage > figure of >…
Re: CPUVPs and Affinity
In article <6uo97h$4rs$1@news.xmission.com>, Nigel Gall <nigelg@ppsl.com> writes > >Hi! > >I've been reading the threads on the ratio of CPUVPs to physical CPUs. > >I have a new server with three CPUs. I'd like to start off with two >CPUVPs and use affinity to bind them to the 2…
CPUVPs and Affinity
Hi! I've been reading the threads on the ratio of CPUVPs to physical CPUs. I have a new server with three CPUs. I'd like to start off with two CPUVPs and use affinity to bind them to the 2nd and 3rd CPU. Over time, I'd like to try increasing the number of CPUVPs and examine t…
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: Multithreaded process - connect problem
Check the ESQL/C manuals, I believe you can only have one active connection thread to a particular server. You could have multiple connection threads to different servers, but only one can be active at any given time. Arun David Ferguson wrote: > G'day > I am writing a multi-…
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: How to determine number of users/sessions?
Bob Gorman wrote: > > How can I query the Informix Dynamic Server inorder to determine the > number of users/sessions connected to a particular database environment? Use 'onstat -g ses' or 'onstat -u' to just look at connected sessions. To see who is connected to what database u…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Q: Linking a MULTITHREADED ESQL/C application
Hi Informix Gurus! we want to use ESQL/C in a multi-threaded application developed for Sun Solaris-2.6. esql requires some special thread library other then lipthread or libpthread: esql: When using -thread, the THREADLIB environment variable must be set to a support…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: 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…
Threaded Process
Given a process with two threads, each with their own "active" connection to the same database make different select queries concurrently, will the queries be executed and acted upon concurrently by the server? Or will the first thread to submit the query cause the other thread t…
Re: AIO virtual processor
Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …
AIO virtual processor
Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Boycott Microsoft
Can we get the Indian government to nuke this thread? -------- Stan Hixon the baby DBA hixons@cgprinting.com…
Re: Boycott Microsoft
die useless thread - die.…
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
netsrv.iem
I would like to change my sqlhosts setting for local connections from onsoctcp to onipcshm for performance. Whenever I change it, my users start to get errors that it cannot find netsrv.iem when utilization is heavy only (more than 50 users or so). I've had this problem since O…
Running multiple threads
I have a system with 4 CPU's where 3 CPU's dedicated to Informix. I do the update statistics on my tables every night. I wrote an ESQL/C program for it. The question is now how can I utilize my CPU's say having three or more update statistics running in parallel. I can't split …
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…
poll threads
What's the best way to monitor poll threads to determine if you need additional ones? We have been having a problem with sessions taking a while to actually make a database connection. When additional poll threads were added, this problem seemed to go away. My question is what…
Re: Optimizing..
A couple of clarifying questions: This limit of threads per CPU VP, is it a maximum limit of all queries, so that if the limit is hit, new queries are blocked, or is it a limit per query, so that only large queries are effected (big join/order/group by could use 30 threads but o…
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] > …
Thread process and Informix license
Is anybody know if i need a license per process or per thread ? I have a multi-thread process that performs parallel connections to a database. Do I need a license for each of the thread or only for the process ? Thanks for responding. -- Regards. _____________________________…
Pardon me. Question on news reader
I've always been seeing IGNORE THREAD/WATCH THREAD options in most news reader. I wonder what do they actually do and how best to make use of them. Sorry for posting the mesg here. LeeKB…
Multiple threads
Hi! I am using IUS 9.12 and web datablade on Solaris 2.51. I installed Netscape Enterprise Server 3.0 to use NSAPI to improve performance. I know it provides multithreading and removes connection overhead. When, however, more than two NSAPI requests are arrived at web server at …
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: multithreaded servers
Peter Weigert wrote: > > hi folks! > > does anybody know wether informix thinks about supporting a > multithreaded applicationserver with one session per thread > (the global sqlca interferes the multithread support). Esql 7.21+ supports multi-threaded applications. A task can …
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Question : ESQL, Threads, DCE ???
Hi, When I was compiling for multithreads, I got following error : esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. This is on Solaris5.5 Does this mean that informix is supporting only DCE …
multithreading question (DCE) ???
I get an esql error " esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. Does this mean that POSIX are not supported. Thanks, Sachin ___________________________________________________________…
ESQL/C System-Descriptor-Area
Hi Informix-Gurus! Does anyone know, whether System-Descriptor-Areas, created by ALLOCATE DESCRIPTOR ... DESCRIBE ... are thread-safe like Cursors and prepared statements, or not? It seems, that they are not thread-safe. Thanks in advance Markus Bschorer mb@alphatron.de…
Re: Poll Threads
Harold, >NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype You are telling online to use one CPU poll thread for shared memory connections. Either take this line out or change it to 3. Jason…
Poll Threads
I have a question about poll threads that some of the gurus may be able to answer. We are starting to use our first multi-processor machine (specifics below) and I don't see any evidence of it running multiple threads for a single user. The TFM is a little vague on the use of p…
Re: Question About oninit
First things first, you must remember that "oninit" is the database engine. It is supposed to take all of the CPU possible to efficiently and expeditiously answer your database requests. If you use onstat -g glo, you can get the pids of the oninits. This ouput will also give y…
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…
Multi_Thread Programming
Hello everyone!! I have OnLine7.11.UC1 running on HP-UX 10.X and ESQL/C 7.11.UC1. I would develop a Database application using multi-thread programming technique. but there is a problem I can't solve. I know Informix OnLine7.11 support multi-thread environment. When threads esta…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Multi Thread App
Alexander Jaremenko wrote: > > Hi All, > I'm about to write multi thread application with ESQLC. I would like to > know how ODS would treat multiple threads doing sql requests - as > separate DB - user sessions ? > Happy New Year! ODS/ESQL-C versions 7.21 and later support thr…
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: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
Re: Questions on INFORMIX 7.13 and CPU VPs
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > 1. Is it true that we can configure only one NETTYPE connection on the > CPU VP ? Currently, both my NETTYPE connections ( SOC and SHM ) are > configured on CPU VPs. If my assumption is true, does INFOR…
Questions on INFORMIX 7.13 and CPU VPs
Hi everybody, Some more questions for everybody. Feel free to answer . I have a lot of questions on CPU VPs and performance. Here goes: some background info: OS -AIX 4.1 Informix : 7.13 UC1 Number of CPUs - 8 1. Is it true that we can co…
Re: Onstat Utility
>Hi, > I'm using onstat -g ath and see threads that are slleping forever. >What could this be? Are users not exiting properly from Informix? How >do I kill these processes. > > The "sleep forever" threads are threads that will be remain dormat until they are activated by some o…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
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…
Re: Understanding high CPU utilization
In article <340E2741.58C8@umich.edu>, Brian Braun <bbraun@umich.edu> writes > >Hello informix pros, > >I'm a unix systems administrator looking at a performance problem on a >machine whose only function in life is to run a version 7.2 informix >database. CPU utilization on the b…
Re: Oninit processes running away with process time
Robertson Lee NTSE wrote: > > Hi, > > We are running Informix 7.13 on HPUX 10.01 and we are currently > experiencing a problem with 2 of our oninit processes. At the OS level > they are eating up a large amount of CPU time. Does anyone have any > ideas as to what this may be or h…
Re: Information about tables in use?!
Mr Cheuk Kong Lo wrote: > > I'd like to know if there is a way to find out what tables are in use > by a user (thread). Any possible of knowing what row is current in use > by a user (thread) as well? > Onstat -g opn shows open tables by thread id. Onstat -k will show locked ro…
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…
Understanding high CPU utilization
Hello informix pros, I'm a unix systems administrator looking at a performance problem on a machine whose only function in life is to run a version 7.2 informix database. CPU utilization on the box is almost always 100% with user time being around 90%, all of it is from oninit.…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: INFORMIX WISH LIST
This is exactly what happens when moving BLOBS across slow links - CPUVP's cranking away, no bufreads, no nothin'...just CPU spinning idly. Hmmm....maybe that's why your post was a reply to mine...boy I'm quick tonight ;-) Greg Richard Stanford wrote: snip... > Just recently, …
cpu and disk utilization
HI all, I am working on informix 7.x running under AIX on SP2 m/c. My system is having 32 nodes. I am working on system performance. What is the best way to find CPU utilization and Disk utilization. I am looking into onstat and unix sar utility. If some knows better and eazy wa…
Re: Performance Tuning
Hi, I presume you are talking level-2 CPU<->memory cache here. If so there are no informix parameters to change. This type of hardware change is transparent to us (though hopefully overall system performance will improve). Chris DRI wrote: > I am going to put in a 1 gigabyte c…
onload Informix 7.14 / pyramid bugs?
machine: Pyramid SMP_DC.OSx 1.1-94d079 dcosx NILE 16/1536 r4400 (16 cpu) Informix: Version 7.14.UD2 Problem: onunload, onload problem with named pipe: Error reading buffer Error no. 32 broken pipe. The onload utility will have a repeat…
Blocking of user threads
Hello, We are using Informix Online 7.13. The problem is that usually the user threads get blocked and if the applications which was accessing the thread exit the database which that thread was accessing gets blocked. Hence to access that particular database once again we need t…
Re: Informix 5 Performance Issues
Phantom173 <loki173@postoffice.worldnet.att.net> wrote: :My company is having performance problems on an application, and I would :like to check out some of the "solutions" that have been given to us by :various sources. : :The client is running Informix 5.2 on a Sequent 790 wit…
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…
Informix 5 Performance Issues
My company is having performance problems on an application, and I would like to check out some of the "solutions" that have been given to us by various sources. The client is running Informix 5.2 on a Sequent 790 with 16-586 (60 MHZ) processors and 760 Meg of memory. According…
Re: SCO Unix and Informix 7 Performance
Kai Shen wrote: > > Hi all, > > we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine > is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB > (plus duplexed). The system is mainly used as OLTP (80%), our onconfig > says: > MULTIPROCESSOR 1 …
SCO Unix and Informix 7 Performance
Hi all, we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB (plus duplexed). The system is mainly used as OLTP (80%), our onconfig says: MULTIPROCESSOR 1 NUMCPUVPS 1 LOCKS 300000 BUFFERS …
Re: Not glo-ing
In article <330de821.62583961@news.gte.com>, cburton@gte.net writes >I am running 7.11.UC1 on HP-UX 9.04. > >When I do onstat -g glo > there are some columns that are not documented anywhere. >Could someone please identify these? > > sched calls thread switches yield 0 yiel…
Re: HP/Raid5/Performance Lessons
David Williams wrote: > > In article <330C89FB.2578@cobe.com>, Edward Bidinotto <edbid@cobe.com> > writes > >If you are running or wish to run with Raid on HP here are some things > >that we recently ran in to. > >Onstat -g sch showed the CPU vp's basically spinning their wheels.…
Re: HP/Raid5/Performance Lessons
In article <330C89FB.2578@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >If you are running or wish to run with Raid on HP here are some things >that we recently ran in to. > >Machine Configuration: > >HP-UX 9.04, 6 cpu's, 1.6 gig mem, 32 gig raid (MTI), 600+ users some shm…
HP/Raid5/Performance Lessons
If you are running or wish to run with Raid on HP here are some things that we recently ran in to. Machine Configuration: HP-UX 9.04, 6 cpu's, 1.6 gig mem, 32 gig raid (MTI), 600+ users some shm and some tcp, Infx 7.11 uc1, around a 30 gig database Initially our informix insta…
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…
Re: Need clarification of 7.2 threaded clients
Philip Walden wrote: > > The Informix-esql/c 7.2 manual describes threaded esql/c programs. It > says that a process can have multiple "active" connections. One active > connection per thread. However it also says that only one connection can > be "current" at any time. > > What …
Re: Oracle vs Informix comparison
The point is that firing a trigger is a more expensive operation that a thread that sniffs the logs and 2pc is ... well 2pc. -- Mark…
SMI- Sessions level stats
Is there any way in OnLine 7.2 to get session level statistics like CPU utilization, idle time, etc. using SMI queries? The closest I got was the table syssdblock which has a column sdb_cumtime. However, this column never gets updated in the tests we did. Any help would be app…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: MULTIPROCESSOR OPTION 7.13
In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…
Re: MULTIPROCESSOR OPTION 7.13
Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…
MULTIPROCESSOR OPTION 7.13
The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…
re: back up utility needed
What about Alexandria? Why? HP uses it in their complex back up situations - over their own omni back. It is used by the who's who of computer indutry for back up. It is simply the fastest and the best. OK no more hype - substance. for 5.x alex uses tbtape for 6 and 7 alex us…
Re: client failures with informix 7.2
This problem is noticed by me in the AIX platform too. However I do not find this 'dummy thread syndrome' while using dbaccess.…
Re: Query Retrieval
Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…
Query Retrieval
Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…
Re: Q: Informix req. dedicated Host?
Daniel Moore wrote: > > We are beginning the process of adding enhancements to an existing > software product which will result in a high utilization of Informix. > The product itself does image processing (eg. image enhancement/OCR/ICR > all of which is rather CPU intensive) > >…
Q: Informix req. dedicated Host?
We are beginning the process of adding enhancements to an existing software product which will result in a high utilization of Informix. The product itself does image processing (eg. image enhancement/OCR/ICR all of which is rather CPU intensive) One issue at hand is how we are …
Re: Informix libraries MTSafe ?
Yes; version 7.2 provides thread-safe ESQL/C. I think you have to use DCE threads at the moment, and you certainly have to compile and link with a -thread option. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Shimon Gonen <sgonen@titan.com> }Date:…
Informix libraries MTSafe ?
Are informix libraries MTSafe? Our application is threaded on Solaris. Can you access a database concurrently from 2 or more threads in the same process? Just want to read different tables in the different threads. Thanks. -- Shimon Gonen…
Re: Oninits Running Amok...
In article <4rtnsa$e2@server2.codetel.net.do>, Tom Hay <nomad@codetel.net.do> writes >Yes, I've seen it too, on Version 7.10D1 on a uniprocessor HP-UX, and >I don't like it either. The machine virtually stops for around 30 >seconds. Can't offer any explanation, though ... sorry !…
Re: 2 CPU VP's
In article <31E262D8.20DC@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have >been thinking of incrementing the amount of CPU VP's from one to two. I don't >use the server for anything els…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
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: onstat -g questions
On 22 Apr 1996, Rajiv Jauhari wrote: > Has anyone used the "onstat -g sch" and "onstat -g spi" > commands to help tune the performance of Informix 7.1 on an SMP? > If so, can you explain the exact meanings of the various columns? I recently made an adjustment based on the info …
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. …
KAIO problem with Online 7.12 on AIX 4.1.4
I am currently using Online 7.12.UC1 on an AIX 4.1.4 platform. Because my dbspaces are created with raw device chunks, the I/O's should be performed by the KAIO threads. Thus, the I/O's should be performed by the CPU VP. However, when I issue the onstat -g glo command, I notice …
Controlling those Nasty CPU VP's
Platform=HP-UX 9.01 Informix 7.11 UC1 How can you control a session thread in a CPU VP from monopolizing the system CPU? We had a single thread take about 90% of the CPU while performing an update.…
<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: 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: ONSTAT question
Bashar Chalabi wrote: > onstat -u (version 7.1) sometimes shows a user thread with position > 1 of the flag field set to Y. The Informix manual says it means > "Waiting for condition". I cannot find anything else. > > What is a condition, and why is my thread waiting for it? A c…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
Re: 7.x, determining a unix process from a session/thread
In article <40aspa$f1l@oscar.cc.gatech.edu>, Carlos Ugarte <cau@cc.gatech.edu> wrote: >With onstat and onmonitor you can determine some information >about each thread, but I haven't figured out yet how to determine >what user process is tied to that thread. Can anyone give a Bu…
Level 0 Archive Sloooooooow
I'm looking for ideas on where to look for the source of my performance problem with tbtape. I have two HP9000/700's with OnLine 5.03 UC1 and am running a level 0 archive on both of them today. The slower model 750 with 3 Gbytes of data and a heavy system load finished after 4 …
User Threads
Does anybody know much about the number of concurrent user threads variable in the /usr/informix/etc/onconfig.std file? We're running an application, and receiving the message "You have exceeded the maximum number of user threads" Can I just up the number of threads in the config…
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: C-ISAM to Informix conversion ???
See my reply to the thread on CISAM to ISQL, it will help if you can work out a possible schema. -- Martin How…
Multithreaded software with ESQL/C 7.10.UC3
Informix Gurus, We are trying to write multi threaded software using Online 7.1 and ESQL/C 7.10.UC3, on an IBM RS6000 AIX 4.1.1. The program seems to hang arbitrarily once threads are created. Is Online 7.1 and ESQL/C 7.1 thread safe? Are there any other libraries we need to …
Splitting tables across file systems
We have an Informix SE 5.01 engine on an Altos 15000 with SCO Unix. We are upgrade our machine to a second 486-50, more RAM, and multiprocessor extensions. We have been told that by splitting the tables across different file systems we can utilize the power of the multiprocessi…
Re: Want to sort CHAR field NUMERICALLY in ACE report (SOLVED)
Thanks to those who replied.. I followed up with the solution in the previous thread.…