Oninit® Archive
Results for “DRDA_COMMBUFFSIZE”
DRDA redirection to HDR primary
I was recently unable to work out how to do this directly on latest IDS 14.10. I am about to write a technical article on a work-around using Connection Manager, but that involves more effort and failure points. Does anyone know how to construct a DRDA client configuration so tha…
Cannot connect to Informix database via Python
Yep, 30081 I know as DRDA connection error (https://www.ibm.com/docs/en/db2/11.5.x?topic=errors-sql30081n-tcpip-communication), which is quite expected if there's no DRDA port/listener configured. -> you'll need another listener (DBSERVERALIASES entry) in your onconfig and a rela…
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 ------------------------------…
Is it possible to import the copy made with ontape from one database to another PC?
I believe even in 7.31 versions, a sqlhosts file was needed, independent of the platform. Informix is mostly dependent on some environment variables which point to the location of the informix base dir, the onconfig file (if deviating file name) and so on. Honestly, I never insta…
HDR shutdown and Restart
Just a side issue: You should ONLY use DRAUTO set to 2 if the network connection between the primary and secondary is ABSOLUTELY reliable to avoid the possibility of suffering from the "two brain problem". It is better to use Connection Manager to handle upgrading a secondary aut…
DRDA w/SSL
Has anyone here had any luck getting a client connected to Informix using the IBM DRDA protocol over SSL? I opened a case on this some months ago and the DB2 and Informix sides of the fence just kept punting back and forth. Setting up a drsocssl listener on the engine side is sim…
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…
Connection Manager Redundancy with DRDA Connection
I have two Connection managers configured with two SLA entries using REDIRECT, one for the native SQLI connection (onsoctcp) and one for DRDA connection (drsoctcp) connection to just on IDS for testing. Everything looks good between the connection managers and the IDS. When I tes…
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…
Remote database access
Hi Fernando, From the first link " Gateway Manager connects the Informix environment with that of any shared-library ODBC Level 2-compliant driver manager and driver on UNIX or Linux. For instance, you can use Gateway Manager with the IBM Informix Enterprise Gateway driver prod…
.Net Entity Framework with Informix
Well, 'DB2' is what you're after in this case .... seriously :-S This was called 'common driver', for any server speaking DRDA, and guess who had picked the DB2 name space for this. You need to have a DRDA port configured on Informix server side. From: "ANDREW KELLY" <andrewpet…
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.…
Authentication with certificates
Hi Jochen, sure there is: you may want to start your search with 'onsocssl' protocol (or drsocssl for DRDA connections), e.g. in Knowledge Center. http://informix-zone.com/files/newsletter/INFORMIX_NL_201507.pdf might also be a good (German language) entry point. Andreas From…
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…
Multiple DRDA setup
Hi Gurus, I'm trying to test JDBC (onsoctcp) and DRDA (drsoctcp). JDBC works fine using jdbc.url = jdbc:informix-sqli:DATABASE=DBname;INFORMIXSERVER=Instance;SQLH_TYPE=FILE;SQLH_F ILE=/opt/informix/etc/sqlhosts; Is it possible to do the same for DRDA? I can test via testconnec…
Issue in transactions with informix using DRDA
Hi, My environment: Informix 11.70 FC8W1 in HPUX 11iv3 64 bits. Anybody knows how to use a distributed transaction in Informix with DRDA. For example: Instance 1, database db1: create table "informix".rviweb ( a integer ); Instance 2, database db2: create table "informix".…
drsoctcp not in the list of protocols in CSDK
Hi IIUG, I am planning to use DRDA protocol to connect to informix database 12.10. The database itself supports the DRDA but what I noticed is drsoctcp is not listed in ODBC (IBM CSDK). only drsocssl is the only DRDA related protocol available. Question: is there any Informix C…
DRDA issue via Connection manager
Hi Gurus, Need help in coniguring the Connection Managers using DRDA. We've already setup but it's failing. Can someone please analyze the below configuration we used? Client sqlhosts configuration ====================== # INFORMIXSERVER ifx_cluster group - - i=10,e=svru2bqaqt…
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)…
Informix and DRAD
Just wondering if any-one out there has much experience with Informix connectivity using DRDA. Our company is considering using this protocol. Are there any performance issues or gotchas that people might have experienced? We are running IDS 11.70.FC6 on AIX Servers. Thanks i…
IDS / OS400 DRDA
Hi, i tried to send some requests between OS400 and IDS (11.50FC9, AIX6.1). I succeed from OS400 to IDS by configuring a drsoctcp server alias and modifying CCSID on OS400 side. But i didn't succeed from IDS to OS400. Does anybody know what to do ? Is there another product to in…
dbaccess with drsoctcp???
Original post: Hi Folks, IDS 11/70.FC8GE Linux 2.6.32-358.el6.x86_64 Is it possible to connect to the database using dbaccess while using a drtsoctcp connection? If so what do I need to do? thanx, dan Reply: I think the answer is no, since drsoctcp is a DRDA protocol and db…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
IBM Data Server Provider - Db_Locale/Client_Locale
Good morning, I am developing new applications using VB.NET and IBM Data Server Provider v. 10.5 connected to IDS 11.70.FC8GE using DRDA protocol All the databases are localized in en_US.819 Previously, with older informix driver, I used SETNET32 to set DB_LOCALE and CLIENT_LO…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
How to connect .NET webservice with Informix
I am looking to develop a new webservice using .NET, which will use Informix DB. So I wanted to know that is best to use the "IBM Data Server .Net provider" for it or there is any other better alternate to it as well. Because, to use the "IBM DATA Server .NET Provider", i will …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
db2 JDBC - connect to informix
Thanks Art , I forgot to mention before... I desire avoid include a drda listener, what I believed isn't possible. Right? On 7/12/2012 17:44, Art Kagel wrote: > You can certainly connect using DB2s DRDA protocol and the DB2 JDBC > driver. You will have to configure an sqlhosts …
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,…
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
original post: 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…
Help with: System.ArgumentException in IBM.Data.Informix.TypeMap.FromSqlType(SQL_TYPE sqlType)
Thanks Raj, i was using 3.70 until i unistall to try 3.50 and see if problem goes away, buy yet in both always using IBM.Data.Informix provider. Questions: with this driver and DRDA protocol: Is other provider ? what is his name ? there is any pdf with the reference ? I have:…
Use of DRDA (EGM or IDS 11.5?)
Hello, I have some questions regarding the connection between IDS 11.5 FC6 and DB2 z/OS V9. We have a client application that is accessing some dozen Informix databases hosted on two unix servers. The same application is also sending Queries via CICS to one of 15 different DB2-…
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…
kerberos and LDAP with DRDA
Hello: We are trying to configure our Informix Server 11.70 installed in RedHat 5 to validate users against a Windows Active Directory. First, we did it using PAM, and then we tried SSO using kerberos, and both worked. We used the following configuration in sqlhosts: olpam onso…
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.…
PHP and Informix?
Dear Informixers, it's been a long time since I've been active in this group. Our IDS server is just running smoothly, so I didn't need assistance. But now something new has come up: We have a web application in_house that our department wants to participate in. The application…
Slow communication performance of Informix 11.50
This simple SQL job has been running in our current 9.40 production environment for years. It moves data at about 6000/rows a second so I assumed it was opening one connection and moving the data then closing the connection. The open/close connection theory is something we have i…
Re: likely database privilege problem
Hi TJ, Here is the information to capture DRDA trace output from IDS server: 1) Open an IDS Command windows 2) Cleanup DUMPDIR output cd $DUMPDIR delete all files at $DUMPDIR FYI: By default the DUMPDIR may be set to $INFORMIXDIR\\\\tmp You can find this by scanning the oncon…
Re: likely database privilege problem
Hi TJ, The instruction you followed to setup the DRDA listening port on IDS se= rver is the right one. I would like to take a look on trace output captured from client and I= DS server. I will soon send you the information to capture the DRDA trace output f= rom IDS server. Mea…
11.70, drda & ldap
Hello, did anybody install 11.70 with ldap authentication and connect client with drda? I installed 11.70, ldap and users can connect with "normal" sqli (with PAM), but I can't configure drda access. Does anybody have cookbook or something similar? Regards, Hrvoje…
network errors
We don't have a definitive answer, but it is a reverse DNS lookup problem. The majority of Informix's reverse lookup requests were timing out with the DNS servers so it would wait and repeat and if still failed, put them back to the bottom of the queue to try again. We added our…
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…
Perl:DBD compile with support for DRDA
Has anyone done this? We are working on this so that we can get our perl to support the new connection manager. David Link…
RE: Any Mac IDS users out there?
Yes. You need an adapter or whatever its being called to make an objective-c call from a Mac OS app. Since IDS runs native on a Mac, one would expect that such an adapter exists and is supported by IBM. So the question is... is the mac os/x adapter to native IDS, or DRDA since …
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
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…
IDS 10.00 maximum concurrent sessions
First, you CAN limit the number of concurrent shared memory connections. Since the communications blocks that shared memory connections use and the semaphores that protect them are allocated when IDS starts up, the number of available connections via shared memory is fixed at sta…
RE: informix drivers
> From: RHabichtsberg@arz-emmendingen.de > To: informix-list@iiug.org > Subject: informix drivers > Date: Thu, 18 Feb 2010 10:19:06 +0100 > > Hi all, > > some folks here argue that in future IBM would drop the support of Informix > drivers like PDO_INFORMIX for the benefit of db2…
Re: informix drivers
Not likely. The DRDA drivers are better (faster) working with .NET than the native SQLI interface is, but in general, the SQLI interface is more flexible and more capable, so it's not going anywhere. DRDA was installed mainly to help convince IBM's tools and product groups to t…
Zend Framework and PDO_INFORMIX
Hi all, is there any way to avoid using PDO_IBM and DRDA with Zend Framework. Instead I would prefer to use PDO_INFORMIX and i-connect (is it i_net?). Any chance? Reinhard.…
Restricting Connection to Informixservers
Sorry to top post... If I understand your question... You use a single web app user id to connect all of your web application servers to the database. (Not a good idea, you may want to consider a single id per web app server.) But your problem is that anyone who knows the web …
Re: CDR connect error
Yeah, something is going on in the network. Perhaps the two machines are on separate segments and the switch/router between the segments is getting errors. Good luck. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in m…
RE: CDR connect error
Yes, Art, that's absolutely possible. Had have similar problems with HPL while transfering data through named pipes to the server grp_db5. Although, the serverhosts are all in the local network with 1000 Mbps (dmesg: link up 1000Mbps Full-Duplex). Must ask our network specialist…
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…
Re: can't connect to database with client
"Robert" <robsosno@gmail.com> wrote in message news:99b51f1c-549b-4326-a7a8-b45cf72ccf88@j4g2000yqa.googlegroups.com... >> > Hello, >> > I'm new todb2. I haveInformixdatabase on AIX and ODBC application >> > on Windows. I'm trying to connect toInformixdatabase using odbc >> > cli…
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: DRDA and Informix 11.50
Hi, Here are my answer: - Is this information correct? Do we need pdo_ibm and DRDA support if we develop with the Zend framework? Yes. - if so, is it enough to install DB2 Client v9.1 or later on the client and modify onconfig, sqlhosts and /etc/services with a drda alias and …
RE: DRDA and Informix 11.50
This is the bad thing. First, there are IBM supported ways of getting connected to the database and then there are non IBM supported ways of getting to the database. IBM 'supports' native Informix connectivity and DRDA connectivity. Because IBM supports both Informix and DB2, …
RE: DRDA and Informix 11.50
> Habichtsberg, Reinhard wrote: > > Hi all, > > > > our php developers claim they need DRDA support to connect > to IDS 11.50. > > Development platform is the Zend framework. The databases > classes would use > > pdo_ibm instead of pdo_informix. > > > > - Is this information corr…
DRDA and Informix 11.50
Hi all, our php developers claim they need DRDA support to connect to IDS 11.50. Development platform is the Zend framework. The databases classes would use pdo_ibm instead of pdo_informix. - Is this information correct? Do we need pdo_ibm and DRDA support if we develop with th…
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…
RE: Writing into Files from Stored Procedures
What about using ER ; it's free (builtin) and works quite happily with unreliable network connections (ie: it's queue-based replication) and it's pretty simple to implement. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] O…
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 …
Enabling DRDA
I'm trying, without success, to enable DRDA on Informix 11.10.UC1 running on SuSE LINUX. In sqlhosts I have a line for it: BARDRDA drsoctcp 192.168.1.60 9502 In onconfig I have both a NETTYPE and an ALIAS: ... DBSERVERNAME BARNET # Name of default database server DBSERVERALIASE…
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…
Gateway ...
Peter_Logan@spartanstores.com wrote: > Can anyone give me there impressions of the gateway products ... I need > to get a bunch of IDS data into DB2 on the mainframe ... and back to IDS > .... Developers are wanting to look at IDS data from DB2 and vice versa > .... > > IDS ... 1…
Re: connecting to Informix 11.5 from .NET error
> > "If you receive error 23104 when accessing the server through the DRDA protocol, the client application might be trying to bind a value that has a different encoding than the database locale. Set the environment variable GL_USEGLU to 1 before you start the Dynamic Server. Thi…
Informix Brand?
> From: david@smooth1.co.uk > Subject: Re: Informix Brand? [SNIP] > > Do you think we will ever be able to convinve IBM to restart XPS? > No. > How else can Informix compete against DB2 DPF/Sybase Cluster Edition/ > Oracle RAC? You bring the feature/functionality in to IDS. Th…
Re: NetBeans anyone?
Ian Michael Gumby wrote: > since I thought it was IBM's goal to use DRDA as the interface in to > *all* of their products. (It is still being called DRDA, right?) > DB2, IDS and Derby/Cloudscape support the DRDA protocol. Sometimes you may find references to Common Client. IDS …
Re: NetBeans anyone?
Ian Michael Gumby wrote: > > So what would it take for someone from the Lab to update the wiki page > with the correct information for IBM's IDS database and their > 'universal' drda drivers? Why don't you ask them? Why are you asking us? Personally, I'd rather IBM sorted out t…
NetBeans anyone?
Hey! I know that most of the readers in this group are DBAs and not app developers. I know that IBM Rationals RAD (Rational Application Development) tool is built on Eclipse. But there are others IDEs like NetBeans. If you are a developer, NetBeans IDE is nice. Really nice, and…
Informix Virtual Appliance
> Date: Sun, 19 Oct 2008 22:33:39 -0700> From: indeep@indeep.com> BTW I don't see DBD::Informix in that stack... might want to add that> into the next release... I believe that with Perl, Ruby, etc ... you're going to see the API written to DRDA standard. One interface, two datab…
Has anyone had any luck getting PDO_IBM to work?
Obnoxio The Clown wrote: > Kristof Benes said: >> We havent and theres no examples or documentation to be found. Someone >> in this newsgroup claimed to have figured it out last month but didnt >> give any examples. We would like to use Informix with Zend Framework. > > Not bei…
Re: PDO_IBM with IDS 11.5
Hi Could you list an example of your PDO_IBM connection string? I have been struggling with this, too. Thanks Brad On 4 Oct 2008, at 00:08, JaxenT wrote: > I found the information in the admin guide chapter three. Under > Distributed Relational Database Architecture (DRDA) …
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…
PDO_IBM with IDS 11.5
I found the documentation to make the connection. It is in Chapter 3 of the Admin guide in the Distributed Relational Database Architecture (DRDA) section.…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Informix Enterprise Gateway Manager with DRDA
Hello, In trying to connect an Informix-4GL or ESQL/C program to DB2 on an MVS mainframe, we are going to use Informix Enterprise Gateway Manager with DRDA version 7.31. Are there any "fast start" or "best practices" guides (other than the lengthy and verbose User Manual)? Are t…
Recover Informix JDBC connections in Tomcat after loss of Network Connectivity
Jason P wrote: > Hi everyone. My application makes use of Informix, Oracle, SQL Server > and My SQL. Of all these databases, whenever my web server loses > connectivity with a database server, only the Informix connections do > not recover. For all the other databases, restori…
Informix DRDA connectivity to DB2
Using the new DRDA gateway functionality in IDS 11.1 is it possible to connect to a DB2 database from IDS ?…
Informix DRDA Gateway Issue.
We are trying to get our Informix DRDA Gateway working. We were able to copy the directories and files from one server to another, but we are getting the following error messages. We're running gateway version 7.31UD1 on Solaris 10: -29087:Network protocol communication error. …
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…
ODBC connections iffy after new kernel
Hi, Maybe any of these ideas help: - At the O/S level (HP-UX) of the Informix server machine: Check for kernel parameter settings related to network/communications (specially TPC/IP parameters) and sockets (such as NOFILES --number of open file descriptors), and check for upgra…
RE: in search of Informix metadata
On Sep 26, 2:35 am, "Obnoxio The Clown" <obno...@serendipita.com> wrote: > Jesse said: > > > One other question. Is it possible to change context from one > > database to another in the same connection? > > > In SQL Server you can issue a USE statement to change context. Or > >…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: Constant online log errors on all servers
>> the problem started at exactly the same time on exactly the same day on all 3. So what was different about that time/day than the others? Did some new process start running at that time? Did a new user process start accessing one of the DBs at that time? I think since …
RE: Constant online log errors on all servers
Poor you.... DB guy stuck in the middle. Oh the fun of "defending the database" ;) Look into this free download product to help you sniff around and watch the traffic: http://www.ethereal.com/ what does your sqlhost file look like, assume these errors are all coming via netwo…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Error 908 - Connection Refused on remote server
I was able to get this working yesterday. After installing the client SDK I did some testing with the ILoginDemo and DBPing utility. The messages they generated helped point me in the right direction. I did some double checking and realized that I had some differences between …
Re: Error 908 - Connection Refused on remote server
Juan Singh wrote: > First, are you confident that you have network connectivity? Try the > following > > telnet RemoteIPAddress RemotePort > > Note, the remote port usually is 1526 > > If you see a blank screen that means you have connectivity. > > Do you have to use DBAccess? I …
Question about Keep-Alive Option
I copied a paragraph from Admin Guideas following, IBM Informix Dynamic Server Administrator's Guide Previous Page | Next Page | Index The Database Server > Client/Server Communications > The sqlhosts Information > Connectivity Information Keep-Alive Option ...................…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Enterprise Replication error when attempting to delete a replicate
Bugs, bugs and more bugs, IMHO. Did you recently try to use the alter facilities that ER now provides? If so according to tech support it is riddled with bugs prior to 10.00.FC5. I was told to destroy my ER environment and rebuild it from scratch when the shadow tables would not…
Enterprise Replication error when attempting to delete a replicate
Hello, When attempting to delete a replicate, the following error is raised: $ cdr del repl r_bln_db_b0400_db_sk57 command failed -- Attempt to perform invalid operation including shadow replicates (122) Additional info: ----- onstat - IBM Informix Dynamic Server Version 10.0…
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: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: IDS Feature Request List (including potential new requests).
On 5 Jan 2006 22:58:31 -0800, "J�rgen Buck" <juergenb@buck-consulting.de> wrote: >david@smooth1.co.uk schrieb: > >> I will ask but I can't see this happening. Certainly on the Informix >> side. >> >> IBM charge you for this. Why would they want to give it to you free? >> OR I …
AW: IDS Feature Request List (including potential new requests).
My most important Feature Request is: DRDA Connectivity from Informix-> DB2 LUW Informix -> DB2 zOS DB2 LUW -> Informix DB2 zOS -> Informix without using additional products like Infomix Gateway for DRDA, or a Wrapper in DB2 Regards Jürgen…
Re: HDR over secondary network
MMarks wrote: > On Thu, 22 Dec 2005 17:55:56 -0500, "Art S. Kagel" > <kagel@bloomberg.net> wrote: > > >>MMarks wrote: > > >>OK, post the sqlhosts entries for the two servers and the exact onmode >>command you are trying to use to initiate HDR. >> > > > on srvA: > > srvA onipcshm …
Re: Informix Gateway with DRDA connection to V5R2 iSeries...
You need to search the DB2 messages documentation for what DB2 iSeries SQLCODE -204 stands for. That will tell you what is the problem on DB2 Thanks, -Manas On 12/17/05, iSeriesDude <nowhere@nowhere.com> wrote: > > The exact error message is, > > -29000: Application Server erro…
Re: Informix Gateway with DRDA connection to V5R2 iSeries...
Hi, Can you provide more information as to what is the message text of SQLCODE -29000? The Gateway is designed such that any errors returned by DB2/iSeries are encapsulated inside Gateway SQLCODE -29000 Thanks, -Manas On 12/16/05, iSeriesDude <nowhere@nowhere.com> wrote: > >…
Informix Gateway with DRDA connection to V5R2 iSeries...
Looking for some details on what is necessary on the AS/400 side to support Informix? We have a Unix server running Informix Gateway with DRDA that is trying to connect to the system however we keep getting this generic -29000 error and I can find no good documentation detailing …
Re: Connecting (IConnect) Solaris machine to a Linux server
On 11/29/05, Art S. Kagel <kagel@bloomberg.net> wrote: > Rupan3rd wrote: > > Hi there, I have a question for you smart guys. > > > > I have Sun Solaris 9 machine where Informix IConnect 10.0 is installed. > > The machine should make use of the database server (IDS 10.0) installed…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
RE: IDS Next Version - features wanted.
Really exists! Informix Enterprise Gateway. and Informix Enterprise Gateway for DRDA (Mainframe). They both work very well and we have been using the DRDA for over 7 years. We create a synonym in the Informix database and the end user does not know the difference. FYI…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
windows NT to unix AIX federation
On Windows: In db abc: 1. create wrapper drda (LIBRARY LIBDB2DRDA.a not available in windows box) 2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA" AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' ); 3. If the above steps are through, probably user …
RE: Mysterious sql problem
Expanding the term "environment" even further..... What's your server doing during this time? How long has it been up? Perhaps a reboot has activated something at the server level (which may have been a recent change or something done a long time ago/needed a reboot/never got o…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Informix Network Connection
So do I. "Lello, Nick" <Nick.Lello@nielsenedi.com> wrote in message news:c2vte7$r5e$1@terabinaries.xmission.com... > > Thomas, > > I believe the correct network connection type for linux is tlitcp not > soctcp. > > > -----Original Message----- > From: owner-informix-list@iiug.or…
RE: Informix Network Connection
Thomas, I believe the correct network connection type for linux is tlitcp not soctcp. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Thomas Ronayne Sent: Saturday, March 13, 2004 7:03 AM To: informix-list@iiug.or…
Informix Network Connection
There is something bothering me in your configuration: When using shared memory connection it doesn't make much sense to specify TCP port number i.e. "informixa" in your /etc/services file. We usually set these connections to dummy in SQLHOSTS file and don't write them to /etc/s…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Re: ER to replace HDR in HA environment
scottishpoet wrote: > But seriously, I'm not sure what the client will see here that they > don't see at the moment with HDR. Maybe Madisson will shoot me down in > flames, but ER won't redirect network connections from one server to > other other when the server goes down any m…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
RE: connection problem
Jonathan Leffler wrote: > Csom Gyula wrote: > > > 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 ca…
Re: connection problem
Csom Gyula wrote: > 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 …
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
IDS 9.3 On Windows 2000
On my Windows 2000 server system, there are two network adapters installed and each was configured with TCP/IP protocol.When IDS 9.3 started, it will select one of them to bind with it.If IDS 9.3 binds with a network adapter which is not connected with twisted-pair, remote comput…
access tables in a db2 database
from IDS 9.30.??. I only did that back in the 90ies using V7.12 and DRDA Gateway V6. I searched on the IBM Web pages and found 2 connectivity products. If the customer wants to keep his setup 'as is' and only wants to be able to make a few selects via frontend contacting his I…
Problem limited connections.
Hi, the error "... oserr=24 ..." points to the OS error number 24. You don't say, which OS your server is running on, but at least on some systems this means "Too many open files.". [ The "oserr" in this case is the UNIX "errno" which you can lookup in /usr/include/errno.h (or …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Please help !!! Error in communication....
We�re trying to perform a select command with DBAccess between an IDS 7.31 UC6 machine to an Online 5.10 machine. The following error appears in the screen: Unable to open input file 's' <tabname> (on top of page) � 25582 - Network Broken Bad File Number ��� ��� (on page bottom…
Error communicating IDS with ONLINE
We are having problems trying to communicate 2 instances of our Informix databases. We�re on a Sun machine, Solaris 2.6, using IDS 7.31 UC6. If we use the "Connect" option in Dbaccess, the communication is OK, we can go through the instances without problems. But when we execute…
RE: Communications service
one possibility : Where is your server/client ? Is the server behind the firewall ? Firewall may restrict to access Informix server, if server is behind firewall. thanks Ravi Yarlagadda -----Original Message----- From: Gregory Taane [mailto:greg.taane@crt.co.nz] Sent: Monday,…
Communications service
Hi there I am trying to set up Informix ODBC drivers on AIX 4.3 The sqlhosts file looks like this: devdata_se seipcpip devdata sqlexec devdata_se setlitcp devdata se2 # Added 27/01/00 for ODBC devdata_se sesoctcp devdata se3 Wh…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: Communicating IDS with Online
What's the problem? I do that all the time, no trouble as long as the OL engine has I-Star (networking module) installed. Otherwise you can use a schema like my dbcopy utility and run it locally on the OL5 machine using shared memory to connect there and a separate network conn…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: SE- Read performance problems
Richard harnden wrote: > > Try with seipcpip, rather than setlitcp. If you don't need network, that is. > > >>> <liliano@my-deja.com> 06/02/00 01:28pm >>> > Hi, > Do you know any configuration parameters that improve performance for > Informix SE SELECT/FETCH operations ? (I use…
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…
I4GL - Problems with Version 7.20
Hartmut Marten wrote: > Hi everybody, > > We have the following configuration/equipment: > > SNI RM400-225 RISC machine, running fine, > ReliantUnix 5.44 operating system, running fine, > ReliantUnix CDSDEV 1.0C32 C compiler, doing its work, > IDS 7.31.UC2AX4, meanwhile also run…
Apache/PHP4/SE7.22.UC2 problem
On Fri, 26 May 2000, Chris Dunlop wrote: > I'm not at all familiar with Informix, however, I have been asked to connect > our webserver to a remote Informix database on a Sun box. > ... > sqlhosts: overthere seipcpip thatserver sqlexec I'm sorry if I misundersto…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: ODBC Read-Only Database Privilege
If this is practical, Art's suggestion is probably the most secure. This may not be practical if, for instance, you have a an existing application that you cannot change which needs R/W access to many objects in the database. If you open up your database for network access (whic…
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…
Re: informix connect to as400 database
From: watawinona@aol.com (Watawinona) > > >i have a problem to conect database to as400 database > >currently we using informix 5 Online in Unix Box ( SCO 5.2) and As400 > >database > >so , anyone know how and what tool / gateway for connet to as400 >database > >??/ > >it is ca…
informix connect to as400 database
>Subject: informix connect to as400 database >From: "pentung" pentung@asaa.com >Date: 10.03.00 05:02 W. Europe Standard Time >Message-id: <iUay4.6950$15.64261@news> > >hi... > >i have a problem to conect database to as400 database >currently we using informix 5 Online in Unix Box…
Sockets library for 4GL
irwin_goldstein@my-deja.com wrote: > Does anyone know of a commercially available library of functions for > network communications using sockets which can be linked to/called from > Informix-4GL? > > TIA, > > Irwin Goldstein > Objective Software Systems, Inc. > http://www.objec…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Client SDK on HPUX
I am trying to connect to an SE 7.2 database on HPUX 10.20 from a windows client. My problem is that I can't start the sqlexed daemon on the server. When I run the command $INFORMIXDIR/lib/sqlexecd csi I get the message: 2000-01-14 11:30:01.820524 daemon err = -25592: Communic…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: Unix to NT database connectivity problems
Mark, to resolve the 908 error you will need to look into all the components of the connectivity equation, below is a checklist that you can employ. ====CHECKLIST FOR 908 error Ensure engine is online and all environment variables are set correctly. Check hosts file for machin…
Changing environments in 4GL
In article <38423A5E.CA2E6726@home.com>, dana <borilar@home.com> wrote: > Does anyone know how I can change environments from within a 4gl > program? I have 3 mirrored databases in 3 different enviroments that I > need to collect data from for a financial report. Can I do a TBC…
Enterprise Gateway To DRDA
Hi all, We are trying to use this product "Enterprise Gateway to DRDA" from informix version 7.3 to connect to an IBM DB2 database. The protocol used is TCP/IP. Are there any other users who have used this product for a similar purpose ? Would like to get a feel for likely hur…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: 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…
CSM
David Williams wrote in message ... >In article <dnlL3.15081$w8.290093@wbnws01.ne.mediaone.net>, Paul >Wolmering <wolmering@mediaone.net> writes >>Hi, >> >> The CSM technology is an API that exists in the client and server. It >>allows the non-Informix technology to be used as th…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix 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…
user rights - odbc
Andreas Lommel <him_lommel@t-online.de> wrote in message news:37ccec65.8622768@news.btx.dtag.de... > The task: A user has access to a table (update, select, insert) via a > program. > This user also should have only select-rights via odbc on a table in > the same database. > How …
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
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…
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: RH Linux and INFX-SE problem
Mario, Thanks for the explanation. VERY clear and VERY thorough. Maybe you should write docs for Informix. On second thought, I wouldn't wish that on anybody. Doug -----Original Message----- From: Mario Estrada [mailto:marioestrada@guate.net] Sent: Friday, April 23, 1999 1:0…
Re: RH Linux and INFX-SE problem
Doug, You are trying to run the sqlexecd daemon program, which is the one you will have to use if you want other machines to access your Informix Server, OR if you want to access the Informix Server via the tcp/ip protocol, using TLI or SOCKETS from the same machine. Either way …
Re: Tracing ALL sql queries - is it possible?
> The following quote no.1 > > "The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week." > > is not the same as the following quote no. 2 > > "The fac…
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…
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…
Re: Informix Connect Question -- sqlexecd
On Wed, 3 Feb 1999, Jon Gjerset wrote: > I'm moving from an old version of Informix SE up to SE 7.24. We > currently have ODBC connectivity to the old server by running the > sqlexecd daemon. The problem is making it work on the new server. I > have the following entry in my …
Informix Connect Question -- sqlexecd
I'm moving from an old version of Informix SE up to SE 7.24. We currently have ODBC connectivity to the old server by running the sqlexecd daemon. The problem is making it work on the new server. I have the following entry in my /informixdir/etc/sqlhosts file mega se…
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?…
SQLRM segfaults under Linux (RH 5.2)
John Hardin wrote: > > We're trying out the Linux SE engine on a Redhat-5.2 box in the hopes > that we'll be able to move some of our legacy apps to newer hardware. > > I've been able to install the server and create and manipulate local > databases using DB-Access, but when I tr…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Help with Socket calls in Datablade IDS/UDO 9.14X
drchen@my-dejanews.com wrote: > > Hi, we are migrating one function from Illustra to IDS/UDO 9.14x. This > function needs to make TCP/IP socket call. It worked fine in Illustra but > failed in Informix, complaining memory type of problem. Here is the code: Did anything else cha…
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: Tehnical problem for Client/server application (UNIX/Windows 95)
What are your settings ??? What is in the SQLHOSTS, SERVICES & HOSTS files ? You need the sqlexecd daemon running as this is what talks to the client side of things. What are your settings in setnet32 ?? Have you attempted the ilogin demo yet ?? Send these, and we'll have as …
Tehnical problem for Client/server application (UNIX/Windows 95)
We are installing a client/Server application , wich use ODBC connection to access data in an Informix database. We are not able to have a good connexion. The server is a HP 9000 with HP-UX V9, Informix-SE V7.1. We have downloaded Informix-Client SDK 2.03. The client is a PC with…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
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 Enterprise Gateway with DRDA
I wonder if anyone with experience in setting up SNAplus and Informix Enterprise Gateway to access DB2 on AS/400 can give me some assistance. I wonder if there is a sample configuration that I can follow. Thanks.…
Informix Enterprise Gateway with DRDA
I wonder if anyone with experience in setting up SNAplus and Informix Enterprise Gateway to access DB2 on AS/400 can give me some assistance. I wonder if there is a sample configuration that I can follow. Thanks.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: 4GL 4.11 frontend via network to 7.30 backend
On Thu, 3 Sep 1998, Richard Spitz wrote: > from many discussions in this group and also from the manuals, I > always got the information that 4.x and 5.x frontend products (like > 4GL or ESQL/C) can only communicate with 7.x backends (like my brand- > new IDS 7.30) via the perfor…
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 …
Re: type 4 JDBC drivers
Mike, Mike wrote in message <902132501.26155.0.nnrp-01.c2de7bed@news.demon.co.uk>... >In article <6nijot$g29$1@news.xmission.com>, mcanto@intec.unl.edu.ar wrote: >> >>Try http://www.openlinksw.com It has a free version with up 2 concurrent >>users. >>Byte byte! > >Is this type 4?…
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: Questions about Informix/Windows connectivity
Hi, You definetly need either IConnect or CLI. We have our database on NT and CLI comes on the CD. Infact the ODBC driver comes along with CLI. You do not need to get the driver from Intersolv. I think that the ODBC driver talks to the CLI instead of communicating to the server…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Local Database and $DBPATH
Richard Spitz wrote: > > Hi Informixers, > > how can I influence the way the DBPATH environment variable is evaluated > for database access? > > We are currently running Online/Star and SE/Net 5.10 concurrently on > the same machine. I know that the SQLEXEC variable will determin…
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: DRDA GATEWAY to IBM - SQL performance
Kate, Its been about a year or so, but try this. Run the query twice. (One right after the other.) You should see the second one run faster. If this is the case, then I might have an idea .... -Mikey Kate_Tomchik@homedepot.com wrote: > > Has anyone seen this before? Any sugge…
DRDA GATEWAY to IBM - SQL performance
Has anyone seen this before? Any suggestions on how we can improve the performance? ---------------------- Forwarded by Kate Tomchik/IS/SSC/THD on 05/13/98 12:08 PM --------------------------- I'm hoping you may be able to shed some light on a performance quirk I noticed …
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…
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…
Re: DRDA (Informix <-> DB2 mainframe) Performance Q.
I found out that the DRDA was originally installed incorrectly. It was placed in a different directory(as tlod by the installer from tech support) because the same tech support guy said to install it AFTER installing Online. Thery were very insistent about installing it last. T…
Re: DRDA (Informix <-> DB2 mainframe) Performance Q.
They are catalogs owned by Informix but resident on the mainframe. They are created through the gwdba script. Once you create the catalog, you need to add each table individually, and update the catalogs on a daily basis ( I have a script that runs from cron each morning. "Jac…
Re: DRDA (Informix <-> DB2 mainframe) Performance Q.
Have you added all the Mainframe tables you are accessing to the catalogs through the gateway? This makes a significant improvement.…
DRDA (Informix <-> DB2 mainframe) Performance Q.
Hi all, I've got DRDA version 6.1 running under AIX on an sp2 node and pointing to ou.r DB2 mainframe db The problem is that queries running on the mainframe take under a minute, while the same query running under Informix(to hit thouse mainframe tables) take 20 mins and more…
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.…
PRESS: INFORMIX, SUN AND CREATIVE HEALTH CARE SYSTEMS CREATE
INFORMIX, SUN AND CREATIVE HEALTH CARE SYSTEMS CREATE COMMUNICATION SOLUTION FOR RURAL HEALTH NETWORK MENLO PARK, Calif., Feb. 23, 1998-- Informix=AE Corporation (NASDAQ: IFMX), Sun Microsystems(TM) Inc. and Creative HEALTH CARE Systems (CHS) today announced that Community Memor…
CLI-Error: Internal communications ... (-25567)
Hi, After installing Informix-CLI Ver. 2.5 and creating the ODBC-Source I alway get the message: 'Internal communications buffer management error detected'. I have checked services (on client machine), server name, protocol type, hostname...etc. It was tested with NT 3.51, NT …
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…
IUS, WebDatablade and nsapi
Hi! I decided to use the web datablade as a nsapi function as it is faster then the cgi version. But ... it doesn't seem to work in some conditions, for example in a page with two or three frames. The log reports: 14817-72838,18) DEBUG: Fri Jan 9 19:03:17 1998 [MI_Exception] o…
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…
Inf7 SE on Linux ? Which nettype ?
Me again ... After copying the installation to a rather new Linux system (2.0.30 w/current iBCS2) I tried again ... seipcshm gave me this: 1997-10-06 08:32:05.000000 daemon err = -25592: Communications service not supported by network driver. seipcpip results in: 1997-10-06 …
Re: Inf7 on Linux w/iBCS2 - which nettype ?
Garry Glendown said >I was trying to get Informix 7 (SCO-Version) up on a Linux machine >(which successfully runs Inf4.*/5.0*) ... I'm aware that communication >through the network will not work (at least somebody wrote that on the >net somewhere), but only local communication …
Enterpriseserver & Informix DB
Hello, has anyone from this comunity got experience in connecting the enterprise server to a Informix SE 7.22 Database under SCO. I've got the Netscape Enterprise Server 3.0 running on WINNT. Using the connect 7.2.TE2 I successfully tested the connectivity with the ilogin tool. W…
Re: INFORMIX 5 : is there a SQLHOSTS file ?
Art S. Kagel wrote: } } Apostolos Varnas wrote: } > } > Peries, Chaminda wrote: } > } > for Online 5 you need an extra product Informix Star Ver. 5.xx in order } > to communicate with } > ODBC drivers that doesn't provide server side software for the } > communication such those …
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…
Re: IBM DB2 serious alternative to Oracle/Informix?
Errol Back-Cunningham (ebc@ix.netcom.com) wrote: : ..of course, if you deploy Informix's Enterprise Gateway with DRDA, : you can make all the DB2 tables available for reading and writing : to the Informix user, and totally transparent too. : Then the departmental squabbles s…
Re: IBM DB2 serious alternative to Oracle/Informix?
..of course, if you deploy Informix's Enterprise Gateway with DRDA, you can make all the DB2 tables available for reading and writing to the Informix user, and totally transparent too. Then the departmental squabbles start about who owns what data... Errol…
Re: Online 7.13 error 25588
David Coburn wrote: > > >What is this error and what are the possible causes? > > Generally means that either your networking setup is hosed, or you > cannot connect for some reason via shared memory. The actual error is > > $ finderr 25588 > -25588 The appl process canno…
Re: Online 7.13 error 25588
>What is this error and what are the possible causes? Generally means that either your networking setup is hosed, or you cannot connect for some reason via shared memory. The actual error is $ finderr 25588 -25588 The appl process cannot connect to OnLine server serv…
Re: Informix OnLine 7.2 for Windows NT Problems...
Nils Paulsson <nils.paulsson@mailbox.swipnet.se> wrote: :Tim Schaefer wrote: :> :> Not to intrude on your discussion, but I have to agree with Nils. I've :> found connectivity for Informix via ODBC / I-connect to be a major :> problem. The documentation is extremely bad, not t…
Re: onconfig & sqlhosts files on-line v7
On 30 Apr 1997 17:53:06 GMT, "Nigel Wain" <nigel.wain@daelnet.co.uk> wrote: > >Hi, > We are currently using on-line v7.13UC1 on IBM SP server. >The performance we are getting is very poor. I have noticed that our >Informix server is defined with the 'onsoctcp' in sqlhosts fil…
Re: as400
Roberto Favaro wrote: >I'm asking if it's possible to have informix running on an AS400 >cause i have a lot of customer that have this system >and they want to remain on as400 for a lot. >.... >if anybody know anything about it... > I don't think that you can run Informix on an A…
Re: Informix-mobile
Andrei Shirobokov,ags@cs.ibank.ru,CINet writes: << Has anyone an experience in using Informix-mobile? Is there any troubles in practice ??? Are there any advantages in using the product for the bad communication chanels ?? and the price of the product, please....? >> We con…
Inter Database Communication Interface
Hi, I am currently working on an analysis for the best way to exchange data between two databases located on different machines (long distance). Both are on the Informix On-line engine / UNIX . It is done in order to achieve communication/interface between a central distribution…
Re: Dumb terminals with NT and Informix Database
On 6 Jan 1997 23:42:41 GMT, Phil DuRall <kf6if@deltanet.com> wrote: >I have tried running this by the Informix tech support with no result yet. > >We are inheriting an Informix database from a UNIX Sequent system and want to >port it to our existing NT box. The management wants t…
Informix DRDA gateway 7.10
We are using an Informix DRDA gateway(v7.10) for Online Dynamic Servicer 7.13 under an AIX box to connect to DB2 database at IBM Mainframe. We currently experience a problem: when we use the gateway utility (gwdba) to access the informix catalog by adding more table/views into it…
Network Driver Problem
I have an informix database running on an HP9000. The file at $INFORMIXDIR/etc/sqlhosts has two lines: sedb seipcpip inca8 sqlexec #sedb sesoctcp inca8 sqlexec When connecting to the sedb using NewEra I have to use the sesoctcp and run sql…
sometimes get 2 sqlturbo processes (?)
Hello. Im running a server program which talks to multiple phone switches and uses threads to start and stop the communication sessions between it and the switches. Im running under Solaris 5.3 and using 5.04.UC1 esqlc. Every so often a switch connection dies and needs to be re…
DRDA gateway for INFORMIX.
Hi Everbody, I wanted to know whether any of you are using informix Enterprise Gateway with DRDA to connectINFORMIX (ver 7.2) database on AIX (RS6000) and DB2(ver 4.0) on MVS. I wanted to know what kind of problems one may face if one is going to use the following set of operat…
Informix Net and DNS
Informix Net appears to require DNS even though Informix says that they do not use DNS. I recently was attempting to setup Informix Net on some PC's and had numerous problems. I talked to Informix several times and they always said to make sure that the hosts files were up to da…
Informix DRDA Gateway -> DB2/6000
Has anybody configured the Informix DRDA Gateway to access DB2/6000? And if so could you expand on the entries required in sqlhosts to make the connection? I have the gateway and DB2/6000 on the same RS/6000 and I'm getting confused about whether I need drapplu6 or something els…
Re: Running c4gl programs
Pete, Unless you can get the version 6.0x DB-Access to communicate with the 7.1x OnLine system, showing that DB-Access works but I4GL does not only shows that 7.1x software is self-consistent. I think you will need to use a network connection to get the 6.0x I4GL to work with t…
Re: fet_buf_size
Keith, Here are 2 email messages I received from tech support on FET_BUF_SIZE. This feature is available for Unix client apps as well as PC client apps, but you need the correct version. I don't know there numbers off-hand. Hope this helps, Steve Berg - spb@masada.nb.com --…
Re: Dynamic Web Page
Nick Nobbe (nnob@loc.gov) wrote: : On Tue, 23 Jul 1996, John P. Zucchero wrote: : > > Imagine yourself in a large brokerage office. Your task is to design : > > a system to allow brokers to pull up client portfolios in one window : > > and in the same window show the current tr…
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…
Informix Net under OS/2 problem
I am trying to use an unusual combination of tools to build an application, due to unusual requirements: I am building a Delphi 1.0 (16 bit) Windows application that connects to an Informix Database running on a Sun, all in the Win-OS/2 mode of OS/2. I have installed and configu…
PRESS: NETSCAPE AND INFORMIX SIGN TECHNOLOGY AGREEMENT
The following announcement was made by Netscape on Tuesday, February 6th, 1996: NETSCAPE AND INFORMIX SIGN TECHNOLOGY AGREEMENT MOUNTAIN VIEW, Calif., Feb. 6 / PRNewswire/ - Netscape Communications Corporation (Nasdaq: NSCP) and Informix Software, Inc. (Nasdaq: IFMX) today ann…
Informix Gateway With DRDA
Hi, I was wondering if there is anyone out there with any experience of this product? I'm particularly interested in :- What Informix SQL extensions are not supported? What is the performance like? What hardware/software and comms are required to get it running? How di…
DRDA-Server
SQL-Queries involving a DRDA-Server and a OnLine-Server ======================================================= We are trying to commit a SQL-query which selects data from a DRDA- application server and inserts the selected data into an OnLine server. We can not make it work, n…
Re: How can an Informix client app access an DB2 server?
If you use Informix DRDA Gateway you will not require a recompliation. If you use IBM's DB2/6000 and DRDA products then you will require a recompliation and probable code changes. The Informix DRDA Gateway will give you a transparent SQL read/write connection between UNIX and th…
We are using Informix DRDA 6.10 on a SUN Solaris 2.4 to link to IBM DB2.
We are using Informix DRDA 6.10 on a SUN Solaris 2.4 to link to IBM DB2. The communication layer on the Sun is SunLink SNA Peer-to-peer RunTime 8.0 We are trying to connect to the IBM through an SDLC line. When we tried to start the peer-to-peer we've faced the following proble…
DRDA - HELP !!!
If there are anyone who have used Informix DRDA to link to the IBM DB2 please contact men via email. Any information on this issue is highly appreciated.…
NEED INFO: AS400 & Informix
Our organization is currently faced with a major dilemma. We would like to move our data-processing to a Unix based Informix client/server platform, but there is already a vested interest in AS400 technology. IBM would like to sell us an "Advnaced Series AS400", and use their ow…
Re: HOW DRDA GATEWAY WORKS ?
DRDA is for Relational systems only. You cannot get to DL/I via DRDA with anyones software (unless they build a SQL to DL/I bridge that happens to use DRDA as the 'API' and nobody in their right mind would do that) In article <44tkrt$70t@sirio.cineca.it>, alogica <logica@ve.nett…
HOW DRDA GATEWAY WORKS ?
Does anyone know how INFORMIX DRDA GATEWAY works? Can it be used to connect to a DL/I IBM MVS host ? Thanks. Marco Calmasini Logica Srl Via San Fermo 11 30174 VENICE ITALY…
Informix Gateway with DRDA, HPUX
We will be installing Informix Gateway with DRDA on one of our HPUX machines next week. The HPUX box will have a token ring interface to our AS/400. Anybody out there "been there, done that"? I'd like to get a feel for the ease of installation, as well as the performance of th…
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?…
Informix 5.0, 5.01 and I-Net PC
Hi, all ! I have got some trouble with Informix Online 5.01 on SCO when communicating with I-Net PC 5.01. In our network we have some PC's with SCO Unix and Informix 5.0 and 5.01 (one PC wasn't upgraded). All connections via I-Star between 5.01 and 5.0 Informix hosts wor…
INFORMIX Gateway with DRDA to AS/400
Has anyone worked with the DRDA gateway to the 400? Looking for useful tips and suggestions. Also, can this gateway (or others) be used to allow for transactions originating on either the INFORMIX or OS/400 side? Vince Germscheid CSC Consulting…
I-Net for Windows
Hi : I have problem with a connection of I-net for Windows and Pc/TCP V3.0 for Win/Dos, but trying of communicate with Demo Ilogin ( of ESQL/C ) tell me the netx message : Error =-932, Error on network connection, getservbyname (WSANO_DATA) system cal…
Is anyone actually using DRDA Gateways?
The company I work for has an IBM AS/400 software product, so I'm very familiar with the AS/400 and it's database (niark, niark). We've recently run across a situation where our potential client has a farm of AS/400's and they've invested an obscene amount of money (>many million…
DRDA and Commits???
Question on use of DRDA (in this case Informix on AIX <-> DB2). How are commits handled in a DRDA scenario? For example: Informix program issues an SQL UPDATE statement. It then performs some more code.....than issues another SQL UPDATE. Are these both considered the same unit of…
Informix<->DB2, DDCS/6000
I am looking for info/experiences with Informix and DB2 using DRDA. I understand Informix has a gateway which will pass SQL requests to DB2. What I'm unsure of is whether Informix can be used on an RS/6000 with DDCS/6000 to exploit the DRDA architecture. The goal: have app develo…
Re: Interfacing Visual C++ application and Informix thru ODBC
sxg7929@ucs.usl.edu (Gottumukkala Srikant) writes: >I am posting this for my friend who does >not have acess to Internet. >Question: Does Visual C++ or Visual Basic support ODBC >to be connected to INFORMIX database system. >He needs to write an application in Visual C++ or Vi…
PRESS RELEASE: Informix Connects To DB2 With Industry's First DRDA Compliant Gateway
Informix Connects To DB2 With Industry's First DRDA Compliant Gateway Non-Proprietary Software Offers Tremendous Cost Advantage to Mainframe Sites MENLO PARK, Calif. (June 30, 1993) Informix Software, Inc., (NASDAQ: IFMX) today announced that INFORMIX-Gateway with DRDA is now …
ANNOUNCEMENT: INFORMIX-Gateway with DRDA
Informix Software Announces Availability of INFORMIX-Gateway with DRDA MENLO PARK, Calif. (March 16, 1993) Informix Software, Inc., (NASDAQ: IFMX) today introduced INFORMIX-Gateway with DRDA, becoming the first major UNIX database vendor to fully support IBM's Distributed Data…