Oninit® Archive
Results for “onstat -g act”
Network tuning advice needed
Greetings All, I am looking for some advice on a new (to me) configuration. Up until now, we have always had our engine running on the same server as our application. That has now changed. We now have a setup with the application on one server and the engine on a dedicated datab…
What is the load on an individual listener or sqlexec thread?
this help at all ? The CPU time shown for a thread is updated each time the thread yields and is based on the change in clock time since the thread last started. For threads such as the poll threads, which spend the majority of their time in an OS call such as s…
Segfault since CSDK 4.50.FC10 with LVARCHAR and CLIENT_LOCALE different from DB_LOCALE
I will open another thread for ifx_var_init() usage. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
ESQL/C conversion error with CLVCHARPTRTYPE
Hello Andreas! Thanks for your answer. I will open another thread for the new issue one of a customer has detected. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
flags (onstat -g ses)
That's the same set of flags as in ' onstat -u ' I'd say. For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one. ------------------------------ Andreas Legner ------------------------------…
Slow Running Query
Instead of using -r2 run the onstat in a loop with a sleep and write each output to a different file. Then you can diff the files to find the long runners: iter=0; while [ $iter -lt 10 ]; do onstat -g act >act.$iter.out sleep 2 iter=$(( iter + 1 )) done You could also enable SQLT…
onstat -g opn: What sysmaster tables will get me this info?
Look at filefd column – I think that links to something that will provide the isfd from onstat –g opn and then the partnums Cheers Paul ------Original Message------ Paul replied privately but I think this should opened up for the sake of community knowledge: Paul suggested use of…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
blocked records
Use "onstat -k" for threads holding locks and "onstat -u|grep L" for sessions waiting for a lock…
Bufferpool configuration
Hi, a recent thread titled "BUFFERPOOL Configuration" dealt with most of these issues. Ben.…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Using complete CPU core instead thread
Hi, is it possible to configure informix to use the whole core per VP instead of only one thread using affinity ? Let's say that now we have cpu=6,aff=(0-5),noage Condidering that there are 2 threads per core, if I configure informix to use only one thread per core, would it use …
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
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…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
sid vs pid
Thanks. I thought the process ID was for a DBMS process. I probably had process confused with thread.…
Full memory even if I set SHMTOTAL
Hello. It seems you are using vp memory cache without the "static" word, after the cache size. Try setting that. A second good practice is to schedule an onmode -F with a good period of execution, according to your memory fill rate. There are some kinds of problems in shared m…
Chunk symbolic links
It's rootdbs. Issue is solved, there was a problem with the link file. This thread can be closed. Thank you.…
Re: RE: onstat -g glo: cpu efficiency
My recommendation would be to disable the four threads per core and reduce that to 2 threads per core (or turn them off entirely). You will get better throughput from the CPU VPs that way and so fewer spins waits. You already have many more NET VPs configured than you need. IBM …
dbexport : -425 - Database is currently opened by
Guys, Did numerous times of dbexport . in past 50 years, NO problem :-) :-) But, now it blocked the job... It is sure , no application , no ER, no HDR, NO nothing running there ( I even stopped scheduler ) ... Any tip to trace the " another user"? By the way, it is fine to d…
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…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
How to define task execute every 100 millisecond?
The only way that I can think of to do this would be to create a UDR and do the task and to have a 100 ms sleep in it using a poll() call. But (and this is very important), a poll() (or select()) function call is not a function which is a well behaved function call if run on the …
Re: RE: Which session is using the most cpu resour
Thank you Michaelis. I am also looking similar to this scenario. That is how to find sessions which are using more system resources? Here are few sample output based on instruction in your post: Top command: top - 12:59:22 up 318 days, 20:53, 2 users, load average: 3.19, 3.93, …
Hyper threading
IDS 12.10.fc5 IDS 9.40.fc5 Aix 6 and 7 We have just moved our Informix systems to a Power 8 system ... previously we were on a Power 7. I remember something from last years conference about Hyper threading ... and if it should be used or not ... but I don't remember .. nor can I …
opentable memory leak
Original post: No AUTOINDEX as far as I can tell. Turning off PDQ avoids the issue and I can live with this until permanent fix is found. Thanks, Andrew Response: It's a APAR in 12.10.xC5. APAR IT09544. The description talks about auto-index path, but the real trigger is an…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
fast recovery
To help prevent this in the future you can also consider lowering you LTXHWM to trigger the rollback sooner. This works if you have a system like mine that should usually not have a transaction that runs over 5 minutes and if there is a big transaction like this it needs to be r…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Re: btscanner running v/s ready
10? 10 is eol last time I checked. j. On Oct 7, 2013, at 3:25 PM, John Miller iii <miller3@us.ibm.com> wrote: > If you are really interested in how many times it has run and for how = long=20 > it has run on the CPU VPs then=20 > take a look at onstat -g cpu | grep btscanner. …
btscanner running v/s ready
The onstat -C report and its options report on the btscanner threads and the table/index hot lists that it processes. As to when it runs, it runs when there is sufficient work in the hot lists for it to process. When the thread finds no more work it sleeps and wakes periodically …
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
CPUs spike
That's a multistep process: - onstat -g cpu or onstat -g glo in combo with your top display to determine which CPU VPs are spinning the processors - onstat -g act to identify active threads, what they are doing, which CPU VP they are running on, and what the rstcb key for the…
Re: nmon and Top Processes
Important note: Use any of this scripts at your own risk. Most of them have been in use in some customers successfully for some time (years) but that doesn't mean they don't contain bugs. For sure, there are bugs. Regards On Tue, Mar 19, 2013 at 10:00 PM, Fernando Nunes <domuson…
nmon and Top Processes
Hello Tom, As Jonathan wrote, Informix doesn't have a 1:1 PID vs session relation (at least Informix Dynamic Server), but I suppose you already know that. In order to quickly find the sessions consuming more CPU at a specific time you can use a script that interacts through seve…
Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"
Well...I tried going to single CPU VP, and it stalled almost immediately so I thought "Oh what the hell!" and set it to 8 CPU VPs (there are 8 on the virtualised machine), along with150 AIO VPs. It then went a lot further than before but then just stopped. Not at a checkpoint or …
Fwd: Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"
On 18/02/2013 19:39, Art Kagel wrote: > What does onstat -l show? If you are dbimporting an export that was > made without the -ss option then all tables are created with minimum > extent sizing which will cause thousands of new extents to be added to > the tables during the dbi…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
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…
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…
Newbie question: fresh default Mac OSX install, co
On Mon, May 7, 2012 at 1:34 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > Sounds to me like some of the shared memory segments got hung. > Here's my session: bash-3.2$ onmode -ky bash-3.2$ ps -ef | grep oninit 502 36861 35084 0 0:00.00 ttys000 0:00.00 grep oninit bash-3.2$ wh…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Informix Status Explanations
That may help, but the vast majority of bufwaits are caused by lru queue latches. You need to increase the number of lru queues for the specific buffer cache that it is waiting on in the BUFFERPOOL parameter lrus=<n> option. Ideally this should be close to the maximum number of …
Safely de-allocate cores?
original post: DS 11.5 FC8W2 on SPARC Solaris 10. We have a Solaris VM ("Container") running with 68 cores. 4 or 5 Informix instances run on here. We wish to de-allocate 4 cores from the VM for IBM Informix licensing reasons. We're pondering whether we can safely do this dynami…
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…
Help! Broken server destroys customer demo...
Here's some more information, the output of an oninit -v command: Checking group membership to determine server run mode...succeeded Reading configuration file 'C:\\\\PROGRA~1\\\\IBM\\\\Informix\\\\11.70/etc/ONCONFIG.ol_matdemo'...succeeded Checking config parameters...succeeded…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
onstat -g glo: cpu efficiency
This is interesting, just looking at a couple of our systems... Efficiency on CPU threads sits between 60-80%. I suspect that's probably about right, because in our environment the client application is on the same box competing for resources... The efficiency on all the io cla…
infos about waitstates
On 18 Jul., 09:07, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi, > > I'm searching for detailled informations about waitstates and how to > interpret them and how to react. > > Examples: > > buf ready > > aio > > mt yield n > > running > > buffer > > m…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Single threaded vs. Multi threaded
Wow, it's been a while since I worked on Informix 5 :-) In Informix, Version 5, UNIX controlled everything. For each user that connected, a process was created and UNIX controlled process switching. This is a single-threaded architecture model. Due to the size of servers back wh…
Scheduler Error
I did end up having to restart the server in order for the AUS Refresh task to run. Now, the real problem is that the dbworker threads failed again (after about half of the update statistics statements) with the following message in the log: 22:07:25 SCHAPI: thread dbWorker1 tas…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
proper way to create rawdevices in Red Hat Enterprise 5.5
This is unnecessary and will quite possibly be slower. See other recent thread: https://groups.google.com/group/comp.databases.informix/browse_thread/thread/61a4908ebbadb977 Regards, Doug Lawry…
Memory Management
oh..also think around 300 threads connected to this database.…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Multiprocessor setting
John's talking about OS scheduling. With your applications and a web server all sharing the same set of processors, I'm not surprised that the VP efficiency is around 35%. If most application and web server tasks entail accessing the database then any action requires at least two…
ontape backup failed
Art: Here is the info # onstat -g seg IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 32 days 14:20: 15 -- 1024000 Kbytes Segment Summary: id key addr size ovhd class blkused bl kfree 0 1381386241 200000000 595591168 437760 R* 144776 63 2 1 1381386242 223800000 …
onstat -g rea
exist a query over sysmaster with similar output of 'onstat -g rea' or 'onstat -g act'?. Thanks…
thread bp_priosweep
what exactly does this thread? have something with LRUs priority??? Is it tunable? $ onstat -u IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34 -- 915248 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites .... 5c06ad0 Y--P--D…
System.FormatException with CSDK 3.50 TC4DE
Changing the Thread's CurrentCulture to Invariant Culture fix this: System.Threading.Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; Ty.…
Buffer Waiting ( onstat -l )
The number of times that threads (sessions) had to wait to obtain a buffer. It's measure of system concurrency.…
soctcppoll and soctcplst
Hi, What is the difference between a thread called soctcppoll and soctcplst ? I'm confused with the output of onstat -g ath…
why so many informix threads on idle systems ?
Each of the threads have a special purpose. Since the system is idle, there are no 'sqlexec' threads. Those are the 'user' threads and are responsible for the actual query. The ER threads are event driven and = are driven when other things happen, possibly from a log being writte…
CPU usage at 100% Identifying the culprit
To identify this issues before v11 , I use the command "onstat -g act -r 1" +awk '{ print $1}' + "uniq -c" +"sort -nk1" (this is just a draft of the commands...) With this , you get the number of times the threads appear running in the last seconds . This is useful only if you h…
Random Server Slowdown "Redone"
Hi Javier , Here my opinion and hints... 1) I agree with Art, where have to lot Lockreqs, but I don't consider this impossible since you have 8 machines running your applications... 2) Active an OS monitoring tool, like sar to collect information for each 10 or 15 minutes... (…
User thread
I'm using Informix 11.5 developer edition and some Windows services are acusing an ODBC error (Cannot create user thread). Informix is installed on Windows. What can I do to fix up this problem?…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
session versus VP
If you use onstat -g act this will print all running threads. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/07/2009 06:52:07 AM: > [image removed] > > session versus VP [17405] > > …
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…
Re: Get Active Sessions
Omar, Thank you. Yes that seems to work. I just need to grep for the sqlexec and map that to onstat -u. Works well. Thank you very much. --David On Wed, Aug 12, 2009 at 3:14 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi. > > You obtain active threads by using onstat -g…
Get Active Sessions
Hi. You obtain active threads by using onstat -g act. That includes user sessions and informix's inner threads. I hope this works Omar --- On Wed, 8/12/09, Dave <In4MixDBA@gmail.com> wrote: > From: Dave <In4MixDBA@gmail.com> > Subject: Get Active Se…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
how to force disconnect user threads?
How can I force disconnect user threads from Informix IDS? Thanks.…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
IDS instance memory
Onstat - shows the amount of shared memory shared across the oninit processes. In addition, you are using memory for one copy of the oninit process itself (shared by all processes), static and dynamic process private memory for each oninit process, etc. However, in general, the o…
Question about the status of the thread
Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.…
Long Spins
The purpose of a spin lock is to lock the object amongst multiple processes. The mutex is to lock threads from each other. If you have configured more cpuvps than physical cpus, then you can encounter lock inversion which can only be resolved by spinning until t= he process hold…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
LTAPEDEV to /dev/null from onmonitor
Kindly Ignore this as another thread is open with same content.…
syspools
>IDS11.10 UC2, AIX 5.3 > >Run the following query on syspools, and attached the partial result list. > >po_name "mt" occupied much of the memory. > >what "mt" means? what is the major jobs of "mt"? > >Thanks, Frank I belive the "mt" stands for Multi-Thread. That pool would be us…
Re: sqldetach not returning
> What is the stack for the thread calling sqldetach and the output of > onstat -g stk <tid> for the corresponding IDS thread? i´ll try to collect this information when the problem happens again.…
listener-thread: err = -27001
Hi, Guys, Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 We repeatedly receive the following error msg in online log, 19:43:34 listener-thread: err = -27001: oserr = 0: errstr…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Re: threads still running?
If the routine contains a query sufficient complex to benefit from parallelism or from fragment elimination and you wanted those options to be always available to any user no matter what their current PDQPRIORITY is. This problem is why my dostats utility resets PDQPRIORITY to z…
RE: threads still running?
Thanks.I see now that that was the problem. The script that updates stats had set pdqpriority 80 at top and never change it before it updated stats for 'routine'. What would be an example of "routines that are known to require PDQPRIORITY set" ? I mean what type of task would th…
threads still running?
This involves ids9.4.tc2 on windows 2000 server. I have been trying to find out why so many connections are open on a server that has at most 20 users on it and the onstat -u may show something like: 2053 active, 2688 total, 2648 maximum concurrent. If I do "onstat -g ses" an…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
b-tree scanner tuning and expected behavior
Hi, we're having some trouble on production instances with the b-tree scanner threads. We're using IDS 9.40FC6-9 on solaris 5.9 (sparc). On some of these instances we observed that suddenly 'something' triggered an increment of CPU usage: we had a guess on what was triggering it …
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
Hi All, Thanks for your replies. I managed to identify the process that caused the problem. 1. Use onstat -g act to look at active threads 2. Perform onstat -u | grep <rstcb value of active thread in step 1> -> get session id. 3. Perform onstat -g ses <session number from step…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
CPU VP Issue
tgirsch wrote: > I've got a puzzling CPU VP issue that I'm hoping someone else here has > dealt with. I've got a dedicated database server running IDS 10.00.FC8 > on a four-core RHEL Opteron server. We've configured four CPU VPs, one > per core. There are almost always five to…
onmode -cuky not working
check which threads are active 'onstat -g act -r 1' and what they are doing 'onstat -g stk <thread-id>' Regards, Nilesh ids-bounces@iiug.org wrote on 05/15/2008 08:07:33 AM: > Hello all, > > i am trying to shutdown the informix instance with onmode -cuky > vikas:/export/home/i…
Create Index Mysteriously Slow at the End - IDS 11.10.UC2W2 - Red Hat EL5
On May 13, 9:22 pm, "Andrew Ford" <af...@networkip.net> wrote: > Thanks for the reply Jacques, > > > What does onstat -g ckp show for the long checkpoints? > > Critical > Sections Physica…
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…
PDQPRIORITY
VIKAS HIVARKAR wrote: MAX_PDQPRIORITY is applied as a percentage multiplier against any user setting of PDQPRIORITY and so acts to limit the maximum PDQPRIORITY setting. See the table below: MAX_PDQPRIORITY PDQPRIORITY setting Effective PDQPRIORITY 100 100 100 100 50 50 75 1…
Re: unkillable sid's
> > If the thread is continuously running it could be moving between vps. > At least it is a start. > It's possible, it just would depend on what sort of loop it was in, if it was in a loop that did a mt_yield call then yeah you might have some sort of reasonable stack. However…
how to balance CPU VP
roger@star2000.com.tw wrote: >> You'll never get nearly even usage out of all CPU VPs, however, if you >> are using shared memory connections, make sure that the NETTYPE >> parameter for ipcshm has the same number of poll threads as CPU VPs and >> that they are configured to run …
Informix thread working with a index
Hi all, I was trying to monitor an internal informix thread. I get a table with 8 million records. I do between 1000 and 5000 insert to this table daily. Every night I update statistics to whole database. There is a thread that it gets a session id but I can't see what it's doi…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Maximum concurrent users threads
Can someone tell me the formula that produces the maximum concurrent number portion of the onstat -u command? Is this based on what is defined in NETTYPE? ----------------------------------------- This message and any attachments may contain confidential information or trade sec…
Listener-Thread Error 25571
Today we saw hundreds of lines in our message log with the following error. The database pretty much came to a halt and nobody could connect or do any work. Only bouncing the engine cleared up this issue. 17:15:47 listener-thread: err = -25571: oserr = 0: errstr = : Cannot cr…
Re: IDS on a Mac?
I thought the title of the thread was "IDS on Mac OSX". Why don't you just create a new thread and move all the Oracle vs. Informix and all the personal bashing over there????…
Re: Calculate optimal value for DS_POOLSIZE
Actually I believe the confusion is betwen the DS cache values with the DD cache variables. DD_HASHSIZE and DD_HASHMAX mean something else. DD_HASHSIZE is the number of buckets or lists, and DD_HASHMAX is the number of entries (soft limit) per buck or list. DS_POOLSIZE indica…
Re: NETTYPE NET/CPU
On 21/09/2007, mohitanchlia@gmail.com <mohitanchlia@gmail.com> wrote: > On Sep 17, 12:37 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > On Sep 17, 12:59 pm, mohitanch...@gmail.com wrote: > > <SNIP> > > > > > I am posting it again as this is a separate question: > > > > > But…
Re: NETTYPE NET/CPU
On Sep 17, 12:59 pm, mohitanch...@gmail.com wrote: <SNIP> > I am posting it again as this is a separate question: > > But when NETTYPE is set to NET it spawns different set of oninit, > which is additional set of oninit as compared to the one started by > informix for NUMCPUVPS. …
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
Re: NETTYPE NET/CPU
> Read more about NETTYPE and have few more questions: > > 1. What determines the polling cycle of poll thread having class of > CPU VP. You mentioned it polls only periodically. What does it do when > it's not polling ? A poll thread running on a cpu vp will poll at a minimum o…
Cpu vp usage
malcolm.iiug wrote: > AIX 5.3 > > IDS 10.00.UC5 > > > > We have had reports of slow performance so I have been monitoring the > system. When I check with onstat �g glo I see that the cpu vp usage is > skewed towards the 1^st cpu vp. In the latest example cpu vp 1 has used > ~…
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.…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
How to remove checkpoint
Hi, What was the cause of the crash ? What is written in online.log ? Is there a af dump ? Does onstat -g act react ? Which IDS version are you using ? Sorry, could be anything ... Marcus -----Original Message----- From: Wahyu Cahyadi [mailto:wahyu@takaful.com] Sent: Monday, J…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Anybody seen a very fast wild cat out there?
FInally, AUTO_AIOVPS is not explained that well. "the database server |automatically increases the number of AIO VPS and flusher threads when the |server detects that AIO VPs are not keeping up with the I/O workload" What threshold determines this? Couldn't adding more and mor…
IDS is busy all the time
Hi, I need a hint. Maybe somebody has had the same or a similar problem: We have an IDS 10 Server which has been running with a load of about 15 % until some days ago. Suddenly (without a config change), the load is > 50 % all the time. We shut down the engine and the load went…
Re: Senior Oracle DBA now Learning Informix by Request
> > > > I stand correct. Simply put ... the fact was, for rather obvious > > reasons, not common knowledge at Microsoft and not in their best > > interests to acknowledge. > > > > I am aware of quite a few other companies use competitor's software > > that, for similar reasons, t…
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…
CPU idles
> Hi, > > First: it is possible to set the NUMCPUVPS parameter to a > higher value than actual processors in the system. This > sometimes leads to better response times. (when you encounter > idle time on your CPU (using sar) and the number of active > threads is not decreasing).…
Holy Sh
So maybe the "marketing blitz" you referred to in your other thread is starting to roll out?…
listener-thread: err = -25573
IDS 10.00.FC4 Solaris 10 New server, New Database Database has been up for 6 days. Received this error last night: 08:36:56 listener-thread: err = -25573: oserr = 13: errstr = : Network driver cannot accept a connection on the port. System error = 13. 08:36:57 listener: poll ret…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
A question of load . . .
We had similiar problems too. What happen was one 'power user' was running Cognos Impromptu query, using non-standard catalog to create her own report, therefore, generating excess number of 'outer join' and suck out all CPU. Next time happen, you can run 'onstat -g act' to see w…
To change extent and next size of huge table
TQ, disk space is a problem. We will try once we got the disk will update the thread then. Thanks again. Regards. Shani…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
sporadic listener-thread errors
Hello, we are seeing listener-thread errors sporadically (once or twice a day): OS: HPUX 11.11 IDS: 9.40FC7W3 Error messages in the message log on server side: listener-thread: err = -25580: oserr = -1: errstr = : System error occurred in network function OR listener-thread: e…
help on onstat
Maumas said: > hi, > please help me how to leave onstat -i mode? Try control-d or control-c. If that doesn't work, control-\\ will. -- Bye now, Obnoxio Information within this post contains forward looking statements within the meaning of Section 27A of the Securities Act of 1…
Initialising Informix
My file settings are as follows SERVICES srvr0001 8001/tcp #Informix port sqlhosts ok_srvr onipcshm 10.0.6.2 ipcs0000 ok_tcp onsoctcp 10.0.6.2 srvr0001 onconfig DBSERVERNAME ok_srvr # Name of…
Maximum number of extends
http://groups.google.de/group/comp.databases.informix/browse_thread/thread/c8d12b3def081d8b/6181761f44b780de…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Informix session VS 'oninit' CPU usage
(Sorry - I am reposting this as it is supposed to the reply for the currently last entry of the thread /R.) Thanx everybody for the feedback. Unfortunately I cannot use the SET EXPLAIN as Ben suggested since the executed statements are encapsulated inside an application that is …
Re: Informix session VS 'oninit' CPU usage
Thanx everybody for the feedback. Unfortunately I cannot use the SET EXPLAIN as Ben suggested since the executed statements are encapsulated inside an application that is executed by the users. However, I will try to mix what you suggested with other suggestions for the same kin…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: Thoughts on Logical Log use requested
malcolm weallans wrote: > You miss the point entirely. > Well, (tongue in cheek) use "WITH NO LOG" (because this is the Logical > Log use thread)! > > Not enough potato EEEEEEEEEEEEEE Actually, I didn't miss the point, I just felt that the thread was regarding logical log usage …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: Hung Server
Art S. Kagel wrote: > Chris S wrote: > >> We've recently been having a very strange issue with one of our >> Informix Servers. It's IDS 7.31UD1 running on AIX 4.3.3. The server >> appears to go into a vegetative state and is no longer controllable >> through normal means. > > <…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Connections hang
You might have tried all the below, if not 1. What is the status of the engine "onstat - ". Is it online or is it in Blocked CKPT state. Might be it is waiting on a check point. 2. What is the status of each session "onstat -u ", third column flags. The first character/flag would…
Join threads
Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Re: Which thread consumes the most CPU time?
Wait statistics tells you the time in microseconds that threads spent in several different run states: running, ready to run, waiting for buffers, etc. To get the time for state running, you can use the sql that roeferr@ig.com.br just sent (I modified it a little): database sys…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Which thread consumes the most CPU time?
What does wait statistics tell me? Is wait statistics covered in the manuals? Regards Christian Eriksson Michael Mueller <m.mueller01.delete_me@kay-mueller.de> wrote in message news:<42160A07.4090302@kay-mueller.de>... > Onstat -g act is probably the simplest. > > But you also …
RE: Which thread consumes the most CPU time?
Onstat -g act is probably the simplest. But you also can use wait statistics. Set "WSTATS 1" in onconfig and use "onstat -g wst" or select from sysmaster:sysseswts. Michael Bill Dare wrote: > You have to monitor onstat -g act and see which sessions are active most > often. A …
RE: More CPUVPs than processors
NOAGE is set and the priority of the process does not change over time. I will get and post an onstat -g spi. I have them stashed away. There were a couple of long spins out there [usually about 6]. Your KIO theory might hold some merit since io rates definitely improve with the …
Re: More CPUVPs than processors
"Mark" <mark@vuntec.com> wrote in message news:<1107909506.05b010d31b61d05ef5b592c7476757b2@teranews>... > Thanks all for your responses. I might see what happens if I renice the > oninit processes to make them run more often/longer. I can't help but > think that one of the reaso…
many threads for process ?
We are running a batch process, and when monitoring it, I see a huge amount of threads associated with it, and most of them are waiting. One of the tables in the query is fragmented, but it only has 10 fragments, so I wouldn't expect to see more than 10 scan threads. Any ideas ? …
DRINTERVAL
It would be interested to know which threads are running that are consuming so much cpu (onstat -g act) and what are they doing (onstat -g stk <tid>). You could try some profiling of the oninit as well to gather more info. On the other hand maybe this cpu usage is not a bad sig…
AW: Too many open files to the master oninit process
pls. see your previous thread :-)…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: IDS 7.31.UD1 hangs
"Esteban Casuscelli" <estebanc00@yahoo.com.ar> ???????/???????? ? ???????? ?????????: news:8a8f14b9.0409070551.3c59d1f0@posting.google.com... > Denis, > > we need more info to diagnose the problem. Esteban, thank you for your answer, I've almost lost my hope. > You said the eng…
RE: Solaris 9 and KAIO
Hi Andrew. Are you using raw device ? IIRC, kaio is an available if chunk is raw device (not ufs). Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Andrew Hamm" <ahamm@mail.com> >Reply-To: "Andrew Hamm" <ahamm@mail.com> >To: informix-list@iiug.org >Subject…
Solaris 9 and KAIO
I cannot find kio or kaio in the release notes for 9.40 on Solaris, but my understanding is that KAIO is always on in Solaris unless you work to stop it? If so, why do I only see 2 kaio listed when I have 3 cpu vp's? I thought it was automatically 1 kaio thread per CPUVP: VP Sc…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: how release threads?
This is a multi-part message in MIME format. --------------020301030302090906080606 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Well, at least I have discovered what status await_MC%d in onstat -g con (or onstat -g wai) of thread means…
Re: how release threads?
make sure when you update statistics for procedure you set pdq to 0...the stored procedures that help facilitatemay be mutltithreading if you do not and the thread count will increase until evetually you get an exception error which might crash the engine.…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
Onbar uses sqlexec threads or???
Hi all, Onbar questions regarding the buffer cache..... (I'm using IDS 7.31.FD6X3 on Sun Solaris 64 bit, with Veritas Netbackup for Onbar) My onconfig : BUFFERS 800000 BAR_MAX_BACKUP 12 BAR_RETRY 2 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 Would this be ? : 800,000 buffers * …
4GL extremely slowed down after migration
Dear Mr Krstic, It is not possible to determine the problem with the information you send. What processes are using the CPU ? I guess it's the oninit(s) . What is the oninit doing? You may start with 'onstat -g act' to monitor the system for a while. What are the Informix thre…
Re: Multiple user threads
On Thu, 15 Jul 2004 11:58:49 -0400, Bjorn De Waele wrote: PDQ threads assigned to a session usually are not released. The session keeps them assigned in case they are needed again. I suppose this cuts overhead in heavily PDQ dependent sessions. It should be harmless. However…
Multiple user threads
Hello everybody, we're using version 9.40.T7 Our max_pdqpriority is 100. Right now, I see much this behaviour with onstat -u. Informix creates plenty of user threads. If I set with the max_pdqpriority with onmode -D to 0. Then I get a single user session which shows me sometim…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Which session is using the most cpu resouce?
Henry, Sorry this response is so delayed; been a little busy. I'll also apologize for not being able to answer it completely, but I've got some direction for you. The way that I look at this is to use "top" or "glance" or "ps" to determine which oninit process is at the top of …
listener-thread: err = -408
Dear Sir, I found error in online.log when i type in shell command the following onstat �m Thu May 27 08:06:29 2004 08:06:29 listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. Then I use the finderr to get more informa…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list sending to informix-list…
I added memory - now what should I change in onconfig to take advantage of it?
sumGirl wrote: replies have gone to your other posting - better let this thread die...…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
listener-thread: err = -25572
Sometimes on Win2000, when I stop the IDS, it will not restart with a reboot. The message in the log says: 13:48:06 IBM Informix Dynamic Server Version 9.40.TC2 13:48:06 listener-thread: err = -25572: oserr = 48: errstr = : Network driver cannot bind a name to the port. Syste…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
RE: Intermittent Performance Problem - What does oninit do?
Raw space or cooked files? It makes a difference with sar statistics. Sar will show idle time when instead of %wio if the i/o is on raw devices. On cooked files it will show %wio. Assuming you are using raw space and you really do have a CPU bottleneck, what you need to do is…
Re: multi thread - Informix
That's a very old version of the CSDK, not a particularly buggy one that I remember though. The thing to be careful of in using ESQL/C with multi-threaded apps is that only one thread can use a particular connection to the server at a time. In order for multiple threads to shar…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
multi thread - Informix
Dear All, We have a multi thread C++ program. The threads fetch data (with prepared cursor) from an Informix DB parallel, but we got coredump (not always) The operating system is: ReliantUNIX-Y 5.45 B2005 RM600 4/768 R4000. We uses the following packages: PKGINST: SIthread…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Fw: Informix thread management
I suppose I deserve this for switching machines and not correctly updating my mail account. cheers j. ----- Original Message ----- From: "Jack Parker" <jack.parker4@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <informix-list@iiug.org> Sent: Tuesday, January 06, 20…
Re: Informix thread management
Thanks Jack, I've read your article now and it's certainly quite informative. I'm still not clear on exactly what DS memory stores and what it allows you to do, and how come parallelisation is still able to happen on the system I am currently working on where IDS 7.3 has default…
Threads waiting on buffers (TWOB)
Well, Once again, our company is faced with the "threads waiting on buffers" (TWOB) issue. At a certain point, a ton of threads suddenly start waiting on a specific buffer (they show 'B' in the first flag of onstat -u). Onstat -X shows that they're almost all waiting on the same…
Re: Informix thread management
Thanks you Norton for shutting that down. cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "Jack Parker" <vze2qjg5@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <in…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Re: Informix thread management
OK, but on the other hand I *have* seen very small queries get blocked when for some inexplicable reason IDS calculated a DS_MAX_QUERIES of 6, which is a mystery in itself. (They haven't set the DS values in the onconfig, but according to the calculation in the manual it should b…
Re: Informix thread management
Thanks for a most informative post Art - as ever. On the site I'm on at the moment users often connect with PDQPRIORITY=HIGH and I'm sure I've seen several run at the same time and not get blocked. They just don't seem to get to do much in the way of parallel processing - though…
RE: What do session statuses mean?
Wait master consumer. eg. a scan thread waiting for a consumer thread like a sort thread, join thread etc. Regards, Bill > -----Original Message----- > From: andykent.bristol@virgin.net [SMTP:andykent.bristol@virgin.net] > Sent: Monday, December 15, 2003 4:43 AM > To: informix-…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Re: Informix thread management
--0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: multipart/alternative; Boundary="1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E" --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: text/plain; charset=US-ASCII Content-tran…
Informix thread management
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi All, I have fragmented my database & now want to use the parallel database feature of Inform…
listener-thread err -930
Hi Folks: I've just got a listener-thread err -930 on a new instance I put up last Friday. This box is in my test bed and is not critical but I would like to know why when I load data from my production server on this test server then shutdown Informix it generates this -930 er…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
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…
Performance of system is slow
I would try and start bottom up from the os: 1) is it a cpu bottleneck (use os tools like sar and vmstat)? 2) is it a disk bottleneck (os tools like in 1)? 3) if it is not 1) something must be blocking in the server. Use onstat -g ath and -g act to see what the sqlexec …
IDS 7.3 and mySQL
IDS 7.31 supports stored procedures (a sort of UDR, but not called such). Stored procedures support the SYSTEM statement (which will be slow). You might be able to leverage this to do the job. OTOH, it may not be feasible -- it will depend on a multitude of factors, such as requi…
JDBC thread hogs processor while query executes.
I'm developing a mutli-threaded Java application on Linux and am finding that when I execute an sql statement the thread that executes the statement just waits for JDBC to return with the results, and does not give up the processor to let other threads have a go while it is waiti…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
A Sleeping Thread - Or is it?
I am running an update statement on a single-cpu configured HP box w/ IDS 9.30FC2. The thread says that it is sleeping (Forever), yet the the update statement is working it's way thru the table. It wakes up once in a while, says it's running, then goes back to sleep. There is cur…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
cpu time
I don't think this has changed in 7.3. Ifxmaillist@quanta.co.nz do you have any indication for that?. It's perfectly normal and I think it's even desirable. If less oninit processes can handle the workload, the os and memory cache overhead may be less. Don't forget that vps are…
RE: "Slow System" Problem
Are you sure you are bottlenecked on CPU? Check sar when this happens to make sure. If that's the case, you can track the most active sessions by looking at which ones show up on the active queue(onstat -g act) most often. That can be a problem if you have a lot of users and s…
No thread isolation-- Unusual or Common?
Just had an experience in which a user attempted to run a very long SQL query. ("Long" in the sense that just to view the text of the query required about a dozen screens when looking at it with onstat) The SQL involved over 170 tables and UNION ALLs. However, the selectivity …
new scan threads
I was tuning my informix with the onconfig and env variables, when I saw the output of onstat -g ses <sesid> with something like this: tid name rstcb flags curstk status 78 sqlexec b154a5b4 ---P--- 67400 b154a5b4 sleeping(secs: 3) 112 scan_1.0 b1553554 ------- 68296 b1553554 run…
Re: AW: NETTYPE
Dan, I've researched and tested this one to death long ago and it still holds. To explain. We originally went with the recommendations in the admin guide and had only one CPU listener for shared memory connections and a couple for TCP connections. Since most connections here are…
Re: What's happening inside the oninit process ?
> Dirk Moolman wrote: > > Hallo everyone, I'm not sure how to word this question. > > Regarding the oninit processes running on our machine, is it possible > to see inside the process to see which users are causing the oninit to > do so much work ? > > One thing we do is to run …
what is busy waits?
hello, in the onstat -g sch output illustrating VP scheduler statistics. What are busy waits? can anyone explain in detail? bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
exchange thread?
hello, can anyone explain me what is an exchange thread ? and the concept behind it. bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
Nettype
Tony Woods schrieb: > > Hello all, > > NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype > NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype > > Does the above setting mean that 3 poll threads will handle 384 connections > or each of th…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
Re: KAIO ands "onstat -g iov" output
In article <932h3l$os4$1@nnrp1.deja.com>, William Rice <ricew@operamail.com> writes >I can't imagine a couple of extra AIOVP's having anything like a >significant impact on performance. > >Will >1 AIO VP's a) Use more memory - seperate process b) Use more thread schedu…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
SIMPLE SQL STATEMENT
HELP I HAVE a table with duplicated records .this was a result of a aplication progmamme which inserted duplicates in stead of updating? i want to remove the duplicate and use some of the duplicate info to update .. eg recno name regnomber course 1 simba 345 ct12 …
Re: You've heard it all before, cont.
Andrew Ford wrote: > > I'm posting some other onstat commands that may help. > > Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 3 days 09:44:13 -- 2545024 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 261671478 74154240…
RE: You've heard it all before: newer, faster server runs slower than older, slower server after data migration
Sorry about that, UPDATE STATS was run (I even used Art's program to do it). Another thing I would like to add. VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 28505 cpu 17491 17534 1000 2 28506 adm …
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Help! Ontape running very slow.
yes, it was the "very old pages" bug. the level-0 backup took about 25-26 hours, but it finally finished. god help me if it comes up again. thanks for the reply. ty -- Ty O'Kelly DBA tokelly@maxor.invalid.com 806-324-5521 Bill Border wrote: > We notices something staring …
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Re: Dropping a dbspace
Calvin Shoults wrote: > > We are using IDS 7.31. There are a couple of dbspaces that we don't use and > do not reference. We would like to drop them, but an message tells us that > the spaces are not empty and will not let us drop them. > Any Solutions would be appreciated. Us…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: NETTYPE question
tienp@wholefoods.com writes: > I have a question regarding the NETTYPE parameter. Which one of the > following is more efficient? IDS 7.x? Probably the first > And does each configure communication > parameters for 256 users? No, the config is for 256 connections (read more…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
threads and informix ...
Hi all, I have an application which creates multiple threads and tries to connect to a database . The command to compile the application is -> > esql -e -g -thread <filename> When I use the -thread option the message displayed is -- esql: When using -thread, the THRE…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Max number of connection?
Hi, my name is Darko. My system: OS SCO OpenServer 5.0.4 IDS 7.30 UC2 When a number of threads come to "magic number of 112" the system rejects the next thread. Somtimes it hangs IDS. In online.log I found err 27001. I tried to rise a number of pool threads and listner threads…
RE: Informix 7.24UC8 performance
I didnt think buffer priority management was implemented until 7.3. Not positive on that though. I would do an onstat -u on the shared memory dump and find out who was doing lots of reads or writes. If someone was analyze what they were doing. onstat -P | tail will tell you dat…
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…
WARNING: A log backup is already running. Can't start another.
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> "Wolf D. Pichler" wrote: <blockquote TYPE=CITE>1.) you cant see ontape, when you use onbar. Try "ps -ef|grep onbar". <br>2.) "WARNING: A log backup is already running. Can't start another." is <br>normal even i…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: NETTYPE
Just a quick thought that the 8200 has only 2 physical cpu's so by the book that allows 1 cpu vp A far better approach would be to use the set up Art suggests with a 3rd cpu in the 8200 We have noticed over a number of years that the third cpu and therefore 2nd cpu vp makes the s…
NETTYPE
mars1972@my-deja.com wrote: > > In article <61CEA8293505D211A0E90000F87AAD7D2E02EE@srrcex1.srrpa.es>, > =?iso-8859-1?Q?Pablo_Herrero_Fern=E1ndez?= <PabloF.Herrero@srrpa.es> > wrote: > > Hello everybody. > > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the > n…
Few (shorter :-)) questions
Hi, I'm interested is there something wrong with configuration (based on onstat results). First, it is Ultra Sparc computer, with 4 processors (1 processor has affinity set). onstat -g glo gives this output: >>Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 15 days 2…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, Piotr Wróblewski <ptrwrb@kki.net.pl> writes >I am running IDS 7.30.UC2 server on HP-UX10.20. >My statistics for G50 says, that millions of disk writes go through 'aio', but TRUE. >when we compare 'onstat -g iov' with 'onstat -g…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Long spins or onstst -g spi. Need any information.
First let me state that you do NOT have a spin problem. The reports you post show an engine that is healthy in this respect at least. I will try to explain as many of the various locks and latches as I know about below: Eugene Nechayev wrote: > > Hi Informixers > > Can somebod…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix use of CPU's question
OK, here is what I see. You have a shared memory NET VP and no TLI NET VPs so I assume that your onconfig (PLEASE post ONCONFIG files for ALL performance related questions) has the following two lines: NETTYPE ipcshm,1,150,NET NETTYPE tlitcp,1,150,CPU or something VERY simil…
Compiling with thread libs
Platform : Solaris 2.6 INFORMIX IDS/UD Version 9.14 UC6-1 INFORMIX LIBASF LIBRARY Version 7.24.UC8 INFORMIX-Connect Version 2.20.UC1 INFORMIX EMBEDDED SQL for C Version 7.24.UC8 INFORMIX LIBGEN LIBRARY Version 7.24.UC8 INFORMIX-Universal Server Version 9.14.UC6 INFORMIX LIBOS LI…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Does the Informix (not Intersolv) ODBC driver support threads and thread safety?
Hi all, I'm looking at whether the 2.8 and 3.3 Informix ODBC drivers (the ones I heard Informix built themselves) support threads, and if so, are they thread safe. Ciao Fuzzy :-)…
Informix vs Oracle, Sybase +...
Thomas Parsli wrote: > > "Art S. Kagel" <kagel@bloomberg.net> writes: > > > Thomas Parsli wrote: > > > > > > "Art S. Kagel" <kagel@bloomberg.net> writes: > > > > > > ... > > > [SNIP] > > > ... > > > > > > > You are correct about Sybase, however, the Linux port is an unsupported a…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
oninit trace to user
Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA js…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Multi-thread capability and non-threaded applications ...
I'm working on a UNIX/Solaris system, and we're just about to move to a version of Informix (7.33 [?]) that supports each individual thread having its own connection to the database, which is something we really want our applications to have. Unfortunately, we link into librarie…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
The ready queue Full but Unix not busy
Generally looking at onstat -g ath will give a better idea when this type of problem happens. Often it's more an issue of a single thread acting up. Are you using any UDRs ? It might be that you are using one that is 'ill behaved' and is blocking on somthing besides IO. Yo…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
RE: Processor affinity
Yes, its possible to determine which physical CPU's the VP's run on. We are running Sun Solaris as our O/S and it looks like you might be also. Using the pbind command, I can list which physical CPU's process are bound to. Then, using onstat -g sch, get the pid's of the oninit pr…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Processor affinity
Hi, Is it possible to determine which physical CPU's the VP's run on. I have 6cpu vp's running on an 8 processor machine,with CPU vp affinity. The message log reads " Can't affinity VP 1 to phy proc 0 errno 4,Can't affinity VP 3 to phy proc 0 errno 62...." errno 2 is "interrupt…
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.…
Re: Processor Affinity
David Meyer wrote: > > Mike, > > I tried to do this on an AIX system and it did not > support it. I found out that some versions of Solaris On AIX you have to do it by hand (or by script) after IDS has been started. Look into the bindprocessor command. The following script work…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Threads - Urgent
Hi all, We have an application using Informix esql/c. From my program, I query a table in another database using scroll cursor. After processing the data, I close and free the cursor, but the user thread is still maintained for the program, till I exit from the program. I woul…
Re: Performance on HP unix
Ahmad Ramzi Salleh <ramzi@telekom.com.my> wrote: > > Hi, > I'm running New Era 2.20 for end-user and using Informix 7.13 on HP-UX > 10.01. > Can anyone tell me how to identify which session take up CPU resources > because > sometimes when ever I issue top command on unix, %CPU g…
Re: onstat -g sch , Busy Waits ?
Jay Aymond wrote: > rdavis@rmi.net wrote: > >In article <78kcue$kng$1@nnrp1.dejanews.com>, > > darren_m_rogers@my-dejanews.com wrote: > >> Hi, > >> Could anyone explain what may cause a large number of 'busy waits' ? > >> Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00)…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
RE: onstat -g sch , Busy Waits ?
According to "Informix, DBA Survival Guide" by Joe Lumbley, on page 260, Monitoring Virtual Processors, "When a CPU VP does not have a thread to run, the process performs a 'busywait' . This is a loop of instructions designed to wait a short time". So comparing CPU VP Number 3, …
onstat -g sch , Busy Waits ?
In article <78kcue$kng$1@nnrp1.dejanews.com>, darren_m_rogers@my-dejanews.com wrote: > Hi, > > Could anyone explain what may cause a large number of 'busy waits' ? > > Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00) > > VP Scheduler Statistics: > vp pid class …
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
thread safe version of informix 4gl
Does anyone know if there exists a thread safe version of informix 4gl. Thanks. William…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: oninit & user threads
onstat -g sch will tell which vp is in which oninit process. This doesn't change. onstat -g act will give you the running threads. Steve Berg On Mon, 21 Dec 1998, Sean Kelsey wrote: > Yuletide greetings to one and all ! > > Chit-chat over, lets get on with my question... > > …
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Software Metrics Best Practices
Do you know the most effective measurements and metrics for software organizations such as yours? How do the metrics your organization uses compare to your peers? We are conducting our second annual study on metrics usage by software organizations. Your participation will take…
Poll threads
A quick question. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ibm1 infmx_service3 And the onconfig file has the following DBSERVERALIASES and NETTYPE entries: …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
Re: system hangs
Are you running Solaris 2.6? If so, you might be running into an OS bug, which we ran into on our ES6000. When the engine is hanging, you should still be able to do onstats. If it happens again, check to see if the ADM VP is still alive. Do an onstat -g glo to find the Proces…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Re: Script to find 'active' IDS 7.2x threads
Thomas J. Girsch wrote in message <363f83a4.0@news.one.net>... >What's wrong with onstat -g act? > >Or the sysmaster database, for that matter? > >The Wilcoxons wrote in message <71nr8s$lo6$1@nw003t.infi.net>... >>Here is a script we have used to track 'active' threads in IDS 7.2…
Re: Script to find 'active' IDS 7.2x threads
What's wrong with onstat -g act? Or the sysmaster database, for that matter? The Wilcoxons wrote in message <71nr8s$lo6$1@nw003t.infi.net>... >Here is a script we have used to track 'active' threads in IDS 7.2x . We >have it linked to onstat-u and onstat-ur so we can have it re…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Re: Follow-up: CPU poll threads ...
On Wed, 28 Oct 1998, Art S. Kagel wrote: > Schaeflein, Paul wrote: > > > > Would you please describe the difference between NET VPs and CPU VPs? And > > why is one better than the other? > [Original reply SNIPPED] > > OK. Basically a NET VP (shown as class tli, soc, ipx, shm, s…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: Follow-up: CPU poll threads ...
Schaeflein, Paul wrote: > > Would you please describe the difference between NET VPs and CPU VPs? And > why is one better than the other? [Original reply SNIPPED] OK. Basically a NET VP (shown as class tli, soc, ipx, shm, str in the onstat -g glo report) is a Virtual Processor …
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Multithreaded process - connect problem
Check the ESQL/C manuals, I believe you can only have one active connection thread to a particular server. You could have multiple connection threads to different servers, but only one can be active at any given time. Arun David Ferguson wrote: > G'day > I am writing a multi-…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Strange Output --
You will also get this message if you are using the wrong version of onstat against the shared memory structure. For example, if the engine is started with 7.11.uc1 and the onstat executable is part of a 7.11.uc2 install. Arun Shastry wrote: > Session information, along with a …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: Strange Output --
Session information, along with a lot of other stuff, is maintained in shared memory. Informix has a data structure that they use to store this info. and that is constantly changing due to the dynamics of the server. Onstat gives you a snapshot of the server state, and cannot ac…
Strange Output --
I'm getting the strange output as follows ------------------------------------------------------------------------------------------- fsce03:informix 146 $ onstat -g ses 3605 INFORMIX-OnLine Version 7.23.UC4 -- On-Line -- Up 2 days 20:51:34 -- 822760 Kbytes session …
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Q: Linking a MULTITHREADED ESQL/C application
Hi Informix Gurus! we want to use ESQL/C in a multi-threaded application developed for Sun Solaris-2.6. esql requires some special thread library other then lipthread or libpthread: esql: When using -thread, the THREADLIB environment variable must be set to a support…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: onstat -g sch
In article <6m99tq$9s5$1@news.xmission.com>, Luse Harold <hluse@vth.colostate.edu> writes > >Would anyone know what the semops, busy waits and spins/wait columns are >in onstat -g sch? > semops = semaphore operations busy wait = when Online needs to obtain a latch and cannot it…
onstat -g sch
Would anyone know what the semops, busy waits and spins/wait columns are in onstat -g sch? VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 86938 cpu 0 0 0 2 81346 adm 0 0 …
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Threaded Process
Given a process with two threads, each with their own "active" connection to the same database make different select queries concurrently, will the queries be executed and acted upon concurrently by the server? Or will the first thread to submit the query cause the other thread t…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Boycott Microsoft
Can we get the Indian government to nuke this thread? -------- Stan Hixon the baby DBA hixons@cgprinting.com…
Re: Boycott Microsoft
die useless thread - die.…
Re: Monitor tools
In article <6ja8nl$irc$1@news.xmission.com>, Peter Tashkoff <TashkoP@kiwi.co.nz> writes > >You could go to the trouble of getting onperf going on your system, if you = >like GUI tools, personally I find them inefficient. >If you have a suspicion that you have a specific process …
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
Re: Monitor tools
You could go to the trouble of getting onperf going on your system, if you = like GUI tools, personally I find them inefficient. If you have a suspicion that you have a specific process that is hogging = resource the steps I take are to identify the active threads, then from = t…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: poll threads
Bill, We have recently gone through (and still experience some connection problems) the same problem. In our environment, we had the following settings: DATABASESERVER sparky_shm DATABASERVERALIAS sparky_tcp NETTYPE tlitcp,4,500,CPU # This number is hi…
poll threads
What's the best way to monitor poll threads to determine if you need additional ones? We have been having a problem with sessions taking a while to actually make a database connection. When additional poll threads were added, this problem seemed to go away. My question is what…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Thread process and Informix license
Is anybody know if i need a license per process or per thread ? I have a multi-thread process that performs parallel connections to a database. Do I need a license for each of the thread or only for the process ? Thanks for responding. -- Regards. _____________________________…
Pardon me. Question on news reader
I've always been seeing IGNORE THREAD/WATCH THREAD options in most news reader. I wonder what do they actually do and how best to make use of them. Sorry for posting the mesg here. LeeKB…
Multiple threads
Hi! I am using IUS 9.12 and web datablade on Solaris 2.51. I installed Netscape Enterprise Server 3.0 to use NSAPI to improve performance. I know it provides multithreading and removes connection overhead. When, however, more than two NSAPI requests are arrived at web server at …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: multithreaded servers
Peter Weigert wrote: > > hi folks! > > does anybody know wether informix thinks about supporting a > multithreaded applicationserver with one session per thread > (the global sqlca interferes the multithread support). Esql 7.21+ supports multi-threaded applications. A task can …
Re: Changing data structure forced command termination.
Jacob Salomon wrote: > > Huh? > > Hi Family. > > One of my users just upgraded their engine to ODS-7.24.UC3 from > 7.13.UC5. Of course, no upgrade is without some grief. Here is a > manifestation of the grief we get now: > > I ran onstat -u and got some lines of output - all th…
Changing data structure forced command termination.
Huh? Hi Family. One of my users just upgraded their engine to ODS-7.24.UC3 from 7.13.UC5. Of course, no upgrade is without some grief. Here is a manifestation of the grief we get now: I ran onstat -u and got some lines of output - all the daemons and the first bunch of users…
Question : ESQL, Threads, DCE ???
Hi, When I was compiling for multithreads, I got following error : esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. This is on Solaris5.5 Does this mean that informix is supporting only DCE …
multithreading question (DCE) ???
I get an esql error " esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. Does this mean that POSIX are not supported. Thanks, Sachin ___________________________________________________________…
ESQL/C System-Descriptor-Area
Hi Informix-Gurus! Does anyone know, whether System-Descriptor-Areas, created by ALLOCATE DESCRIPTOR ... DESCRIBE ... are thread-safe like Cursors and prepared statements, or not? It seems, that they are not thread-safe. Thanks in advance Markus Bschorer mb@alphatron.de…
Re: Poll Threads
Harold, >NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype You are telling online to use one CPU poll thread for shared memory connections. Either take this line out or change it to 3. Jason…
Poll Threads
I have a question about poll threads that some of the gurus may be able to answer. We are starting to use our first multi-processor machine (specifics below) and I don't see any evidence of it running multiple threads for a single user. The TFM is a little vague on the use of p…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Multi_Thread Programming
Hello everyone!! I have OnLine7.11.UC1 running on HP-UX 10.X and ESQL/C 7.11.UC1. I would develop a Database application using multi-thread programming technique. but there is a problem I can't solve. I know Informix OnLine7.11 support multi-thread environment. When threads esta…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Multi Thread App
Alexander Jaremenko wrote: > > Hi All, > I'm about to write multi thread application with ESQLC. I would like to > know how ODS would treat multiple threads doing sql requests - as > separate DB - user sessions ? > Happy New Year! ODS/ESQL-C versions 7.21 and later support thr…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
Re: chekcpoints, BUFFER settings, and optimization
In article <348FFD23.5D0B@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >David Kosenko wrote: >> >> "Art S. Kagel" <kagel@bloomberg.com> wrote: >> +Dave I have to disagree. I agree that additional cleaners are of >> +limited use during normal LRU writes but they a…
Re: chekcpoints, BUFFER settings, and optimization
David Kosenko wrote: > > "Art S. Kagel" <kagel@bloomberg.com> wrote: > +Dave I have to disagree. I agree that additional cleaners are of > +limited use during normal LRU writes but they are needed for fastest > +checkpointing. Since at checkpoint time each chunk is assigned to…
Re: chekcpoints, BUFFER settings, and optimization
"Art S. Kagel" <kagel@bloomberg.com> wrote: +Dave I have to disagree. I agree that additional cleaners are of +limited use during normal LRU writes but they are needed for fastest +checkpointing. Since at checkpoint time each chunk is assigned to +another cleaner thread until …
Re: chekcpoints, BUFFER settings, and optimization
In article <348F1333.4F79@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >David Williams wrote: >> >> In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca >> <inf@dpx20.growela.pt> writes > >> >} In article <881611278.1353908229@dejanews.com>, >> >} jneuge…
Re: chekcpoints, BUFFER settings, and optimization
David Williams wrote: > > In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca > <inf@dpx20.growela.pt> writes > >} In article <881611278.1353908229@dejanews.com>, > >} jneugebauer@ameritrade.com writes > >[...] > >David Williams writes > >[...] > >} ># Shared Memor…
Re: Major performance problems with Informix Online
Tim asked the original questions, David responds. David Williams wrote: > Questions about the responses ( Koens and Davids ): > >> > >>1. The logging information was a bit confusing. > > > > ??? > Sorry I've been away for a while - what logging info? > You guys each had…
Re: Major performance problems with Informix Online
In article <344efd22.9330992@news.tel.hr>, Ivica Smolic <ismolic@open.hr> writes >On Mon, 20 Oct 1997 07:21:54 -0400, Tim Schaefer ><tschaefe@mindspring.com> wrote: > >>I <was> curious to some of the tuning information, were these recommendations >>purely for a Siemens machine or…
Re: Onstat Utility
>Hi, > I'm using onstat -g ath and see threads that are slleping forever. >What could this be? Are users not exiting properly from Informix? How >do I kill these processes. > > The "sleep forever" threads are threads that will be remain dormat until they are activated by some o…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
My 0.02c worth on this. If one process has a page from the database in shared memory and they update it or otherwise cause it to lock then if another process wants to access that page it has to wait for the page to be free. As the page is in a buffer already and does not need to…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
Thanks for responding... SaTriGuy <satriguy@aol.com> wrote in article <19971004200101.QAA06456@ladder02.news.aol.com>... > >Online on HP-K460 is NOT-SCALABLE? > >From: "James Francis" <jfrancis@dxi.com> > >Date: Sat, Oct 4, 1997 13:48 > > First of all, your buffers are really way…
Re: Information about tables in use?!
Mr Cheuk Kong Lo wrote: > > I'd like to know if there is a way to find out what tables are in use > by a user (thread). Any possible of knowing what row is current in use > by a user (thread) as well? > Onstat -g opn shows open tables by thread id. Onstat -k will show locked ro…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Two Instances on Multiple CPU Machine
Think of it this way, if any single instance has enough simultaneous requests that it must queue them up until the CPU VP can get around to them, then Informix will do better with an additional CPU VP on any decent SMP box. Although the Informix affinity settings might take some…
Re: Informix and NOAGE
Jim Jordan wrote: > > In article <33CC2D68.307@bellsouth.net>, > MIS Dept <whsmis1@bellsouth.net> wrote: > >Saeed Talebbeik wrote: > > >> Both NOAGE and processor affinity can boost the performance. > >> However look into the machine notes of your platform to see if > the…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Informix and Oracle in the same shop
David Williams wrote: > > In article <5n1dv1$2ar@mew.corp.sgi.com>, Pablo Sanchez > <news_reader@mew.corp.sgi.com> writes > > > >In article <33935782.7D9610FC@devnull.org>, Tim Schaefer <devnull@devnull.org> > >writes: > >> Pablo Sanchez wrote: > >> > > >> > No vendor, that I kno…
Re: Informix and Oracle in the same shop
In article <5n1dv1$2ar@mew.corp.sgi.com>, Pablo Sanchez <news_reader@mew.corp.sgi.com> writes > >In article <33935782.7D9610FC@devnull.org>, Tim Schaefer <devnull@devnull.org> >writes: >> Pablo Sanchez wrote: >> > >> > No vendor, that I know of, is truly multi-threaded... at leas…
Re: onstat -g sch
}>From ilist@rmy.emory.edu Mon Jun 2 13:30:44 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id NAA15009; Mon, 2 Jun 1997 13:29:47 -0600 }>Received: (from ilist@localhost) by rmy.r…
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: AIO vp's
Edward Bidinotto wrote: > > IN running 7.11 uc1 you can dynamically add AIO vp's but cannot > dynamically remove them. > > Can someone tell me the reason behind that and do future releases > allow this functionality? > > Tks > Ed Hi, maybe it's because most of the users add so…
Re: HELP: MEANING OF onstat -g sch output
In article <5ds4qr$hg4@cssun.mathcs.emory.edu>, Rick Ward <wardr@gusco.com> writes >Edward Bidinotto wrote: >> >> Can anyone explain what the output on onstat -g sch means especially the >> column >> "busy waits"? Does a high number in that column mean that the vp is >> staying b…
Re: HELP: MEANING OF onstat -g sch output
Edward Bidinotto wrote: > > Can anyone explain what the output on onstat -g sch means especially the > column > "busy waits"? Does a high number in that column mean that the vp is > staying busy > or that it is staying idle? > > We need to find out from the following output if we…
HELP: MEANING OF onstat -g sch output
Can anyone explain what the output on onstat -g sch means especially the column "busy waits"? Does a high number in that column mean that the vp is staying busy or that it is staying idle? We need to find out from the following output if we need to add cpuvps or delete also if w…
Re: Need clarification of 7.2 threaded clients
Philip Walden wrote: > > The Informix-esql/c 7.2 manual describes threaded esql/c programs. It > says that a process can have multiple "active" connections. One active > connection per thread. However it also says that only one connection can > be "current" at any time. > > What …
Re: Performance / Internal Q's -- Online 7.2
Hello, jimlenahan@aol.com wrote: > > Greetings: > > A few questions on performance and internals on this beast: > I never have had a possibility to run such a big system, sorry. But: > I have a 4way HP Kclass machine as server connected to a pair of HP > G class mac…
Re: Oracle vs Informix comparison
The point is that firing a trigger is a more expensive operation that a thread that sniffs the logs and 2pc is ... well 2pc. -- Mark…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: client failures with informix 7.2
This problem is noticed by me in the AIX platform too. However I do not find this 'dummy thread syndrome' while using dbaccess.…
Re: Good Informix bug found
In article <3223B8C4.7588@cyberramp.net>, Greg <greg@cyberramp.net> writes >June Tong wrote: >> snip..... >> >> What gets locked up and what do you kill -9? I'd be really surprised if it's >> really locked up; more likely it's just taking a long time to return a result. > >On 7.…
Re: Informix libraries MTSafe ?
Yes; version 7.2 provides thread-safe ESQL/C. I think you have to use DCE threads at the moment, and you certainly have to compile and link with a -thread option. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Shimon Gonen <sgonen@titan.com> }Date:…
Informix libraries MTSafe ?
Are informix libraries MTSafe? Our application is threaded on Solaris. Can you access a database concurrently from 2 or more threads in the same process? Just want to read different tables in the different threads. Thanks. -- Shimon Gonen…
Re: Oninits Running Amok...
In article <4rtnsa$e2@server2.codetel.net.do>, Tom Hay <nomad@codetel.net.do> writes >Yes, I've seen it too, on Version 7.10D1 on a uniprocessor HP-UX, and >I don't like it either. The machine virtually stops for around 30 >seconds. Can't offer any explanation, though ... sorry !…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: LRU writes
brian, we should keep this either as private e-mail or just to the list, as i get two messages for everything that gets send out! not a big deal, but kind of a pain. the advantage of the list is that other people can see it and throw in ideas. it can be difficult to diagnos…
Re: onstat -g questions
On 22 Apr 1996, Rajiv Jauhari wrote: > Has anyone used the "onstat -g sch" and "onstat -g spi" > commands to help tune the performance of Informix 7.1 on an SMP? > If so, can you explain the exact meanings of the various columns? I recently made an adjustment based on the info …
onstat -g questions
Has anyone used the "onstat -g sch" and "onstat -g spi" commands to help tune the performance of Informix 7.1 on an SMP? If so, can you explain the exact meanings of the various columns? (I've appended excerpts from the output of these commands below.) I've read the manual, and …
Controlling those Nasty CPU VP's
Platform=HP-UX 9.01 Informix 7.11 UC1 How can you control a session thread in a CPU VP from monopolizing the system CPU? We had a single thread take about 90% of the CPU while performing an update.…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
CLIENT/SERVER CONFERENCE
*****Customer Intimacy and Information Technology**** The Yankee Group's Client/Server Conference has been scheduled for October 25 - 27, 1995 at the Fairmont Hotel in San Francisco. Customer Intimacy is easy to envision. It's about enhancing the customer's experience with you…
Re: 7.x, determining a unix process from a session/thread
In article <40aspa$f1l@oscar.cc.gatech.edu>, Carlos Ugarte <cau@cc.gatech.edu> wrote: >With onstat and onmonitor you can determine some information >about each thread, but I haven't figured out yet how to determine >what user process is tied to that thread. Can anyone give a Bu…
User Threads
Does anybody know much about the number of concurrent user threads variable in the /usr/informix/etc/onconfig.std file? We're running an application, and receiving the message "You have exceeded the maximum number of user threads" Can I just up the number of threads in the config…
ERROR -354 in VB -> Q+E ODBC -> INFORMIX 6.0 SQL
Hi Folks, This is a very interesting problem that i am facing. My client is Windows 3.11 /16MB and running an application written in VB accessing Informix 6.0 using Q+E Informix ODBC drivers on TCP/IP. The four statments that are called …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: C-ISAM to Informix conversion ???
See my reply to the thread on CISAM to ISQL, it will help if you can work out a possible schema. -- Martin How…
Multithreaded software with ESQL/C 7.10.UC3
Informix Gurus, We are trying to write multi threaded software using Online 7.1 and ESQL/C 7.10.UC3, on an IBM RS6000 AIX 4.1.1. The program seems to hang arbitrarily once threads are created. Is Online 7.1 and ESQL/C 7.1 thread safe? Are there any other libraries we need to …
Re: Want to sort CHAR field NUMERICALLY in ACE report (SOLVED)
Thanks to those who replied.. I followed up with the solution in the previous thread.…