Oninit® Archive
Results for “onstat -g con”
Getting Error -271 On Batch Insert Randomly
Btw, the version of Informix is 11.10 THanks…
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 ------------------------------…
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 ------------------------------…
Innovator-C download?
https://www.ibm.com/resources/mrs/assets/packageList?source=ifxids&lang=en_US Scott Pickett IBM Informix WW Tech Sales IBM Informix WW Cloud Tech Sales IBM Informix WW Informix Warehouse Accelerator Tech Sales IBM Strategic Partnerships Boston, Massachusetts USA spickett@us.ibm.c…
How to detect if table has old-fashioned attached indexes (index pages in non-fragmented table partition)
oncheck -pT #Informix…
flags (onstat -g ses)
OK, to track locks, latches, or waits, start be determining the thread address(es) for the session of interest with onstat -u. That's the first column in the onstat -u report. You can filter on session id in the third column: onstat -u |fgrep 14123 46bf98a0 ---P--- 14123 in…
Slow Running Query
If like multiple rows , then how can be checked which thread id we need to compare ? Regards Amit P ------------------------------ AMIT PATEL ------------------------------…
Spot the difference
Hi all. As has been reported here, in xC6 and up you'll need to set the ONSTAT_LEGACY environment variable to get back the original header. (Any value will do at the moment.) My apologies for the problem. I would anticipate that changing the meat of an onstat output could break s…
DBACCESS_COLUMNS environment variable
I am not saying it doesn't exist on platforms, just that is not installed and not allowed to be installed. OAT/InformixHQ are all great (enough), but if you are not allowed to install them then you are back to the "always there" tools, dbaccess and onstat etc ------Original Messa…
New utility: fcopy-table.pl, Perl application to copy/extract one table or view to another table
#Informix…
RSS over SSL
Hi, Maybe this article could be helpful https://www.cursor-distribution.de/en/community/community-informix/84-informix-t echnische-infos/1224-informix-ssl-connection Cheers Erik…
New version Informix 14.10
We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…
Informix 14.10 Innovator-C
Informix 14.10 Innovator-C no available for download, why?…
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…
Connection Managers not forwarding connections
There was an OS/bios upgrade not informix…
blocked records
Use "onstat -k" for threads holding locks and "onstat -u|grep L" for sessions waiting for a lock…
Moving a file from one server to another server
check out the the 'system' command for Informix SPL.…
Bufferpool configuration
Hi, a recent thread titled "BUFFERPOOL Configuration" dealt with most of these issues. Ben.…
BUFFERPOOL Configuration
Let me answer your questions inline below: Questions : 1. Coincidentally we are running on AIX with OLTP System so item #2 would be a great fit for us. But why is the min and max lru set to 1 and 2 respectively? does it mean 1% and 2%? Currently ours are set to 50 min and 60 ma…
Re: 12.10.FC9 1809 Error
first i've installed with root, then with informix but the same issue ls -lt $INFORMIXDIR lrwxrwxrwx 1 informix informix 12 Apr 16 10:05 /app_ifx/informix -> ifx12.10.fc9 ls -lt $INFORMIXDIR/bin/oninit -rwxr-xr-- 1 informix informix 45269121 Apr 17 08:54 /app_ifx/informix/bin/on…
Continous logical log backup stuck - primary
Informix 12.10.FC10…
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 …
Does DBD::Informix support SSL connections ?
Does DBD::Informix support SSL connections ?…
Threat : swth:sbt_subclass_lpgsrc_ol_796
Hi Ley! Probably you're facing a kind of memeory bottleneck. I had a similar issue related to memory contention on my environment (that was shown through onstat -g wmx) and it lead to a defect. Also, I had many other memory contention issues during my IBM journey on huge custom…
How to monitor wait conditions and times
Have a complex application. Want to monitor when a thread has a wait condition and for how long it lasts. systhreads table has the below columns. The th_startwait column allows the wait time to be calculated. Have not been able to determine how th_conwait can be interpreted. Do…
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.…
Cannot Connect To Newly Installed Informix
141 is the IP of the informix virtual machine.…
dbexport : -425 - Database is currently opened by
An example, on my system onstat -u shows two waiters: IBM Informix Dynamic Server Version 12.10.FC5W1 -- On-Line -- Up 5 days 20:48:03 -- 658200 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites ... 44e72068 Y--P--D 24 informix - *46296c10 * 0 0 94…
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…
Performance issue after migrate to IDS from Online
Hi, There's nothing too obvious here... I think I agree with Art and your observation that, as you are using workgroup edition, the DS parameters are not relevant. Temp table spaces work ok in most versions as far as I know. From memory temp tables for sorting or joins go into…
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…
Wakeup RSS Server
Stuart, What version are you running? We had some problems but now work reliably. Art suggested 'kicking it' by re-running the 'onmode -d' command on the secondary. I still think of this method that it can often work with HDR, but I have never seen it do anything useful with RS…
best index method for heavy update and read table
Hello, forgot to say the informix version is 11.70 Thanks pushpa…
Update statistics issue
If you would like you large tables running update statistics = low to run very fast then you need to read the link below. I= n general this makes each index which update data statistic low is run o= n take about 1 minute (unless there is great data skew). http= ://www.ibmn…
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.…
Update fields of a table from a list
The Database is Informix SE 7.25…
Informix Training for Informix Users
Hello, Free Webcast - Database Driven Websites - Using PHP with Informix by Thomas Beebe, Advanced DataTools Corporation You are invited to attend our next Webcast on Tuesday, February 12, 2013 at 2:00 pm, Eastern Standard Time What do Wikipedia, Facebook, Wordpress, and Yahoo…
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…
Informix diversification?
http://www.wholesale-tablet-pc.com/ViewDetails140.aspx -- Ian The Hotmail address is my spam-bin. Real mail address is iang at austonley org uk…
cant start informix on windows
yes are members of Informix-Admin group Role seperation not enabled…
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…
update - locking
Err... the situation is not as simple as you put it... Lets see... - Other databases (I suppose you're thinking about Oracle) would read the previous value in the locked row.... If the row validates the condition it would try to update, but it couldn't because the row is already…
Newbie to Informix
Hello, I'm currently working on expanding my knowledge and would like to work more on the database side of things. I would like to learn more about Informix, as a newbie, and would specifically interested in learning how to run queries from it. My hope is to eventually t…
Problem with identifying root cause of continual m
Ok. I think it probably some application problem. Could you check out if your Informix server is using OPTOFC=1 value? It should. I also suggest you to search for the JDBC connection string (or properties), for IFX_AUTOFREE parameter. It also must be turned on. Maybe that´s the c…
Increasing shared memory
Hi All, We have Informix 11.10.FC2 on SUSE Linux 10,RAM 24GB with shared memory of 19190788 Kbytes. The bufferpool is as follows: BUFFERPOOL default,buffers=102400,lrus=32,lru_min_dirty=1.000000,lru_max_dirty=2.000000 BUFFERPOOL size=2K,buffers=204800,lrus=32,lru_min_dirty=1.000…
Informix & Splunk
hi all has anyone had experience with using Informix and Splunk? if so, care to share thoughts, experiences, etc thanks…
Migrate Oracle/MSSQL to Informix
With Informix it is easier to learn also. I learned DBMS concepts easily and quicly with Informix than oracle. For me Informix is Simply the Best & Love at first sight.…
IDS 11.7 - cannot create instance
PPS: INFORMIXDIR = /housing/informix/ids11_7 INFORMIXSERVER = v6live ONCONFIG = onconfig.v6live…
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
we are running on AIX and ran into this issue on FC8W2 ... maybe it is the same issue? IC75072: RACE CONDITION BETWEEN ONTAPE AND SQLEXEC THREAD CAN CAUSE DEADLOCK ON DBS MUTEX. Support informed us that it was fixed in 11.50.FC9 ________________________________________ From: i…
Using CodeIgniter with Informix
Anyone has successfully using CodeIgniter with Informix ?…
Informix ... and marketing.
Informix ... and marketing. Please read this important post! : http://t.co/k0QfC0s #Informix…
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…
PHP and Informix?
Dear Informixers, it's been a long time since I've been active in this group. Our IDS server is just running smoothly, so I didn't need assistance. But now something new has come up: We have a web application in_house that our department wants to participate in. The application…
Need onstat Interpretation Help
Good Morning, IDS 11.50.FC5 O/S AIX 5.3 I have a recurring locking issue that I am trying to get to the bottom of. I have a script that will detect a lock held for > 15 seconds and among other things, grab an onstat -a and some session information for the holder of the lock as …
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…
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…
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…
informix on windows
Hi All Has anyone ever run Informix on Windows using an account other than the Informix account? It is being suggested that we run it as a Windows Domain/System Account instead but I don't know if that will even work or not - We have always run Informix using the Informix accoun…
Error starting IDS v10
mol_dev : /usr/informix/etc> ls -l /dev/rdevrootdbslv crw-rw-rw- 1 informix informix 39, 38 Oct 7 12:16 /dev/rdevrootdbslv…
"Re-indexing" Informix
My users, having been raised on whOracle, seem to believe that if we drop all 40 GB of detached indexes from our 180-GB database and recreate them, without changing anything else, it will improve performance, just like in the other DBMS. Despite my explanation that Informix use…
Memory Management
oh..also think around 300 threads connected to this database.…
frozen sessions
Original Post: Can somebody tell me what a session in a "cond wait PC_I hash" condition mean? I've never seen a session in this state before. I have multiple sessions that are all stuck at the same place. The statements are all called from stored procedures. The last one execut…
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…
RE: Long Checkpoints with HDR and 11.5.
Art Kagel wrote: No, Jacques, IDS secondaries do not share buffer pool updates with the primary. Only the logical log buffers are transferred, so only the server's transaction rate would affect the data transfer rate between the servers and that would be about the same regardles…
New Informix Blog
Folks, this might be interesting: http://informix-zone.com/bruce-weed-informix-blog Please also remember the two important Informix events that are happening soon: http://informix-zone.com/ibm-virtual-event Thank you.…
informix drivers
Hi all, some folks here argue that in future IBM would drop the support of Informix drivers like PDO_INFORMIX for the benefit of db2 drivers or has it already done. Would you agree with that opinion? Please, no new flame debate but a realistic estimation. Reinhard.…
ER template realization problem
Yes on both servers the owner is informix, and user informix has the same privileges too…
Informix Mirroring
Hello, I was reading up on Informix Disk/Chunk Mirroring and was wondering if anyone has any experience using Informix mirroring versus O/S or Hardware mirroring relating to performance? Also, is this a typo in the Informix documentation for mirroring? See the sentences, "On t…
Informix in the Press
Informix makes it into The Register! http://www.theregister.co.uk/2010/01/11/ibm_lawsuit_bgc_informix/ -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous…
Waits cond wait netnorm and IO Wait
Netnorm is the engine waiting for the user to enter a request. Could be between SQL or waiting for a FETCH on an open cursor. Iowait is waiting for the asynchronous IO mechanisms to return data. Sleeping forever happens when a Netnorm wait condition lasts a long time. The threa…
Informix FAQ
Hi, I send this question to the list because the address which is mentioned as maintainer of the FAQ (david@smooth1.co.uk) doesn't work: I wanted to search the FAQ as member. Unfortunately the link to search (http://www.iiug.org/members/search_faq.html) does not work. The resul…
IDS random slow down
Jumping in here... I am guessing the diagnostics you posted were ran when the engine was in its slow state right? I'd like to see a few things: 1) What is the sqlexec thread that is running actually doing? You can get this information by looking at, in your diagnostics, the on…
User thread
I'm using Informix 11.5 developer edition and some Windows services are acusing an ODBC error (Cannot create user thread). Informix is installed on Windows. What can I do to fix up this problem?…
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…
onaudit problems after upgrading from11.10.FC2 to
using informix . role separation not being used…
how to force disconnect user threads?
How can I force disconnect user threads from Informix IDS? Thanks.…
Fastest Informix DBA Contest II
http://www.advancedatatools.com/Informix/…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
Question about the status of the thread
Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.…
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…
Informix and Security?
Hi, This may be a question that Jonathan will have to answer.... If I understand some earlier posts, Informix now requires an IBM library that has to be installed in a specific directory in order to do encryption. The good thing is that this software library can do certified F…
connect through java using group_name con mgr
Kamran: If you want to access all nodes as a group, you could modify and add a mach_group to the oncmsm's sqlhosts as below. g_mach group - - e=ids_net_RSS ids_net_primary ontlitcp 192.168.0.16 sql_net_primary g=g_mach ids_net_secondary ontlitcp 192.168.0.15 sql_net_secondary g…
Monitor HDR
On Apr 14, 5:40 pm, Mo <mohitanch...@gmail.com> wrote: > Informix 11: > > We run HDR and I see waits on logbf0, logbf1. I think it's something > to do with log shipping to secondary node. Is there a way to look at > to make sure that log shipping is not the issue why I see some o…
LTAPEDEV to /dev/null from onmonitor
Kindly Ignore this as another thread is open with same content.…
Informix Blogs
http://www.ibmdatabasemag.com/blog/main/archives/informix/index.html -- }(:…
Informix Brand?
Its great to see some heated discussions about the product and marketing issues. Serge alluded to something that hasn't really hit the streets and thats the branding effort of IDS and DB2. Yes both are truly brands in the context that there are a couple of different flavors of e…
IBM posts good number yet how frustrating is this...
> One of the things that has > happened last year is the branding of IDS and DB2 software underneath > IM. That is a pre-condition for marketing. Now that all pre-conditions are met, which took IBM only 8 (lost) years since the takeover of Informix, when can we expect that IB…
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…
Difference between 32bit Informix and 64bit Inform
What are the difference between 32bit Informix and 64bit Informix version?…
Problema con logs
buenas tardes necesito saber si se puede salvar esta base de datos. tengo el siguiente problema: # oninit -vp # onstat -m 13:20:52 Onconfig parameter VP_MEMORY_CACHE_KB modified from 21822020 to 5455505. 13:20:52 Dataskip is now OFF for all dbspaces 13:20:52 Logical Log Files ar…
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.…
Dbspace creation
Output for /dbspace2 and /dbspace2/db1 drw-rw---- 3 informix informix 4096 Nov 7 07:31 /dbspace2 -rw-rw---- 1 informix informix 0 Nov 7 07:31 /dbspace2/db1…
listener-thread: err = -27001
Hi, Guys, Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 We repeatedly receive the following error msg in online log, 19:43:34 listener-thread: err = -27001: oserr = 0: errstr…
Cannot issue oninit to IDS 11.5 on Windows Vista
I should say that the informix user is a member of group informix- admin. Cheers R…
informix+informatica
Hi Can informix be used as repository in informatica? Regards Deba…
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…
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…
Informix SE is dead?
Any news on the fate of Informix SE? PN…
Informix 11
What is the best version of informix 11 at this time. We are planning to upgrade from Informix 10FC* and Informix 10FC4 ( one instance) to Informix 11. Not sure whather to go to Informix 11.1 or Informix 11.2 or Informix 11.5 at this time. Any guidance will be appreciated. than…
Sentencias preparadas en Store procedure
perdon informix 730…
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…
IDS11 SDS
duebel wrote: > Hi! > After startup both nodes can see each other (onstat -g sds). Both > nodes can > see dbroot. > > After issuing a manual checkpoint or simply waiting about 5 minutes > secondary node is "shot in the head" by primary with the following > message > in online-lo…
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…
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…
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…
Condition Wait Netnorm
Hi all, am the project manager for an application running on IDS 10. Off late the users complain of the sessions getting stuck. Whenever they try to insert an record it takes a lot of time to insert. At times the session just hangs and then they have to get it killed. From whate…
Re: IDS on a Mac?
I thought the title of the thread was "IDS on Mac OSX". Why don't you just create a new thread and move all the Oracle vs. Informix and all the personal bashing over there????…
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
Re: HDR recommendations
On Aug 25, 3:41 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 25, 4:12 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
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…
HDR recommendations
mohitanchlia@gmail.com wrote: > On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: >> mohitanch...@gmail.com wrote: >>> On Aug 24, 9:59 am, Madison Pruet <mpru...@verizon.net> wrote: >>>> mohitanch...@gmail.com wrote: >>>>> On Aug 23, 8:45 pm, Madison Pruet <mpru...@v…
BAR_MAX_BACKUP - not spawning parallel threads
Version : 10 We are running onbar -b -l with BAR_MAX_BACKUP = 4 and BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process I just see one onbar_d process. I was expecting atleast 4 processes. Why is it just spawning one process. Is it because our SHMTOTAL is 0.…
Re: 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.…
oninit
-rw-rw---- 1 informix informix 0 apr 25 17:00 /informix/dbspaces/online_root…
Instalacion de Informix 10.00.FC4 en GNU/Linux
INSTALACION DE IBM INFORMIX DYNAMIC SERVER 10.00.FC4 EN SUSE LINUX ENTERPRISE SERVER 9 1. Nos logueamos con el usuario root y realizamos los siguientes pasos: creamos el grupo informix. groupadd informix 2. Cr…
Deny connect over network user informix
Hi, it's possible to deny connection to the informix database over tcp with user informix? So user informix works local only. Thanks Marco…
Re: Anybody seen a very fast wild cat out there?
FInally, AUTO_AIOVPS is not explained that well. "the database server |automatically increases the number of AIO VPS and flusher threads when the |server detects that AIO VPs are not keeping up with the I/O workload" What threshold determines this? Couldn't adding more and mor…
Rogue user session
>539c9818 Y--P--- 32885158 userxyz 29 52ccd890 0 3 202 129 The session is holding three locks, see what they are: onstat -s|grep -i 52ccd890 onstat -k|grep -i 52ccd890 Check to see if any of the locks returned are being held by other sessions. Compare any values…
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…
Informix
I have ids7.3 runninig on hpux.I have the following error when i run oninit: Fatal error in shared memory creation'.I got this error message after sucessfully restoring the database with last year's tape.I tried to reboot the server so that i can free the shared memory but ,this …
pasos para instalar informix 10.0 en suse 9
Ing. edwin grullón egrullon@gmail.com INSTALACION DE IBM INFORMIX DYNAMIC SERVER 10.00.UC4 EN SUSE LINUX ENTERPRISE SERVER 9 1. Nos logueamos como el usuario root y realizamos los siguientes pasos: creamo…
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: Ayuda sobre performance
On 3 Aug 2006 21:49:42 -0700, alberto.jsp <alberto.jsp@gmail.com> wrote: > > Hola a todos, quisiera me pudiecen ayudar con esto que les voy a > presentar: > > necesito saber como puedo ver los usuarios que tengo y los privilegios > de los mismos. > asi como el sacar estadisticas …
Ayuda sobre performance
Hola a todos, quisiera me pudiecen ayudar con esto que les voy a presentar: necesito saber como puedo ver los usuarios que tengo y los privilegios de los mismos. asi como el sacar estadisticas de rendimiento de la base de datos o de accesos. Gestor, claro, Informix, Sistema Oper…
How can I import easily data from an XML file....
into Informix Database? Thanks in advance!!!!…
Re: SHMBASE VALUE FOR > 4 GB - V10
Fernando: una pregunta, tienes 64 bytes en x86?? que hardware es?? que s.o. CentOS 4.3?? corre bajo procesadores AMD 64 (Athlon 64, Opteron) and Intel Pentium (Xeon EM64T) processors?? Yo tengo IBM x236 con Xeon EM64T, si monto red hat para 64 bytes , valdra IDS V10FC?? Gracias …
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…
instalacion de informix
Cuales son los pasos que has seguido, yo solo le he hecho con IDS 9.4 y la version 10, pero si quieres dime que es lo que has hecho y lo revisamos, saludos TBP wrote: > amin wrote: > > HOLA A TODOS, > > > > Hola Amin > > TENGO UNIXWARE 7.1.1 > > Ay caramba! > > Y QUIERO INSTALAR…
Re: Error message 243 - need help"Could not positi
Depends, as others have pointed out, on the ISAM error code. Usually it's a lock condition on the row the app is trying to access. If the tasks are all accessing the rows only briefly then the ISAM code is probably indicating that this is a lockout condition. The fix is to includ…
Initialising Informix
My file settings are as follows SERVICES srvr0001 8001/tcp #Informix port sqlhosts ok_srvr onipcshm 10.0.6.2 ipcs0000 ok_tcp onsoctcp 10.0.6.2 srvr0001 onconfig DBSERVERNAME ok_srvr # Name of…
Maximum number of extends
http://groups.google.de/group/comp.databases.informix/browse_thread/thread/c8d12b3def081d8b/6181761f44b780de…
Comportamiento de un proceso
Hola Juan Pablo, tenes pdq activado? Veo que tenes muchos threads para una sola sesion, varias de ellos (me refiero a threads) estan esperando para la liberacion de buffers y otro ha provocado un Checkpoint. todos esos threads estan activos. Si tuvieras pdq activado tendrias qu…
onstat -g ath
It means that the thread is waiting on the condition. netnorm (network= normal). That meand that the thread is waiting for somthing to be sent= from the client. = "Marco Schwarz" = <marco.schwarz@ro = lmail.net> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = …
Re: Trusted Hosts facility implementation frustration
Would Informix I-spy be of any use for this?…
Re: Thoughts on Logical Log use requested
malcolm weallans wrote: > You miss the point entirely. > Well, (tongue in cheek) use "WITH NO LOG" (because this is the Logical > Log use thread)! > > Not enough potato EEEEEEEEEEEEEE Actually, I didn't miss the point, I just felt that the thread was regarding logical log usage …
Need Informix IDS 9.5
I need Informix IDS 9.5 256 users.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
what is waiting for
Yes, you are right. Basically the "Y" flag in the first position of an onstat -u or ( cond wait netnorm )means that there is nothing to do on the server side ( database server ) and the session is waiting for new messages from the client side ( in your example dbaccess ). esteb…
RE: the ugly Americans and how the IIUG will save Europe
the DB2 magazine includes a reasonable section on Informix…
RE: Merry Christmas & Happy new year
"Damn it Jim I'm a doctor not an Informix marketing agent"...…
Re: Merry Christmas & Happy new year
Kwanzaa: http://www.officialkwanzaawebsite.org/ sending to informix-list…
Informix helper?
exist Informix helper?…
IDS 10.0FCnWm, replication and reversion
My customer is running IDS 10.0FC3 on a production system. It's crashed twice in the past week due to what turned out to a known bug (Bug: 173090 SERVER CRASH WITH "ASSERT FAILED: YIELD_PROCESSOR: CONDITIONAL LATCH COUNT NON-ZERO IN THREAD 7" AT 2ND NODE IN A 2-NODE REPLICATION …
Cannot put Server Online in Informix 7.31
oopps it should read crw-rw---- informix informix.... Superboer.…
Re: onstat -g wmx
>Query sysmaster directly? What does that show? > >onstat -g ses for each session? > >onstat -g stk all? > >onstat -g con ? > >Let us know what you find.. > Unfortunately it was last Saturday when this came up and it not occurring now and is unlikely to happen again in the near …
Re: IDS 10 erratic run times
1. Try running onmode -F before each run (free shared memory segments/blocks and general tidy up memory structures). 2. What does onstat -g stk <thread id> give for the sqlexec (or sessions threads) and the kaio threads during the freeze? Repeat several times to see what func…
ontape error 102
----- Original Message ----- From: Santosh Nikumbh <sagarthanawala@yahoo.com> At: 7/14 4:26 Hi, Iam getting this error when I do ontape -s -L 0 :- Archive failed - Error changing logging status - iserrno 107. -107 ISAM error: record is locked. Another user request has locked …
rootdbs memory problem
agt122:(informix)/home/informix>oninit -iy oninit: Not enough room in ROOT DBspace. Requested 213638K, ONCONFIG value 'ROOTSIZE' 160000K. oninit: Fatal error in shared memory initialization agt122:(informix)/home/informix>…
ODBC Memory Allocation Error
Can't comment 'cos I don't use ODBC, but it must be worth a try, you should be able to test this easily by stepping through the code and monitoring the memory usage under onstat -g ses mauroc@beacon-ct.co.uk wrote: > Hi, > > thanks for the rapid reply. As far as closing the con…
Alpha Tru64 IDS 9.40.FC5 - Faster System Runs Slower
If network configuration is the problem, then one would have to assume, that the third configuration on IDS on royale / application on royale would use some sort of loopback through the Network! (instead of the virtual local loopback device) You may want to check the connection …
Re: Horny Teen Girls
Hows their Informix?…
Re: NEED RPG2/UNIBOL36 anything to do with Informix
What does this question has to do with Informix ?…
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.…
RE: Oracle 9.2. on AIX 5L
I suggest you buy Informix instead of Oracle…
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 ? …
HDR - Waiting on logical-log buffer
Gerd, in HDR, when logical log buffers get flushed to disk, they also get transferred to HDR secondary. If secondary is not able to process the logical log records as fast as they are produced on primary, and primary's HDR buffering might get filled up, and sqlexec threads on pr…
Complete Backup on Windows NT
Greetings all, The various postings I have observed in this group have proven to be very helpful (as I am a novice Informix database administrator). In an attempt to cover my a$$...I am trying to backup an Informix database on a Windows NT machine that is still being used... I…
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…
nuevamente Performance
Dooku Maul wrote: > Hola > Estoy con algunas dudas, las mismas que finalmente se reproducen en > problemas de performance para mi servidor de base de datos. > Mi plataforma basicamente es la siguiente: > HP-UX 11.11, 4 CPU's y 12GB de memory. > Revisando literatur…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
Re: Fatal error in ADM VP at mt.c:12239
Here is another part of the af file: ===========------------- - - - - - - /home/informix/bin/onstat -F: IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 1 days 20:14:49 -- 2549264 Kbytes Fg Writes LRU Writes Chunk Writes 0 8396195 30928…
AW: Too many open files to the master oninit process
pls. see your previous thread :-)…
Re: Problem with ER
I didn't see this yesterday. This is a race condition bug --- very hard to reproduce and very unlikey to be seen. Bouncing the server is probably the best way to get arround it if you don't have the patch. "Denis Melnikov" <dm�lnik@regent.ru> wrote in message news:clvolq$2m7$1…
monitoring sequential scans in 9.40FC4W4
In addition to this question, this parameter with as another one can be related for knowing if all are working well? Like Art Kagel's ratios.sh script .. Thanks Paola este parametro con cual otro se puede relacionar para saber si el motor esta funciondo bien? Mensaje citado po…
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…
transactions et concurency
hi, i'm trying to simulate oracle behavior on the following point: (from 4js technical documentation) ORACLE uses a multi-version consistency model: A copy of the original row is kept for readers before performing writer modifications. Readers do not have to wait for writers as …
log files - maximum?
Informix 7.31UC4 Whats the maximum log files allowed?…
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...…
Informix
About Informix --> http://en.wikipedia.org/wiki/Informix Regards, Chavan Koya…
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…
QUE ME RECOMIENDAN?
Hola muchachos/as! Les comento que estoy buscando herramientas de administracion para un ids 9.21 (proximamente 9.40). Estuve probando las versiones Java y win32 de Server Studio. Entre estas dos opino que la version Java esta mejor hecha, tiene reportes muy interesantes que la v…
Performance Problem - Mutex Waits
Hello all. I have a performance problem that I am hoping someone can assist me with please. Aix 4.33 Maintenance Level 11 4 CPU 8 GB IDS 7.31.UD4 7 Instances 150-200 Databases Per Instance All Databases have the same schema, with the same 61 tables. Buffwait Ratio is on avera…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > > > > > snip > >> > > > > > > Holas muy bien.. tengo una duda yo puedo tener varios kio (KAI…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > > > > > snip > >> > > > > > > Holas muy bien.. tengo una duda yo puedo tener varios kio (KAI…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com> > ----- > > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST) > > De: "ANGEL MARIA...." <angru…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com> > ----- > > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST) > > De: "ANGEL MARIA...." <angru…
Fwd: KAIO con HPUX 11 [265]
angruiz@coomevamail.com wrote: > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com> ----- > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST) > De: "ANGEL MARIA...." <angruiz@coomevamail.com> > Responder-A: "ANGEL MARIA...." <angruiz@coomevamail.com> > Asu…
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…
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…
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-…
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…
Re: max number of connections
Christopher wrote: > The Y--P--- flags mean the thread is waiting on a condition. ... Well I know about the flags and I can RTFM :-) but the problem is that when the machine hangs, the threads are not waiting for anything, that's why I don't know what else to look for. > > at…
Re: max number of connections
Micha wrote: > > Christopher wrote: > > > The Y--P--- flags mean the thread is waiting on a condition. ... > > Well I know about the flags and I can RTFM :-) but the problem is that when the machine > hangs, the threads are not waiting for anything, that's why I don't know what …
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…
Re: IDS Performance problem
Nothing you mention here specifically indicates a problem. If you know how to use dbaccess, run it and select a database. Use another session to take a look at what your backend process is doing. You will find that it is in exactly the state you describe below. This status will …
RE: IDS Performance problem
Hi I agree with Obnoxio Jpp :- when u do update statistics in your system ? HITEN -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Friday, October 03, 2003 3:16 AM To: informix-list@iiug.org Subject: Re: IDS Performance problem jpp wrot…
IDS Performance problem
Hi, I have performance problems with on IDS 9.30 on hpux. When i look current sessions with onstat -g sql somme are always with status cond wait(netnorm) and wait more than 1000 times. What is meaning for this status ? When i look all waiting sessions on threads with onstat -g …
Re: Space Usage on Informix Question
Valium wrote: > No entiendo bien el ingles pero si lo que quieres es saber cuanto > espacio te queda en los chunks pues lo puedes ver con onstat -d y si > lo que quieres es que te ocupe menos espacio en el chunk porque has > hecho drop por ejemplo en el archivo de huellas prueba …
If You have an option to move from 7.3 to 9.3 or 9.4. Which one
Thanks Basheer sending to informix-list…
Re: Space Usage on Informix Question
No entiendo bien el ingles pero si lo que quieres es saber cuanto espacio te queda en los chunks pues lo puedes ver con onstat -d y si lo que quieres es que te ocupe menos espacio en el chunk porque has hecho drop por ejemplo en el archivo de huellas prueba a hacer un dbexport y …
ESQL/C -439
On Wed, 20 Aug 2003 08:56:23 -0400, Corne' Cornelius wrote: Better to perform this control with your own conditions and mutexes. When a thread acquires a connection it sets the corresponding condition, when it is finished with the connection it clears the condition. Mutexes pro…
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: Unexpected behavior
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:pan.2003.07.11.11.07.26.757481.15473@bloomberg.net... > Has anyone seen this one before? > > I have code that has to run in production and test environments and > access datafrom two databases in a single query. On produ…
Re: Unexpected behavior
hmmm interesting stuff - could we have a look at the stack of thread 469? also from an onstat -u | grep 469, what's it waiting on? onstat -g lmx or onstat -g con, do they show a matching value on the wait column above? Art S. Kagel wrote: > Has anyone seen this one before? > > …
Unexpected behavior
Has anyone seen this one before? I have code that has to run in production and test environments and access datafrom two databases in a single query. On production the two are resident in different servers on test they reside in the same server. I did the following (a simplifi…
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…
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…
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/…
INFORMIX
Hello, I am an user that needs to begin in the topic of DATABASES of INFORMIX. I want to find information about that it is INFORMIX. Could you indicate me where I can find this information? Thank you for your attention. Cordial greetings. -- ***********************************…
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…
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: Shared memory not initialized...
Nope, everything appears to be set up correctly. INFORMIXDIR=d:\\informix INFORMIXSERVER=ol_aries ONCONFIG=ONCONFIG.ol_aries PATH=d:\\informix\\bin;%PATH% INFORMIXSQLHOSTS=\\\\ARIES DBTEMP=d:\\informix\\infxtmp CLIENT_LOCALE=EN_US.CP1252 DB_LOCALE=EN_US.8859-1 SERVER_LOCALE=EN_U…
informix
how i can find the version i have i think its 2.1 from sco thanks…
Friendly lock mode
Peter Komanns wrote: > > Hi all! > The question is this: when some transaction locks a row (as for an update) > other tasks can't modify that row until the modifying transaction has been > closed with a commit or rollback statement. > So, any transaction coming after that update …
Process waiting after issuing OPEN CURSOR, onstat shows a thread in waiting condition await_MC1
Hello, i need some help. We have some strange problems with waiting conditions on our IDS 7.31FC4 server on Digital unix. The problem seems to happen from C source with embedded SQL and also when client applications access the database via ODBC. What happens from within the C s…
Re: SET INDEXES ... ENABLED very slow
From: roman.daniel@tconsult.cz > >We are running IDS 7.30 on HPUX 10.20, IDS 9.21 on HPUX 11.00. The >later one >is several times slower on SET INDEXES ... ENABLE (the machine is more >powerful, the load is almost none, database schema and data are >identical). >Does the output o…
SET INDEXES ... ENABLED very slow
We are running IDS 7.30 on HPUX 10.20, IDS 9.21 on HPUX 11.00. The later one is several times slower on SET INDEXES ... ENABLE (the machine is more powerful, the load is almost none, database schema and data are identical). Does the output of onstat -g ses ..., onstat -g con have…
Informix
I'd like to know details about INFOEMIX, what is it? What is it for? I'm a student at one university and have to do my assignment about it, but unfortunately, I cannot find any books on this topics. Or it's grateful if you can recommend me sone internet sites that have details, b…
Re: set debug on : permission problem
hi there, are you refering to $INFORMIXDIR/bin ? if yes then output as below -rwxr-xr-x 1 informix informix 3150016 Jun 29 14:19 QA_cockpit -r-xr-xr-x 1 informix informix 1045675 Mar 28 1999 ansrd -rwxr-xr-x 1 informix informix 3007104 Jun 29 14:18 archecker -r…
Re: set debug on : permission problem
hi there, are you refering to $INFORMIXDIR/bin ? if yes then output as below -rwxr-xr-x 1 informix informix 3150016 Jun 29 14:19 QA_cockpit -r-xr-xr-x 1 informix informix 1045675 Mar 28 1999 ansrd -rwxr-xr-x 1 informix informix 3007104 Jun 29 14:18 archecker -r…
remove informix-list
Remove informix-list…
remove informix-list
Remove informix-list…
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…
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…
��� ������� ����������� � informix
мЕНАУНДХЛЮ ОНЛНЫЭ - ПЮГНАПЮРЭЯЪ Б informix РЕК:332139 e-mail:kokota@chat.ru…
RE: no index used
I seem to recall having better luck getting the results I wanted with unions instead of or statements, you might try that. Will >===== Original Message From steinhoefel@dcs-systeme.de ===== >Thanks again for your answers, > >I had already tried to change OPTCOMPIND from 2 to 0 -…
onstat -g con interpretation
IDS 7.30 FC7 on Tru64 4.0F onstat -g con has been reporting threads waiting on drcb_bqe, logbf1, logbf2. Whilst I would guess this has something to do with waiting for HDR and logical log buffers to be flushed to disk, I would appreciate any further details anyone could give - …
JDBC and transaction processing
Peter, JDBC's autocommit is turned on by default. You must explicitly turn it off through the setAutoCommit method. For example: con = DriverManager.getConnection(url, "red", ""); con.setAutoCommit(false); Peter Wages wrote: > We have a web application which accesses 2 …
How to start Informix on NT when running as a "non-informix" user
Hi! When I log onto NT as informix I can start informix (oninit). When I try to start informix as a different user I get: D:\\informix\\bin>oninit Only user informix can start Informix Dynamic Server. Does anyone know of a way around this? TIA! Roger…
onstat -g con
we're running Informix 7.3 on HP-UX 11 when I run onstat -g con (show threads which are waiting on something) I see "netnorm" as the condition being waited for. This is documented as meaning "thread waiting for a request to be placed in network queue". Is this normal? Is tha…
onstat -u ....waiting on condition
Hi I was just looking at the output from onstat -u 3b706d2c Y--P--- 97984 3b70d958 Y--P--- 121881 3b710860 Y--P--- 100957 3b71167c ---P--- 121893 3b711fe4 Y--P--- 113791 3b71b1b0 ---PR-- 121842 3b7230ac Y--P--- 100952 3d96c014 S--PR-- 121894 3d96fd38 Y--P--- 104413 3d9714bc Y--P…
sleeping forever .
Generally when a thread is "sleeping forever", it is waiting for some external event to occur. For instance, if the thead is sleeping forever on netnorm or smread, then it is waiting for the client program to send more data or requests to the thread. David Van Huffel wrote: > …
RE: onstat -g sql
One of the reasons I ask this question is due to the fact when I do an onstat -g sql I have sessions with current queries, but onstat -g con shows them to be waiting on sm_read or netnorm. I thought that meant they were waiting for requests. Why would they wait for requests as w…
RE: What is "cond wait(sm_read)" ?
I am using 7.30, but I think this applies to 9.x as well. I believe that this condition means that your thread is waiting for the program to submit an sql statement. In other words, if I log into dbaccess and connect to the database via shared memory this is the condition my th…
What is "cond wait(sm_read)" ?
The sm_read condition is the condition that the sqlexec thread is waiting on when it is waiting for somthing from the client application and the client is using a shared memory interface. Geoffrey Poole wrote: > Dear all, > Universal Server 9.14.UC2 (to be UC7 after Y2K!), Sun …
RE: Tracking conditions
I believe that this condition means that your thread is waiting for the program to submit an sql statement. In other words, if I log into dbaccess and connect to the database via shared memory this is the condition my thread is waiting on. When I am not waiting on submitted SQL …
Tracking conditions
If a thread is waiting for a resource which is a "condition", is it possible to find out what that condition is? informix@Lawson $ onstat -u | grep robink e2bdf798 Y--P--- 55397 robink - e62c2608 0 1 101 0 informix@Lawson $ onstat -g con | grep e62c2608 …
Informix
Hi everyone, I am new to programming and Informix. What will be most helpful? Where do I go to see how each table affect each other? Should I do a sql? Trainee, John…
Test. Empty.
Informix list. Test message.…
Informix
We are looking for an Informix guru. 10+ years experience. The salary is open. The position is in the Dallas, TX area. Please forward your resume to dylanriedconsultants@hotmail.com…
Informix Certification Exams
There are sample questions on the Informix website.…
Compiling with thread libs
Platform : Solaris 2.6 INFORMIX IDS/UD Version 9.14 UC6-1 INFORMIX LIBASF LIBRARY Version 7.24.UC8 INFORMIX-Connect Version 2.20.UC1 INFORMIX EMBEDDED SQL for C Version 7.24.UC8 INFORMIX LIBGEN LIBRARY Version 7.24.UC8 INFORMIX-Universal Server Version 9.14.UC6 INFORMIX LIBOS LI…
informix
GO HERE TO GET PAID WHILE YOU BROWSE THE WEB! http://www.gotoworld.com/getpaid/default.asp?rid=1023195981…
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 :-)…
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…
informix ??
Quelqu'un peu-t-il m'expliquer comment utiliser la base de donn�e INFORMIX sous UNIX sur IBM RISC 6000 ? Somebody can explain me who to run under UNIX on IBM RISC 6000 ? Personne ne sais l'utiliser et moi je suis sp�cialis� enmicro PC avec quelques notions de Unix et de C Nobody…
Shared Memory Size vs Physical Memory Size
Can somebody please explain the pros and cons of increasing either the initial virtual memory segment or adding a further segment via "onmode - a" on a machine that is Informix Dynamic Server dedicated. Our calculated shared memory size, as can be seen below, is only some 50% of …
Re: Performance problems
In article <3756CBFE.B27DB9E0@bloomberg.net>, kagel@bloomberg.net wrote: > [ ... snip ... ] > for any busy chunks, with the number of LRUS as a minimum. So if you > increase LRUS to 32 use AIOVPS of 32 otherwise at least 14. Monitor > onstat -g iov at least one or two of th…
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…
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.…
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…
LOCK MODE WAIT doesn't seem to work in SE
Andy Kent wrote: > > I was surprised to find that, under SE, if a table is locked and I attempt > to read it having executed a SET LOCK MODE TO WAIT, the read aborts on > error -242/ -113, rather than waiting for the lock to clear. I've > demonstrated this using two sessions of d…
thread safe version of informix 4gl
Does anyone know if there exists a thread safe version of informix 4gl. Thanks. William…
Informix IDS on Informix
Informix has released IDS Linix Suite and is available for download (or in CD) from either RedHat or Intranetware. This is a try and buy version with 30 days eval period. I am not sure what happens after 30 days. Anyone?? Enjoy..... Happy New Year..... Idiot…
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: …
Re: Informix Performance
Larry Strickland wrote: > 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 …
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…
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'…
INFORMIX to INFORMIX connection
Hi folks, We are using Informix DS 7.23 on Windows NT 4.0 Boxes. We have several Database servers. The problem is; I am tring to select data from one database server (e.g: server2) while connected to another one (e.g: server1) via SQL. Such as; suppose we are connected to db1@…
subscription
Subscription to Informix list…
Re: ODBC, NT and Workgroup problem
On Thu, 22 Oct 1998, Jun Nolasco wrote: > But, why is it that even with row level locking, these errors still > occur eventhough no one else is currently using the record in question > (but with others holding locks on other records)? And from the error > messages, it looks like…
Re: ODBC, NT and Workgroup problem
But, why is it that even with row level locking, these errors still occur eventhough no one else is currently using the record in question (but with others holding locks on other records)? And from the error messages, it looks like it is the index record that is locked, not the d…
Re: ODBC, NT and Workgroup problem
Jun Nolasco wrote: [Reply SNIPPED] > asevillano@gesfor.es wrote: > > > > Hello all, > > I have a problem in a NT 4.0 with INFORMIX Workgroup 7.23 and ODBC (Informix- > > cli). When I insert a lot of records with a unique program there is no > > problem, but when I execute severa…
!US - Informix Positions
Informix development and DBA positions available around the US http://www.premierjobs.com/informix…
US - Informix jobs
Job postings for Informix Professionals http://www.premierjobs.com/informix…
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-…
Posting from the Informix-list
Subscription to Informix-list…
Informix DBA's and Developers needed around the US!
http://www.premierjobs.com/informix…
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
-Informix
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
Re: wait conditions onstat -g con
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
Re: Just to know
Goldy Magaly Pastor Murillo wrote: > > Hi.. > I'm migrating from Online 5.0 to DS 7.23 and monitoring the status of the > users I found that in DS 7.23 reportes wait with the address of the latch > waiting.. but in 5.0 this doesn't happend .. what is the meaning en 7.3.. ??? > > …
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…
onstat -g con
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 waiter waittime 543 …
wait conditions onstat -g con
The column, CID, displayed by the onstat -g con is a numeric value for which I would like to find its equivalent English-like description. Thanks for any help on this. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp …
onstat -g con
The first column of onstat -g con is CID. As I understand, CID is the condition being waited on. Where are these CIDs described in an English-like form ? thanks -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp …
informix
informix…
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: Broken transaction
Nigel Gall wrote: > > Hi! > > Platform: Digital UNIX 3.0b > OnLine : 5.05.UC1 > 4GL : 4.13.UD1 Pcode Version 8 > > Is there any condition, aside from an error in programming, which would > cause half (or piece) of a transaction to occur and not the other, even > when both (o…
Re: Session is waiting for long....
>Hi, > >A perticular session is waiting on a condition "netnorm" >and it's not doing anything for long. >What does it mean and how to make it run ? >Pl. reply as soon as possible. >Thanks in advance. > > netnorm is the condition that the user thread uses when it it waiting for in…
Re: Session is waiting for long....
Abhay Mannur wrote: > > Hi, > > A perticular session is waiting on a condition "netnorm" > and it's not doing anything for long. > What does it mean and how to make it run ? > Pl. reply as soon as possible. > Thanks in advance. > > Abhay Mannur. > Informix DBA > Fairchild Semicon…
Re: Session is waiting for long....
Abhay This is normal ,You can not make them to run manually . For Network connections Sqlexec thread is waits for poll thread to wake up and to process client request. or client session submitted a query to online , online finished with its work and is telling the session to tak…
Session is waiting for long....
Hi, A perticular session is waiting on a condition "netnorm" and it's not doing anything for long. What does it mean and how to make it run ? Pl. reply as soon as possible. Thanks in advance. Abhay Mannur. Informix DBA Fairchild Semiconductor…
Re: Need some performance help ..
alvin lam wrote: > > Hi > > I am using Online 7.14 engine; In 1 sql, I have to join 5 tables together; > > > > table 1 is a "orders" files which has over 12,000,000 records; > > table 2 to 5 are for description purpose. they have a little bit over 10,000 > records. > > Looki…
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…
Girish here
I have working experience in Informix and with Informix arround 2 years on variety of Informix products. can send my resume to you. I am in OR thx comp.database…
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…
Re: Universal Server - Row Locking Problem
Frido van Orden wrote: > > Yes, this is a classic one! > > THe problem is that you don't have an index on this table. As you issue the > second update statement, IUS starts looking for a record with col_id = 2. As > no index is available, it just starts looping through all the re…
Re: Waiting on condition problem.
Hi Madison, > >18807 prodadm 140 erp-trai 1 131072 79552 > > > >tid name rstcb flags curstk status > >28185 sqlexec 99cf4118 Y--P--- 34024 99cf4118 cond wait(netnorm) > > > > >How to find out the condition on which this is waiti…
Re: Waiting on condition problem.
>Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. >How to find out the condition on which this is waiting ? >And how to make it run ? > > >Here is onstat -g ses for a session which is waiting on condition for >more than >an hour. > >1880…
Meaning of drcb_bqe
I have another challenging question which may shed some light on my long checkpoint problem: What does the abreviation "drcb_bqe" stand for? Here's the context of the question. NOTE: Only the pertinent lines of the onstats are shown. onstat -l has the following entry in it: …
Waiting on condition problem.
Environment : ODS 7.23uc4 HP-UX 10.20 Here is onstat -g ses for a session which is waiting on condition for more than an hour. 18807 prodadm 140 erp-trai 1 131072 79552 tid name rstcb flags curstk status 28185 sqlexec…
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…
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. _____________________________…
!US - Informix DBA's and Developers needed
Informix DBA's and Developers needed in Phoenix, AZ and around the US. http://www.premierjobs.com/informix…
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…
Waiting on condition
I have a situtation where a client/server (PowerBuilder/Informix) is hanging. When I do an onstat -u or -g sesid, the first flag position is a "Y". I looked it up in the Admin manual, but all it says is "waiting on condition." Can someone please explain to me what this means? …
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 …
informix?
What is informix?…
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 …
Index build times with the HPL (longish posting)
Hi, I=92ve been doing some performance tests on the High Performance Loader. = (You may have seen my earlier post.) We are running ODS 7.23 on a dual = CPU HP server, running HP-UX 10.20. My tests involve loading a single, = initially empty, table with approx. 1.4 million rows …
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…
- Informix?
Can anyone help me? I'm looking for someone with informix and 4gl sql skills to start a six month contract in London but am having no success!! - Do these people actually exist? If you can prove me wrong (and would love this contract!!) please contact me at the below - my last …
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…
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…
! US-Informix DBA's and Developers needed
Informix DBA's and developers needed in the US. Check us out at http://www.premierjobs.com/informix…
Informix
Hi, Where can i get ODBC drivers for Informix. I've got the Crystal Reports drivers, but they give error code 126?!!! Please help…
Informix
Is it possible to use informix databases from a Visual Basic client without using ODBC driver. And what about delphi possibilities for this question Thanks…
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…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
<No Subject Supplied>
REMOVE INFORMIX-LIST SUBRAMANYAM MEKALA THANKS…
<No Subject Supplied>
REMOVE INFORMIX-LIST SUBRAMANYAM MEKALA THANKS…
<No Subject Supplied>
REMOVE INFORMIX-LIST TERRON WRIGHT…
<No Subject Supplied>
REMOVE INFORMIX-list@rmy.emory.edu…
Informix?
Wow, this is still here so I guess the company is too.…
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: Status in onstat -g
>We have Informix 7.10 running on a SCO Box. > >I did an onstat -g ses ## and got a status of "mode wait(netnorm)". Does >anybody have an idea what this means? > > Basically that you are using tcp to communicate with the engine and that the engine is currently waiting on the cl…
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…
Apple and Informix will announce merger
Apple and Informix will announce merger on Tuesday. This should cause both Apple and Informix stock to rise significantly. For details on the Apple and Informix merger, check out http://www.stocks4tomorrow.com…
Informix
Testing…
Informix
Informix…
!!! Informix DBA's and Developers
Informix DBA's and developers needed! Check us out at http://www.premierjobs.com/informix…
!!! Informix Developers and DBA's
Informix DBA's and Developers needed! Check us out at http://www.premierjobs.com/informix…
US- INFORMIX (60 Openings) informix, informix, informix, informix, informix, informix, informix, informix, informix, informix, informix, infor
JOB ID # Skill Set #Needed Location AJ 01 Informix 7.x DBA 6 Arkansas AJ 02 Informix 4GL 3 Arkansas AJ 03 C/ESQL 2 Arkansas AJ 04 Visual C++ 2 Arkansas AJ 05 Java 2 Arkansas AJ 06 Informix 4GL 5 Minnesota AJ 07 Informix 7.x DBA 2…
US- INFORMIX 7.x DBA Arkansas informix, informix, informix, informix, informix, informix, informix, informix,
JOB ID # Skill Set #Needed Location AJ 01 Informix 7.x DBA 6 Arkansas Immediate Start� ALL CANDIDATES MUST HAVE INFORMIX BACKGROUND. (Unless Oracle or another database is specified) Requirements: 1. Excellent communication skills 2. Travel 40-60% 3. Excellent written s…
!!! Informix DBA's and Developers
Informix DBA's and Developers needed. Check us out at http://www.premierjobs.com/informix…
!!! Informix DBA's and Developers
Informix DBA's and Developers needed. Check us out at http://www.premierjobs.com/informix…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
!!!Informix DBA and Devlopers
Informix DBA and Developers needed. Check us out at http://www.premierjobs.com/informix…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: adjacent key locking
We are having a similar problems :- online 7.12 isolation level is dirty read lock mode is row level set wait is 5 A large(ish) process is inserting into the table in question, as soon as someone tries to update this table via a composite primary index they often get timed o…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
WHY ?
Question... Why Informix ?…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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: DR Question
On Thu, 17 Apr 1997, David Williams wrote: } } In article <5j0ihd$gf2@cssun.mathcs.emory.edu>, Con Woodall <cwoodall@vt } h4.vth.colostate.edu> writes } >There is some inconsistency here, bot it doesn't "always" work but I } >find that I need to have teh DBSPACETEMP variable set…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: verify
The Informix key is NOT stored somewhere in the Informix software - contact Informix Uwe…
Re: Informix sessions hang !
I would appreciate it if someone would give me a few pointers to the problem below: We are on solaris 5.5.1 with informix 7.22 running r4gl apps. Every now and then we get a user session that freezes up. -------------------------------------------------------------------------- …
Re: Informix sessions hang !
Manoj wrote: > We are on solaris 5.5.1 with informix 7.22 running r4gl apps. > Every now and then we get a user session that freezes up. > A "ps" shows that the user is running the prog and the time is clocking up. > An "onstat" shows the the user is in cond wait(sm_read), locke…
Re: PRESS: Informix in the News
Informix reports a bad Q1.…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: 7.22 onstat -u flags
On Wed, 12 Mar 1997, Allen W. Jantzen wrote: } Well, I finally moved my production db to 7.22 from 5.03. After } (finally) remembering to do an UPDATE STATISTICS and tuning } the parameters, things seem OK, but a bit slower than ver 5.. } } My question: the onstat -u output ha…
Re: 7.22 onstat -u flags
With DSA (6.x 7.x), the onstat -g ath is probably going to give you more information about what's going on in the engine than the onstat -u. You will often see the sqlexec thread (these are the user functions) on a condition wait (sm_read) or condition wait (netnorm). This is t…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: 7.22 onstat -u flags
On Thu, 13 Mar 97 05:43:05 GMT, rferdy@kuwait.net (Rudy Fernandes) wrote: >>> My question: the onstat -u output has a "Y" in the first slot of the >>> flags column for _all_ my client processes almost all the time. >>> >>> The doc just says that a "Y" means that the process is …
Re: 7.22 onstat -u flags
On Thu, 13 Mar 1997 01:43:49 +0000, David Williams <djw@smooth1.demon.co.uk> wrote: > A condition is a mutex (latch). Look in $INFORMIXDIR/etc/sysmaster.sql > as search for "create table sysconlst". This is "{ Conditions }" and > contains one field "con_nwaits integer, …
Re: 7.22 onstat -u flags
In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> wrote: >Allen W. Jantzen wrote: >> My question: the onstat -u output has a "Y" in the first slot of the >> flags column for _all_ my client processes almost all the time. >> >> The doc just says…
Re: 7.22 onstat -u flags
In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> writes >Allen W. Jantzen wrote: >> >> Well, I finally moved my production db to 7.22 from 5.03. After >> (finally) remembering to do an UPDATE STATISTICS and tuning >> the parameters, things seem OK…
Re: 7.22 onstat -u flags
Allen W. Jantzen wrote: > > Well, I finally moved my production db to 7.22 from 5.03. After > (finally) remembering to do an UPDATE STATISTICS and tuning > the parameters, things seem OK, but a bit slower than ver 5.. > > My question: the onstat -u output has a "Y" in the first…
7.22 onstat -u flags
Well, I finally moved my production db to 7.22 from 5.03. After (finally) remembering to do an UPDATE STATISTICS and tuning the parameters, things seem OK, but a bit slower than ver 5.. My question: the onstat -u output has a "Y" in the first slot of the flags column for _all_…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
(no subject)
REVIEW INFORMIX-LIST f=mail…
NO SUBJECT
Is there a special Informix 4GL newsgroup?…
Re: Need clarification of 7.2 threaded clients
Philip Walden wrote: > > The Informix-esql/c 7.2 manual describes threaded esql/c programs. It > says that a process can have multiple "active" connections. One active > connection per thread. However it also says that only one connection can > be "current" at any time. > > What …
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: ???netnorm???
W95SCRIP (Leo_Chen@usc.com.tw) wrote: : Hello: : Would you please tell me what's the meaning of the word 'netnorm' below? : It's the output of command "onstat -g con". We have many 'netnorm's in the : conditional wait output. : Thanks!! : leo : =============================…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Informix
I have a few users trying to compile 4GL modules using C. They are running Informix 4GL 4.2. The users that run the Microsoft TCP/IP hang at compile, while the ones using the Chameleon TCP/IP have no problems. Does anyone know of any solutions or known causes for this. Thanks.…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Informix
We used informix/unix for our applications and we are on the process in porting our applications to Window NT4. Does anyone know where I can get examples for converting the esql/c/unix version to Window NT, and examples for informix-CLI/ODBC using Visual C++? Thanks in advance fo…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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: US-FL- INFORMIX OPPORTUNITIES - CONSULTING / FULL TIME
In article <01bbe3c3$141ea0a0$8e02e3c7@gate.net.gate.net>, "Computer Careers Inc.," <careers@gate.net> wrote: > > >**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX >**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX >**** INFORMIX**** INFORMIX**** …
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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.…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix DBA's should have some on-line experience, Uni…
INFORMIX
INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix DBA's should have some on-line experience, Uni…
INFORMIX
Reposting article removed by rogue canceller. INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix…
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…
Subscribe
subscribe 'informix-list@rmy.emory.edu'…
Unsuscribe
Unsuscribe 'informix-list@rmy.emory.edu' apsf@server1.santafe.com.ar'…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
NEED AN INFORMIX PROGRAMMER IN MPLS
Interested in working with an Informix contract programmer on a…
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.…
unsub informix-list
unsub informix-list…
informix
Hello, I have a problem with the connectivity between Newera on a PC, and the Informix server on the IBM platform. Situation: PC with Newera 1.0 and Windows 95. Informix server 7.1 on a IBM rs6000, AIX 4.1 The problem is when I start the tool of Newera I get the message that …
Re: ONSTAT question
I think it means that session is idle, waiting for next SQL statement OR user action. In article <491umh$hvm@newsgate.dircon.co.uk>, Bashar@ctl.com says... > >Hi there. > >onstat -u (version 7.1) sometimes shows a user thread with position >1 of the flag field set to Y. The Info…
Re: ONSTAT question
I think it means that session is idle, waiting for next SQL statement OR user action. In article <491umh$hvm@newsgate.dircon.co.uk>, Bashar@ctl.com says... > >Hi there. > >onstat -u (version 7.1) sometimes shows a user thread with position >1 of the flag field set to Y. The Info…
Re: ONSTAT question
Bashar Chalabi wrote: > onstat -u (version 7.1) sometimes shows a user thread with position > 1 of the flag field set to Y. The Informix manual says it means > "Waiting for condition". I cannot find anything else. > > What is a condition, and why is my thread waiting for it? A c…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…
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…
Chicago Area Informix Usergroup???
Is there a usergroup in the chicago area for Informix users?? e-mail: zarion394@aol.com…
<No Subject Supplied>
Set informix-l DIGEST REVIEW…
(no subject)
Is there any good FAQ for informix?…
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…
***INFORMIX DBA, INFORMIX DBA, INFORMIX DBA***
I HAVE 2 IMMEDIATE OPENINGS for INFORMIX DBA's in US/CA - SF Bay Area... 3-6mos. contract to join team and perform regular DBA duties as well as application development work.......Please contact Wanda Lee at (800)33-5339, or (415)788-8488, or wandal@toner.com, and/or fax resume t…
informix
Using 4.10.UC4 SE. In the reports section with 'option page length 66' and nothing fancy in tthe 'on every row', after the last line on the report is printed, informix then generates more than enough empty lines which send the report into the middle of the next sheet. It looks l…
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…
Informix P/A, Informix DBA
We are looking for consultants for a six months contract, minimum: 2 years experience - Informix 7.0 DBA and UNIX Shell Script 3 years experience - Informix Programmer/Analyst, C/C++, UNIX Shell Script Fo…
[?]INFORMIX <--> INFORMIX
C> From: cpilot@teleport.com (cpilot) C> As the subject line suggests, my questions regard Informix to Informix > connectivity via I-Net where all Informix databases reside on RS/6000's. C> BTW, I will be running the Standard Engine on all (about 32) of these boxes. C> 1. Is …
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…
Re: Informix Locking Questions ???
Bill Border (border@col.hp.com) wrote: : 1. Does Informix do deadlock detection - we've observed : circumstances that appear to be deadlocks between : threads and they just sit there (no reads/writes/ : locks). Yes, Informix does deadlock detection. It traces all t…
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 …
No Informix WWW
What happened to Informix's home page? Its been screwed up for several days. Earth to Informix, come in Informix.…
Linux Implementation
Is there a Linux port for any Informix release?…
Re: Phantom Inserts
In article <pwongD4C773.F15@netcom.com>, pwong@netcom.com (Philip S. Wong) writes: |>I was wondering how different databases/vendors implement protection |>against phantom inserts. In particular, how can they achieve phantom |>protection while maintaining a good degree of concur…
Error 581 -- Need HELP
Whenever I use the 'set explain on' statement I get error 581 I can reproduce this error running Online 5.1 (SCO-Version) on my Linux box. The same error happens on Interactive Unix with Online and SE. As far as I can tell all the messagefiles are in their place in the msg subdir…
New Era & WFW
Hi Informixer's, simple question : why informix doesn't support NE on WFW...?…
FAQ on Informix?
Is there an FAQ on Informix RDBMS? Thanks.…
Informix manuals online
I agree Informix should have their manuals online. Robyn…
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.…
Deadlock timeouts
One of my projects is plagued with "deadlock timeouts" and programs getting stuck in infinite loops and I'm hoping for some insight. An SCO Unix/Informix OnLine 4.10 system is running at least 20 4GL processes at any given point in time that operate on a common pair of header/det…
Did Price Change Happen
Did a informix price change happen???…
informix
We are in need of Informix expertise in two areas: 1) query optimization and the use of indexes, and 2) performance tuning using self-joins and outer joins. 1) We have a query that should use an index, but doesn't. When a second index is added to the table, the query now re…
Re: tblspace does not exist
this is what informix told me to do...…
Re: DELAY after ESCAPE
bochner@das.harvard.edu (Harry Bochner) writes: >In article <C35B7F.697@ipars.cts.com>, scotto@ipars.cts.com (Scott O'Connell) >writes: >|> I'm just getting back into programming with Informix 4GL 4.10 and was >|> noticing the delay time between pressing ESCape and Informix real…
Re: HELP! Selecting and locking rows in a transaction
Marco Penengo writes: > within a transaction I need to select some records from a table (in a database > created in MODE ANSI) and lock them in exclusive mode to avoid that other users |> modify these records until the end of the transaction. |> My test contains this 4GL code: |>…
HELP! Selecting and locking rows in a transaction
I'm using Informix 4.00 on SCO UNIX System V/386 and I have the following problem: within a transaction I need to select some records from a table (in a database created in MODE ANSI) and lock them in exclusive mode to avoid that other users modify these records until the end of…
Informix & Softbench
Informix users, We are using Informix & Softbench on our HP-700s. Any help on integrating Softbench & Informix? Thanx, N.Strifas…
Informix ...
Path: emory!wupost!tulane!uflorida!eng.ufl.edu!usenet.eng.ufl.edu!tsao From: tsao@tcad.ee.ufl.edu ( Tsao) Newsgroups: comp.databases Message-ID: <TSAO.91Sep15131210@neptune.tcad.ee.ufl.edu> Date: 15 Sep 91 17:12:09 GMT Sender: news@eng.ufl.edu Organization: VLSI TCAD, University …
informix
Path: emory!wupost!uunet!viusys!uxui!unislc!mrc From: mrc@unislc.uucp (Mike Cederholm) Newsgroups: comp.databases Summary: I desperately need help with importing data..... Keywords: help please with inport data Message-ID: <1991Aug29.065208.10269@unislc.uucp> Date: 29 Aug 91 06:5…
informix
Path: emory!swrinde!zaphod.mps.ohio-state.edu!ncar!noao!amethyst!hindmost!jgotobed From: jgotobed@lpl.arizona.edu (Joe Gotobed x4549) Newsgroups: comp.databases Summary: How's their support? Message-ID: <3047@amethyst.math.arizona.edu> Date: 15 Aug 91 19:27:38 GMT Sender: news@am…
INFORMIX
Path: emory!sol.ctr.columbia.edu!cunixf.cc.columbia.edu!cs.columbia.edu!news From: duanyang@cs.columbia.edu (Duanyang Guo) Newsgroups: comp.databases Keywords: Trouble-ticket, database management Message-ID: <1991Jul11.204519.9424@cs.columbia.edu> Date: 11 Jul 91 20:45:19 GMT Sen…
Informix Online <> Informix standard
Path: emory!samsung!uunet!mcsun!unido!logixwi!rcr From: rcr@logixwi.uucp (Rainer Ruppert) Newsgroups: comp.databases Keywords: informix, online, database Message-ID: <1991Jul11.114558.8396@logixwi.uucp> Date: 11 Jul 91 11:45:58 GMT Organization: Logix GmbH, Wiesbaden, W-Germany …