f



RE: Web Server connecting to Informix Server #2

John

Assuming you have IDS running on your web server you don't need anything
else to communicate between the two engines apart from setting up the
sqlhosts, /etc/services and .rhosts (/etc/hosts.equiv) files. You can then
update any tables from either engine. (Both databases need to have the same
logging state).
To make names easier you might want to use synonyms or views.

Keith

-> -----Original Message-----
-> From: Wilson, John [mailto:JWilson3@troy.k12.mi.us]
-> Sent: Wednesday, September 03, 2003 5:31 PM
-> To: informix-list@iiug.org
-> Subject: Web Server connecting to Informix Server
-> 
-> 
-> 
-> I am running an OLTP system with Informix 7.3 IDS on HPUX.  
-> We are considering writing some web interfaces to connect to 
-> the database.  At first we mirrored the database tables to a 
-> web server so that no one was ever touching live data.  This 
-> was relatively easy, just do a nightly export/import to the 
-> web server.
-> 
-> However, we now wish to create some "updating" web pages 
-> that will connect back to the server.  On the web server I 
-> am using PHP/MySQL/Apache for web development with the 
-> Slackware Linux v 9.0 (Linux 2.4.7) distrobution.
-> 
-> I have tried multiple times to install the Linux Client-SDK 
-> hoping that somehow I could make a ODBC connection back to 
-> the Informix server.  I have not yet been successful.  I 
-> found a company that makes an Informix ODBC driver.  I was 
-> unsucessful at getting it licensed for a 30-day trial.  I 
-> tried compiling informix libraries into PHP, but ESQL 
-> doesn't seem to be compatible with gcc.
-> 
-> What is the best way to connect the Linux web server to the 
-> HPUX Informix server?  Can anyone point me to documentation 
-> on how to do this?  I would RTM if I could find one.  Any 
-> tips, links, articles, etc would be appreciated.
-> 
-> 
-> John Wilson
-> Administrative Systems Specialist
-> Troy School District Information Systems
-> 
-> 
-> sending to informix-list
-> 

**********************************************************************************
This message is sent in strict confidence for the addressee only.  It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************
sending to informix-list
0
Simmons
9/4/2003 7:37:35 AM
comp.databases.informix 16083 articles. 0 followers. Post Follow

0 Replies
676 Views

Similar Articles

[PageSpeed] 29

Reply:

Similar Artilces:

Web Server connecting to Informix Server #2
I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server. However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution. I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc. What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated. John Wilson Administrative Systems Specialist Troy School District Information Systems sending to informix-list sending to informix-list ...

Re: Web Server connecting to Informix Server
One easy way is to use java to connect ( java driver for informix is free - ifxjdbc.jar ). If you want, you can get the relevant information here - http://www-3.ibm.com/software/data/informix/pubs/library/ Rgds Preetinder Wilson, John wrote: >I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server. > >However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution. > >I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc. > >What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated. > > >John Wilson >Admin...

Web Server connecting to Informix Server
I am running an OLTP system with Informix 7.3 IDS on HPUX. We are considering writing some web interfaces to connect to the database. At first we mirrored the database tables to a web server so that no one was ever touching live data. This was relatively easy, just do a nightly export/import to the web server. However, we now wish to create some "updating" web pages that will connect back to the server. On the web server I am using PHP/MySQL/Apache for web development with the Slackware Linux v 9.0 (Linux 2.4.7) distrobution. I have tried multiple times to install the Linux Client-SDK hoping that somehow I could make a ODBC connection back to the Informix server. I have not yet been successful. I found a company that makes an Informix ODBC driver. I was unsucessful at getting it licensed for a 30-day trial. I tried compiling informix libraries into PHP, but ESQL doesn't seem to be compatible with gcc. What is the best way to connect the Linux web server to the HPUX Informix server? Can anyone point me to documentation on how to do this? I would RTM if I could find one. Any tips, links, articles, etc would be appreciated. John Wilson Administrative Systems Specialist Troy School District Information Systems sending to informix-list This should work fine, do the esql demo programs compile OK, if they do then the following scripts should give you a fully working apache/ssl/php installation, or at least it does on our Sun ser...

RE: RE: Informix and SQL Server #2
Or you create sql/program on the informix side, dump it to filesystem. Then use DTS in sqlserver to FTP the file from informix server to sqlserver server (or somewhere sqlserver can pick it up)... And either transform the data on the way in from the flat file, or load the flat file to a "work-in-progress" table in sqlserver, then DTS/massage that working table into what you need... Not exactly a straight hook, but sometimes straight isn't the cat's meow either ;) -----Original Message----- From: Jean Sagi [mailto:jeansagi@myrealbox.com] Sent: Tuesday, February 15, 2005 5:05 PM To: Sebastian, Norma J. Cc: spinto@cap.org; wweaver@amicus.com; informix-list@iiug.org; owner-informix-list@iiug.org Subject: Re: RE: Informix and SQL Server Interesting. I saw the linked servers stuff and tried to add a new one. It seems that it could only be implemented with OLEBD and ADO. I mean I didn't see any options for an odbc data source. The only Informix providers I see are: - IBM Informix OLE DB Provider - Microsoft OLE DB Provider for ODBC Drivers (this one?) - Sybase Informix ADO Provider (I have Power Builder) Really a mini-guide on how to do this would be very helpfull. I have situations that I'm restricted to DTS or similar tools to join information from sql-server and IDS. J. -----Original Message----- From: "Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> To: "Savio Pint...

RE: Restore Informix software & Database to another server #2
Make sure you don't have any informix process still running..and grabbing memory Verify with ipcs -m Also, verify your $ONCONFIG, so that you SHMBASE goes with the release notes ( if should not impact, but you never know) If that still does not work, try reducing the SHMVIRTSIZE -----Message d'origine----- De : owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]De la part de Paul Watson Envoy� : 19 janvier, 2004 06:18 � : informix-list@iiug.org Objet : Re: Restore Informix software & Database to another server Check the release note in $INFORMIXDIR/release/*/*/ or look in the /etc/system on the working server KW Foo wrote: > > What should I check in the /etc/system ? > > Regards, > KW Foo > > -- > "Paul Watson" <paul@oninit.com> wrote in message > news:400B9841.75DB2436@oninit.com... > > Have you checked that the /etc/system on the second server is correct > > > > KW Foo wrote: > > > > > > We are trying to backup the server which includes the Informix 7.31 > > > application and the data and restore to another server. > > > > > > We are running the Informix in SUN Solaris 2.6, backup the server using > > > "ufsdump" to the tape drive and restore using the "ufsrestore" to > another > > > server (with the same directory structure and hardware). > > &g...

Re: database restore with ontape -r on Informix Online Dynamic Server #2
Paul Watson wrote: > something like > > onstat -r <<EOF > y > n > n > n > EOF > > should work, but I wouldn't use it on a production system Which is exactly the same as the example given, except for the obvious command error and the missing initial <CR> to the enter tape and press RETURN prompt. However, I am not convinced of the order of the answers, and I don't have ontape to hand to test..., on dev or prod. So I agree, simply run ontape -r and answer the prompts manually. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list ...

RE: Informix 9.4 Arcserve 11 Unable to open connection to database server
Rochelle wrote > We're running Informix 9.4 on Windows 2000 Server (sp4) with Arcserve > 11 Backup Agent for Informix. These two pieces of software > are installed on a "clean" machine (flattened and rebuilt). > Just after the Informix 9.4 software and the Arcserve agent > was installed, I ran a full backup from the Arcserve Manager > server. It worked just fine. > The DBA started tweaking the Informix server to get it ready > to import the data from our production database and now it > won't allow us to back it up any more. We get the Unable to > open connection to database server 155 (0x9b) error. I have > another clean system that I installed a similar configuration > on and it has continued to allow us to use Arcserve to back > up the database (no changes were made to the Informix server > configuration though). A couple of other notes - the > Arcserve manager resides on a separate server and all of the > servers in my configuration are workgroup (not domain) > servers. We've compared the configurations of the two > servers mentioned above and re-entered configuration data > until we're blue in the face. About the only thing we > haven't done is uninstalled and/or re-installed any of the > software. Anyone have any ideas about what might be causing > this problem? > What configuration files have you checked - Ser...

RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #2
Christian Knappke wrote > > "Colin Bull" <c.bull@videonetworks.com> wrote: > > > Here is one I prepared earlier --- > > > > onbar/ontape whatever .. > > FORCEOL=n > > until onstat - | grep "On-Line" > /dev/null > > do > > echo "Off line" # ; sleep 20 > > onstat - | grep "[BQ][lu][oi][ce][ks]" > /dev/null && ( echo > > "\nServ blokd" > > if [ x$FORCEOL = "xn" ] ; then > > echo "Onlining.." ; onmode -m ; FORCEOL=y; > > sleep 240 > > else > > echo "waiting to online " ; sleep 240 > > fi > > ) > > onstat - # for comfort factor > > sleep 60 > > done > 'onstat -' sets the return code according to the server state -> > no need for boll*cking greps... > > >From the top of my head: > 255 = server is offline ("Shared memory not initialized...") > 5 = online > 4 = some error > 0..3 = several other states like quiescent, blocked etc. (don't > know exacly) > That will make it a lot tidier, should be able to use a case statement. I will revise next week sometime. Colin Bull c.bull@videonetworks.com sending to informix-list "Colin Bull" &...

Re: Linked server informix in sql server
--0-1493394840-1190988030=:43942 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Keep in mind that linked server operates in the same way a distributed que= ry works in Informix. If using OPENQUERY, which is the only way I've been a= ble to utilize a linked server to Informix the entire result set of the que= ry executed by OPENQUERY is returned to SQL Server before the results can b= e used as a table. Put filters in the OPENQUERY call when possible to limit= the data returned from Informix.=0A=0A----- Original Message ----=0AFrom: = "rortiguela06@gmail.com" <rortiguela06@gmail.com>=0ATo: informix-list@iiug.= org=0ASent: Friday, September 28, 2007 7:45:22 AM=0ASubject: Re: Linked ser= ver informix in sql server=0A=0AOn 28 sep, 14:21, Premnath Srinivasan <s.pr= emn...@in.ibm.com> wrote:=0A> Hi,=0A>=0A> Against which database did you ru= n the coledbp.sql file ? This SQL file=0A> should be run in SYSMASTER dat= abase.=0A>=0A> And what is this error ? Please translate that to English.= =0A> Error 7399: El proveedor OLE DB 'Ifxoledbc' informa de un error.=0A> E= lproveedor no proporcion=F3 informaci=F3n acerca del error.=0A>=0A> Regards= ,=0A> Premnath Srinivasan=0A>=0A> rortiguela06@gmai = =0A> l.com = =0A> ...

Re: Running Informix on 2 different Servers in parrallel #2
Hopalong said: > Hi, everybody. Got a question for the experts. Well, I'll have a go anyway. > I have a client who runs Informix Dynamic Server 7.20 UC3 on a SCO > Unixware 7.01 box and has done for 5+ years. > > We had a disaster recovery PC of identical configuration which was > tested regularly to see if the customer's ontape backups could be > restored. > > Unfortunately the motherboard on this PC has failed and a repair would > be prohibitive, so we are looking at upgrading the disaster PC. > Unfortunately our research has found out that Unixware 7.01 is not > compatible with modern hardware and never will be as SCO no longer > support it. Herefore we must upgrade software too. > > My question is thus, what parameters are important in being able to > restore ontapes. Could we change to MS Windows 2000 Server and still be > able to restore? Could we change from using RAW DISK SPACE to > filesystems? Is just the onconfig file important or are other > parameters used? You are not guaranteed being able to restore on any other OS than Unixware. Windows is extremely unlikely to work. Raw to cooked will work, but why do you want to do that? Performance will suck. The onconfig and environment variables are both important. > Any help would be most appreciated. Thanks. Go onto ebay and buy an old PC, use that to get your data off, then migrate to a new linux box. Good lu...

RE: Informix and SQL Server #2
Hi, there's "Informix Enterprise Gateway Manager" (as others have already suggested), but as far as I remember, it provides to Informix (server or applications) access to other databases, but not the other way round. I.e. it cannot let SQL Server make a connection to IDS. At least my understanding of it. For more info check out http://www.ibm.com/software/data/informix/tools/egm/ Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 14.02.2005 22:41:43: > Nobody seems to want this one! Please, if anyone can help I would really appreciate it! > > Thanks! > > Bill Weaver > Director of Engineering > Amicus, Inc. > 512-531-3463 (office) > 512-531-3401 (fax) > -----Original Message----- > From: William Weaver [mailto:wweaver@amicus.com] > Sent: Thursday, February 10, 2005 4:03 PM > To: 'informix-list@iiug.org' > Subject: Informix and SQL Server > > > It?s been a while since I?ve been in the Informix world (sigh) as I?ve been working lately > with a Sybase database (yuck!) so I need some help getting back into things with Informix. > > I have a client who needs to connect a Microsoft SQL Server database to an Informix database. > What is the best driver for this in terms of both speed and data type conversion? > Of special concern is Informix d...

Re: Difference between Informix connect and Informix Client SDK #2
Hi Francisco. Client SDK is a developer's kit. You can create and compile program using ESQL/C (it is bundled.) Connect is a runtime of Client SDK. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Francisco Roldan <froldan@5b.com.gt> >To: informix-list@iiug.org >Subject: Difference between Informix connect and Informix Client SDK >Date: Tue, 8 Jul 2003 12:18:35 -0600 > >Does Somebody would tell me the difference between >those Informix products? > >And the estimated cost of each one (for Linux) ? > >...

unixODBC connection to Informix db
I get the following error [informix@kylie bin]$ ./isql -v pic2 [S1000][unixODBC][Informix][Informix ODBC Driver][Informix]Client host or user informix@localhost.localdomain is not trusted by the server. [ISQL]ERROR: Could not SQLConnect [informix@kylie bin]$ I am logged on as user informix. I am on the same machine as the database and datasource. Does anyone have any ideas? Note I have 64bit IDS and the datasource is using 32bit libraries Hi, Can you possbile rlogin without password ? ie) Good case [tsutoo@urraco ~]% rlogin cspc08 Last login: Thu Jul 20 10:36:16 from tky019 [tsutoo@cspc08 ~]% Bad case [tsutoo@urraco ~]% rlogin cspc08 Password: If you will see "Password:" prompt, add your machine in $HOME/.rhosts. Then try again. Just my $0.02. -- Tsutomu Ogiwara from Tokyo Japan. >From: "kjuliff@gmail.com" <kjuliff@gmail.com> >To: informix-list@iiug.org >Subject: unixODBC connection to Informix db - user informix not trusted >byserver >Date: 19 Jul 2006 14:42:17 -0700 > >I get the following error > >[informix@kylie bin]$ ./isql -v pic2 >[S1000][unixODBC][Informix][Informix ODBC Driver][Informix]Client host >or user informix@localhost.localdomain is not trusted by the server. >[ISQL]ERROR: Could not SQLConnect >[informix@kylie bin]$ > >I am logged on as user informix. > >I am on the same machine as the database and datasource....

Re: RE: Informix and SQL Server
>Nobody seems to want this one! I assume this is for you mime posts. Informix has a product called "Informix Enterprise Gateway Manager", look for it at www.informix.com under the "tools" categorie. Have in mind that it has its own cost. Maybe another one here knows of a way to do a distributed query between an IDS database and a Sql-Servero one. J. -----Original Message----- From: "William Weaver" <wweaver@amicus.com> To: <informix-list@iiug.org> Date: Mon, 14 Feb 2005 15:41:43 -0600 Subject: RE: Informix and SQL Server Nobody seems to want this one! Please, if anyone can help I would really appreciate it! Thanks! Bill Weaver Director of Engineering Amicus, Inc. 512-531-3463 (office) 512-531-3401 (fax) -----Original Message----- From: William Weaver [mailto:wweaver@amicus.com] Sent: Thursday, February 10, 2005 4:03 PM To: 'informix-list@iiug.org' Subject: Informix and SQL Server It's been a while since I've been in the Informix world (sigh) as I've been working lately with a Sybase database (yuck!) so I need some help getting back into things with Informix. I have a client who needs to connect a Microsoft SQL Server database to an Informix database. What is the best driver for this in terms of both speed and data type conversion? Of special concern is Informix date variables to SQL Server native datetime. Than...

Re: Informix Dynamic Server and DB Tuning #2
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 situation, in fact some applications now take much longer. Before adding buffers check your memory usage for the whole day. If ther are times when you are already memory bound then proceed with caution. regards Malcolm --- Muthana <muthana@gmx.de> wrote: > 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 > sending to informix-list ...

RE: java app shuts down Informix Server #2
Mel, if what you're seeing looks like this: 07:00:42 Assert Failed: No Exception Handler 07:00:42 IBM Informix Dynamic Server Version 9.40.HC2 07:00:42 Who: Session(10, informix@myserver, 0, ce9ed5a0) Thread(15, btscanner 0, ce9bd26c, 1) File: mtex.c Line: 431 07:00:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem 07:00:42 Action: Please notify IBM Informix Technical Support. 07:00:42 stack trace for pid 28311 written to /tmp/af.3f72478 07:00:42 See Also: /tmp/af.3f72478 Assertion Failure Type: CRASH Host Name: myhost Database Server Name: myserver Time of failure: Sun Dec 7 07:00:45 CST 2003 AF file: /tmp/af.3f72478 Shared memory file: None System Blocking: OFF 07:00:59 mtex.c, line 431, thread 15, proc id 28311, No Exception Handler. 07:01:00 The Master Daemon Died 07:01:00 PANIC: Attempting to bring system down 07:01:00 semctl: errno = 22 07:01:00 semctl: errno = 22 07:01:00 semctl: errno = 22 07:01:01 semctl: errno = 22 07:01:01 semctl: errno = 22 It could be this bug: Bug: 163521 ASSERT FAILED: NO EXCEPTION HANDLER WHEN RUNNING DQUERIES STRESS TEST -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Thursday, December 18, 2003 1:50 PM To: informix-list@iiug.org Subject: Re: java app shuts down Informix Server Mel Haynes Jr wrote: > Hi all, > > I am getting ...

Re: Running Informix on 2 different Servers in parrallel
Neil Truby said: > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:41BF66EE.1090103@bloomberg.net... > >> Don't go windows, you already know UNIX, go with Linux. There are many >> excellent releases of Linux and IDS runs very well on them. You will >> not >> be able to get IDS 7.20 (which BTW is very old, out of support, and not >> even Y2K compliant). But you could build the new server, port >> everything >> there, and make that the new main box while building a new backup box, >> also running Linux. I'd recommend going to IDS 9.40UC5 or later. > > As a matter of interest, now that IBM has extended the end-of-support to > v7, > why would you recommend a user on a very old version of v7, by all > accounts > not very innovative, move to v9? Not saying your wrong but one of my > users > asked me the same question today: "Why should I move to v9 if I'm happy on > v7?". "To help pay for my holiday in The Maldives" is the actual answer, > but didn't seem politic, so I said I'd think about it. Thing is, I'd like > to sure I'm not missing anything before replying. For a user who is > comfortable with v7, does not want to use user-defined datatypes or > datablades (in my experince, 90%++ of them), and whose database is modest > enough in size that the 2G chunk limit is not a...

Error executing remote system command on an AIX Informix database from an NT Informix Server
Dear All, I realise there are many queries and answers already posted on a similar topic, but none seem to be able to get this working. I have two informix servers, one on Windows NT and one on AIX 4.3. Informix NT (7.31) Informix AIX (7.xx) I have a stored procedure on the unix box with a system command SYSTEM '/usr/bin/ksh /usr/bin/env > /tmp/mylog' I have set up the trust, so that I can connect to the AIX instance as informix from the NT server. I connect from the NT server to the AIX instance as informix and execute the procedure. I get the following error - 668 Command cannot be executed 127 No Primary Key I think that the 127 error number is from the shell execution. The /tmp/mylog file is created but with no values. Even if I replace it with an echo hello command I get an empty file. Having read one of Jonathan Leffler's responses, the SHELL environment variables needs to be set to the the Shell of the remote system. In my case that is 'set SHELL=/usr/bin/ksh' . I did this and it still didn't work. Am I missing further environment variables as I am executing the procedure from NT. Has anyone managed to do this? Many thanks in advance, Nick Have you tryed it on aix itself?? does that work?? try: SYSTEM "(/usr/bin/ksh /usr/bin/env 2>&1) > /tmp/nonexistingfile"; -- check what is in nonexistingfile or SYSTEM "(/usr/bin/ksh ...

Re: Running Informix on 2 different Servers in parrallel #5
scottishpoet said: > My alter ego was called many things in the past, but and Informix God?? Why not? You have the body of a god: Buddha! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list ...

Re: Running Informix on 2 different Servers in parrallel #3
Neil Truby said: > "Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message > news:10s070nqi9utl9f@corp.supernews.com... >> Obnoxio The Chav wrote: >> >>> Speed? Better diagnostics (I mean much, much, *much*, _*much*_ better >>> diagnostics)? New features? I mean, would you advocate that someone who >>> was happy on 7.23 stayed there if 7.31 was available? Even if you >>> discount >>> large chunks and extensibility, there is a load of new stuff in the 9.x >>> code stream. >> >> An upgrade to 7.31 from 7.23 is free, if you have support. An upgrade to >> 9.x from 7.x is not. Also 7.23 is not supported, 7.31 is. >> >> I agree with you on the speed and diagnostics and maybe these might be a >> good enough response to the "why should I /pay/ for this upgrade?" >> question. > > Is "these might be" good enough when the uplift is �60k or more ? It depends. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, &qu...

Re: Running Informix on 2 different Servers in parrallel #4
malcolm weallans said: > Speed???? > > Now you are having us all on. Are you really saying > that 9 is faster than 7? 9.4 maybe but I have a > number of customers who swear that SE is faster than > 9.3. Everybody's mileage may vary. All my 7.31 clients who upgraded to 9.3 found a performance increase. All my 7.31 and 9.3 clients who upgraded to 9.40 found a performance increase. What do you expect me to say? :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list ...

Re: Database Server Hangs / Perl DBD Informix Module
I found a solution, It worked well with tcp connections, Looks like perl's Informix DBD Module doesn't like shared memory connections,at least with my versions. But I can live with tcp connections. Thanks anyway. I have other question , Does anybody knows how to actually get the number of rows returned/affected in a query with perl ? I tried with : $nrows=$sth->rows(); always returned 0. $nrows = $sth->{ix_sqlerrd}[2] always returned 0 too. Any ideas ? ----- Original Message ----- From: "Francisco Roldan" <f_roldan@admcentralagricola.com.gt> To: <informix-list@iiug.org> Cc: "Jonathan Leffler" <jleffler@earthlink.net>; <jleffler@us.ibm.com> Sent: Wednesday, May 12, 2004 9:12 AM Subject: Database Server Hangs / Perl DBD Informix Module > Hi everybody, > I have > Informix Dynamic Server Version 7.30.UC11 > on Red Hat Linux 9 > perl v5.8.0 built for i386-linux-thread-multi > DBI 1.42 > DBD Informix 2003.04 > > After installing perl's DBI and DBD Modules for Informix I > finally get a script to connect and disconnect to the database . > But after running the script several times (that only connects and > disconnects to the database ) , the server hangs and it does not let to > connect to any database > with the message : 25588: The appl process cannot connect to the database > server > Restarting the server f...

Re: Restore Informix software & Database to another server
KW Foo wrote: > We are trying to backup the server which includes the Informix 7.31 > application and the data and restore to another server. > > We are running the Informix in SUN Solaris 2.6, backup the server using > "ufsdump" to the tape drive and restore using the "ufsrestore" to another > server (with the same directory structure and hardware). > > We use "ufsdump" to backup the informix software and also all the Informix > chunk directories after we shutdown the Informix using "onmode -ky". > > We also did an "ontape" level 0 backup to a tape. > > After we restore the application and the Informix chunk directory, when we > try to start the Informix engine using "oninit", the server go into "FAST > RECOVERY" mode, after few minutes, it display message "oninit: Fatal error > in shared memory initialization". > > > The following are the message recorded in the online.log: > > 13:41:32 Informix Dynamic Server Initialized -- Shared Memory Initialized. > 13:41:32 Physical Recovery Started. > 13:45:16 Physical Recovery Complete: 84946 Pages Restored. > 13:45:16 Logical Recovery Started. > 13:45:16 shmget: [ENOMEM][12]: key 52564806: out of shared memory, check > system > max shared memory segment size > 13:45:16 out of virtual shared memory more available shared memory...

Re: Looking for a copy of informix 7.2 dynamic server
Assuming you want it for testing/learn purposes you better get ids 9.3/9.4 from iiug. Even you could get the new 10.0 from informix.com. J rbl wrote: > Hi, > > does anyone here have a copy for windows/unix that they'd like to barter > for? I'm assuming that since it's been de-supported and de-marketed by > IBM, it should be ok now. If not, apologies. > > rb > > sending to informix-list Yeah, but unfortunately I need to test specifically against 7.x for compliance reasons. There are some very large institutions that are still using it and won't budge. rb Jean Sagi wrote: > Assuming you want it for testing/learn purposes you better get ids > 9.3/9.4 from iiug. Even you could get the new 10.0 from informix.com. > > J > > > rbl wrote: > >>Hi, >> >>does anyone here have a copy for windows/unix that they'd like to barter >>for? I'm assuming that since it's been de-supported and de-marketed by >>IBM, it should be ok now. If not, apologies. >> >>rb >> >> >> > sending to informix-list > ...

Web resources about - RE: Web Server connecting to Informix Server #2 - comp.databases.informix

Connecting rod - Wikipedia, the free encyclopedia
In a reciprocating piston engine , the connecting rod or conrod connects the piston to the crank or crankshaft . Together with the crank, they ...

COVER BOY: Dec. 15 Issue of ‘Time’ Features Mark Zuckerberg on Connecting the World
The cover of the Dec. 15 issue of Time features a familiar face — that of Facebook co-founder and CEO Mark Zuckerberg , the star of a long feature ...

Digital Media Wire - connecting people & knowledge —
dmwnews : Anomaly, the ambitious graphic novel by Brittenham and Haberlin, features augmented reality. http://bit.ly/Iwrxjr Already optioned ...

Connecting People to Brands and Products on Mobile
People come to Facebook not only to connect with friends and family but also with products and brands. Here's how we're making it easier to list ...

What stops users from connecting with an app through Facebook?
... This equals 850 million users who connect with apps using Facebook at a 59 percent conversion rate. About 590 million users back out of connecting ...

Home - WHLT 22 Connecting the Pine Belt Fan
Facebook is a social utility that connects people with friends and others who work, study and live around them. People use Facebook to keep up ...

US IT Staffing Recruiters Group - Connecting Ideas !
US IT Recruiter's Groups: IT Technical Recruitment. Its all about connecting to new Ideas !

Cold Christmas Bubbles - A Cool Connecting Dots Puzzle for Kids on the App Store on iTunes
Get Cold Christmas Bubbles - A Cool Connecting Dots Puzzle for Kids on the App Store. See screenshots and ratings, and read customer reviews. ...

Connecting a Relay to Arduino - Flickr - Photo Sharing!
Simple circuit to connect a 5V relay to one of the digital output pins of the Arduino. I drew this after a few threads showed up on the Arduino ...

Evidence Connecting Scott Roeder to Operation Rescue Found in Roder's Car - YouTube
Rachel Maddow unveils video evidence from KMBC TV in Kansas City of a note found in Scott Roeder's car at the time of his arrest for the murder ...

Resources last updated: 3/3/2016 12:26:10 AM