Oninit® Archive
Results for “onstat -g wai”
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
Speedup Index Creation on a large table
David: Could be 3 sockets of Sparc T7 or M7 processor chips with 32 cores and 8 SMT threads per core which is 256 threads per socket for 768 threads which Informix will see as 768 cores. The biggest Oracle/Sun box can host up to 16 of those besties for a whopping 4096 SMT threads…
any recommendation on NONEXCLTRIG parameter?
Hello, I was recently advised to use onstat -g opt to get list of threads and open tables by these threads as some DDL operations requires that tables cannot be even open without any locks by other sessions. Milan Rafaj --…
Listener Thread
Hi All, How can I tell if my listener threads are over worked , is there a gauge to monitor the performance of the listener threads? Basically, We have many applications that constantly logon and logoff, when it gets really busy complaints are coming in that it takes too long for…
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 ------------------------------…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
High CPU across all Informix processes
Mark: Check into the btree cleaner threads (onstat -C) ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
Large memory segment vs smaller ones
Oops, I found this in my Drafts. Thought I had sent it out already. Dennis: There are two ways to improve bufwaits. Remember that bufwaits represent contention for either individual buffers or, far more commonly, for the lru queues themselves. Given that the most important thing …
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 ------------------------------…
Informix JDBC driver cleanup bug - memory leak
From which version of the JDBC driver are these connection cleaner threads used? ------------------------------ Øyvind Gjerstad Developer/Architect PostNord AS ------------------------------…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
What does ALTER FRAGMENT do extending a fragment?
Hi, onstat -g ses |<sid> - get thread id. onstat -g stk <thread-id> What does the stack say it is doing? Regards, David. ------------------------------ David Williams ------------------------------…
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 ------------------------------…
When users complain of generic slowness (without specifics)...
When non specific, and you want 3 things...then I would check general items: 1) CPU idle on the box (at high level and individual cores) 2) Ready Queue (onstat -g rea) 3) Sessions not waiting on network (onstat -u | grep -v " Y--"), e.g. sessions waiting on locks. if nothing reve…
Get session ID of file in $PSORT_DBTEMP
Doug: Sort file: srt0010527_001 belongs to the session with sqlexec thread # 527 Ordinal sqlexec Ordinal Sort # Thread # File # ---------- -------- ---------- srt 001 0527 _001 Art ------------------------------ Art S. Kagel, President and Principal Consultant A…
Buffer wait occurs when performing INSERT in multiple sessions
Chunk writes are more "efficient" for the OS and the storage, but LRU writes are what keep the server's data moving out to disk. More LRU Writes is better in any OLTP system. Obviously in a Data Warehouse server you want to be going heavier towards 50-50 LRU -vs- Chunk writes, bu…
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…
How many aio/KAIO
As for AIO VPs, you will likely need between 2 and 6 AIO VPs with KAIO enabled and DIRECT_IO set to 4 (temp dbspaces processed with KAIO) rather than 0 or 1 if your temp dbspaces are not on RAW disk. If your temp dbspaces are cooked and DIRECT_IO is set to 1, you may need more. A…
Performance of 14.10.FC5 is worse compared to 12.10 is that possible?
Hi Paul, what's this referring to, why in this thread, where are you seeing this? Cheers, Andreas ------------------------------ Andreas Legner ------------------------------…
Slow Running Query
If like multiple rows , then how can be checked which thread id we need to compare ? Regards Amit P ------------------------------ AMIT PATEL ------------------------------…
NETTYPE connections per thread
Hi all I'm trying to get a better understanding of Informix threads and performance. I have an instance using these values: NETTYPE ipcstr,12,200,CPU VPCLASS cpu,num=12,noage,autotune=1,max=14 Is performance impacted when the number of threads starts to reach the 200 per thread? …
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
KAIO: out of OS resources, errno = 11
Thank you all. After further checking, I noticed that while the error message occurred, the mutex wait and the buffer wait of the INSERT session were continued. (Thanks to InformixHQ) As shown in the screenshot, the time when the application that executes the INSERT statement in …
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
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…
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…
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.…
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…
Transaction Locking and Indexes
David: OK, here's what's happening: Without the index every delete has to scan the entire table looking for matching rows to delete. Each row as it is examined has to be locked, dirty read or no dirty read, for a fraction of a second. As multiple scans zip through the table it …
Make Slow rollback job faster ?
If you have not looked at onstat -x, it provides an estimated= rollback time. Also you might want to consider increasing the dis= tance between LTXHWM and LTXEHWM. Increasing this distance between then = means you will start rollbacks earlier and allows other to do work whi…
Socket listener stuck behind non-yielding thread
I'm re-building all 1,900 foreign keys on a system, sometimes a many as 5 such jobs are running concurrently. Occasionally we are getting -27001 failures. I trapped one this morning: dbschema -d hangs and eventually fails -27001 Read error occurred during connection attempt. L…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Hyper threading
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…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Mutex - guard ?
From what I recall the PMR recommendation was to change to SMT-2... I have no direct experience with performance issues on P7 with SMT-4. As with all "smt*", they're SMTs and not cores for a reason. That's why I'm not surprised with SMT-2 recommendation, but I'm a bit surprised w…
Input/Output Operations
Anyone know a command that will give the Input/output operations/second(IOPs) that an Informix 11.5 instance is being asked to handle? Please understand that what I'm asking for is different than the read/write times returned per chunk from an onstat -g iof command. That command …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
ER queue data
Paul, The following are the three outputs of the commands. Please Let me know if you see some clue. The ER rejected transactions in ATS/RIS directory is fine to us( we lived with this for years, we can do manual data sync late, no problem at all). As long as ER continue to pro…
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.…
WL -244 Could not do a physical-order read to
Hi Gurus, I would like to ask your assistance on isolating the problem encountered below. The application team is trying to isolate what caused the problem -244 in Weblogic Apps Server side. I have already verified the indexes and also done update statistics of the tables concer…
Replay - Webcast -Informix Performance Tuning by Art Kagel, from March 12, 2013 at 2:00 pm, EST
Folks, The replay of Art's Webcast is now available on YouTube at http://www.youtube.com/AdvancedDataTools and at: http://www.advancedatatools.com/Informix/Webcasts.html Informix Performance Tuning by Art Kagel, Advanced DataTools Corporation Webcast on Tuesday, March 12, 2013 …
Webcast -Informix Performance Tuning by Art Kagel, Tuesday, March 12, 2013 at 2:00 pm, EST
Folks, This Tuesday - Informix Performance Tuning by Art Kagel, Advanced DataTools Corporation our next Webcast on Tuesday, March 12, 2013 at 2:00 pm, Eastern Standard Time For the Performance Tuning Webcast: Art will go through the steps one takes to determine the health of t…
Webcast -Informix Performance Tuning by Art Kagel, Tuesday, March 12, 2013 at 2:00 pm, EST
Informix Performance Tuning by Art Kagel, Advanced DataTools Corporation our next Webcast on Tuesday, March 12, 2013 at 2:00 pm, Eastern Standard Time For the Performance Tuning Webcast: Art will go through the steps one takes to determine the health of the server and start Inf…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
ER queue question
Hi, sorry, the picture from OAT is not visible in the posts. Perhaps the output of onstat -g rqm may help: IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 160 days 06:40:12 -- 1392640 Kbytes CDR Reliable Queue Manager (RQM) Statistics: RQM Statistics for Queue …
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,…
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…
question on a strange IDS issue for the group -- l
thank you all very much for the help. latest actions were to turn off KAIO. this only slightly improved the flush rates, but for all practicality removed the user waits on the checkpoint. my assumption is that since informix is now managing the i/o, it can be a little smarter a…
1024 incomplete connections at this time.
Original Post: Well that message is coming from the listener thread doing a comparison that is has (in you case) 1024 incoming connections it hasn't gotten to at that particular moment. So basically at the tci/ip layer there's 1024 or more, incoming connection requests queued up…
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…
ONTAPE Level 1 resource usage
Answers in line... On Thu, Apr 19, 2012 at 12:27 AM, MATTHEW HOUSTON < matthewh@wedderburn.com.au> wrote: > Hi guys, first post! I have inherited an Informix database running our > companies ERP system and while I'm learning fast I am far from even > competent. > > Congratulati…
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…
Wait and Queue statistics
Can anybody provide clues on how to interpret onstat -g wst and onstat -g qst output please? I looked at the standard documentation but not much useful. Thanks, idos…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Informix Status Explanations
All of your guesses are correct. A bufwait occurs under two ceircumstances. One is when a page in the cache is locked by a session that needs to modify its contents either to modify the existing page, to read a new page into a cache page from disk, or to create a new page to be a…
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
How many concurrent sessions do you normally have? How many LRU queues are configured? How many physical processor cores on the system? How fast are they? Itanium or PA-RISC? How many CPU VPs are configured? What are your settings for: VPCLASS cpu MULTIPROCESSOR RESIDENT Art Ar…
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
This is interesting, just looking at a couple of our systems... Efficiency on CPU threads sits between 60-80%. I suspect that's probably about right, because in our environment the client application is on the same box competing for resources... The efficiency on all the io cla…
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…
RE: System Freezes
Itanium - rx6600 server. From: Art Kagel [mailto:art.kagel@gmail.com] Sent: Tuesday, January 11, 2011 3:50 PM To: Rubinstein, James Cc: informix-list@iiug.org Subject: Re: System Freezes Wait, HPUX? Is this a PA-RISC system or Itanium? If PA-RISC, how many shared memory s…
network errors
We don't have a definitive answer, but it is a reverse DNS lookup problem. The majority of Informix's reverse lookup requests were timing out with the DNS servers so it would wait and repeat and if still failed, put them back to the bottom of the queue to try again. We added our…
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…
BI as a SaaS deployment
Yesterday, in part two of our four part blog series on Cloud Computing – The benefits of Business Intelligence in The Cloud (Part 2) – we outlined the benefits of utilizing a Business Intelligence (BI) tool as a Software-as-a-Service (SaaS) deployment in The Cloud. The benefits …
Queries waiting for mutex
Hi, There a no Informix processes with sessions, only threads. And there are quite a few threads with no session: page cleaners, log writers, btree cleaners, and more. Take a look at onstat -g ath (All THreads) to see the full set. You may have one of those internal threads caus…
Memory Management
oh..also think around 300 threads connected to this database.…
RE: Enterprise Replication help - urgent
PMR logged - 03969,999,796 - now I wait for IBM to ring back :) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Tuesday, 24 August 2010 2:45 a.m. To: ids@iiug.org Subject: Re: Enterprise Replication help - urge…
RE: Enterprise Replication help - urgent
Thread 205 is gone (disappeared with the engine bounce) As it was heading into the night here in New Zealand, I threw a whole heap of space at the smart blob space and said "sort it in the morning". My first task when I get in to work (about an hour away) is to raise a case with …
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…
Multiprocessor setting
John's talking about OS scheduling. With your applications and a web server all sharing the same set of processors, I'm not surprised that the VP efficiency is around 35%. If most application and web server tasks entail accessing the database then any action requires at least two…
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…
What does onstat -g lmx spots?
Hi all, quick question, what does onstat -g lmx tell you? when I face a slow down and I check "onstat -g lmx" output saying there is a pt_# mutex with a holder and a long queue of threads waiting for that resource, does it mean that the thread holding the lock is generating the …
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…
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…
mutex dbs_partn and pt_170003
Hi, today happened the same thing, the batch processes suffered for mutexes, in onstat -g wmx shows the thread which have waiting for mutex others usethreads is one userthread of batch process: 10010210|IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up 3 days 13:48:…
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.…
Question about the status of the thread
On Jun 30, 2:58 pm, Peternt <roger_vi...@yahoo.es> wrote: > 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 "sleepin…
large number of sessions with Y flag
Run an onstat -g wai if you have WAITSTATS enabled, to see what's being waited for and determine where the contention lies. What's your BR (Bufwaits Ratio) look like? Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mi…
Re: Configuring IDS for multi-threaded processors
Niagra 2 is just as bad as Niagra 1 just worse because is supports more cores and more threads per core. The major actual improvement of Niagra2 over 1 is that Niagra1 only had one FPU per chip while Niagra2 has one per core. Otherwise, Niagra2 is probably worse than Niagra1 be…
Re: Configuring IDS for multi-threaded processors
Cesar Inacio Martins schrieb: > Hi Art, > > Can you tell me if this behave occur with processor Niagra 2 (UltraSPARC T2) ? > Where I can get documentation about this kind of information? threads optimization on Sun Processors (T1 and T2)... > > > --- Em seg, 8/6/09, Art Kagel <ar…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
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.…
Re: Best Use of Free Memory
Longer chains do mean more latch contention, however there is a very simple solution -- increase the number of chains. These are very cheap -- the overhead is roughly the amount of memory it takes to hold a couple extra latches and pointers, which is only in the tens of bytes per…
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…
Weird one
In AIO environments, overallocating AIOVPs and/or CPUVPs can lead to IO Wait problems and substantial performance degradation. The AIOVPs end up waitting on each other for physical disk access. Since the AIOVPs occupy cpu resources to get to the disk, it backs up that physical re…
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…
Problems on SUN with chunks being marked down
It's not a permission's issue and a reboot was not involved either time. That was the very first thing I checked anyway just in case. :-( The disk showed no errors, no waits, no queue lengths, nothing! Thanks,Alyx…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
Hi Experts, We use an informix database as database layer for an ERP application. We encounter high CPU usage of the informix server while the ERP application is hardly used (low number of active users). The high CPU load always starts at the same timepoint in the morning and en…
onstat -g rea almot 100 queue there !!!
You have idle time and items in the queue concurrently because the CPU VPs sometimes have to wait for resources. There is lots more information we need to try to help you: - How many LRUs do you have configured? - How much cache is configured? If you do not have enough LRUs co…
Re: IDS 11 upgrade - slower and different mutexes
Hi John, Your reply is greatly appreciated.? I will take a look at the items that you mentioned.? Thanks again. Bruce -----Original Message----- From: John Miller iii <miller3@us.ibm.com> To: ids@iiug.org Sent: Wed, 11 Jun 2008 12:52 am Subject: Re: IDS 11 upgrade - slower and…
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 11 ugrade - slower and different mutexes
Hi, An upgrade from IDS 10.00.FC7 to IDS 11.10.FC2 was just done on an HP-UX? 11.23 server with PA-RISC CPU architecture.? Going from IDS 10 to 11.1 a direct conversion of the database is done.? Update statistics was run on the database after the conversion.? It was hoped that t…
Re: CPU VP Issue
pokeyman76@yahoo.com wrote: > VPCLASS cpu,num=4,noage,aff=0-3 > This will turn on noage and affinity for your 4 cpu vps > > NETTYPE onsoctcp,1,600,NET > FASTPOLL 1 I've seen stuff on FASTPOLL, but have…
CPU VP Issue
tgirsch wrote: > I've got a puzzling CPU VP issue that I'm hoping someone else here has > dealt with. I've got a dedicated database server running IDS 10.00.FC8 > on a four-core RHEL Opteron server. We've configured four CPU VPs, one > per core. There are almost always five to…
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…
onbar restore blocked on checkpoint
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] > Sent: Monday, March 17, 2008 11:05 AM > To: ids@iiug.org > Subject: Re: onbar restore blocked on checkpoint [11631] > > Just wanted to add a few observations from my last (unsuccessful) test…
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, let me add my 2 Eurocents Art S. Kagel (Oninit LLC) schrieb: > SAMUEL JAKABOWSKI wrote: >> Hi, >> >> While setting up a test environment, a question concerning the correct > setting >> for NUMCPUVPS popped up. >> > > So, what's the question? You have 4 cores and you have co…
Request for input on IDS V10 Checkpoint Blocking
Has anyone seen a problem with IDS V10 going into checkpoint and not coming out? AIX 5.3 > oslevel -s 5300-06-03-0732 IDS 10.00.FC5 I currently have a case open with support and it has been sent off to development but what I am hearing makes me want to rollback until FC8 is av…
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????…
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…
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.…
Buffer waits
Onstat -R shows clean versus dirty buffers, not used versus unused. Onstat -P on the first line which is partnum zero (0) the 'other' column is the number of unused buffers, usually zero for any server that's been online for a reasonable time. Bufwaits have two sources, one is s…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
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: cond wait: drcb_bqe problem
Lynn, Will you let me know if support recommends anything or finds a solution to your problem. I am currently experiencing a similar issue with HDR, logbf cond waits and long checkpoints. Thanks, Andrew ----- Original Message ----- From: "Lynn Nguyen" <Lynn.Nguyen@the401kcom…
Re: cond wait: drcb_bqe problem
Lynn Nguyen wrote: > We are doing async HDR. Our network pipe from Austin to Denver is DS3 > 45 mbits/sec. The ping time is 33 ms. > > I didn't notice any L0, L1, or L2 at the time. Though I did see the > logbf in the cond wait. I put some entries in you case and talked with …
RE: cond wait: drcb_bqe problem
We are doing async HDR. Our network pipe from Austin to Denver is DS3 45 mbits/sec. The ping time is 33 ms. I didn't notice any L0, L1, or L2 at the time. Though I did see the logbf in the cond wait. Thanks, Lynn Nguyen -----Original Message----- From: informix-list-bounces…
cond wait: drcb_bqe problem
Lynn Nguyen wrote: > Hello, > > We�re having big performance problem with replication (HDR) and hoping > you can help providing some suggestions. With replication on, our > applications take 4 times longer to run. Onstat �g ses on the session > showed a status of �cond wa…
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…
monitoring load
the second one : onstat -g rea These threads are 'ready to run' (waiting for CPU). onstat -g wai shows waiting threads (waiting for IO, Locks, Checkpoint, ...) Regards, Andreas Kutsche > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptze…
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?…
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…
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…
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…
rootdbs full error
Hi all, IDS 7.31 online.log gave an error "CDR QUEUER: Send Queue DB space is FULL - waiting for space" this morning. Also, I saw that rootdbs was full and 4gl applications didn't run. There is two IDS 7.31 and replication is defining active - passive. Problem is passive server. …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
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?…
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/…
Informix session VS 'oninit' CPU usage
NOTE: I have just done the Informix Internals course You could set WSTATS 1 in the onconfig file and run onstat -g wst and look at the run time per thread. Of course all this getting the current time every time a thread moves from the run queue to the ready or wait or sleep …
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!…
what is waiting for
No sweat. Keep pounding away at understanding, that's how most of us got what little knowledge we have. Art ----- Original Message ----- From: NStor GMe.... <ids@iiug.org> At: 1/13 13:01 thanks Rob and Art for your comments. This is not a 'problem' indeed, is a rather of 'try…
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.…
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…
Connections hang
You might have tried all the below, if not 1. What is the status of the engine "onstat - ". Is it online or is it in Blocked CKPT state. Might be it is waiting on a check point. 2. What is the status of each session "onstat -u ", third column flags. The first character/flag would…
bad performance on delete
On Informix 7.23, when deleting records on large tables it goes very slow. What should we change to get better performance? $ onstat -p INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 01:06:01 -- 130680 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bu…
bad performance on delete
On Informix 7.23, when deleting records on large tables it goes very slow. What should we change to get better performance? $ onstat -p INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 01:06:01 -- 130680 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bu…
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…
Re: Single cpu vp woe
Art S. Kagel wrote: > > Andrew, I disagree. NOAGE has nothing to do with allowing IDS to > take over the "complete allocation of the cpu cycles" of one or more > processors. The reason for NOAGE is that some OSes (most > aggressively HPUX and less so Solaris) progressively redu…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: More CPUVPs than processors
Neil Truby wrote: <SNIP> >>This keeps bugging me...with more CPUVPS than physical CPUS we should >>just be spending more time context switching between VP ... > > > Well, yes, I too fail to understand how, conceptually, having more cpu vps > than cpus can work. Since several res…
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 ? …
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…
AW: Too many open files to the master oninit process
pls. see your previous thread :-)…
Re: Cannot set/unset DELIMIDENT
Petro Schutte wrote: > Solaris 8 > Informix Dynamic Server Version 7.31.FD1 > > On the specific server commands in dbaccess behave as if DELIMIDENT is > set. Neither does it show when I list the current environment > variables nor can I unset it. I have tried it in Kourne shell …
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 * …
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…
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…
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: [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…
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…
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…
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…
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?…
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 …
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…
Tuning IDS 9.30 after migration from IDS7.31
We've recently migrated from 7.31UC5 to 9.30UC5. Our platform is AIX 4.3.3. The hardware is an S7A with twelve CPU's. KAIO is enabled. The machine runs both the database and 4gl, c, and perl applications that connect to the database. There are also many remote applications th…
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…
Re: Onbar Backup?
Venkatesh, Well, the backup speed is dependant on the type of tape drive you have. For a DLT7000 you should get about 40-50 GB/hour. Backing-up to a disk storage unit is the fastest speed you will ever get, so you can benchmark against this. The Informix "arc_very_old_page" bug…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
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…
cpu time
I am not sure how to explain that. It's just 2 cpus and what happens depends on scheduling and timing details. Some minor change in your application or in the online server might be responsible for this. With 9.30.UC3 on an 8 cpu Solaris8 machine with 8 cpu vps and this client s…
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 …
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…
Multiple DBs vs Multiple instances
This is sometimes a difficult choice. Multiple databases in one instance: On the minus side: all the work on all the db's is done by the same set of virtual processors, and all that work uses a common set of shared memory segments. The thread scheduler in IDS is not terribly sop…
Buffer wait ratio
Tony Woods wrote: > > Hello all, > > Calculating Buffer wait ratio or Buffer turnover ratio : > ((bufwaits/(pagreads + bufwrits)) * 100) That's the Bufwaits Ratio (BR), yes. Buffer turnover rate is different: (BUFFERS / (pagreads + bufwrits)) / [minutes since stats zero'd] > …
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/…
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…
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…
FW: Queue statistics
On HP I just add the following entry to the onconfig file - WSTATS 1 You will have to shutdown and restart the database of course Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Beh…
Queue statistics
Hi! What should I do to enable queue and wait statistics ( those shown with onstat -g qst , onstat -g wst ) ? I have IDS 2000 V 9.20 on an Unixware 7.1 box . Thanks. Sorin Ifrim…
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…
RE: KAIO - out of OS resources ..any idea
OK, sorry, the reply I posted was HP-specific. I can't find 7.31FC6 in the Informixtechinfo pages, but here is the an extract from the release notes for 7.20UC3, with a relevant paragraph: <EXTRACT FOLLOWS> 16. Known Defect(s) 1. Bug No: 40041 Short Description : DEC …
RE SIMPLE SQL STATEMENT
I cannot just delete the ct12 and keep the existing ct14 record instead of deleting the later and updating the former because the former has some columns with values that are useful which are not contained in the columns of the later.Any way I have managed to write a program whic…
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…
SIMPLE SQL STATEMENT
HELP I HAVE a table with duplicated records .this was a result of a aplication progmamme which inserted duplicates in stead of updating? i want to remove the duplicate and use some of the duplicate info to update .. eg recno name regnomber course 1 simba 345 ct12 …
Re: You've heard it all before, cont.
Andrew Ford wrote: > > I'm posting some other onstat commands that may help. > > Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 3 days 09:44:13 -- 2545024 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 261671478 74154240…
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…
Insert performance is poor
Tony Flaherty wrote: > >TBLSPACE_STATS 1 > > This has a huge (allegedly 20-30%) processing overhead, it should be turned > of (0) unless you are trouble shooting a specific problem. > This is'nt quite right. TBLSPACE_STATS hardly affects performance (but allows you to retrieve…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: onconfig advise please
Michal Hajek wrote: > > "Art S. Kagel" wrote: > > More LRUS & CLEANERS your BR is 25% more than 4X normal, you are running on > > Art, I have read the term "BR" from you many times, but I've never > discover what does it mean ? > How do you calculate it ? It seems to be one of mo…
Servicing multiple users
Informix gurus -- Kind of new at informix and would appreciate any info regarding client server: I'm constructing a 3 tiered client server architecture using informix (server on solaris, clients on NT) and was wondering: When multiple requests come in, can those requests be se…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
RE: informix IDS7.31 crawling
We are using 7.31 on HP UX 11.0 and our users are happy with the performance, but there are changes that need to be made for the optimizer to work. Wayne -----Original Message----- From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] Sent: Monday, July 10, 2000 9:04 AM To: informix…
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: informix IDS7.31 crawling
UPDATE STATISTICS? From: chivaviro1379@my-deja.com > >I have just upgraded my server from HP900k260 HP-UX10.2 32 bit 1,5GIG >ram with informix IDS 7.30 and runner 7.2 UD6 TO HP 900 L100 HP-UX >11.0 2GIG ram with Informix IDS 7.31 UC5-1. with runner 7.2 UD8. The >problem is that…
informix IDS7.31 crawling
I have just upgraded my server from HP900k260 HP-UX10.2 32 bit 1,5GIG ram with informix IDS 7.30 and runner 7.2 UD6 TO HP 900 L100 HP-UX 11.0 2GIG ram with Informix IDS 7.31 UC5-1. with runner 7.2 UD8. The problem is that I could not use the 7.2 UD8 runner to run programs compil…
Re: Slowness
Leonids.Voroncovs@dati.lv wrote: > > "Art S. Kagel" wrote: > > > If you still have BR problems you can try increasing BUFFERS also > > and then you have to use the undocumented ONCONFIG parameter LRUPRIORITY > > to alter how clients select LRU queues to reduce contention. > > Oop…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
RE: What is bufwaits (onstat -p)
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >"Art S. Kagel" wrote: >> >> The bufwaits indicates when a thread has to wait to read a page into a >> buffer from disk usually this is caused by the LRU Queue to which the thread >> has hashed to …
RE: What is bufwaits (onstat -p)
I have one question. From your message: -- Pages that get both update and read activity or pages that get updated by multiple users are the source of bufwaits. The odds of two users with incompatible access modes hitting the same page at the same time is little affected by the …
Re: What is bufwaits (onstat -p)
Bufwaits have little or nothing to do with LRU contention nor with reading in a page from disk. As Vinod said it does occur when one has to wait on a buffer because another is accessing it. The counter is not incremented because one waits to get access to an LRU. It is increme…
What is bufwaits (onstat -p)
The bufwaits indicates when a thread has to wait to read a page into a buffer from disk usually this is caused by the LRU Queue to which the thread has hashed to acquire a buffer being locked by another thread trying to do the same thing or needing to move a buffer from the 'clea…
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…
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…
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…
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…
onstat -g glo output
Internally we use the gfd (Global file descriptor) instead of simply fd for each of the chunks. This is because the global file descriptor is common for each of the vps while the local file descriptor would not. The maxlen is the maximum length of the queue of outstanding reque…
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…
Re: NETTYPE
Just a quick thought that the 8200 has only 2 physical cpu's so by the book that allows 1 cpu vp A far better approach would be to use the set up Art suggests with a 3rd cpu in the 8200 We have noticed over a number of years that the third cpu and therefore 2nd cpu vp makes the s…
NETTYPE
mars1972@my-deja.com wrote: > > In article <61CEA8293505D211A0E90000F87AAD7D2E02EE@srrcex1.srrpa.es>, > =?iso-8859-1?Q?Pablo_Herrero_Fern=E1ndez?= <PabloF.Herrero@srrpa.es> > wrote: > > Hello everybody. > > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the > n…
Few (shorter :-)) questions
Hi, I'm interested is there something wrong with configuration (based on onstat results). First, it is Ultra Sparc computer, with 4 processors (1 processor has affinity set). onstat -g glo gives this output: >>Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 15 days 2…
Re: Periodic extremely slow ontape archives
Thanks for the feedback and question. Yes, we take a level 0 each night. The level is hardcoded in the script we use. Dick "Obnoxio The Clown" <obnoxio@hotmail.com> on 01/07/2000 05:24:06 AM To: Dick Brieck/CHASE@CHASE, informix-list@iiug.org cc: Subject: Re: Periodic ext…
Re: Periodic extremely slow ontape archives
This might sound stupid, but are you taking the same level of archive every night? From: Dick.Brieck@chase.com > >Greetings. We have been experiencing intermittently long archives >using ontape for several months. These long runs have increased >in duration and frequency durin…
RE: Periodic extremely slow ontape archives
Dick, I have experienced the same problem. It turned out to be a faulty tape drive (DLT7000 also). It was replaced and all is well. Scott H. > ---------- > From: Dick.Brieck@chase.com[SMTP:Dick.Brieck@chase.com] > Sent: Wednesday, January 05, 2000 3:57 PM > To: informix-l…
Periodic extremely slow ontape archives
Have you had the tapes checked and the tape drive cleaned? Dick.Brieck@chase.com wrote in message <850e1p$gu7$1@news.xmission.com>... > > > >Greetings. We have been experiencing intermittently long archives >using ontape for several months. These long runs have increased >in du…
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…
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: Long spins or onstst -g spi. Need any information.
Hi William I thought so too, but my interpretation from documentation is that onstat -g sci shows long spins. Maybe it isn't correct However " - spi Prints spin locks that virtual processors have spun more than 10,000 times to acquire. These spin locks are called longspins. Th…
Re: Long spins or onstst -g spi. Need any information.
I found this one : "This command lists spin locks that have been obtained after more than 10000 spins for any virutal processor. When a virtual processor spins more than 10 000 times, this is called a longspin. There are four things that you can do to reduce longspin: - Reduce l…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
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…
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 :-)…
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…
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…
performance turning help
Hi all, Can anybody help me look at my onconfig file to see something odd need to make a change. My Informix seen to run slow and not taking full CPU resource. I would ppreciate any help I can get on this problem. Thanks In Advance. --Wayne Trieu PS: sorry for the long …
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
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…
Re: Checkpoints - a mystery
Sean Kelsey wrote: > > Sorry if I have already posted this once already...we are having problems > with our news server... > > HP-UX 10.20 running IDS 7.24.UC5 > > We have been having isolated problems with checkpoints - see below. During > the lengthy checkpoints, obviously no u…
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…
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…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
RE: onstat -g sch , Busy Waits ?
According to "Informix, DBA Survival Guide" by Joe Lumbley, on page 260, Monitoring Virtual Processors, "When a CPU VP does not have a thread to run, the process performs a 'busywait' . This is a loop of instructions designed to wait a short time". So comparing CPU VP Number 3, …
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
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…
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: Informix Performance
Speaking of this, when the 'User thread Status' shows 'Y--P---' it indicates that the process is waiting on a 'condition'. It often seems this indicates the process is waiting on some input from a user process via the network. However, this may not always be true. Is there a w…
Re: User thread status help
gquian wrote: > > I'm running an application process that works abnormaly slow on Informix > >Online DS. > >I've take a look in on-monitor about user-threads. > > > >The 'User thread Status' column shows 'Y--P---' during a lot of time. Like the 'B' in your first posting the 'Y'…
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…
Re: Question: Online 7.14 not shutting dwn completly
In article <r9fV1.100$yU.305044@newse1.midsouth.rr.com>, Carlos Bolden <cbolden1@midsouth.rr.com> writes >Hi All, > > I have a problem. We have a system at work ( NCR 3555 running Informix >ODS 7.14, TOPEND 02.02.02.00 with a serious application built for it. 186gig >of datas…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Re: Follow-up: CPU poll threads ...
On Wed, 28 Oct 1998, Art S. Kagel wrote: > Schaeflein, Paul wrote: > > > > Would you please describe the difference between NET VPs and CPU VPs? And > > why is one better than the other? > [Original reply SNIPPED] > > OK. Basically a NET VP (shown as class tli, soc, ipx, shm, s…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: Follow-up: CPU poll threads ...
Schaeflein, Paul wrote: > > Would you please describe the difference between NET VPs and CPU VPs? And > why is one better than the other? [Original reply SNIPPED] OK. Basically a NET VP (shown as class tli, soc, ipx, shm, str in the onstat -g glo report) is a Virtual Processor …
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…
Question: Online 7.14 not shutting dwn completly
Hi All, I have a problem. We have a system at work ( NCR 3555 running Informix ODS 7.14, TOPEND 02.02.02.00 with a serious application built for it. 186gig of dataspace mirrored, and in need of some serious DB maintenance, 2 gig of ram and 16 pentium 133 processors, running…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
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:…
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…
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: 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: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: latch/lock , buffer - questions.
Sadagopan, Sathish wrote: > > Hi All, > 1) When a thread needs a buffer to read in data , does it acquire any > latches/locks.How is the allocation done ? This is all explained in the Administrator's Guide. Basically the thread hashes into the LRU queues selecting a queue at …
Re: onstat -g con
wrosale@cap.org wrote: > > Is there somewhere that describes what the 1st column, cid , column refers > to ? > > /informix> onstat -g con|more > > INFORMIX-OnLine Version 7.22.UC1 -- On-Line -- Up 16:34:03 -- 1498328 Kbytes > > Conditions with waiters: > cid addr name…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re[2]: queue statistics
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable In the $ONCONFIG file, set QSTATS to 1 for onstat -g qst to work, or=20 WSTATS to 1 for onstat …
Re: queue statistics
Sadagopan, Sathish wrote: > > Hi, > The qst option of onstat says "queue statistics not enabled".How to enable Q > statistics ? There is an environment variable that has to be set in the engine's environment at startup that enables stq and wai statistics recording. These are dis…
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…
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…
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…
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…
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…
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. _____________________________…
Re: Lock Mode To Wait 5
Bill Weaver wrote: > Does "Set lock mode to wait 5" attempt to get a lock for 5 seconds and then time > out or does it try once and then a second attempt 5 seconds later? It will attempt to get the lock for at most 5 seconds. It will be queued on the lock, so if the lock frees…
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 …
Re: waiting for SEM
According to Elizabeth Suto's book: if you set the MULTIPROCESSOR to 1, this alters the OnLine system to use spin locks for threads. Thread spin locks keep threads from being put on a sleep or wait queue while waiting a very short time for a resource. IF you set SINGLE_CPU_VP t…
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…
OKIIUG Performance Tuning Seminar
THIS IS THE LAST WEEK TO REGISTER !!! The second annual Informix Engine Tuning and Performance Seminar will be held on Saturday, January 31, 1997 from 8:30 a.m. ~ 4:30 p.m. The seminar will be conducted by an outside consultant that specializes in Informix engine work. He is a…
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…
PERFORMANCE TUNING SEMINAR - OKIIUG
The second annual Informix Engine Tuning and Performance Seminar will be held on Saturday, January 31, 1997 from 8:30 a.m. ~ 4:30 p.m. The seminar will be conducted by an outside consultant that specializes in Informix engine work. He is also a certified, current Informix instr…
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…
Gradual Performance Drop on 7.23.UC1 x86
We are having some performance problems that increase gradually over time. We just recently upgrade to 7.23.UC1 for x86 that solved the majority of our problems, but this one remains. As such, I believe that it is a configuration problem but I can't figure out where it is. We …
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
Re: Logical Logs -Explain
In article <3485C2BE.73FA@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Almost, Mark. It would be more accurate to say that a foreground write >happens when an application thread needs a buffer to write into and >cannot get access to one after a specified number o…
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: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
James Francis asks: > We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed > disk array. > Our database is around 100GB. > > When we run our application with one user everything performs lightning > fast. > As more users degrade, the performance continues t…
Re: Informix hogging CPU
The multithreading architecture of DSA uses the virtual processors scheme in which we have the CPU virtual processors (they are called CPU VPs because they run the cpu intensive threads and they are supossed to make non-blocking system calls). There's allways a low priority probl…
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…
Re: onstat -u, B-flag
Alexander Selg wrote: > > Hello All ! > > The command "onstat -u" gives some information about the userthreads. In > the 2.column you can see the flags to each thread. The 1.position > indicates the resource a thread is waiting for. > My question is: if there is a "B" on the 1.po…
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…
Re: When does bufwaits get incremented ?
In article <33F9E9A6.7EE8@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >tony edwards wrote: >> >> Hey, >> I've been trying to track down some information about when bufwaits is >> incremented. I found the following in the ODS Admin guide... > >If after a li…
Re: When does bufwaits get incremented ?
tony edwards wrote: > > Hey, > I've been trying to track down some information about when bufwaits is > incremented. I found the following in the ODS Admin guide... If after a limited number of attempts to find an unlocked queue, no free buffer has been found the thread …
Re: When does bufwaits get incremented ?
tony edwards wrote: > > Hey, > I've been trying to track down some information about when bufwaits is > incremented. I found the following in the ODS Admin guide... If after a limited number of attempts to find an unlocked queue, no free buffer has been found the thread …
Re: Informix and NOAGE
Jim Jordan wrote: > > In article <33CC2D68.307@bellsouth.net>, > MIS Dept <whsmis1@bellsouth.net> wrote: > >Saeed Talebbeik wrote: > > >> Both NOAGE and processor affinity can boost the performance. > >> However look into the machine notes of your platform to see if > the…
Re: Informix and NOAGE
In article <33CC2D68.307@bellsouth.net>, MIS Dept <whsmis1@bellsouth.net> wrote: >Saeed Talebbeik wrote: >> Both NOAGE and processor affinity can boost the performance. >> However look into the machine notes of your platform to see if these two >> features are really supported.…
Re: Undocumented oninit variables
Hi, Jeff Craig wrote: > You can put two settings in your onconfig file as: > WSTATS 1 > QSTATS 1 > > Then, issue onstats -g wst or onstat -g qst to view wait and > queue statistics. If you make any headway in understanding > what they tell you, please post me back. You may al…
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: excessive latch waits
In article <5k3eeg$s0h@cssun.mathcs.emory.edu>, Mark Steele <msteele@firstam.com> writes >Got a little problem. I am running Informix 5.01.UD3 Online on an IBM >RS/6000. Lately we have seen some performance problems. Then looking >at tbstat -u, I am seeing an excessive amount …
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: semaphores or lack there of
david, you didn't say if all this was in response to a problem. i assume if you have 24 to 30 threads in the wait queue that you are experiencing some performance problems, but not necessarily. > When I do a onstat -g wai and look at my sqlexec threads I see 24 to 30 > of my …
semaphores or lack there of
I have a few questions as to how to identify if you are running out of semaphores, and the exact parameters to set. My environment is a 16 way SGI with 2gb and one four tray five disk MTI at raid 5. I also have 5 single disks not raided across 5 controllers for indexes. The thre…
Re: Tuning CPUVPS/AIOVPS
In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…
Re: main_loop stuck !
In article <5d9n8i$rf2@cssun.mathcs.emory.edu>, Rick Ward <wardr@gusco.com> writes >Hello everyone, has anyone out there had this problem ??? > >Using: Online 7.13.UC2 >on: Solaris 2.5 > >The situation is as follows: > >Logical log files are almost full - backup is needed. > >…
main_loop stuck !
Hello everyone, has anyone out there had this problem ??? Using: Online 7.13.UC2 on: Solaris 2.5 The situation is as follows: Logical log files are almost full - backup is needed. (Before you all start chastising me, there are valid(ish) reasons for this !) I have LBU_PRESE…
Re: HELP! My Page Cleaners keep dying!!!
------------673325D547C2 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > Running Informix OnLine 5.03 (ancient, I know) and > I continually have page cleaners to go into (E)xit > state and NEVER COME BACK! > > Kinda new to Informix, and I'm not sure …
Re: Is this stack trace normal?
While semaphores are often used to lock memory, that is not their only use. They are also used as a binary lock. What your are seeing is normal for a shared memory connection when the query has been passed to the engine. Let me explain. Each shared memory client is assigned a …
Re: Is this stack trace normal?
David Anderson wrote: > > I'm using Informix online 7.1 on an alpha running unix. > I access the db using esql/C programs. > When I interrupt these programs in the debugger, > the stack trace ALWAYS starts as follows: > > #0 0x3ff828d90a8 in semop () > #1 0x12007e394 in buf_wai…
Concurrency between processes
I'm perhaps wrong so i'm ready to get any corrections. Our problem is the high concurrency between processes and the application has a big amount of update (several updates or insert per second). First we didn't use the mechanism of 'CURSOR FOR UPDATE' when updating or deleting…
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…
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: 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: Index clustering and performance
In article <3259EA83.66D30FD7@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Land, Todd wrote: >> >> I remember a thread from long ago . . . can you refresh my memory? >> >> My database performance is declining, and my DBA wants to dump and reload >> the…
Re: Index clustering and performance
Land, Todd wrote: > > I remember a thread from long ago . . . can you refresh my memory? > > My database performance is declining, and my DBA wants to dump and reload > the database, hoping that will help. > > Isn't there something I can do to my indices (re-cluster?) to regain >…
Re: Executing stored procedures - performance problem
Oleg V. Besedin wrote: > > recently we found a kind of interesting behaviour of our Informix system. > Stored procedures which normally work within 2 - 3 minutes started > to take 8 - 9 hours to complete (180 times performance drop - ha-ha). We recently had a drastic performance…
Re: tbinit in debug mode?
David Williams wrote: > > In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley > <jlumbley@netcom.com> writes > >zsun@br00dbss.med.osd.mil wrote: > > > >: Hi, > > > >: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an > >: un-documented option to ru…
RE:debug mode, undocumented features, etc.
}In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley <jlumbley@netcom.com> writes }zsun@br00dbss.med.osd.mil wrote: } }: Hi, } }: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an }: un-documented option to run tbinit in debug mode, unfortunately t…
Re: tbinit in debug mode?
In article <jlumbleyDxMLLz.Ip7@netcom.com>, Joe Lumbley <jlumbley@netcom.com> writes >zsun@br00dbss.med.osd.mil wrote: > >: Hi, > >: Has anyone heard of, or used tbinit in debug mode? I was told there was/is an >: un-documented option to run tbinit in debug mode, unfortunately th…
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: Logical problem.
In <4tb3ba$bjt@cssun.mathc> Jack postulates whilst scratching thoughtfully: >I have a scheduler which waits for files and a datetime to occur before >running a process. So at a given datetime the process is 'queued' but >cannot run until it's source files/tables are ready. So …
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
This is a multi-part message in MIME format. --------------C4C26D4394 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit David Williams wrote: > > In article <4rsf8p$kt@sjx-ixn4.ix.netcom.com>, Stuart Cracraft > <cracraft@ix.netcom.com> writes > >The…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
David Williams wrote: snip > LRU's too low means the there is contention among the queues and > Informix runs slower as processes have to wait before the can update > the queues. There is one mutex per queue which controls give thread > can update the queue. Remember que…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
In article <4rsf8p$kt@sjx-ixn4.ix.netcom.com>, Stuart Cracraft <cracraft@ix.netcom.com> writes >The On-Line manual on page 12-36 says LRUS should be either 4 or the >number of virtual cpus -- this is a very low number. > >Most of the Informix Press tuning books and chapters on tu…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
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: page cleaner #1 timed out
> From informix-list-owner@rmy.emory.edu Tue Apr 30 03:41:00 1996 > From: Guy Germonpre <germonpre_guy/dis@bekaert.com> > Subject: page cleaner #1 timed out > Date: 30 Apr 1996 07:43:59 GMT guy, > Online 5.03.UD2 on Compaq proliant 4500. From time to time we get the > error > "E…
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 …
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.…
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…
Re: Hanging processes after database startup
In article <46gh9g$oc5@cssun.mathcs.emory.edu>, Jack Parker <jparker@hpbs3645.boi.hp.com> wrote: >> >Have you guys checked to see if the engine needs a checkpoint? > >We have seen lockups when doing an archive where the engine was waiting for >a tape to be mounted. For a while i…
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…
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 …
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.…
Re: Is a Multithreaded Ingres On the Horizon???
In article <dshapiro-180893123726@dshapiro.apple.com> dshapiro@apple.com (David Shapiro) writes: >In article <24qubr$bjr@infochi.com>, rfinkel@infochi.com (Richard >Finkelstein) wrote: > >> Richard Finkelstein (rfinkel@infochi.com) wrote: >> If there are companies who have succes…
Re: Lost invoices (Was: Couple of Oddities...)
In article <8872@emory.mathcs.emory.edu>, infmx!obelix!johnl@uunet.UU.NET (Jonathan Leffler) writes:` < stuff deleted...this is my part:> > }If you need to do multiple processing on a queue (say you have two or more > }printers that can handle invoices) then by all means use _int…
Re: Lost invoices (Was: Couple of Oddities...)
}From: uunet!nas.nasa.gov!jcarter (John R. Carter Sr.) }Subject: Re: Lost invoices (Was: Couple of Oddities...) }Date: 6 May 92 18:00:42 GMT }X-Informix-List-Id: <news.1188> } }In article <8849@emory.mathcs.emory.edu> you write: }|> I'm observing some strange things happening wit…
Re: Lost invoices (Was: Couple of Oddities...)
In article <8849@emory.mathcs.emory.edu> you write: |> I'm observing some strange things happening with an invoicing process |> that we're using at a client. The operator fires off an invoice program |> that runs in the background and inevitably spools the invoice to the |> print…