Oninit® Archive
Results for “FASTPOLL”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
listener-thread: err = -25580 IDS 9.40 UC 4
Hallo, since a few days we get the fallowing error in our online Log: 09:10:18 listener-thread: err = -25580: oserr = -1: errstr = : System error occ urred in network function. The error occure every 10 seconds. We are running IDS 9.40 on an Red Had Cluster. We can`t remember…
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…
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 ------------------------------…
Connection Manager + TLS: A Major Annoyance
Periodically, we'll have clients attempt to connect to our connection manager, but be rejected (or disconnect themselves abruptly). Those rejections will come with error messages like these: ``` 18:34:26 listener accept new fd failed:network error = -28014 cannot accept/error:140…
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…
listener-thread@soc_be.c:3073: err = -25582:
Hi Folks, Recently we are getting this error at a random intervals . During this error the connection is lost from the client and it goes for a time out. Tried with onstat -g ntt,nta , netstat -an but no luck. Can anyone suggest how to find the root cause and fix the issue. …
informixhq agent start problem
Here the informixhq-agent is trying to create a web socket to the informixhq-server. This is configured via the server.host and server.port parameters. This should be straightforward and will work if the informixhq-server is listening on this port, which it will be if it is runni…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
IO performance issues
Michael: FWIW, your other post (with onstat -g mgm) doesn't tell us anything useful except that the server's been online for 11 days and 18 hours or 282 hours. Assuming you have not zero'd your stats since startup, I can calculate a rough Buffer Turnover Rate (BTR) across the tw…
IDS and keepalive
AIX 7.1; IDS 11.50.FC8 Seeing ever-growing number of timeouts from a client (at their end) ... the message in engine msg log: 09/06/16 09:40:06 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. I still suspect it's network-rela…
dbaccess dbname hangs for seconds
It's not clear to me: "netstat -a" shows small hangs? On Fri, Aug 12, 2016 at 1:54 AM, CHALLENGER212 ABDERRAFI < abderrafi212@gmail.com> wrote: > ok, but Why today, I have the same problem 3 months ago and it was because > of > a long request which generate realocating memory s…
REST API
Original post: <stuff removed> ... Questions 1) Why the wireless listener accepting connection from the local host(127.0.0.1) instead of ifmx-server(127.0.0.2) ? 2) Why I can not query by a single record(in test 3), anything wrong with the syntax or setting or the wireless confi…
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)…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
Fetch time on 12.10FC4
Hi Javier! Did you rebuild the statistics of all databases from your instance after the upgrade? This situation (differences between fetch time and exec time) used to happen when table's statistics are not accurate. Regards, Alberto Pessonio 2015-05-15 18:35 GMT-03:00 JAVIER P…
listener-thread: err = -25580: oserr = 32.......
Frank You need to talk to your network supplier to find out why the connection is interrmittant/very slow and causing the connection loss Keith On 25 March 2015 at 14:49, FRANK <yunyaoqu@gmail.com> wrote: > Guys, > > IDS12.10 FC4 > RHEL > > Recently, suddenly see these error ex…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
JDBC-System or internal error java.io.IOException
Hi Fernando Nunes , Thanks for you Quick and prompt reply. Question - You should have an Informix error... please check it, and if needed change the exception handling to extract it... Ans - I have checked in the Informix online Message Log File not able to find any errors.Plea…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Re: IDS 11.7 Tuning help
Thanks John - I do already have the cache set up.. NETTYPE soctcp,40,100,NET LISTEN_TIMEOUT 60 MAX_INCOMPLETE_CONNECTIONS 1024 FASTPOLL 1 NUMFDSERVERS 4 NS_CACHE host=900,service=900,user=900,group=900 I will try increasing the number of listeners for the port... Laurie On …
Re: IDS 11.7 Tuning help
Laurie: I would suggest a few of the following. First utilize the new cache capability this will reduce the number of network calls to the operating system. Second, make sure FASTPOLLing is enabled. Ensure you have more than one FD server to spread the load around. NS_CACHE…
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,…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
1024 incomplete connections at this time.
Original Post: Well that message is coming from the listener thread doing a comparison that is has (in you case) 1024 incoming connections it hasn't gotten to at that particular moment. So basically at the tci/ip layer there's 1024 or more, incoming connection requests queued up…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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 …
Performance Issues
Hello John & All, Thanks for your findings and suggestions: We have increase the memory allocated to informix by 20% VP_MEMORY_CACHE_KB 100000 FASTPOLL 1 The cpuvps are now spining equally, I have not yet changed the NETTYPE as you have suggested but planning to do the same…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Re: NETTYPE in IDS 10
Yes. Art On Jun 13, 2011 6:17 AM, "Dirk Cornel...." <moolma_dc@mtn.co.za> wrote: > NETTYPE ipcshm,2,300,CPU # Configure poll thread(s) for nettype > NETTYPE soctcp,5,300,NET # Configure poll thread(s) for nettype > > Question: Is the tcp NETTYPE in IDS 10 dynamic, ie. Will the d…
NETTYPE in IDS 10
NETTYPE ipcshm,2,300,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,5,300,NET # Configure poll thread(s) for nettype Question: Is the tcp NETTYPE in IDS 10 dynamic, ie. Will the database grab more sessions if it needs more, even though your NETTYPE is set to a fixed v…
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.…
RE: NETTYPE "CPU" vs "NET"
Pollthreads on NET VPs can "idle" themselves. In CPU VPs they cannot. In theory it may happen that the "net code" steals precious CPU time from the CPUVPs. This may be specially noticeable if you use FASTPOLL set to 1. This may not apply to all situations... in your case you hav…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
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…
How to Monitor Open Connection Tiime???
NETTYPE soctcp, 8, 200, NET NETTYPE ipcshm 1, 20 , CPU FASTPOLL 1 I have 500 connections, but in my environment, the application open the connection, do the authorization (like a credit card for health insurance), and close the connection. I have the SMTP service active. Can t…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Re: Connecntion Manager x DBSERVERALIASES
Just a correction, The CM isn't to smart like I said. They appear be capable to identify listeners of localhost and not try do redirect client connection to them . But about not redirect to services / network what the client ins't capable to use, isn't true. I execute a new test …
Re: Connecntion Manager x DBSERVERALIASES
Just a correction, The CM isn't to smart like I said. They appear be capable to identify listeners of localhost and not try do redirect client connection to them . But about not redirect to services / network what the client ins't capable to use, isn't true. I execute a new test …
Connecntion Manager x DBSERVERALIASES
Hi, csdk 3.50 xC7 ifx 11.50 xF7 - Linux. I got a issue here to configure the Connection Manager over a HDR cluster and theirs DBSERVERALIASES. On the configuration of the two instances, exists some aliases what not should be considered to client connectivity. I already notice…
Connecntion Manager x DBSERVERALIASES
Hi, csdk 3.50 xC7 ifx 11.50 xF7 - Linux. I got a issue here to configure the Connection Manager over a HDR cluster and theirs DBSERVERALIASES. On the configuration of the two instances, exists some aliases what not should be considered to client connectivity. I already notice…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
error 25580
Hi All, A user is complaining that error 25580 happen always.Any Idea? The DB is 9.4 and it's running on AIx 5. Ive check the sqlhosts, onconfig.file the configuration correspond to the proper db. Any suggestion please? 23:23:23 Maximum server connections 141 23:25:28 listener…
listener-thread Network error
JESUS GARCIA wrote: > In this moment I have: > > onstat -u: > 101 active, 256 total, 149 maximum concurrent > > and into the onconfig i have: > > NETTYPE soctcp,4,50,CPU > > It can have 200 users and always the users are betwen 100-150 no more > NETTYPE soctcp,4,50,CPU is no no …
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…
listener-thread: err = -27001:
Tracing client IP address with xtrace http://www-01.ibm.com/support/docview.wss?uid=swg21162482 --- Em qua, 19/5/10, JACQUES RENAUT <jrenaut@us.ibm.com> escreveu: De: JACQUES RENAUT <jrenaut@us.ibm.com> Assunto: Re: listener-thread: err = -27001: [20188] Para: ids@iiug.org Data…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
Slow responses from remote application server
Six poll theads isn't quite enough for 2000 connections and certainly not i= f you expect a peak of 1.5 times that. Try this: NETTYPE tlitcp,10,300,NET IBM's rule of thumb is that a single poll thread can handle ~350 connection= s but <300 is best performance. FASTPOLL 1 defin…
IDS 10.00 maximum concurrent sessions
First, you CAN limit the number of concurrent shared memory connections. Since the communications blocks that shared memory connections use and the semaphores that protect them are allocated when IDS starts up, the number of available connections via shared memory is fixed at sta…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
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…
NETTYPES and FASTPOLL = 1
IDS 11.5.FC5 AIX 5.3 One (oldest) server: 10 CPU 1.6Ghz Power 5 Single Thread/CPU System One (newest) server: 16 CPU 3.8ghz Power 6 Multi-Core/CPU System (so, 32 CPU thread allocation). NETTYPE ipcshm,1,350,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,9,350,NET # …
CPU consumption and table size
Can we get top queries with respect to CPU consumption/usage? And there is how much impact of poll threads of type NET with CPU high usage, if any?…
Number of dbaccess/OS process per os session
You haven't mentioned if you have enabled FASTPOLL or not, but if you aren't you probably should. Check your $INFORMIXDIR/release/en_us/0333 directory for more information. When you enable it in the $ONCONFIG file, when you bring the server up, I believe you will see a message ab…
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…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
Correlation between NETTYPE and VPCLASS
Hamran The 6 in NETTYPE define the number of poll threads you want to bring up. Generally, one poll thread need to run on one VP. Hence the num=6 in VPCLASS. Please refer the details to below text or informix information center. Regards. -Ping =================================…
FASTPOLL with AIX
Hello all, We just (finally) upgraded to version 10.UC8 of IDS (can't go to 11.50 until I upgrade AIX to 5.3). During the conferance last week it was noted to turn on FASTPOLL for AIX, but it appears as this is a version 11 config parameter from what I can find digging around th…
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 …
IFX SE processes
Note: I haven't worked with SE in a long time! I have a client's server that I'm trying to dbexport from 7.24 SE. I can't seem to get exclusive access. I see a couple root-owned processes writing to log files from boot time. Any chance these are ISTAR-like network listeners? One…
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…
TCP problem upgrade 9.40 to 11.50
Hi Servio, In the sqlhosts, you have ontlitcp, while in the ONCONFIG you have NETTYPE soctcp. In Solaris, we use TLI for TCP communication, rather than sockets (SOC). Can you try just changing the NETTYPE in the ONCONFIG file, to change from 'soctcp' to 'tlitcp', make sure you…
IDS-9.4 FC6
Hi Error -25587 is a generic error that appears whenever a connection fails and so has many possible causes. You can check the output of onstat -g ntd for rejected packets. It is sometimes accompanied by other errors so look for any other errors in the online log that might give…
listener-thread: err = -27001
If the incoming connection request is being rejected by the listener thread there won't be a session id - the session does not exist yet. Unless you are getting hammered by incoming connection requests or your network is being overhwhelmed by other apps I doubt a second listener …
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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.…
Re: CPU VP Issue
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.1140.1211265848.20610.informix-list@iiug.org... > > tgirsch said: >> pokeyman76@yahoo.com wrote: >> > VPCLASS cpu,num=4,noage,aff=0-3 >> > This will turn on noage and affinity f…
Adding Logical Log (HDR Enviroment)
Hy, Guys. What do I have to consider to add logical logs to primary server in HDR enviroment ? I got a customer that uses HDR solution and we are haveing some troubles with HDR performance. In some place in online.log I got this message WARNING! Logical log layout may cause Dy…
Re: Lot of "listener-thread: err = -25580: oserr = 0:..."
Cesar Inacio Martins wrote: You day "the solution doesn't work here" but did netstat -s report dropped connection attempts? What does ndd -get /dev/tcp tcp_conn_request_max show is the current setting for tcp_conn_request_max? If it's now 256 did you try to increase that to …
Lot of "listener-thread: err = -25580: oserr = 0:..."
<table cellspacing='0' cellpadding='0' border='0' ><tr><td style='font: inherit;'><div id="yiv2107734370"><style type="text/css"><!--#yiv2107734370 DIV {margin:0px;}--></style><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">Hi, <br><br>IDS 7.31FD2 <br>HP-U…
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 …
IDS 11.10.FC2 crash
If VP_MEMORY_CACHE_KB doesn't help monitor memory usage with onstat -g seg (Segments) onstat -g mem (Memory Pools) If you see huge Pools you can investigate further with onstat -g afr <pool> OR onstat -g ufr <pool> Have you changed/added the onconfig parameter FASTPOLL 1 (TCP/IP…
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…
Update from Digital 7.31.FD1to ....
Back to one of the origional issues, performace goes South when there are 150 users on the box. Believe this issue has been discussed before, how many NETTYPE threads can be configured of each configured CPU. You have configured 3 CPU's but list: NETTYPE soctcp,8,50,NET # Config…
IDS 10 err = -25580
Hi,everyone The IDS10 always appear "17:35:07 listener-thread: err = -25580: oserr = -1: errstr = : System error occurred in network function. System error = -1. " Someone said it happen because of the configure NETTYPE of $ONCONFIG file. But I really don't know the relation. B…
Re: NETTYPE NET/CPU
On 25 Aug, 06:35, mohitanch...@gmail.com wrote: > On Aug 9, 6:50 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > > > On Aug 8, 8:57 pm, mohitanch...@gmail.com wrote: > > > > Version: IDS 10 > > > I'll leave you mostly with Jonathan's entries and just add a bit as > > we…
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…
Re: Cpu vp usage
On Aug 17, 1:02 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Aug 17, 4:31 am, "malcolm.iiug" <mali...@btopenworld.com> 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 o…
database informix hang!
I'm using IDS 9.4 on a HP-UX 11 on an rx4640 machine My instance is hang and I get error log on informix log: 16:35:16 listener-thread: err = -25580: oserr = 1: errstr = : System error occurred in network function. System error = 1. 16:35:38 listener-thread: err = -25580: oserr …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
ONSTAT -U Question
Hi guys, I got a old question, at least "old" for me. The last line of onstat-u output show something like that 13 active, 128 total, 25 maximum concurrent I got NETTYPE setting to NETTYPE ipcshm,1,5,CPU # Configure poll thread(s) for nettypeNETTYPE soctcp,1,5,NET # Configure …
listener-thread: err = -27001: oserr = 0: errstr =
Hi, while this can be a real problem in the network layer, it can also be a kind of "denial of service attack". The message says that the listener thread got a connection request and tried to read the initial data that is expected in this connection request. During this read at…
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…
IDS on Solaris(spark server)Multiprocessor Setup
Hello All, I want to set up IDS 10.0(FC4)instance on Sun Spark server, which has one 24 core processor. So i am not sure how should i give the multiprocessor settings in the onconfig files parameters related to that instance. Please find below the parameters about which i need t…
TCP Listeners: Preferences?
Hello, all. We're in the process of setting up several new IDS 10 servers which will run TCP/IP listeners (onsoctcp on AIX) _only_. In the past, we've set up shared memory (onipcshm) poll threads to run on CPU VPs, with the TCP/IP poll threads running on NET VPs. Since the new…
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…
FASTPOLL
I am going to turning on the FASTPOLL configuration parameter on our IDS 10.00.UC5 database. How do I monitor its performance? I can't seem to find and onstat command that helps. Thanks Peter…
Re: listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken.
On Feb 20, 7:03 pm, "Davorin Kremenjas" <davorin.kremen...@alfatec.hr> wrote: > Some script or similar agent is "pinging" your instance every 5 minutes. > It has no username and/or password so it cannot finish the handshake. > Monitor the Informix port and analyze network traffic…
listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken.
Every 5 minutes I am seeing the error below in the online log file. However, there have been no complaints from users. IBM Informix Dynamic Server Version 9.40.FC8 13:09:07 listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken. 13:14:07 listener-th…
Re: 10.0 xC6
On 6 Feb, 23:36, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Fernando Nunes" <s...@domus.online.pt> wrote in message > > news:45c905d3$0$1723$a729d347@news.telepac.pt... > > > Neil Truby wrote: > >> "dbagirltx" <dbagir...@yahoo.com> wrote in message > >>news:1170789326.225772…
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…
Re: NETTYPE's poll thread number
Version of IDS from 9, number of max connection is number of poll threads multipy by user per thread e.g NETTYPE soctcp, 2,100, NET : Max connection is 2x100 = 200 So first you have to monitor number of user connections before fill the number in by command : onstat -u , onst…
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…
Re: Slow Connection - HP 11 9.30
Sebastian, Norma J. wrote: > Brian, > > Did something get garbled in your post? > Your ONCONFIG shows: > NETTYPE # Configure poll thread(s) for nettype > > If you don't have NETTYPE set, maybe that's the problem. > I don't know what the default is for NETT…
Re: Slow Connection - HP 11 9.30
Sebastian, Norma J. wrote: > Brian, > > Did something get garbled in your post? > Your ONCONFIG shows: > NETTYPE # Configure poll thread(s) for nettype > > If you don't have NETTYPE set, maybe that's the problem. > I don't know what the default is for NETT…
Constant online log errors on all servers
This is a repeat of a problem I posted a couple of months back. Searching for inspiration really. IBM Informix Tech Support says it's a network error (PMR 04123,019,866 refers). RedHat tech support say it's a database error. The network administrators have no idea. I tend to …
Unable to connect informix via JDBC driver2.21
Hi all, I have installed IDS 9.4 on RHEL3. Now i'm trying to connect to Informix via JDBC Driver 2.21 but, it is raising an exception com.informix.asf.ifxASFException. On investigating in online.log, i found that there are two errors on that are causing this error. 12:42:19 On…
Re: Question about CPU utilization
Jï¿œrg Rï¿œschenschmidt schrieb: > Hi, > > I have question about CPU utilization. My system is a HP UX 11.11 with > IDS 10.00.FC5. I heard once IDS is well configured if you have > usercpu/syscpu relation of >= 4 in onstat -p. > > Today I checked my instance and I found a relatio…
Re: Question about CPU utilization
Jï¿œrg Rï¿œschenschmidt wrote: > Hi, > > I have question about CPU utilization. My system is a HP UX 11.11 with > IDS 10.00.FC5. I heard once IDS is well configured if you have > usercpu/syscpu relation of >= 4 in onstat -p. > > Today I checked my instance and I found a relation …
Re: Question about CPU utilization
As with every rule, there are exceptions. The 4 to 1 ratio applies to many types of systems under various loads. However, the socket connections on HP are expense (they eat a lot of CPU). Move it to the CPU VP and use the new FASTPOLL capability and you will reduce context sw…
Question about CPU utilization
Hi, I have question about CPU utilization. My system is a HP UX 11.11 with IDS 10.00.FC5. I heard once IDS is well configured if you have usercpu/syscpu relation of >= 4 in onstat -p. Today I checked my instance and I found a relation of 2 only. My conclusion : There is somethi…
listener-thread: err = -25573
IDS 10.00.FC4 Solaris 10 New server, New Database Database has been up for 6 days. Received this error last night: 08:36:56 listener-thread: err = -25573: oserr = 13: errstr = : Network driver cannot accept a connection on the port. System error = 13. 08:36:57 listener: poll ret…
Re: Odd network error message
I once experienced a kind of network attack with similar consequences. Check the network logs. "Neil Truby" <neil.truby@ardenta.com> wrote in message news:4nuov3Fc7kt4U1@individual.net... > On every Informix server on the subnet - dev, test, production, doesn't > matter - we've …
Re: Odd network error message
Neil Truby wrote: > Sorry. It's 10.0FC5 on RHEL AS 4 Update 3. > > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:4nuov3Fc7kt4U1@individual.net... >> On every Informix server on the subnet - dev, test, production, doesn't >> matter - we've been getting this messag…
question about compression with IConnect
Vivien Kobayashi wrote: > Is anyone aware of any way of compressing the data using IConnect or > any middleware? > <snip> > > Our version of ideal solution is that the IConnect layer can be > optimized, potentially with built-in compression. However, it seems > compression is ava…
Odd network error message
Sorry. It's 10.0FC5 on RHEL AS 4 Update 3. "Neil Truby" <neil.truby@ardenta.com> wrote in message news:4nuov3Fc7kt4U1@individual.net... > On every Informix server on the subnet - dev, test, production, doesn't > matter - we've been getting this message for a day or two. Any id…
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…
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…
cpu-vps and number of physical cpus
Hi Art, Just need to thwo in one caveat in the whole NETTYPE discussion. At least in version 9, and 10, and I can check other versions as well, if #of polls threads is > than number of CPU VP's, we put all the Poll thrads on the NET type. eg. VPCLASS CPU,num=3,aff=1-3,noage …
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…
IDS 10.0 performance on RedHat
Neil Truby wrote: > Having now got IDS 10.0FC5 to work on RHEL I thought I'd share a few > findings. > > > Not a thorough benchmark by any means, but I offer it up in case anyone is > interested. > Thanks Neil. We are skipping UC5 and looking at UC6 next. Do you find UC5 fa…
RE: HDR in IDS 10.0xc5: slow Secondary restart
Hi, Madison, I've submitted the problem to the ESR system. Actually, I ran into another problem with HDR on 10.FC5: When FASTPOLL is set to '1' (enabled) on Secondary, one of NETVP oninit's is consuming all available cpu resources of a single cpu on Seconsdary. I know, that it…
RE: HDR in IDS 10.0xc5: slow Secondary restart
Hi, Madison, I've submitted the problem to the ESR system. Actually, I ran into another problem with HDR on 10.FC5: When FASTPOLL is set to '1' (enabled) on Secondary, one of NETVP oninit's is consuming all available cpu resources of a single cpu on Seconsdary. I know, that it…
IDS 10.00.UC5
Which platforms is FASTPOLL applicable for? Where is the VP Memory Cache? Where are the machine notes on the website? - they stop at xC4! The Windows release notes say archecker needs Client SDK 2.90.TC5 but there are no release notes for the TC5 release on the website! Other…
HDR in IDS 10.0xc5: slow Secondary restart
Hi, everybody, Long-awaited IDS 10.0xC5 (with a great FASTPOLL feature) is finally released... and appeared to be almost unusable for large installations, using HDR Really, really bad 'feature' was added to HDR mechanism. Every time, HDR Secondary is restarted (that is, stoppe…
HDR in IDS 10.0xc5: slow Secondary restart
Hi, everybody, Long-awaited IDS 10.0xC5 (with a great FASTPOLL feature) is finally released... and appeared to be almost unusable for large installations, using HDR Really, really bad 'feature' was added to HDR mechanism. Every time, HDR Secondary is restarted (that is, stoppe…
SOS - Please help error code - 25573 and oserr 72
AIX 5.2 IDS 7.31.UD8 Websphere - Max # of users 800 during peak Max # of active sessions during peak : 2800 Nofiles (descriptors) set to unlimited Getting listener-thread err = -25573 oserr =72 errstr= :Network driver cannot accept a connection on the port I am seeing this mo…
SOS - Please help error code - 25573 and oserr 72
AIX 5.2 IDS 7.31.UD8 Websphere - Max # of users 800 during peak Max # of active sessions during peak : 2800 Nofiles (descriptors) set to unlimited Getting listener-thread err = -25573 oserr =72 errstr= :Network driver cannot accept a connection on the port I am seeing this most…
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…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: HDR over secondary network
Hmmm ... if two networks are used, srvB and srvB-sync would resolve to different ip addresses, similar would be true for srvA and srvA-sync, wouldn't it? So is srvA (DBSERVER...) listening on srvA or on srvA-sync now? In other words: the two sqlhosts files' informations don't s…
MULTIPROCESSOR settings on a multiple CPU server with
Is it a must to set MULTIPROCESSOR to 1 on a multiple CPU server even if you only using 1 CPUVP and SINGLE_CPU_VP is set to 1? Some posts on c.d.i say yes, some say no and the IDS docs do not give a concrete answer. Also, it has been said that when configuring ipcshm poll threa…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Configuring remote tcp connections.
Hi, I've got this line on my $ONCONFIG file: NETTYPE ipcshm,1,120,CPU # Configure Poll thread for nettype I need this line. How can I define other NETTYPE values? Can you show me an example of two distinct configurations? Regards, Nuno Paquete…
Thread network information (onstat -g ntu) header
Header from output onstat -g ntu : Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp Explain 'read' and 'writes' fields ? There are in Kb, network buffers or other ?…
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: Error message in online.log
I suspect that these messages are related to the network. I see them periodically on different systems, and generally when ODBC or JDBC connections are in use. I suspect that they onl occur when the network is busy. Regards Malcolm -----Original Message----- From: owner-info…
Error message in online.log
You should check your operating system logs, these errors occurs for example when your application server is dying, your network card/cable is faulty (or a switch/router). Regards, try_and_err Colin Dawson schrieb: > We received the following error messages overnight, can anyon…
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:…
Users cannot access database
Hi, Any body know what was the problem? System and network was fine. The problem only last for 10 minutes. Thanks to anybody help me. Owen Primus Canada Toronto,ON. 416-2077143 4:35:58 listener-thread: err = -25573: oserr = 24: errstr = : Network driver cannot accept a connect…
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…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Performance Issues
Roger Cariah wrote: Here's what I see: NETTYPE ipcshm,1,30,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,5,25,CPU # Configure poll thread(s) for nettype You should never use CPU VPs for TCP listeners (ignore the manual). Also shared memory listeners…
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'?…
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: 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…
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.…
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…
=?gb2312?B?tPC4tDogb251bmxvYWQgLyBvbmxvYWQgZmlsZXNpemUgaXNzdWVz?=
"K.Hong Lee" schrieb: > what is your NETTYPE configuration ? > informix/etc/onconfig: SERVERNUM = 0 DBSERVERNAME = ifxdms DBSERVERALIASES = NETTYPE = onsoctcp By the way: I have 7.30.UC7-2 from intraware. (not UC3 -sorry, my mistake) From www.informix.com I have the informati…
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,…
On Nettype Configuration
Hi forum, Looking for high level thought on these two configurations for Nettype. Using soctcp,,500,NET (without # of poll threads) for nettype value in onconfig. If left blank does it take a default value. vs. soctcp,4,500,NET (with # of poll threads) for nettype value in onco…
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…
Conexiones tcp's se pierden y se congelan.
NETTYPE ipcshm,4,100,NET # Configure poll thread(s) for nettype NETTYPE soctcp,4,100,CPU # Configure poll thread(s) for nettype creo que las conexiones de TC/IP son tipo NET y no CPU, connectivity information page 3-30 Administration Guide…
Network / TCP problem (?) - sorry for Mime, can't send as text
Dirk Moolman wrote: > This is a multi-part message in MIME format. > > We've been battling with network problems over here, and will install = > BMC next week to help us find the problem. Maybe you can help me with = > this one. > > Solaris 8 > > IDS7.31FD3 > > I am getting the…
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…
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.…
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…
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.…
hello, could some one help me
i am geeting the following error log.: Wed Oct 22 11:44:39 2003 11:44:39 Booting Language <c> from module <> 11:44:39 Loading Module <CNULL> 11:44:39 Booting Language <builtin> from module <> 11:44:39 Loading Module <BUILTINNULL> 11:44:44 Warning: Number of poll threads fo…
Instance startup time
Try onstat -g ntt, and use the open time of the poll or listener threads? On my system it's a few seconds before On-Line Mode appears in the message log. -- Phil@oninit.com…
Problems with Shared Memory
I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok changing them to tcp... but they are running a 4gl app and I want them throw INFORMIXSERVER shm. I check the sqlhosts and NETTYPE and I t…
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…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: Bloody ERP schema
Hi everybody, Well, yesterday we have tested the recommended NETTYPE parameter on a hpux machine as it could be set on this one of course. That is to say: #NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for nettype NETTYPE ipcshm,5,80,CPU # Configure poll thread(s) for n…
cpu time
This may have to do with affinity, but may also have to do with poll threads. Check the NETTYPE config parameter to see how many poll threads you have of the type that is used to connect most often, and to see if they run on CPU VP's. This is the way we have it, and we always see…
-27001 error
Hi everybody, this warning appears, to many times, in the server message log: 18:54:24 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. Can I know if is it a network problem or server problem? Because in the Informix Answer Onl…
NETTYPE
What was odd to me was that it is set to 1,100 and 2 CPUVPS. Which would allow for 200 concurrent connections. For the past two years we have been around ~1000 maximum concurrent connections. How can the server report that I have had a maximum of ~1000 concurrent connections when…
Informix listener-thread: err = -25580 and -25573
Hi All, We are running IDS version 9.21 FC3x1 running on HP-UX 11.0 (64-bit). The following errors have started appearing in our message log today: 07:39:28 listener-thread: err = -25573: oserr = 233: errstr = : Network driver cannot accept a connection on the port. System err…
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: AW: NETTYPE
Don't confuse the poll thread with the listener thread. The listener thread accepts a connection and spawns the sqlexec thread. The poll thread looks for network/sharedmemory-IO completion. When the poll thread is TCP and running on the CPUVP, it issues a short select in a loop…
NETTYPE
Hello, yes it's posssible to put several NETTYPEs in one file. I also have two entries in one file: NETTYPE tlitcp,4,96,CPU # Configure poll thread(s) for nettype NETTYPE ipcshm,2,64,CPU # Configure poll thread(s) for nettype ciao, Thomas -----Ursprüngliche Nachricht----- Von:…
Re: Server hangs with "mutex wait nsf.lock"
Art S. Kagel wrote: > Also I notice that your shared memory NETTYPE only specifies > one listener poll thread, shared memory listeners should always > be run in ALL CPU VPs for best responsiveness and to keep > CPU VP#1 (which handles the first poll thread) from > running flat o…
oracle?
<laughing> So I just went to the oracle.com site looking for some info that is supposedly there re: the reference implementation of sqlj. When I hit the "Search" link I got: Database Log In Failed TNS is unable to connect to destination. Invalid TNS address supplied or…
RE: Nettype
How do you judge whether you need 100 per thread or 200 ?? We have an average of 1300 sessions. "Watson, Paul" <Paul.Watson@aggregate.com> wrote in message news:95dtqj$q9c$1@news.xmission.com... > > > Although the manuals don't differ they are not particularly > > explicit in 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…
Nettype
I have been experiencing some network errors in my online.log. Is there anything that I can tune? There is about 1300 users connecting and this is my network configuration. NETTYPE soctcp,20,100,CPU # Configure poll thread(s) for nettype 11:24:54 listener-thread: err =…
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…
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…
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…
Re: Console message
Look up errno 24 in /usr/include/sys/errno.h on most UNIXes it is: Too man open files. Reconfigure the kernel to allow more open files. Art S. Kagel Consorzio Idrico Piceno wrote: > > Using INFORMIX-OnLine Version 7.23.UC1 on Unixware 2.1.3 with a COMPAQ > Proliant Server (Dua…
Exceeding Number of Connections
What are the practical effects of exceeding the number of connections that a poll thread is set to handle via onconfig file's NETTYPE parameter? During functional testing, we inadvertently created over 750 connections (as reported by onstat -u) with NETTYPE set to tlitcp,1,128,…
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 …
RE: no tli vp class
Run onstat -g ath, and look for the tli poll (tlitcppoll) thread. If you did not specify anything in the NETTYPE parameter the tli poll thread will be running in the CPU vp. If you want the tli poll thread to run on a TLI vp, specify it in the NETTYPE parameter. Example: NETTYP…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: IDS2000 on Red Hat 6.2
>I have my server running on Linux and can connect locally but I can't >connect across a network. I get an error -908 "Attempt to connect to >database server (servername) failed" when using I-Connect. My client >machines can still connect to my NT server which has informix7 serv…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
RE: Adding additional Listener ports
"Watson, Paul" wrote: > Disagree, if you have a largish number of users that need to log in a > a relatively short period ie 1000 in five minutes then have multiple > listeners on a single card does help. If you watch the q-exceed in > onstat -g nt? then it tends to have an ent…
Re: Adding additional Listener ports
gary child wrote: > > It has been suggested to me that adding additional Listener ports to /etc/services > and corresponding aliases to sqlhosts may provide a performance gain by spreading > user connectivity between the multiple listener ports. We run 7.31.UC5 on > HPUX11 and al…
Re: NETTYPE parameter
mars1972@my-deja.com wrote: > > Per poll thread. Right now what you have is 4 poll threads, each > handling 300 connections, or 1200 connections total. You want it set to > 75? I'd just make it: > > NETTYPE soctcp,1,75,NET No, I think the point was he wanted 300 connections,…
Re: NETTYPE parameter
Todd Roy wrote: > > Is the number of concurrent connections in the NETTYPE option > per poll thread or total? > > I have: > NETTYPE soctcp,4,300,NET > and informix tells me that I have 1200 connections, and should set it to 75. You have defined 300 users per poll thread, …
Re: NETTYPE parameter
From: Todd Roy <troy@holstein.com> > >Is the number of concurrent connections in the NETTYPE option >per poll thread or total? Per thread. >I have: >NETTYPE soctcp,4,300,NET >and informix tells me that I have 1200 connections, and should set it to >75. >I am forcing each…
NETTYPE parameter
Is the number of concurrent connections in the NETTYPE option per poll thread or total? I have: NETTYPE soctcp,4,300,NET and informix tells me that I have 1200 connections, and should set it to 75. I am forcing each poll thread to handle up to 300 connections. Thanks, …
NETTYPE parameter
Is the number of concurrent connections in the NETTYPE option per poll thread or total? I have: NETTYPE soctcp,4,300,NET and informix tells me that I have 1200 connections, and should set it to 75. Thanks, Todd. ********************************************************…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
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…
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…
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…
Network driver cannot accept a connection on the port --- System
>Subject: Network driver cannot accept a connection on the port --- System >From: "Arshad, Shehla" SArshad@purolator.com >Date: 10.03.00 23:35 W. Europe Standard Time >Message-id: <8abtv2$7bt$1@news.xmission.com> > > >We got the following error in the message log file of an Infor…
Posting from the Informix-list
Hi list, I have following paramters in onconfig. NETTYPE ipcshm,1,60,NET # Configure poll thread(s) for nettype NETTYPE tlitcp,2,250,CPU # Configure poll thread(s) for nettype I wanted to know how can I find active no of connections through each type at a given …
CPUvps
Madison Pruet wrote: > > I think that Mark Stock has already raised the question of 'more CPUVPs than > physical CPUs'. I'm going to attempt to address CPUVP scheduling. > > We don't attempt to equalize the load of the CPUvps because unlike disk IO there > is nothing to be gaine…
RE: Connectivity: authentication over ssh instead of rsh?
Thomas B Tatum schrieb: > > Along these same lines, is there a way to run dbaccess on the Unix command > line from a client machine so it will use a network connection to connect to > the DB? > > If Im on the same machine as the instance, its simply > > dbaccess dbname sqlfile.sq…
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…
DB Connection Times
Question: 1 - What Informix onstat commands or Unix statistics can I analyze to understand the cause for long delays when connecting to our database. I've looked at "onstat -g nt?" commands but they don't seem very useful. 2 - What Informix/Unix parms can I "tune" to reduce co…
[Help!]Informix Server 7.31 no response?!
paul wrote: > Dear sir > Our Informix 7.31 TC2 server has some troubles recently, it work properly > about 4 or 5 hours and then it reject any request! but the users who already > in the server will still work properly, why? It never happen until recently! May be this bug? …
listener-thread: error
Alexey Semenov <swaj@swaj.nospam.ru> wrote: > Hi! > I got messages in /opt/online.log approx. twice an hour: > ... > listener-thread: err = -27001: oserr = 0: errstr = : Read error > occurred during connection attempt. > ... There is probably something on your network that po…
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…
Bringing up a new instance of Informix
I need some help. Platform HP UX 10.20 Informix version 9.20 UC1 Informix version 9.14 UC7 Informix version 7.31 UC4 I am configuring a new instance of informix 9.20 UC1. I am having problems if I add DBSERVERALIASES. I have the 9.14 and 7.31 configured and working properly. …
[HELP]Informix Dynamic Server got errors!!
Paul, Did the error occur before the engine went to online mode? It could simply mean that some of your network clients tried to connect to engine before it went online. paul wrote: > Dear all. > Our server (Informix IDS 7.31 TC2)got an error that no any connection can > co…
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…
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(2): Write cache hits slipping !
J.Cooper@MS03.dss.gsi.gov.uk wrote: > Tony Flaherty wrote: > > > > Ok, here goes my first EVER attempt at advising on someone elses onconfig, > > I'd go with any advice Art gives you ;o)) > > Good advice more comments below. I agree. Keep it up Tony. [SNIP] > > >NETTYPE …
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…
Network Problem IDS7.30.UC3+Linux (SuSE6.1)
When I try to start the Dynamic-Server, setup with the following: IDS 7.30.UC3 Linux SuSE 6.1-i386 (Kernel 2.2.9, libc6). sqlhosts: ifxdms onsoctcp lxsrv ids_tcp /etc/services: ids_tcp 1526/tcp I get the following error-messages in the online-logfile: liste…
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 IDS on Linux -> Error -25573
Hi there, I have a Informix IDS 7.30 UC7.2 on SuSE Linux 6.1 (Kernel 2.2.5). Our /etc/services file contains: turbo 1536/tcp Our /etc/hosts file contains: 192.168.1.99 EASYLNX Our sqlhost file is: ids_test onsoctcp EASYLNX turbo The environmentvariabl…
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…
SHARED MEMORY NOT INITIALIZED
> SERVERNUM 9 # Unique id corresponding to a Dynamic Server instance Try to decrease this to 0 or 1, if you are not using multiple residency. > NETTYPE soctcp,1,100,NET # Configure poll thread(s) for nettype > NETTYPE ipcshm,1,100,CPU # Confi…
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.…
Re: Listener Thread Error
pkedar@hotmail.com wrote: > > Hi Art, > > Thanx for your answer. > > I guess tcp listener thread is getting too busy to handle more requests as > finderr of error 27001 shows: > > When you encounter this error on the CLIENT side, it indicates that a > network I/O error occurred w…
Re: Listener Thread Error
Hi Art, Thanx for your answer. I guess tcp listener thread is getting too busy to handle more requests as finderr of error 27001 shows: When you encounter this error on the CLIENT side, it indicates that a network I/O error occurred when the client tried to connect to a databa…
listener-thread: err = -25580: oserr = 35
I suspect we got the error after installing RAS on Windows NT 4.0 : 16:01:50 listener-thread: err = -25580: oserr = 35: errstr = : System error occurred in network function. System error = 35. Before this the connection is relatively fast. After installing RAS, it takes a lon…
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.…
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…
TLITCP and JDBC
Hello, I just installed the Informix's JDBC driver, but have been unable to connect to the DB. I've tried the JDBC URL with port 1533. Is that the standard port? Anyway, here's the sqlhosts file: sac_online onipcshm libra sac sac_tcp ontlitcp lib…
Re: What is NETTYPE
kbg wrote: > > I don't understand how the NETTYPE parameter affects the performance of > the db and how I must configure it, > is it necessary to define it in the onconfig file? > what is the diffrence between the NET and CPU NETTYPE, > It's not well described in the Informix lit…
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.…
poll-threads on NT
Hi all, currently I am involved with a customer that runs 7.30TC3 on Windows NT. Please read on... When I specify multiple poll-threads by means of the NETTYPE parameter (in the NET class of course on NT, since I have no other choice), I see things which I am not used to see on…
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…
Re: SCO & INFORMIX:Network driver cannot bind a name with the port
Alex Can you please include the original thread because I dont remember the problem anymore and I am sitting at the end of a email list feed? To answer some of your questions: AFAIK, USERTHREADS is not supported in 7.x anymore. It is calculated by multiplying number of poll-th…
Re: IDS-Linux - cannot connect to DS from net
Three things: From: "System.admin. Rubtsovsk Inc." <andrei@rubtsovsk.ru> > >Hi, All. >Sorry for bad english. >I have Slackware 3.x (kernel 2.0.35) + IDS 7_30_uc7_1, > Forking 4 'ipcshm' listener threads...succeeded > Forking 4 'soctcp' listener threads...succeeded >/etc/services…
IDS-Linux - cannot connect to DS from net
Hi, All. Sorry for bad english. I have Slackware 3.x (kernel 2.0.35) + IDS 7_30_uc7_1, Forking 4 'ipcshm' listener threads...succeeded Forking 4 'soctcp' listener threads...succeeded /etc/services sqlexec 1540/tcp $INFORMIXDIR/etc/sqlhosts sb27049 onipcshm sb2…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
How do I monitor a checkpoint thread?
I've been reading a lot lately about the debate over whether to run the soc poll threads on CPU or NET vp's. Art Kagel's argument for NET discusses the possiblity of the checkpoint thread hogging CPUVP #1 unless there are no page cleaners available. Is there a way to see the ch…
Re[2]: Long checkpoints (LRU_xxx_DIRTY/LRUS)->NETTYPE values
On Thu, 25 Mar 1999 11:25:10 -0800, MOPSOMER@raychem.com wrote: > Here is some additional information regarding these long checkpoints > we have in our productional SAP R/3 environment (Informix 7.24.UC3). [snip] > Yesterday, I had to extent a couple of dbspaces, whic…
Informix DS + Linux 2.2.3 ?
"Aleksey V. Lukin" wrote: > > Hi, All! > > Is anybody get it working? > Is some hints /patches available? > New kernels much faster so it's a pity that ontcp refused to work. > Hi, i have here the same problem. onsoctcp runs fine on 2.0.36, but refuses to work on 2.2.3 with the…
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…
LISTENER -THREAD ERR:25580
Hi there! Do you have any idea what might have caused this error? listener-thread: err = -25580: System error occurred in network function. This message appears on my online.log whenever I reached 1400 connections and all goes to a single listener thread. Here's my platform: …
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…
Problem with ERM
OS: DEC UNIX 4.0D IDS: 7.30 I have a problem getting the Replication Monitor side of IECC to work. The problem appears to be getting the Informix sub-agent to connect to Digital's esnmp master agent. Looking at the onsnmp.*.log files I see messages like: 'smux: connecti…
Connection to SE database
Informix Standard Edition issue: We're attempting to use I-Connect or ODBC to connect to an Informix server running on a Digital Unix box. The Unix machine has three physical interfaces. Two are utilizing internal IP addresses (not pingable) and the third is the routed address t…
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…
linux 2.2.x onsoctcp
anybody got IDS onsoctcp running on 2.2.x this is what I got in sqlhost db onsoctcp mymachine db the errors I am getting in online.log are 01:16:22 listener-thread: err = -25573: oserr = 11: errstr = : Network driver c annot accept a connection on the port.…
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…
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…
Help needed: onsoctcp on Linux
Marc Mielke wrote: > > Hi, > > I do have problems getting Informix IDS to startup when > network connectivity related entries are present in 'sqlhosts'. > > Apreciating any help.. I believe that you need a NETTYPE entry specifying that CPU VP be used to listen to TCP connections…
query maxed out problem.
Yan Zhu wrote: > > hi all: > > I am running informix 7.22 on solaris 2.6. > I wrote a web interface for the user to construct sql statement, > then I save it to a sql file, and call dbaccess to execute it. I just > found out that if I submit the query very quickly, say 50…
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?…
Problem conecting to informix
I'm triying to connect to a informix server from a win95 machine, and I set the hostname, username, password, also verify the port in the "services" file, but when I try to use the I-Login app to test the connection, this program crashes with out any error message. I was thinking…
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: Establish Informix network listener...
T. Saunders wrote: > Hello all. I am currently having difficulty reconfiguring my lab's > Informix database to support network connections. We are running Informix > Universal Server 9.12.UC2X21 on a Solaris 2.6 platform. I can, using the > old onconfig and sqlhosts files, br…
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…
Re: Poll threads again
I have to admit I goofed. The poll thread simply issues a poll() to determin network completions. An array of file descriptors is passed to the poll() function and completed statuses are returned for any connections that have data ready. This is a bit different with shared memo…
Poll threads again
Ok, so some say yes, some say no, and some are not clear on the question. So here it is again in a different form. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ib…
Re: Poll threads
OPPS - Major embarassement - red face and all ;) Jacques P Renaut wrote: > Luse Harold wrote: > > > A quick question. > > > > If the sql hosts file has two entries for socket/tcp connections: > > DBSERVER NETTYPE HOSTNAME SERVICES > > server2 onsoc…
RE: Poll threads
Luse, I think by specifying only 1 unique type of Interface/Protocol combination in your sqlhosts file, you only get 1 poll thread anyway. By specifying the Interface/Protocol entries as your DBSERVERALIASES, the poll thread will run on a NET VP by default. Thus, your NETYPE ent…
Re: Poll threads
Luse Harold wrote: > 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 …
Re: Poll threads
Luse Harold wrote: > 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 …
Poll threads
A quick question. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ibm1 infmx_service3 And the onconfig file has the following DBSERVERALIASES and NETTYPE entries: …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
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 …
Follow-up: CPU poll threads ...
Would you please describe the difference between NET VPs and CPU VPs? And why is one better than the other? TIA. -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, October 27, 1998 4:22 PM To: informix-list@iiug.org Subject: Re: What means…
RE: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'nam
My Informix On-line Dynamic Server (7.2) classroom material dated 01-97 states: "Only one protocol can run a poll thread on a CPU VP." Has this restriction been removed in IDS 7.3? -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, October…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
> >From: dengelsen@my-dejanews.com > > > >Informix (7.23) produced the following error in the message Log File: > > > >CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads > started on > >NET VP's. > > > >What does this message mean? > >What must I do to solve it? It…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
Hi Detmar, What's your plattform? --babak >From: dengelsen@my-dejanews.com >To: informix-list@iiug.org >Subject: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......? >Date: Mon, 26 Oct 1998 16:48:48 GMT >Reply-To: dengelsen@my-dejanews.com > >Hello, > >Informi…
Re: What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
dengelsen@my-dejanews.com wrote: > > Hello, > > Informix (7.23) produced the following error in the message Log File: > > CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on > NET VP's. > > What does this message mean? You have requested that your poll th…
What means: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' ......?
Hello, Informix (7.23) produced the following error in the message Log File: CPU poll threads exceeds 'NUMCPUVPS' NETTYPE 'name' poll threads started on NET VP's. What does this message mean? What must I do to solve it? Thanks for the help Greetings, Ditmar den Engelsen --…
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: 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…
Re: onload performance
According to last year's Informix conference: NUMCPUVPS set to number of CPUs NETTYPE Configure one poll thread for each CPU VP and be sure to run poll threads on CPU VPs BUFFERS Maximize CLEANERS Set to number of chunks allocated for the largest table CKPINT…
Re: onload performance
According to INFORMIX here are guidelines for loading environment: NUMCPUVPS Set to number of cpus NETTYPE Configure one poll thread for each CPU VP and be sure to run poll threads on CPU VPs BUFFERS Maxim…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
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: +…
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
Can't give you an exact answer, except to confirm that changing our poll threads from 2 to 4 (with about 400-600 active connections) fixed our connection errors as well. ...Terry.…
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…
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: Poll Threads
In article <6anilu$b75$1@news.xmission.com>, Harold Luse <hluse@vth.colostate.edu> writes > > >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 ev…
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…
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…
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: HELP: Informix Performance on Tandem Non-Stop
Bergero Claudio wrote: > > My problem sounds like this: > > Trying to add connections to Online up to 65-75 the server isssued this message in online.log: > > 16:43:35 listener-thread: err = -25574: Network driver cannot open the network device. > 16:43:39 NSF putlocal: t_open …
HELP: Informix Performance on Tandem Non-Stop
My problem sounds like this: Trying to add connections to Online up to 65-75 the server isssued this message in online.log: 16:43:35 listener-thread: err = -25574: Network driver cannot open the network device. 16:43:39 NSF putlocal: t_open error: t_errno = 8, errno = 28. My…
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: Network connection.,,
In article <5ps3u8$dh1@cssun.mathcs.emory.edu>, thabib@bob.zentropy.soft aware.com writes >Hello all, > >I'm trying to connect to a INFORMIX-OnLine Version 7.12.UC1 (online >dynamic server) with a esql/c application (INFORMIX-ESQL Version 7.12.UC1). >I have doubled-checked the sq…
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 on Linux?
In article <01bc1117$6327bd40$da01128b@servilo>, Wolfram Diestel <diestel@rzaix340.rz.uni-leipzig.de> writes > >I succeeded now to run Informix on Linux 2.0.28 with last iBCS-version >(summer 96) locally, t.e trough the ipc-interface. I take it this is a version for SCO - I'll …
Re: Performance / Internal Q's -- Online 7.2
This is a multi-part message in MIME format. --------------24681CC654CE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit jimlenahan@aol.com wrote: > > I have a 4way HP Kclass machine as server connected to a pair of HP > G class machines. On th…
Re: OnLine Internals and Performance Questions
jim, > - The IFMX docs say that MAXCPUVP should not exceed the real number > of processors in the system. However, my CPU's are typically running at > 50-65% utilization. Is there really anything that could go wrong if the > number of CPU VP's were greater than physical p…
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…
Problem of ESQL/C in Online 6.0 under HP-UX9.X
Hello, I get problem in running the demostration files. I am using ESQL/C 6.00 UC2 and Online 6.0 under HP-UX 9.X. My error is -25505 when connecting database. However, I get no problem in access the database under dbaccess. I find the following in the log file when running the…
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?…