Oninit® Archive
Results for “onstat -g ntu”
Network tuning advice needed
Greetings All, I am looking for some advice on a new (to me) configuration. Up until now, we have always had our engine running on the same server as our application. That has now changed. We now have a setup with the application on one server and the engine on a dedicated datab…
Long transaction message discusses a strange number
Hi Jake, for matching " Aborting Long Transaction: tx: 0x1d298fba8 ..." with onstat -x, simply go by this tx address. The tx_id's use, for the user, mainly is to identify the transaction in onlog output, in combination with LSN info (log unique ID + log position within that log).…
Informix 15 is out! Well sort of...
Hi Luis, Could you, before actually running the SQL, determine the session's sqlexec thread and then run "onstat -g stk <thread_id> -r 1" while the query is taking? Then do report the most common stacks observed here ... And for everyone else: happy to learn about any findings, …
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 ------------------------------…
Meet-our-speaker at TechXchange
The upcoming TechXchange Conference is the premier, technical learning event designed with technologists for technologists who use IBM products and solutions. It offers over a thousand technical breakout sessions, hands-on experiences, product demonstrations, instructor-led labs,…
flags (onstat -g ses)
That's the same set of flags as in ' onstat -u ' I'd say. For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one. ------------------------------ Andreas Legner ------------------------------…
onstat statement
Amit - sometimes a session can't be killed. It can get itself into a state where it is simply hung. This doesn't happen often, but it can. I doubt that it's a locking issue which is preventing the termination of the session (which is what you would be looking at with onstat -k)…
onstat -g opn: What sysmaster tables will get me this info?
Jacob: No, the "address" column in sysactptnhdr is NOT the same as the address column in sysrstcb. The latter is the 'address' shown in onstat -u for a session and in 'rstdb' field in the onstat -g opn output associated with each session. The sysrstcb table is the session control…
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…
RSS Encryption Performance Hit?
Does ENCRYPT_SMX need to be set only on the RSS, only on the Primary, or on both? After enabling this network encryption, how can one verify that it is operating? Thank you. DG…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
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…
Thousands -27001 errors
Hi, I've noticed that we have around 25 thousands -27001 errors in online.log after I checked the database because of an EG crash in IIB. EG crashed because it couldn't lock a table in informix they said. Because of this I saw all the network errors , which started since 2 days a…
sid vs pid
No. PID is the client process id and is not directly related to the server itself. A client session has a single SID or Session ID associated with it but can have many TIDs or Thread IDs if it is multi-threaded inside the engine due to parallel query or parallel sorting. Art Ar…
Erroc when dropping a table -- how to debug?
Hi, > I wonder if the 2nd error may actually be "-106 ISAM error: non-exclusive access", this is the most common error. Diagnostics returns that message, though I am not sure why my code returns 103 as error num -- but I agree, it should be 106 (will double check that) > From …
explain onstat -g ntu
Folks, The last session(session id 672) is running in another box, the read/write columns mean the session has read 4074114 KB data from database server box to its local box and also written 4074114 KB data from local box to the database server box, correct? Thanks Frank [info…
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)…
Network traffic usage
Not sure which version you are on so I will give two answers. You can get an idea of the amount of data by the number of network read and write calls done at the network layer with onstat -g ntu. This information is show for each session. This has been around for a long time. In …
listener-thread: err = -25580: oserr = 32.......
Guys, IDS12.10 FC4 RHEL Recently, suddenly see these error excessively. Any comments or able to trace it? Thanks Frank 14:24:07 CDR Spool transaction queue completed 14:27:02 listener-thread: err = -25580: oserr = 32: errstr = : System error occurred in network function. Syst…
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?…
does this mean a dropped network connection
John Not necessarily a network problem, but yes, the server lost contact with the application. Could be network, could be the user just shutdown the app while a query was still running, or just pressed the power off buttton on the PC !! Keith On 3 December 2013 13:44, John Adam…
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.…
named pipes - external tables
Original post: Aix 5.3 IDS 11.50.fc5 I'm working on moving some data from informix to a Netezzza N1001-05. One of the ways we are looking to do this is by using external tables in informix which are named pipes ... Then on the netezza side the nzload utility is used to insert t…
cant access DBSERVERALIASES
entry as follows dbt633_ecms_uat onsoctcp wldbt633 1526 everthing seems ok now there have been some network errors…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
ontape pipe restore times
This would be faster than gzip if you are now CPU rather than network limited (no difference with gunzip): http://zlib.net/pigz Regards, Doug Lawry…
Join my network on LinkedIn
LinkedIn ------------ akli imecaoudene requested to add you as a connection on LinkedIn: ------------------------------------------ I'd like to add you to my professional network on LinkedIn. Accept invitation from akli imecaoudene http://www.linkedin.com/e/-dryrhn-h52re…
memory used by a session
This thread is eerily similar to some problems I had with some Java programmers (may the fleas of a thousand camels infest their armpits) some time ago where we got excessive dynamic virtual segment allocations: it's to do with java sessions not freeing statements after they've c…
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 …
Network
I have a query that we are running between 2 LPAR's on the same P6. Both systems are IDS 11.70.fc3x9 and AIX 6.1. The table contains about 3.2 million rows... database eisds01@dss_lnk; select * from c3ods@ods_lnk:temp_event_item into temp test_data with no log; 3+ minutes dat…
migration checklist 7.31 to 11.7
Art: Thanks for the notes... I'm getting a bit more confident that the small scale, SQL stuff for site specific jobs won't be that big of an issue (as long as the OS and environment doesn't change that much without the developers telling us). FYI I found a migration presentatio…
drop CPU VPs....
Hi Martin, Few minutes after post this email here, I discovery exactly what you said, I just check which is the last CPU VP with "onstat -g glo" , use the "onstat -g cpu" to found all sessions what running more over it and killed only this session with more cpu utilization.. then…
Join my network on LinkedIn
LinkedIn ------------ Pedro Ivo has indicated you are a Friend ------------------------------------------ Eu gostaria de adicioná-lo à minha rede profissional no LinkedIn. Accept invitation from Pedro Ivo http://www.linkedin.com/e/-dryrhn-gtq5nirr-1t/TE9gQQCW5u…
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…
Join my network on LinkedIn
LinkedIn ------------ Pedro Ivo requested to add you as a connection on LinkedIn: ------------------------------------------ I'd like to add you to my professional network on LinkedIn. Accept invitation from Pedro Ivo http://www.linkedin.com/e/-dryrhn-gqkq4n8o-29/TE9gQQCW…
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.…
network traffic
Hi guys! Does anybody know where can I find some presentation that explain the steps to reduce network traffic between client/server? I've seen once, in 2007 presented by Vlaunir Silva (IBM US) at IBM Brasil on a Informix Workshop. He showed how to reduce the network traffic and…
Help on dbworker threads (memory not freed)
Hello friends. Informix 11.50.FC6W1X7 on linux_64 redhat based machine. Our machine is running up 52 days, and I have this doubt: our dbscheduller (dbworker) sessions are using too much memory, without running anything right now: onstat -g ath |grep dbWorker 106 1628a5b50 15fb7…
network errors
OS: HP/UX 11.11 IDS: 9.4FC3 (we are in the process of upgrading, but new server/db not ready for production yet) We started seeing these errors in our log Friday when users complained of not being able to connect. We checked back over time and there have been a few here and ther…
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…
Queries waiting for mutex
Hi, There a no Informix processes with sessions, only threads. And there are quite a few threads with no session: page cleaners, log writers, btree cleaners, and more. Take a look at onstat -g ath (All THreads) to see the full set. You may have one of those internal threads caus…
wait for mutex ... IDS hang....
Frank wrote: (4) mutex holder ??? it shows session 88852, but onstat -g ses 88852 shows nothing ( see below) informix@dora $ onstat -g lmx IBM Informix Dynamic Server Version 11.10.UC2 -- On-Line -- Up 4 days 03:03:29 -- 2120544 Kbytes Locked mutexes: mid addr name holder lkcn…
listener-thread Network error
Hello Everybody, I have a problem with a instance. I´m runing IDS 11.50.FC7 on HP-UX B.11.31 And every five minutes in the online.log put a message like this:"listener-thread: err = -25582". Almost of the time appears exactly like this: 12:01:25 listener-thread: err = -25580:…
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…
Connections blocked - Connect Timeout Expired
Correction (zero NET VPS after changing VPCLASS to cpu); With; NETTYPE soctcp,7,350,NET VPCLASS net,num=7,noage Results in; 7 Network VP, and 1 CPU VP. With; NETTYPE soctcp,7,350,NET VPCLASS cpu,num=7,noage Results in; 0 Network VP and 7 CPU VP!…
Buffer Waiting ( onstat -l )
The number of times that threads (sessions) had to wait to obtain a buffer. It's measure of system concurrency.…
soctcppoll and soctcplst
Hi, one is the listener thread, listening for new connection requests and subsequently serving them (new session). The other is the poll thread, checking if new data arrived on existing connections and notifying the appropriate session threads (normally called sqlexec threads). …
IDS 9.40 on windows stops working
Hi all, We now have installed IDS 9.40 on Windows XP. When I put connect the standalone pc on a network, the database engine does not respond anymore. I need to do a restart of the service to work with the engine again. I have the same situation when I started our application wi…
What does onstat -g lmx spots?
Hi all, quick question, what does onstat -g lmx tell you? when I face a slow down and I check "onstat -g lmx" output saying there is a pt_# mutex with a holder and a long queue of threads waiting for that resource, does it mean that the thread holding the lock is generating the …
Network Buffer Pools
IDS 11.50.FC5 AIX 5.3 For HDR replication between two AIX 5.3 servers, is there a suggested value for the following environment parameters: 1. IFX_NETBUF_PVTPOOL_SIZE 2. IFX_NETBUF_SIZE 3. Sqlhosts option b (client buffer size) The primary has 64GB of memory while the second…
How to secure ODBC connection
Sorry. You cannot encrypt ODBC. For internal systems you can restrict access to your company's internal network or use your company's network hardware to do encryption. For both internal and external (i.e. internet) you can encrypt with something like SSL, ssh or sftp. -L.S.…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
session versus VP
Try this: onstat -g glo lists the VP's. onstat -g cpu lists the session (thread) id and the VP it is associated with. Also, onstat -g ses lists the session id and the pid, then ps -u followed by the instance owner name, will list all the pid's for that instance. You should …
Re: Occasional onbar log backup hangs
Hello JPM, I had onbar logs (and backups) hang almost every week. Our problem was usually that our network had brief (1 second or more) outages during the day. Since I could not get our network guys to fix it (and other issues with onbar), I got off of it. I switched to a col…
Get Active Sessions
Hi. You obtain active threads by using onstat -g act. That includes user sessions and informix's inner threads. I hope this works Omar --- On Wed, 8/12/09, Dave <In4MixDBA@gmail.com> wrote: > From: Dave <In4MixDBA@gmail.com> > Subject: Get Active Se…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: how to force disconnect user threads?
don't do onstat -z, that will zero out your metrics for the instance. it's onmode -z ----- Original Message ----- From: "gansvv" <gansvv@gmail.com> Sent: Mon, August 3, 2009 11:36 Subject:Re: how to force disconnect user threads? On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wr…
how to force disconnect user threads?
On Aug 3, 11:31 am, gansvv <gan...@gmail.com> wrote: > How can I force disconnect user threads from Informix IDS? > > Thanks. I think I got it. onstat -u and then onstat -z for that session?…
Re: Connection manager redirect
A Network error, because the client at the public network can't connect directly to the IDS server at the private network, it's for that reason we use the connection manager between them. We want to know if always the connection manager is used only to the initial connection to t…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Re: The ultimate firewall
Obnoxio The Clown wrote: > http://obotheclown.blogspot.com/2009/02/best-hardware-firewall-in-world.html > > Wowzers! ;o) > I beg to differ http://www.cyberwalker.com/images/editorial/network-plug.jpg Is the ultimate firewall…
Lies, Damn Lies and Statistics...
On 24 Jan, 22:17, Mark Townsend <markbtowns...@sbcglobal.net> wrote: > >> Where do you think DB2 got its multi-threaded server from? > > DB2 for LUW was multi-threaded on Windows since inception > > (DB2 V5.1 I think). > > All that was done in DB2 9.5 was to extend the concept to…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
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…
IDS 7.31.UD8 Running out of memory
Hi everyone, I'm running IDS 7.31.UD8 on AIX 5.1 ML9 and it seems that whenever I reach somewhere around 2600 informix sessions , IDS runs out of memory and can not start any further sesssions. This causes the ERP application to lock up and many orphaned sessions are left in Inf…
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…
RE: ids connections lost to vpn
Thanks to all that replied. I agree with im_gumby's assessment: "... Or just lazy programmers assuming that when you connect to the VPN all network traffic should go through the VPN." There are some network connection settings that could be played with in the ipv4/ipv6 area. I j…
Network errors appear in online.log
Hello again! We have several errors appearing in online.log, and we don´t know how we could debug them, or fix. ----------------------------------- The first number is error: -25580 System error occurred in network function Is there any log we could analyse to track this problem…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
Hi All, Thanks for your replies. I managed to identify the process that caused the problem. 1. Use onstat -g act to look at active threads 2. Perform onstat -u | grep <rstcb value of active thread in step 1> -> get session id. 3. Perform onstat -g ses <session number from step…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Network connection is broken
Hello, Im having an error while attempting to execute a command dbschema on an instance of IDS - 9.40.FC2 on aix 5.2., it displays the following message: netuno:/desenv/hotel/htsp>dbschema -d system -t cmp_cmpotp DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.FC2 Copyright…
ER backing up on network
Version: Informix Dynamic Server 2000 Version 9.21.UC5XF Yes, we are in the plans with our 3rd party vendor responsible for upgrades to upgrade to 10, finally. However.... we are running ER between a server in Denver and a server in Dallas. Both are rs6000, one runs AIX 4.3, the…
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…
Re: hadr checks
a network glitch that attached the SAN to DB2 as well as Informix secondary *may* have caused a corrupted page on the DB2 side. so i wanted to see if there were further check on informix hadr.…
Failed to grant minimum permission requests.
Hi Shesh, thanks for your response,already there is fulltrust permission,and already have network permissions too.pls suggest ...…
The pioneering personals site that revolutionized online dating, with nearly million members-Millionaire!{$500K-$2M/year} A friend network, blogs, chatrooms and much more.
The pioneering personals site that revolutionized online dating, with nearly million members-Millionaire!{$500K-$2M/year} A friend network, blogs, chatrooms and much more. http://arealtgp.servik.com/Millionaire.htm…
Ip for a network session
Is there a reasonable way to get the source ip address for all network connected session? I don't see an onstat option that looks obvious for this. -- -------------------------------------------- Chris Salch Programmer/Analyst LeTourneau University…
Informix thread working with a index
PAULO RAFAEL PADILLA VELAZQUEZ wrote: > Hi all, > > I was trying to monitor an internal informix thread. > I get a table with 8 million records. > I do between 1000 and 5000 insert to this table daily. > Every night I update statistics to whole database. > > There is a thread tha…
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…
IDS10 ODBC
Tried this. I got a "conection refused". May be the Express Edition did'nt allow connections from the network ?…
Re: Counting Sessions
"Nog" <noel@gfm.co.uk> wrote in message news:873c1a7b-c863-41b0-ad19-92afa29369d1@i12g2000prf.googlegroups.com... > On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > Thank you all for your suggestions, > > Cesar Inacio Martins suggested the following which I'm going to use, > unle…
What is ids11 new function RSS for?
The HDR primary sometimes waits for a response from the secondary (for example after a checkpoint) so can suffer if there are network latency issues With RSS the primary does not wait for response from the secondary so these soort of network issues do not affect the performance …
Networker and Informix
People, We are currently implementing Legato Networker to backup our Informix instances. From the testing performed it seems that the process that backups up the logical logs is taking around 25 seconds to backup a 2Mb log file. From the initial diagnosis it seems that Informix …
Re: IFX_NETBUF_PVTPOOL_SIZE
On 4 Oct, 20:07, mohitanch...@gmail.com wrote: > Version IDS 10: > > I was reading Performance guide and came accross > IFX_NETBUF_PVTPOOL_SIZE, which seems to be very interesting. I have > some questions: > > 1. Is this pool used by Informix to store incoming or outgoing data > …
Re: rstcb
On Oct 10, 3:31 pm, zok <Hrvoje.Zoko...@gmail.com> wrote: > On 1 list, 18:46, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Oct 1, 12:15 pm, mohitanch...@gmail.com wrote: > > > > Version IDS 10: > > > > In different onstat output I see "tcb" and "rstcb". I am not sure …
IFX_NETBUF_PVTPOOL_SIZE
Version IDS 10: I was reading Performance guide and came accross IFX_NETBUF_PVTPOOL_SIZE, which seems to be very interesting. I have some questions: 1. Is this pool used by Informix to store incoming or outgoing data from application clients. 2. So, what happens if client is tr…
Re: Network connection is broken
On Jul 9, 9:52 am, "LoicPhil" <l...@nospam.org> wrote: > Hi, > > I'm experiencing a strange issue with my Informix server. > > When I try to connect from a PHP script, I get the error > "(-25582) Network connection is broken". > > There is no problem on the network though, the se…
Re: informix connection interrupt within 10 seconds
I want to know what network problem caused the connection to drop.Are there any settings on OS or informix can cause this problem?…
informix connection interrupt within 10 seconds
On Aug 22, 4:14 am, starduo...@gmail.com wrote: > WINSQL reported error like this:Error: System error occurred in > network function. (State:S1000, Native Code: FFFF9C14). FFFF9C14 maps to the integer -25580 which is the Informix error: > finderr -25580 -25580 System error oc…
Re: NETTYPE NET/CPU
On Aug 9, 12:10 pm, Mark Jamison <maj...@yahoo.com> wrote: > ----- Original Message ---- > > Makes it more clear. However, I have few more questions: > > >1. If an application runs on the same box as Informix then does it > >connect through socket or uses shared memory directly. …
ODBC to Solaris 10
Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix] System Error occurred in network function. This is the error return from the test ODBC. What could possibly be the problem.…
Network connection is broken
Hi, I'm experiencing a strange issue with my Informix server. When I try to connect from a PHP script, I get the error "(-25582) Network connection is broken". There is no problem on the network though, the server correctly receives the connection from the client, the request …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Network Connection is broken
we got ID 10 FC4 on solaris 10, suddenly we notice the above message in the log, and the connections are becoming very slow.... can anyone please help..... regards...…
IDS 10.0 and Legato Networker
We just upgraded from IDS 7.31 to IDS 10.0 We backup the database with Legato Networker 7.2.2 and the Networker Module for Informix 2.0. We noticed the backup failing when the dbspace backup was complete and it tried to backup the logical logs. 2007-06-04 11:48:45 541 11050 /inf…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Available Immediately ( Siebel, C/C++ Unix, Network Engineer, QA Tester)
Hi, Following 4 consultants are available immediately with Us: 1) Manish Shukla / Siebel 2) Khalid Ansari / C/C++ Unix 3) Rubeel / Network engineer 4) Bhaskar / QA Tester Thanks & Regards Sudin 402 218 2179 sudin@kraftware.com…
RE: Unusual GLS online.log error
Doug Conrey wrote: > Sorry, should have anticipated that question. These errors have appears, > always together, several times in the last few days. Also, the vast > majority of our connections are tcp (maybe 8 or 10 shm). > > NETTYPE ipcshm,1,50,CPU # Configure poll thre…
Re: NETTYPE's poll thread number
OS : AIX 4.3 IDS version : 7.31 Is ids version 7.31 will make any difference ? Pankrich Khanthasa-ard 寫道： > 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…
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…
RE: Network receive failed
Thanks, I will try both these options (increasing nettype, and the reply from ("big potato"?) - running 1 shm pollthread) :-) -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of hariog@yahoo.com Sent: 17 November …
RE: Network receive failed
Hi, I have a problem at a clients machine, where we are getting a lot of these messages in the online.log 13:52:41 listener-thread: err = -25587: oserr = 0: errstr = : Network receive failed. They are all connecting directly to the server, and using shared memory connections. …
Network receive failed
Hi, I have a problem at a clients machine, where we are getting a lot of these messages in the online.log 13:52:41 listener-thread: err = -25587: oserr = 0: errstr = : Network receive failed. They are all connecting directly to the server, and using shared memory connections. …
informix help
but if the 2 PCs are at different network, how should i do the connection?…
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 …
Odd network error message
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 ideas what it means?: 08:33:30 listener-thread: err = -25580: oserr = 104: errstr = : System error occurred in network function. System error…
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…
query using cpu
Floyd Wellershaus wrote: > Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost instantly ? Not pdq, just a query, on a non fragged table. > > It is doing multiple sequential scans of the…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Down Informix -
HP-UX 11.11 Informix 7.31 FD 8 =========================================================== The instance informix key and occurred the following message of error: 10:44:05 Assert Failed: No Exception Handler 10:44:05 Who: Session(11289017, unique01@c0a8646f, 1388, -609530840) …
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…
RE: Assert Failure
what could have been the problem Looking through the various AFs 02:10:26 Assert Failed: pthdrpage:ptalloc:bad bfget 02:10:26 Who: Session(11, root@rp4440, 0, -2132966728) Thread(200, xchg_1.9, 80db4500, 4) File: rspartn.c Line: 5408 02:10:26 …
Restore and network down problem
I loaded informix and did a restore of the ontape backup (ontape -r). but I get the error of networkdown after the restore was done. When I restored I did not recreate the database I only created the chunks and dbspaces. Did i do something wrong here? here are the results and s…
Informix Network down error
I loaded informix and did a restore of the ontape backup. but I get the error of networkdown after the restore was done. When I restored I did not recreate the database I only created the chunks and dbspaces. Did i do something wrong here? here are the results and settings I hav…
Network down
I getting this error "network down" when I use on monitor. I am using informix 7.31 on HP UX 11.11. What could be the problem. I have checked the sqlhosts file and it is ok.…
UNIX/Windows network security
I have two different Informix instances running in two separate machines in the same network: One in UNIX and another in Windows: 1st machine: -------------- OS: SCO UNIX hostname: thasos Informix DS 9.21, server name: ol_aegean user: akin Database dbakin $ cat /etc/hosts.equiv…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
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: PRINTING OVER THE NETWORK
sorry: remsh is not an internal or external command in WINDOWS Willaert Doris <Doris.Willaert@alcopa2wheels.com> escribi�: LET p_pipe = "remsh remote_machine lp -dlpt1 -s" START REPORT report_name TO PIPE p_pipe --------------------------------- From: informix-…
RE: PRINTING OVER THE NETWORK
LET p_pipe = "remsh remote_machine lp -dlpt1 -s" START REPORT report_name TO PIPE p_pipe ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Luis Carlos Díaz Otero Sent: woensdag 19 april 2006 17:06 To: …
PRINTING OVER THE NETWORK
Sorry if it looks like a newbie or dumb question. I have a WINDOWS XP network. If i want to print on my local printer i do: START REPORT report_name TO PRINTER or, if i have the report in a file, i do: PRINT /d:printer_device filename Where printer_device may …
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/…
Question: onbar and onstat -g ntu or onstat -g ntt
Hello, Are we suppose to see any of these "ontape" processes when we are not running any ontape or onbar backup? We start having some onbar failures (abort by client on some dbspaces...), and we haven't found the cause of the problem. Thanks onstat -g ntu | grep ontape c00000010…
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 …
IDS network configuration and problem detection
Hello, can someone explain the meaning of the onstat -g ntm and onstat -g ntu output? What indicates problems with the network configuration / connection load ? The examples are from IDS 7.30.UC3 - I know, not supported anymore and with a lot of bugs, but I think my question is…
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: How to get ip address of client ?
Indeed. See: http://groups.google.com/group/comp.databases.informix/browse_thread/thread/96f37ba67f599234 -- Regards, Doug Lawry www.douglawry.webhop.org "Paul Watson" <paul@oninit.com> wrote in message news:NMKdneb2WpAQSyjenZ2dnUVZ8qednZ2d@pipex.net... > If the ip doesn't res…
Re: HDR over secondary network
Andreas Legner wrote: > 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? > Correct. The machines are on two networks. as srvA and srvB they have IP addresses such as X.X.…
HDR over secondary network
HPUX machines, Informix 9.4 We have a primary database server, srvA, and a server we want to use HDR to back the database up to, srvB. Both machines are on our primary network, as well as a sync network, where they have a different set of IP addresses (which are identified in…
Enterprise Replication, hour syncronization
NTP (Network Time Proctol) is your friend!…
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: Network Driver Cannot Open Network Device!!
Hi, I think you are somehow running out of some system resource. However, I'm not sure it is due to kernel parameters. As you are on Solaris, I assume you use TLI (protocol ontlitcp in sqlhosts file). TLI errno 8 simpy means "System error" - which is not very much help. Errno …
Network Driver Cannot Open Network Device!!
Hi, In no particular pattern, i get this error, and the only way out is to reboot the server (and take downtime), which is not good. It could happen after several monhts, or several days. 16:56:11 NSF putlocal: t_open error: t_errno = 8, errno = 12. 16:56:11 listener-thread:…
Network Driver Cannot Open Network Device!!
Hi, In no particular pattern, i get this error, and the only way out is to reboot the server (and take downtime), which is not good. It could happen after several monhts, or several days. 16:56:11 NSF putlocal: t_open error: t_errno = 8, errno = 12. 16:56:11 listener-thread:…
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 ?…
Re: IDS 10 erratic run times
1.ok... what does condition bp_cond mean? does anyone have an internals manuals? 2. onstat -g stk is not for the thread I wanted a) onstat -g ses <session id> for the session what is the name of the threads that are running. b) onstat -g stk <thread id> for each session…
Onbar with Legato Networker
Does anyone have experience with using Legato Networker as the storage manager for onbar? In particular, we want to write the data to disk devices not tape. Our IT guys aren't much help but they suggested that we might need an add on module to be able to use disk devices. BTW thi…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Informix and legato networker
I am installing Legato networker with a Informix 7.31 TD1 system. The Informix database exists with a Microsoft cluster running on a pair of Windows 2000 Advanced servers. All seems to be configured Ok and it backs up ok both the Level 0 backups as well as the logical logs. Wha…
Re: Network Down
Did you ever figure out why you were getting network down message? We have benn running our database for three years and just recently we get this message. It happens only a few times a week. ONSTAT looks okay. Just ONMONITOR gets this message and applications can not access the …
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: WARNING: Network Down / Error Writing to network
Are you using the correct settings as mentioned in the release notes ( tcp / ipc) ? Is this a new installation of an in place upgrade ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Geezer From The Freezer Sent: …
RE: WARNING: Network Down / Error Writing to network
I would download the current verions (UD8) and install that. UC4 is quite old. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Geezer > From The Freezer > Sent: Thursday, 28 April 2005 2:21 a.m. > To: in…
WARNING: Network Down / Error Writing to network
Just installed Informix 7.31UC4 on Solaris and when running onmonitor I get WARNING: Network Down Any idea how to get around this problem. Help would be most appreciated.…
Connections hang
You might have tried all the below, if not 1. What is the status of the engine "onstat - ". Is it online or is it in Blocked CKPT state. Might be it is waiting on a check point. 2. What is the status of each session "onstat -u ", third column flags. The first character/flag would…
Re: how to know the session
Susana Barea wrote: > Hello list > > i want to know what session is consuming more cpu. > I've IDS 7.31 > > I'll apreciate any help > > Susana > > sending to informix-list See thread "Which thread consumes the most CPU time?" on this newsgroup. If I understand your question r…
Re: how to know the session
Susana Barea wrote: > Hello list > > i want to know what session is consuming more cpu. > I've IDS 7.31 > > I'll apreciate any help > > Susana > > sending to informix-list See thread "Which thread consumes the most CPU time?" on this newsgroup. If I understand your question r…
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: Which thread consumes the most CPU time?
You have to monitor onstat -g act and see which sessions are active most often. A session is identified by the rstcb column. On a busy system with multiple CPUs this becomes quite a task. I have a shell script I use to monitor active threads and display a sorted list of the mo…
Sysmaster tables for "onstat -g ntt" info
As if by coincidence I find myself needing very similar information. In my case I am trying to produce a status report on IDS systems showing things such as total number of users, number of local (shm/str), and number of remote (tcp). I can get this information from onstat -g nt…
Re: Informix 7.23 connection problem
Obnoxio The Chav wrote: > Cristoff said: > >>There is no chanse for upgrading. The system just close any next >>connection. After some time it blocks the network card. We have NETTYPE >>set up, but it probably needs initialisation. > > > What do you mean "blocks the network card"…
RE: Informix 7.23 connection problem
There is no chanse for upgrading. The system just close any next connection. After some time it blocks the network card. We have NETTYPE set up, but it probably needs initialisation.…
Re: Network Error??
Randy, I agree with Clive, the error message clealrly indicates that there is something wrong with your network setup. I would ask the SA to do a thorough check up of the network setup. On Tue, 18 Jan 2005 19:49:37 +0000, Clive Eisen <clive@serendipita.com> wrote: > Kennedy, Ra…
Network Error??
IDS 9.40FC3 HP-UX hp9ux3 B.11.11 U 9000/800 (ta) Trying to track down the root cause of these errors: 14:36:53 listener-thread: err = -25580: oserr = 232: errstr = : System error occurred in network function. System error = 232. 14:37:59 listener-thread: err = -25573: oserr =…
MT_EX_OS
Hello, Can someone help me with the following problem ? IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 01:58:29 -- 245760 Kbytes 09:49:44 Exception Recursion while handling: MT_EX_OS, Context: mem 09:59:44 VP Notify mechanism incomplete after 5 minutes. Th…
Resolution for '-25557 Network internal error'
'-25557 Network internal error' is resolved by adding this to the Path environment variable : C:\\Program Files\\Informix\\Connect\\bin sending to informix-list…
-25557 Network internal error
Hello, When a user tries to connect through PowerBuilder 10 to Informix 9 he gets an error 25557. Description of the error is -25557 Network internal error. If this internal error recurs, please note all circumstances and contact Informix Technical Support. I-Login test work…
Error numbers 25572,25574, 27001
Hi We are currently using Informix Dynamic Server Version 7.31.UC4 on Unix SysV R4 MPRAS. We keep getting frequent Informix freezes on our server caused by the error numbers 25572,25574, 27001. In this state connections to the application fail: listener-thread: err = -25572: os…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: psort used ?
"Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:<ZaLZc.234545$qp1.12220489@phobos.telenet-ops.be>... > Hello everybody, > > I enabled the psort_nprocs and set it too 8. > Is there any way I can monitor the psorts ? I want to know if they are > effectively used. >…
RE: Slow network connection
Erwin- Another possibility might be to uninstall the server and reinstall without the domain components. The downside there is that all users must have a local account. --EEM > -----Original Message----- > From: Erwin Lotter [mailto:lotter_NO_S_PAM_@zsw-bw.de] > Sent: Frida…
Re: Slow network connection
Everett, that's a very nice idea. However, I thinks I will not be able to follow it: First, the database NT is a workstation, not a server NT. Also, our domain controller is a Win2K server. With a lot of help from Murray I found out, that the authentication at the domain takes l…
RE: Slow network connection
Erwin- You could set up the database NT box as a backup domain controller, allowing it to authenticate its own requests...If it isn't too busy otherwise. If you're running HADR, you could set the redundant server as a domain controller and hopefully, since you can't guarantee t…
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: Slow network connection
I have to make a correction: The database does accept windows users from the domain too, but I don't need that.…
Re: Slow network connection
It seems that you are right. I have found out the following: In dbaccess, a connect takes (less than) a second, except after I have changed the user password: the first connect then takes a minute, subsequent connects take a second again. The very same happens when I start a cli…
RE: Slow network connection
This sounds like a Windows authentication problem. Where does this take place - locally or at a DNS? How many users exist in the user table - and can you reduce that list? When you dbaccess from the command line on the database server, how long does it take for the authenticat…
Slow network connection
Hi there, I'm running Informix Online V7.3 on Windows NT4 (sp3). In the beginning all worked fine, but after about 1 year I observed an extended delay when I connect to the server (via the native Informix driver that come with PowerBuilder 5) over the network from any client. In…
Error listener-thread: err = -27001 in online.log
----LNX_Thu_Aug_12_2004_08:59:00_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2004.08.11 20:34:37 >Sender: THORLEIFUR .... <thorleif@islmark.is> > >Does anyone know the cause of this error in online.log. >This slows d…
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…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
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…
informix over WAN
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:2ktvuvF6g6v0U1@uni-berlin.de... > What are the parameters to be tuned when connecting to Informix over WAN. > I know FET_BUZ_SIZE. Anything else. The client connects to Informix using JDBC. > > While testing, we are experie…
Which session is using the most cpu resouce?
Can I tell which session is using the most cpu resouce? I can use ps check which process or thread using the most cpu resouce. But Can I make a relationship between threads or sessions of informix and processes or threads of operate system?…
onbar backup with Legato Networker
Hi, Currently, we can have manual backup of our informix instance with "onbar -b -w -L 0" on the command line and onbar sends the backup data to legato. Our problem is, if we want to start the backup from networker server, it doesn't work. It gives XBSA BSAObjestCrate error and …
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.…
Network Down
Hi All, I am trying to initiate a new database like I've done a few times before. To me, it looks seems OK, but when I start the server I get this message: ** WARNING: Network Down **--On-Line------- Press CTRL-W for Help. -------- I have checked the onconfig-file an /etc/serv…
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…
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,…
OnLine Connection Error enabling/disabling the network connection
Hello, All! I've set-up a Toshiba Tecra with Win-Xp Pro running a Perl web based application on IIS and Informix OnLine 9.4: all the pieces seems work fine but if the PC is turned on without the network connection and after that I active a network connection (locale, via a netwo…
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…
RE: -25587 network receive failed
Remember that you also use tcp (network) connections on the server, to connect to Informix - check your server limits (kernel parameters), or the number of allowed connections to Informix -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@…
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…
-25587 network receive failed
Aix 5.1L Informix 7.32 UD6 A night batch process keeps failing about 50% of the time, with this error: -25587 Network receive failed. Yet there is no networking involved, the process is started on our IBM pSeries 650 and ends there. The process used to work perfectly every nigh…
-25587 Network receive failed
Aix 5.1L Informix 7.32 UD6 A night batch process keeps failing about 50% of the time, with this error: -25587 Network receive failed. Yet there is no networking involved, the process is started on our IBM pSeries 650 and ends there. The process used to work perfectly every nigh…
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.…
FW: Log errors - network ?
I am getting the following errors running my logical logs (continuous backup). We've been having A LOT of network problems lately, and my question is - could these also be network related ? I can only think that somehow I am getting tcp errors, and this is affecting Unix (or t…
RE: What do session statuses mean?
Wait master consumer. eg. a scan thread waiting for a consumer thread like a sort thread, join thread etc. Regards, Bill > -----Original Message----- > From: andykent.bristol@virgin.net [SMTP:andykent.bristol@virgin.net] > Sent: Monday, December 15, 2003 4:43 AM > To: informix-…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
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.…
WARNING: Network Down
Greetings! Trying to finish an install for IDS 9.21 on Linux but getting WARNING: Network Down message. The log shows the following entry: Get Shadow Passworkd for user [informix] faild! Check for password aging/account lock-out. listener-thread: err = -951: oserr = 0: errstr = …
Network driver bind issue
Hi, I'm having a problem starting up a database. Oninit -v shows everything starting no problem and I am brought back to the command line happily. However, onstat after that shows the shared memory is not initialized. In the log we have: listener-thread: err = -25572: oserr = 9…
connection problem
Hi everyone, did someone meet the following issue? We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V Release 4.0). Currently only 91 users can connect to the database. Afterwards no new user can login - till someone logs out and the user can connect to the server…
IDS Performance problem
Hi, I have performance problems with on IDS 9.30 on hpux. When i look current sessions with onstat -g sql somme are always with status cond wait(netnorm) and wait more than 1000 times. What is meaning for this status ? When i look all waiting sessions on threads with onstat -g …
q-exceed
Hi, when i do onstat -g ntu, the quota q-exceed is increasing (for the second value), see below. Does someone know what it means ? What parameters are to be modified for that ? It happens when i use enterprise replication. Thanks Informix Dynamic Server Version 7.31.UD2X4 --…
ER : how to speed up sender ?
Hi, i am working with ER replication. I have 2 computers : A 4 CPU RM400 (siemens) with sinix OS (or reliant unix) and a 7.31UD2 database server. A 8 CPU SunFire 880 with Solaris 8 and a 9.30UC2 database server. The network is a 100Mbit lan. All the database user tables of RM40…
Re: Tuning IDS 9.30 after migration from IDS7.31
dthacker@omnihotels.com (Dave Thacker) wrote in message news:<554c618d.0308280657.2c8627bd@posting.google.com>... > We've recently migrated from 7.31UC5 to 9.30UC5. Our platform is AIX 4.3.3. > The hardware is an S7A with twelve CPU's. KAIO is enabled. The machine runs > both …
Changed the IP address on an informix 9.3 machine
I changed the IP address on the informix 9.3 machine and now when I try to bring informix online it says that the network is not connected? Is there something inside of informix 9.3 that references the IP address of the machine that I need to change…
waiting on flush of log buffer - try two - Assembled_onstats.txt (0/1)
I've got this situation: A session, building an index on a fragmented temporary table, spawns 4 additional threads, one goes into a critical section (flag X in position 5), one goes into a wait for a flush of a log buffer (G in position 1) Other sessions fall into a wait state,…
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…
RE: Informix 9.40 crash after stress test.
If a user connects to the server using shared memory or TCP/IP has nothing to do with how much shared memory is allocated for the threads running from that users session. Shared memory connection vs. TCP/IP is simply the method of communication between the server and client. If…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: IDS license count per user or per session?
"Doug McAllister" <doug.mcallister@nospam.fmr.com> writes: > Actually, since Informix never had the concept of a "named user", licensing > cannot be based on users. You do not add users anywhere in an Informix > system, you just grant predefined Unix users database permissions. …
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: "Slow System" Problem
Hi, can you tell me how can I detect the "looping connections" from te onstat -ntu? thank's Gustavo Tobares Administrador de Sistemas y DBA Centro de Computos - Red Megatone TE: 0342-4500972 - Fax: 0342-4500940 -----Mensaje original----- De: Greg Mitchell [mailto:greg.mitchel…
"Slow System" Problem
Zev, That's a tough one. First off, try using something like Peter Schmidt's most_active1.sh script at www.peterschmidt.com to determine which engine thread is doing the most I/O at the time. After that you may want to use the onlog utility to review the log entries to determi…
Re: Assert Failed.
Hi, I am using IDS Version9.21.UC4 running in Sun E450. Recently, the informix database ususally down with following messages in online.log: 18:47:57 Assert Failed: No Exception Handler 18:47:57 Who: Session(41327, informix@server_1a, 14926, 705960568) Thread(41358, sqlexec, …
Informix & Storage Area Network
Hi, I would like to have more information on Informix and SAN. We plan tyo buy a SAN solution and we want to be aware how other people do. I work with Informix 7.31FD2 How do you manage backup, mirror copy, snapshot, etc. Thanks ... And if you can refer me to any good web sit…
-25574 Network driver cannot open the network device
-25574 Network driver cannot open the network device I'm getting the above on with Informix 7.31 UC5 on a SCO 505 server. What seems to have caused this is an increase in the number of users. Where would I start for increasing something in the onconfig file? Thanks Gary Quir…
Database is on line ,but has warnings
WARNING: Network Down **--Recovery------- Press CTRL-W for Help. ------ Why? thank you Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Multiple users logging on with same ID
I have a question regarding multiple users logging into informix via inet with the same user id. What type of problems can this cause. My concern is what happens when page level locking is implemented and one user is updating data at the same time another user with the same id…
RE: Exceeding Number of Connections
We are having -908 problems but all users lock out when it occurs. After consultation with Informix they tell us that for tcp connections then these parameters are ignored and the no of sessions are allocated dynamically. Checking this out if you do an onstat -u this tells you t…
RE: Exceeding Number of Connections
As far as I know this shouldn't occur. When you specify in your NETTYPE the number of connections it won't allow you to exceed that number. When you executed onstat -u are the session ids unique? It's possible that a session (connection) spawned more than one thread. And what yo…
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 …
network driver cannot accept on hp-ux 11.00
"Art S. Kagel" wrote: > "Nicholas Pieter Heesters Jr." wrote: > > > > I need to make a correction. I was looking at the wrong > > server when I said the version was 7.31UC2. It is really > > Informix 9.21FC1 that is giving me the problems. > > > > The value of NETTYPE is "soct…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
dbcopy and shm
cyclonejls@my-deja.com wrote: > > Can dbcopy use a shared memory connection? When I run dbcopy using a > shared memory connection, I get the following error: Dbcopy uses a separate connection to a database server for each side of the copy. That is why it can copy between datab…
Assert Failed: semop: errno = 36
Hello, Our test server crashed this night and yesterday night, at the same time, but I can't find a reason ... Can anyone help ??? The errno 36 is : /usr/include/sys/errno.h #define EIDRM 36 /* Identifier removed */ but I don't really understa…
onperf utility
Art S. Kagel wrote in message <39932718.4CD3DFD6@bloomberg.net>... >Francois La Haye wrote: >> >> Hello, >> >> Did anybody used the onperf utility ?? Any comments on this tool ? > >PHLEH! > >Too few variables tracked, too many crashes. > >Art S. Kagel Can't remember if it is …
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…
Checkpoint/LRU question
"Manel Falcó i Aige" wrote: > > Hi, > Does a checkpoint block the users sessions ? As well when buffers are > flushed via MAX LRU ? At checkpoint time any users performing updates will be blocked. In addition, at least through 7.30 Informix says they have rewritten this in 7.3…
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?…
change of server made network problems
Hello again, I have some informix network problems. I moved my Informix ON-Line Dynamic Server to another Server (diferent host and IP), and when I startup the server, it starts OK, but says this: ** WARNING: Network Down **--On-Line--- So I have no network connections. I chan…
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…
ERROR: -25574: Network driver cannot open the network.
Hello, Server: SCO Open Server 5.0.2 256 MB Ram Online 7.22 UC2 10:54:55 NSF putlocal: t_open error: t_errno = 8, errno = 6. 10:54:55 listener-thread: err = -25574: Network driver cannot open the network. Thanks in advance.…
Informix spawning threads every 5 seconds
In article <8id17o$8o$1@oak.fernuni-hagen.de>, Johnson <johnson@kudzu.fernuni-hagen.de> writes >We have Informix 7.23 UC3 running under AIX 4.2.1. Aio has been activated. >Using vmstat, I have observed that the number of runnable kernel threads jumps >from 0-1 to 19-21 every 5 se…
Segmentation Violation, system Down
Hi all, Can someone help me on this. 15:20:22 Assert Failed: Internal Error - Segmentation Violation 15:20:22 Who: Session(33, informix@financeweb, 28092, 169115948) Thread(57, sqlexec, a12b638, 1) 15:20:22 Results: OnLine must abort 15:20:22 Action: Rein…
Killing a session using onmode -z
Hi guys, How safe is to kill a session using the following command : onmode -z sessid Do we need to take any precaution while executing it? Do we need to check the state of that user/session/threads? I mean if it is in critical state. Thanks in advance. Vinod Bhansali. ______…
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…
Consultants - FREE Zero Impact Sql & Service Level Monitor
> "It does this on a separate box - the network must be configured such > that it can see all the packets" > > Neil, don't you contradict yourself? Everything has some cost. Nothing > comes for nothing. It is zero impact on SQL Server and any other device on the network. There…
Open database
Is Informix an open database? * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
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…
Error 25574
Hello everybody ! During execution of an ESQL/C program I've got the following error code: -25574 Network driver cannot open the network device. A system call has failed. See the UNIX system administrator for assistance. Does anyone know anything about this bug ? Regards Ry…
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…
onstat -g con
we're running Informix 7.3 on HP-UX 11 when I run onstat -g con (show threads which are waiting on something) I see "netnorm" as the condition being waited for. This is documented as meaning "thread waiting for a request to be placed in network queue". Is this normal? Is tha…
System catalogue
Sounds like HDR to me. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
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…
HELP- database won't start !!
Informix error is 25572, os err 227. Network driver cannot bind a name to a port.... Any assistance is appreciated.…
i.star information needed
tqma@my-deja.com wrote: > > A search for 'i.star' on informix.com did not show up anything. > Where can I find information about this feature of IDS-7.3, please. IStar and INet were the Informix server and client networking products for Online 4 & 5 engines. The IDS 6/7/8/9 pro…
Re: SQL running on unix
current * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
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…
Network Appliance
Anyone have any experience/comments on using Informix with Network Appliance file servers? They have software called SnapMirror (replication) and SnapRestore (data recovery) that keeps versions of disk pages. Has anyone used this with an Informix DB? Christopher A. Franks Senio…
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: NetWorker
From: thopper@imsn.net > >I am looking for a way (script? command?) to shutdown Informix before a >NetWorker backup and startup Informix after the backup is completed. I >see in the man pages a command "savepnpc." Would I use this? If so, Why do you want to shut Informix down…
RE: NetWorker
Tiffany Are you trying to back up the Informix chunks? Do you know whether you could ever restore and re-use these files (in all circumstances) ? There are several choices, but at some sites we do: 1. An Informix archive to disk 2. Backup the archive file, not the chunks. M…
NetWorker
Hi, I am looking for a way (script? command?) to shutdown Informix before a NetWorker backup and startup Informix after the backup is completed. I see in the man pages a command "savepnpc." Would I use this? If so, how do I implement this. My supervisor is thinking that a cr…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
onSNMP?
An interface daemon to SNMP (Simple Network Management Protocol) tools so that they can monitor IDS servers. Art S. Kagel Top Cat wrote: > > What is onSNMP?…
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…
IDS 7.31 UC2 crash and burn
It happened again.... This goes to (Informix) support -but maybe someone here have seen this before. HP-UX 10.20 on a K380, patches and kernel-settings pr. release-notes. Thomas Latest crash: 23:22:20 Logical Log 2 - Backup Completed 23:51:27 Assert Failed: No Exception Hand…
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…
"Funny" crash on 7.31
We've had two of them this week, both under relativly high load (generating indexes or running update statistics on large tables). I've mailed these (and the stack trace) to Informix, but decided to ask here just in case someone had "been there, done that": (Informix Dynamic Se…
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: 7.31 question
From: dianne.pendleton@autodesk.com > >Does anyone know why so many threads are being allocated to one session? That's what a multithreaded database does. It looks like you're getting a lot of throughput. I'd be happy if I were you... :-) _______________________________________…
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…
error 951
Hi guys, When trying to connect to a network server from a client, I get an error 951. any ideas would help. I'm sure that the user name i'm using is correct, and I can access the server and database without any problems from the console through the network port.…
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…
Network problems with IDS 7.3 and Linux Kernel 2.2.x
The network connection works fine with Kernel 2.0.36. So if you don't need to use Kernel 2.2.x ... Harald Raffelt…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: onmode -z
Mukund Perhaps the logs are full, since the thread is waiting in a critical section for some significant time period? Set LTAPEDEV to /dev/null and run ontape -a to clear them. As for moving the development DB to another chunk, that will not help much if you want to shutdown th…
Timeout
We use a centralized IDS 7.30.TC2 server to keep information on our customers. When a customer enters a remote site, which have IWS 7.30.TC3 servers, the data is retrieved from the central site if it is newer than the data on the local server. Because some of our sites are in r…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: ZERO Impact Performance Monitor for Informix BETA program
> C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION > when the SQL was issued across the network (e.g. telnet session) will be > available next week. Okay, but wouldn't this also work for a network connection for a telnet session also? What relevance does …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
listener-thread: err = -25587: Network receive failed.
Messages from online.log: listener-thread: err = -25587: Network receive failed. Assert Failed: Internal Error - Segmentation Violation Who: Session(11168, ok4@d381, 7336, -976900320) ^ Thread(339657, sqlexec, c5c3c1d8, 1) | Se…
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…
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…
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?…
Help: Segmentation violation.
I've get the following message from my Online DS 7.23: 14:04:23 Assert Failed: Internal Error - Segmentation Violation 14:04:23 Who: Session(38, user@bd, 10232, -2063193804) Thread(60, sqlexec, 85041540, 3) 14:04:23 Results: OnLine must abort 14:04:23 Action: Reinitiali…
IECC over a dialup connection
I'm trying to use IECC over a dial-up connection, and cannot seem to connect to the server. When I'm directly connected to the network, I can connect to the server fine, but when dialed in to the network, I can't seem to see the server(s) (but I know they are there, and accessabl…
networking databases
Hi I am developing a database ith Access 97.However I need to network it but have no idea about how to do this. Someone told me it was easier to use Visual Basic as a front end and network it from there, and I have also heard about going through the ODBC. I have absolutely no ide…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: onmode -z problems; Baan is not guilty
Martin Both wrote: > Martin Both wrote: > > > rare circumstances. I use dbaccess from a remote host and is it not possible > > to kill the thread with onstat -z. Killing dbaccess is useless. > > I don't know why and it happens very seldom. > > Sorry I mean onmode not onstat. > >…
test - please ignore
This is a test. Please ignore Sujata -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own…
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: Warning:Network down
In article <72vbgc$n1l$1@nnrp1.dejanews.com>, huesing@my-dejanews.com wrote: > Hallo! > We try to create a new chunk by using onmonitor. > When onmonitor starts up a warning appears: Network down > The create fails with "no permissions to write to network or user unknown on > t…
Informix Warning: network down/no permission
H1 Environment:SOLARIS 5.6 --INFORMIX 7.3 we try to create a new chunk by using onmonitor. When onmonitor starts up a warning appears:network down. The create fails with :no permission to write to network or user unknown . Is someone able to help us or is there any idea?? Thank…
Warning:Network down
Hallo! We try to create a new chunk by using onmonitor. When onmonitor starts up a warning appears: Network down The create fails with "no permissions to write to network or user unknown on the database server" There are no problems with oninit and dbaccess (creating tables etc) …
warning:network down
Hallo! We try to create an new chunk by using onmonitor. When onmonitor starts up a warning appears : network down The create fails with "no permission to write to network or user unknown. Our environment is SOLARIS 5.6 -Informix Online 7.3 with oninit and dbaccess there are no p…
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…
Extracting a viewable tif image from a BLOB?
I wish to get a tif image from a BLOB field to a location on a shared drive so that others on the network can view it from their PC's. Any suggestions? Thanks, Rolly Vipond FBS…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Triggering-Question
Hello! I want to call a 4GL-Programm from a trigger. Is there a way to do this? Bye Andy M. Bettin -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own…
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…
merging 2 databases
Hello Version 5.06.UC2 of Informix Is it possible to merge an exported database with a running informix database and not have any data be lost? Thanks Steve Nolan Bay Networks…
SMI query for onstat - g opn (open tables)
I'm trying to write an SMI query similar to "onstat - g opn" which shows open tables for each user thread. But, I want to see the username, database name, and tablename instead of thread ID and table partnumber in hex!!! I can't seem to track down the columns that I need in the…
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 …
Informix 7.14 Bug (drop Table)
I have Informix 7.14.UD1 and server Sequent with Dynix/ptx 4.2.1 (1GB RAM, 4x Pentium). Some time Informix is go down ( action - drop table, ...?): Online.log ---------------- Block magic is -4114 (BL_MAGIC_FREE), expecting 7 Assert Failed: Memort block possibly freed twice Who…
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
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: Session is waiting for long....
Abhay This is normal ,You can not make them to run manually . For Network connections Sqlexec thread is waits for poll thread to wake up and to process client request. or client session submitted a query to online , online finished with its work and is telling the session to tak…
oninit, thread and session id's
We have oninit processes that sometimes start "running away" eating up gobs of CPU time, io, etc. Which brings the system to it's knees. After tracking down and killing an offending job, the system becomes normal again. Is there any way to find the thread and session i…
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: +…
Re: sid <--> tid
Serg Shejkin wrote: > > Hi everyone. > > How I can determine, to what user session (sid) belongs thread ( tid ) > > Thanks. > > Serg Try Database sysmaster; select sid from sysrstcb where tid = 1234 ^^^^ …
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
Re: Connection rejected - too many users
John F Miller III wrote: > > malvarez@antena3tv.es wrote: > > > Hello, > > I had just migrated from ODS 7.14UD1 to 7.23UC4 yesterday and everything > > seems to be OK up to now. However, today I am having a few messages in > > the log saying "conection rejected - too many users" …
Re: Connection rejected - too many users
malvarez@antena3tv.es wrote: > Hello, > I had just migrated from ODS 7.14UD1 to 7.23UC4 yesterday and everything > seems to be OK up to now. However, today I am having a few messages in > the log saying "conection rejected - too many users" and there are only > 70 users active. …
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: Current processed SQL statement
Johannes Plassmann wrote: > > Hi there, > I've a question of how to determine a currently processed SQL STATEMENT. > > Imagine a thread which is processing a bunch of sql statements and > another thread which wants to figure out which statement is currently > processed. Open a s…
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…
Network driver cannot open the network device
We are testing client/server applications with INFORMIX-4GL Version 6.05.UD1 and INFORMIX-OnLine Version 7.12.UC5 on DG/UX R3.10. We can use dbaccess from client to access server database. Therefore we believe INFORMIXSERVER/DIR,PATH, sqlhosts, services and hosts.equiv are set u…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: multithreaded servers
Peter Weigert wrote: > > hi folks! > > does anybody know wether informix thinks about supporting a > multithreaded applicationserver with one session per thread > (the global sqlca interferes the multithread support). Esql 7.21+ supports multi-threaded applications. A task can …
Re: Trusted user question
Mark Check your hosts.equiv file? Go strangle your network administrator until he gets his certification...... Could be a combo subnet mask and router problem. ---------- Stan the baby DBA…
Is Informix Reliable?
I am currently evaluating Informix -vs- Oracle, and would appreciate your input. I have read on a few threads that people have had to unload and re-install the database to fix corrupted system tables, indexes, etc.. How often does this happen? Also, how reliable is Informix in …
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…
Re: Cannot connect to Online
Dirk Scheer wrote: > > Hello out there, > > since 4 weeks, there's a very strange behaviour with INFORMIX Online 7.13.UC3 > on HP-UX 10.01. From time to time it happens, that no new user can establish a > connection to Online (the process hangs, until online shutdown). Users > cu…
Re: Multi Thread App
On Tue, 6 Jan 1998, Alexander Jaremenko wrote: } Hello Mr Kagel, } Thank You for response. } } > ODS/ESQL-C versions 7.21 and later support threaded applications. } > Versions prior to 7.13 supported only one connection per process and } > 7.13->7.20 supported multiple sessions …
Re: Multi Thread App
Alexander Jaremenko wrote: > > Hi All, > I'm about to write multi thread application with ESQLC. I would like to > know how ODS would treat multiple threads doing sql requests - as > separate DB - user sessions ? > Happy New Year! ODS/ESQL-C versions 7.21 and later support thr…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Re: Deamon Threads
In article <676bpr$9nj$1@gte2.gte.net>, Hitesh Dave <davehit@vsol.com> writes >Hi Guys, > > We are running Informix Online ver 7.23.UC5, we have two informix >instances configured in HDR pair on two sun boxes running solaris 5.5.1. >Configuration on both the boxes is identical.…
Re: Deamon Threads
I have seen this behavior on Sun boxes when the NUMIOVP variable (in the ONCONFIG file) is blank. Make sure that it is set to at least one (1). -d At 10:58 AM 12/16/97 -0600, Hitesh Dave wrote: }Hi Guys, } } We are running Informix Online ver 7.23.UC5, we have two informix }…
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…
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…
Network connection.,,
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 sqlhosts files, onconfig, hosts.equiv, hosts files, and restarted the database engine, only to ge…
Informix access through firewall
I have the following set up for my WEB. external network NT 4.0 running IIS ----firewall------ middle network NT 4.0 internal network running HPUX 9.0 Informix 5 My informix database resides on the internal network and I need to get my Informix infomation to/from the WEB. I wo…
Re: Backup tools
Mr Cheuk Kong Lo wrote: > > Can anyone give me some input on the 3rd party backup tools? > We are considering to use Networker on our AIX+Informix (7.12) > server. In particular, how does Datatools' SQL BackTrack, > Networker and On-Bar (Informix 7.2x, we may upgrade soon) compar…
semaphores or lack there of
I have a few questions as to how to identify if you are running out of semaphores, and the exact parameters to set. My environment is a 16 way SGI with 2gb and one four tray five disk MTI at raid 5. I also have 5 single disks not raided across 5 controllers for indexes. The thre…
Informix ODS 7.21 online backup - beta code available
All, The evaluation beta for BusinesSuite Module for Informix, version 1.1 (beta) is now available on Legato's web site, under www.legato.com/forms (see NetWorker beta programs). BusinesSuite Module for Informix -------------------------------- * online backup for Informix ODS …
Legato Networker Backup?
Does anyone use Legato Networker to backup Informix? Have you had any problems? What issues did you face? MO…
Solved: Please help: OWS don' trust me...(NT 3,51 OL 7.12)
So, don't ever let this to be different: Program manager - Control Panel - Network - Computer name = xxxx and Program manager - Control Panel - Network - TCP/IP protocol - DNS - Host Name = yyyy Thanks to everyone. Andrej…
onmode -z question/comment
onmode -z can only be run by informix/root. In our current situation, 'security' rules require that we (developers), the people closest to 'the action' cannot become informix or root on the production machines. Occasionally, through the wonders of ODBC, we get hung threads that…
Re: find session id
In article <55cfj5$pn8@netnews.csie.nctu.edu.tw>, ccliu <ccliu@csie.nctu.edu.tw> writes >Hi, > When informix has BUS error, it will show: > >18:20:13 Checkpoint Completed: duration was 1 seconds. >18:21:09 Assert Failed: Internal Error - Bus Error >18:21:09 Who:Session(114…
find session id
Hi, When informix has BUS error, it will show: 18:20:13 Checkpoint Completed: duration was 1 seconds. 18:21:09 Assert Failed: Internal Error - Bus Error 18:21:09 Who:Session(11445, mes@u3hsrv3, 8702, -1073275464) Thread(13999, sqlexec, c0053420, 3) 18:21:…
MS-Access - Informix 5.0
Please recommend an (easy to set up) ODBC software to link MS-Access 2.0 under WfW3.11 to an Informix 5.0 DB under Unix. Network Protocol is TCP/IP. Thanks - Hartmuth…
Test - don't read
This is a test of the emergency broadcast network.…
Re: ARCHIVE SID?
kosovali wrote: > I've got also this message when i try to retrieve an archvie from another server : error 1191 Need a transit vset for a network request. I'm lost with all that stuff!!…
ifmxload
Does anyone have any idea what ifmxload or ifmxload.dat does? I have this running on 5.0...I've never heard of it before. Tks.. -- ---------------------------------------------------------------------------- Ed Bidinotto bidinott@ucar.edu BIS Network…
IFMXLD
Does anyone know what ifmxld does in 5.0 or what the ifmxld.dat file is? Tks in advance.. Ed -- ---------------------------------------------------------------------------- Ed Bidinotto bidinott@ucar.edu BIS Network Mgr (…
Restricting Concurrent Sessions, OnLine 7.12 for UNIX/Solaris
We would like to restrict each user to running no more than 3 concurrent OnLine database sessions (number of threads is not of concern). The users might be connecting via DBACCESS, ISQL, 4GL programs, ODBC, NewEra... Any ideas on how to neatly enforce this restriction? Thanks.…
ontape, Networker and Solaris
Has anyone used Legato's idtasm software module to automate informix archiving using Legato Networker software? I have downloaded the idtasm software and would like pointers on installing it. jake@surf.com…
segmentation violation on O.L.7.12
On aix 4.1.4 an online 7.12.uc1, online crash after the following statement: revoke all on fakturen from public; The table fakturen has 532020 rows. The log file indicates: Assert Failed: Internal Error - Segmentation Violation Who:Session(271, informix@dpescam1, 12472, 107402…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Panic!: SCO OpenServer can't trap INTERRUPT from dbaccess
I believe that you can solve this problem by installing the SCO maintenance patch for OpenServer 5.0. Good luck! Christos Liacouras Transaction Network Services, Inc.…
Test Message
This is a test message -- Dave Harding __________________________ TRIVIUM Project BBC Network Radio __________________________ HARDID02@bh.bbc.co.uk…
Re: Q: Does ESQL/C require a local engine?
> I would like to install ESQL/C on a system without a local engine. > However, OnLine 7.10 will reside on the network. Can I do this? Should be no problem...…
Q: Does ESQL/C require a local engine?
I would like to install ESQL/C on a system without a local engine. However, OnLine 7.10 will reside on the network. Can I do this? Thanks. Edwin Babadaglian edwinb@panix.com…
Controlling those Nasty CPU VP's
Platform=HP-UX 9.01 Informix 7.11 UC1 How can you control a session thread in a CPU VP from monopolizing the system CPU? We had a single thread take about 90% of the CPU while performing an update.…
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
Technical databases
I am a PC analyst with great intrest in my trade,networking and computer security can anywone tell me what database resorces there are available to someone with such interests or point me in the right direction? Please respond to Matthew_Pritchard@bendnet.com…
Re: ONSTAT question
I think it means that session is idle, waiting for next SQL statement OR user action. In article <491umh$hvm@newsgate.dircon.co.uk>, Bashar@ctl.com says... > >Hi there. > >onstat -u (version 7.1) sometimes shows a user thread with position >1 of the flag field set to Y. The Info…
Re: ONSTAT question
I think it means that session is idle, waiting for next SQL statement OR user action. In article <491umh$hvm@newsgate.dircon.co.uk>, Bashar@ctl.com says... > >Hi there. > >onstat -u (version 7.1) sometimes shows a user thread with position >1 of the flag field set to Y. The Info…
Slow screen redraws with VT220/FTP
Are you sure that this is not a network problem ?? Have you tried with other termcap settings ?? -- Terry Boyland…
Re: RE: NewEra on Windows 95
There are some networking issues with Win 95 that we are trying to resolve to get NewEra 2.0 supported on Win95 and WinNT before the 3.0 release. Stay tuned.…
CPU Usage per session
I am looking for a way to determine cpu usage per session in 7.1. Under 5.x I was able to use UNIX system accounting info, but now that the Informix engine does multiple threading, Informix shows getting all the time. Any ideas??…
RE: online crash
Assert Failed: Internal Error - Segmentation Violation ^^^^^^^^^^^^^ Assert Failed is not the error. Segmentation Violation IS!!. There are quite a few (I don't want to use the word "many") situations that will cause the engine to generate an Assert Failure. Segmentation Violat…
Error -25574 on Informix 7.1
Has anyone seen error -25574 "Network driver cannot open the network drive" on informix 7.1? Any suggestions would be helpful. Reply to matts@iqsc.com.…
informix app on network
We are considering an application package that is written with informix and are wondering if it will run on a Lantastic network? Has anyone had experience with informix on a lantastic peer-to-peer or on the new lantastic dedicated server?…
Re: 7.x, determining a unix process from a session/thread
gainer@gainer.engr.sgi.com (Patrick Gainer) writes: >In article <40aspa$f1l@oscar.cc.gatech.edu>, >Carlos Ugarte <cau@cc.gatech.edu> wrote: >>With onstat and onmonitor you can determine some information >>about each thread, but I haven't figured out yet how to determine >>what u…
Re: 7.x, determining a unix process from a session/thread
In article <40aspa$f1l@oscar.cc.gatech.edu>, Carlos Ugarte <cau@cc.gatech.edu> wrote: >With onstat and onmonitor you can determine some information >about each thread, but I haven't figured out yet how to determine >what user process is tied to that thread. Can anyone give a Bu…
7.x, determining a unix process from a session/thread
Could anyone tell me how to determine what process (the unix process) is associated with a particular thread and/or session (probably the same thing)? With earlier versions of Online, you could detect what executable was tied to an sqlturbo (or sqlexec, I guess) because both 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?…
Re: report writer(generator)
try IQ for WIndows...simple to use.... requires a network solution at this time character based version scheduled for near future…
REPLIICATION VENDORS
Does anyone know the current state of replication technology? Who has products, and what engines/networks/platforms they support, and whatever other interesting info that is current? Please also reply to (mkhomo@mcs.com)…
Re: NFS mounted database
Why use a NFS mounted database when all the database vendors have perfectly good networking products to allow you to perform the same function. NFS is definitely not the right way to go here and I am not surprised it isn't supported. NFS is a Networked File System not a Networked…
Tuxedo Mailing List
I can't subscribe the "Tuxedo Mailing List", because it isn't prossible to get the network adress of imc.com. If somebody is reading this mail, who has access to the wanted list, please send me the network - address or help me to sign on. heimo Bergler Heimo Ungerdorf 116 A-820…
<No Subject Supplied>
Does anyone know of any front end products that will allow the retreival of info from an Oracle database and bring it back to an Informix database in a clent-server relationship over a network?…
Re: ODBC with Oracle and Informix on the same server.
> To clarify this and my other posting I have been informed that the > Visionware product is actually two products. They have an ODBC > product and a network transport product, sold independently, but which > can work together. The network transport product replaces the > datab…
network security
We have a system set up with two RS/6000s, one as our database server and one as a "software server". Our users rexec a command from their PCs to run our application on the latter machine. We run I-Net and I-Star for the communications between the machines. The users have to h…
QUEL query language
Are there any QUEL references available on the network, or any books availableon the subject?…
distributed data base issue
I wonder if informix can manipulate a distributed data base in network? Or, can informix be able to place on file server and can have a several desktop computers linked to file server via lan? RonS…
Re: Bizzare sqlerror codes
In article <8817@emory.mathcs.emory.edu>, patrice@mediatech.COM (Patrice Badger) writes: |> -46 Protocol family not supported |> I don't even have error -46 |> in my Informix manual. What is it? That's because it's a Unix error that's just being passed on by Info…
Help me, BLOBbers
(This is a refinement of a previously submitted question:) I have a '386 running Unix and On-Line. Networked to this host, I have some PCs with VGA monitors. The network soft is TCP/IP. I'll run network terminals (with telnet) on the PCs, and then I'll trig a pro…