Oninit® Archive
Results for “HETERO_COMMIT”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
12.10.FC15W1AWE Blocked in LONGTX
Could it be that the rollback was still going, but had hit the LTXEHWM threshold? onstat -x would have shown some movement if that was the case. If the logs had got to the point where the next log had an open transaction, you could have tried adding logs manually with onparams -…
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Hi, Some other items OFF_RECVRY_THREADS is used to define the number of apply threads on the secondary LTAPEBLK I believe is used for the size of replication buffers SEC_APPLY_POLLTIME needs tuning on secondarys onstat -g laq (and the undocumented onstat -g laqp that gives timi…
Informix Enterprise Gateway Manager Error
Hi All, I am testing connecting to the mssql server through egm. When connecting to the mssql data source using dbaccess directly as shown below, sql runs fine. Instead, when using in the form of distributed query as shown below, a 908 error occurs and the egmd process crashes. I…
Bizarre CM/Connectivity Issue on 12.10.FC14
I finally received an explanation from support on what seems to be going on here: With a distributed query like select count(*) from sysmaster@dummy:systables; This is a server-side issue with Connection Manager involved for distributed query, the coordinator (local) server needs…
gTA cannot be killed
If I'm getting this right, onmode -Z is meant for I-Star 2-phase-commit distributed transactions, whereas onmode -H is for XA global transactions. The later (XA transactions) typically are not owned by Informix and should be taken care of by the XA transaction manager that initia…
Long Running Purge Script
Hi Art, Thank you for your insightful clarifications. Thoroughly appreciate your help. With the best regards and thanks, Saradhi Motamarri +61430022130 Sent from Yahoo Mail for iPhone ------Original Message------ Saradhi: See my responses below: So, IDS is behaving well. But I wo…
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…
Informix Enterprise gateway Manager
Good evening to everybody, IHAC who claims that since he upgraded to ORACLE12 from ORACLE10, Informix Enterprise gateway Manager 7.31 is not working. Configuration: Informix Dynamic Server 11.50 (32 bits) running on RedHAt Linux 6.9 (64 bits). The question is: Does IEGM 7.31…
email to/from this group working?
The IIUG Board is aware that the email gateway for the forums is broken. We are working on a new Forum site. In the meantime, only the online forum interface is working for reading posts. Posts sent into the forum via email are being posted, however.…
IIUG discussion forums?
Bryce: The email gateway for the forums is broken. The IIUG Board is working towards a new platform for the forums that will reestablish the email gateway as well. Stay tuned. In the meantime, only the online forum interface at iiug.org is working for reading posts. Posts sent i…
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
Sent from my iPad Hi Kenneth, Long time no see! Informix enterprise gateway manager should do that for you. > On 16 Feb 2018, at 10:04, KENNETH PENZA <kenneth.penza@gov.mt> wrote: > > Good morning, > > Currently we are running Informix 12.10.FC7 on RHEL7. An application requir…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Issue in transactions with informix using DRDA
Hi Roger, The application code that you mention is not a good approach for distributed transaction (DT). With this approach, it will become extremely complex as on when more heterogeneous servers are getting added to the transaction. The recemented choice will be to relies on DT…
Informix Enterprise Gateway
Hi, We are doing a PoC to validate our goals using Informix Enterprise Gateway. Executing together with IBM BP, since it's a trial release. After a few days testing it, we identified a few defects and some lack of resources. Our BP is having difficults to get some answers from …
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
Trying to set USELASTCOMMITTED='COMMITTED READ' do
I'd like to set onconfig parameter USELASTCOMMITTED from "NONE" to "COMMITTED READ" dnymically using onmode -wf, but whatever I tried I always get an error "onmode: Unknown option READ". So the value given as two words is not recognized as one always. I tried this on Solaris usi…
IDS / OS400 DRDA
Hi, i successfully installed informix enterprise gateway to be able to communicate with AS400. The configuration is done and daemon gwd started. With gwdba, the connection test succeed. But i can not do the bind package operation, i tested some environment variables and did some …
Looking for and IBM Rep for Product Purchase.
We can't seem to find or receive and return call or email from our IBM Rep, for purchasing 2 of these product on this list below. Can any IBM'ER assist with this? Here’s what I found on the IBM website: Informix evaluation software The products listed below are available only …
IBM Informix on limited memory device
Hi, I'm considering IBM Informix on a limilted memory device (IoT-gateway-device) having 256 MB RAM and running (Debian) Linux. - What are the minimum (memory) requirements for running IBM Informix in an acceptable way (is 64 MB acceptable)? An IoT gateway is mainly meant to gat…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Re: Sysmaster - Tabelas Temporária
On 20/01/14 17:20, Fernando Nunes wrote: > I'm not absolutely sure I got your requirement correctly... You say: > > "a program that runs once .... keep the session alive": > You cannot keep a session alive without a program running. > > Then you say: > "I need to drop temporary t…
Informix to Oracle interface
You can only do that using the IBM Informix Enterprise Gateway which is a separately licensed product. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own o…
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.…
informix 11.70 growth edition features
Upps, that would mean a Growth/Workgroup edition could not be part of a XA distributed transaction including other databases on different sites (not necessarily Informix, whatever edition) ? I was thinking that would be only an I-Star function in case the IDS engine itself was t…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
identifying a lock seemingly without an owner
Original post: Fernando, Yes it has been a long time. Hope all is well with you. I tried onstat -G and the list was empty. I just stopped and restarted the instance and 2 locks immediately appeared ( same table ). The application was down at the time and they were no other co…
select for update
HI, Coud I use 'select for update' clause to prevent others read the same record? the default isoaltion level is 'committed read', ids version is 11.5. in windows one: I excute： dbaccess stores_demo; begin work; set isolation committed read retain update locks; sel…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
IDS crashes in flexible grid create table commit
Hello All, I am using Informix version 11.70.FC4GE. I have two nodes set up in a flexible grid, with ER active. Whenever I try to create a table within a begin/commit block, IDS crashes. So, this causes a crash when trying to execute the commit: begin; execute procedure ifx_gr…
XA question
Hello. On your Informix engine, ensure that you´re using HETERO_COMMIT=1 (default is zero). That should fix your issue, considering (of course) you are acessing logged databases. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Informati…
WOW, can't believe how slow iiug.org website is!
You know what, it's not so slow! I just posted a message to this board via the email gateway and it was posted here and emailed out to gateway users within two minutes! I'm posting this response via the web interface at 11:11AM on my laptop clock let's see how long it takes to sh…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
HDR question once again
Jack: You are missing a lot. A bit of recent history then. Informix from version 7.10 through 7.31 and 9.10 through version 10.00, supported two overall replication types: 1. HDR or High availability Data Replication - This supported one read/write primary server and one read-…
Use of DRDA (EGM or IDS 11.5?)
On Wednesday 21 December 2011 10:09:18 THOMAS WOLTER wrote: > 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 …
Error with XA transactions
Hi All, Hope someone familiar with XA transaction setup via WebSphere can provide me some answers. We recently switched from Connection Pooling to XA transactions via WebSphere, connecting to some Informix 9.40 databases. We started receiving SQL Exception error messages "The da…
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…
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.…
Convert second to second field to numeric or other
Hello, I have an issue where a field with second to second datatype cannot be viewed through heterogenous gateway on the Oracle side. Now I want to resolve it on the Informix side by converting the field datatype to a numeric or char. I've tried everything I could think off to no…
Error -1801in IDS 11.50.FC4
Thank you for your answers No, there isn't any message about this error in the log I just try to set HETERO_COMMIT to 1 but it doesn't solved the problem I don't know if this will help, but here are some details: The application is developed with PowerBuilder which use a "aut…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
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…
Re: how to terminate global transactions?
> Thanks for your help. > Yes, it was a Java Application Server using distributed transactions and > this ran out of PermGen space so I had to kill -9 it. > Today I cannot figure out anymore why the transaction was not rolled back. > The instance is used for testing and developin…
Re: Is there a gateway issue?
Ian Goddard wrote: > Ian Michael Gumby wrote: >> >> >> > From: goddai01@hotmail.co.uk >> > Subject: Re: Is there a gateway issue? >> > Date: Fri, 5 Mar 2010 09:30:13 +0000 >> > To: informix-list@iiug.org >> > >> > Neil Truby wrote: >> > > "John Carlson" <jwcarlson1@yahoo.c…
Re: Is there a gateway issue?
Ian Goddard wrote: > Neil Truby wrote: >> "John Carlson" <jwcarlson1@yahoo.com.invalid> wrote in message >> news:hmpqvh$r3n$1@news.eternal-september.org... >>> I'm reading on c.d.i UseNet. It seems that there are replies that >>> are referenced that I don't see. Is there an iss…
RE: Is there a gateway issue?
Maybe your ISP doesn't like Hotmail? > Date: Fri, 5 Mar 2010 13:59:18 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: Is there a gateway issue? > > Ian Michael Gumby wrote: > > LOL... > > > > Sure Art... (:-P) > > > > Uhm I believe Verizon turne…
Re: Is there a gateway issue?
Ian Michael Gumby wrote: > LOL... > > Sure Art... (:-P) > > Uhm I believe Verizon turned off their Usenet feeds a couple of years ago. > > Usenet is a peer to peer system, so yes, who you pull your feeds from is > an issue. > I think Supernews may still be around. > Its been a w…
RE: Is there a gateway issue?
LOL... Sure Art... (:-P) Uhm I believe Verizon turned off their Usenet feeds a couple of years ago. Usenet is a peer to peer system, so yes, who you pull your feeds from is an issue. I think Supernews may still be around. Its been a while and I guess I could post via google g…
Re: Is there a gateway issue?
This is not an IIUG filtration problem Gumby. Honestly, there is no filter on the gateway that I can locate. Besides, two posters have indicated that they were losing posts from a direct Usenet feed also. I suspect that the IIUG's Usenet source is one of the problematic ones. …
RE: Is there a gateway issue?
> From: goddai01@hotmail.co.uk > Subject: Re: Is there a gateway issue? > Date: Fri, 5 Mar 2010 09:30:13 +0000 > To: informix-list@iiug.org > > Neil Truby wrote: > > "John Carlson" <jwcarlson1@yahoo.com.invalid> wrote in message > > news:hmpqvh$r3n$1@news.eternal-september.org...…
RE: Is there a gateway issue?
You know... you should be careful on what information you filter. ;-) I mean, I know I've been the largest pain in the ass when it comes to IBM's sales and marketing of IDS, but I also happen to know the most about IBM's S&D and what and how customers perceive IDS. And when I sa…
Is there a gateway issue?
I'm reading on c.d.i UseNet. It seems that there are replies that are referenced that I don't see. Is there an issue with the gateway? JWC…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
THIS BOARD NEEDS A MODERATOR TO SCREEN POSTINGS...
On Thu, 2009-10-22 at 14:04 -0400, FRANK ROTOLO wrote: > FROM JERKS LIKE OBNOXIO BEFORE THEY ARE PUBLISHED!.. OK, SO I COMMITTED A > MISTAKE BY POSTING MY RESUME HERE, BUT SOME OF YOU NEED SOME GROWING UP TO DO! > ALTHOUGH IBM HAS NO CONTROL OVER THIS BOARD,I HOPE THEY TAKE NOTIC…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
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 …
Informix Enterprise Gateway
I am configuring Informix Enterprise Gateway Manager. I am on a AIX 5.3 using EGM 7.31 UD2 trying to connect on oracle 10g in a Windows. The Gateway is working well, I am able to connect to others databases, but that oracle .. I am having problem in Oracle Wire Protocol con…
Re: EXT3 & EXT4 filesystems are NOT safe.
Art Kagel wrote: > Friends, Colleagues, Clients: > > According to Linus Torvalds, Linux's EXT3 filesystem is not safe since > it writes its meta data to disk before committing the related data > changes to the file. This can mean corrupted files if the system > crashes between t…
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 ...
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 ... 11.50.fc3 - Aix 5.3 DB2 v8 - OS 360 If someone el…
Update statistics returns erro -255
Hi, We run update statsitcs in parallel on our database on IDS 11.5 FC2X2 on an HP-UX is64 server.? Some tables and indexes are fragmented across multiple dbspaces. Sometimes the update statistics returns and error code of -255 on several tables: finderr -255 -255??? Not in tra…
Acceso desde Informix a Oracle *NM*
JOSE: Para esta necesidad, el producto que hace la comunicación entre el Informix y oracle es el Informix Enterprise Gateway Manager 7.31. Con este producto, usted también que obtiene para comunicar el informix con sqlserver, DB2 UDB para el Linux, Unix y Windows, Teradata, Sybas…
Accessing Oracle From Informix
Please check this link http://www-01.ibm.com/software/data/informix/tools/egm/ Informix Enterprise Gateway Manager runs on AIX, HP-UX, Solaris, Windows=AE=A0NT=AE, and Windows XP=AE. Thanks.. Amitava Chakraborty PMP=AE Lead - Informix Interoperability = "David Reed" = <Davi…
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…
Can some body please help translate this into an I
SELECT DISTINCT dbo.typeclass.name AS TypeClass, dbo.device.name, dbo.device.description, dbo.devicenumplanmap.display, dbo.numplan.dnorpattern, dbo.typemodel.name AS TypeModel, dbo.typedeviceprotocol.name AS TypeDeviceProtocol FROM dbo.typedeviceprotocol RIGHT OUTER JOIN dbo.…
Translation to Informix Query
Can somebody please help translate this query ( for SQL Server ) for use with Informix SELECT DISTINCT dbo.typeclass.name AS TypeClass, dbo.device.name, dbo.device.description, dbo.devicenumplanmap.display, dbo.numplan.dnorpattern, dbo.…
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…
Why you can't trust IBM when it comes to committing to Informix.
Ian, I think the space needs to be forked into at least three, not two: 1. Commitment to maintaining and supporting a product. 2. Committing to "investing in" a product (which usually means new features, new platforms, etc.) 3. Committing to marketing and promoting a product. …
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. …
Re: Informix to Oracle replication
"Keith Simmons" <smiley73@googlemail.com> wrote in message news:mailman.424.1202461128.20610.informix-list@iiug.org... > On 08/02/2008, Neil Truby <neil.truby@ardenta.com> wrote: >> I realise that this is a high-level question. >> IDS 10.0. >> >> Does anyone know of a product, av…
RE: TPS
I think, I can make Mark's question more specific: - Each transaction is making 25 bufwrites, 400 bufreads average (that is, transactions are pretty complex, most logic in SPL) - Only committed read-write transactions are counted; - 24x7 system - 3 Terabyte instance, unbuffere…
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…
syntax of insert like mysql
vomaringo@yahoo.com wrote: > is there an option to allow : > insert into customer (fname) values ('a'),('b'); > No, using pure SQL you'll need two inserts to do that. If you are using a host language you can use an INSERT cursor to insert as many rows as you like with a single …
RE: Kansas City, gateway to .....
> Date: Thu, 27 Dec 2007 23:28:06 -0600 > From: paul@oninit.com > Subject: Re: Kansas City, gateway to ..... > To: informix-list@iiug.org > > Never had a single problem with US immigration apart from the length of > the queues in O'Hare. I've done 15 minutes flight to flight vi…
RE: Kansas City, gateway to .....
Uhm, Do you really want to fly anything called "Skybus" ? :-) And yes, Cow-lumbus OH is their main hub. So you'll be spending the night at one of the "no tell motels" by the airport. If you try and practice a midwestern accent and say "How you doing?" to the guys at the immigr…
RE: Kansas City, gateway to .....
> From: neil.truby@ardenta.com > Subject: Re: Kansas City, gateway to ..... > Date: Thu, 27 Dec 2007 22:59:54 +0000 > To: informix-list@iiug.org > > >> You're already looking to the "next" event before the first event is even > >> off the ground. :-) The reason KC was chosen was…
Re: Kansas City, gateway to .....
Dallas? Try st. louis. St. Louis is the murder capital of the U.S... If you survive your connection through st. louis think of the stories you can tell the family when you get home... > --- Dirk Gunsth�vel <dirk@guncon.de> wrote: > > > Dallas is an option too... its only 30…
Re: Kansas City, gateway to .....
Dallas is an option too... its only 30 mls or something longer to Kansas City. I fly there often and never had any problem. And I dont think thats because they trust Germans a lot there ;-) Dirk "Paul Watson" <paul@oninit.com> schrieb im Newsbeitrag news:mailman.141.1198724183.…
Performance Tuning of batch insert and batch update using JDBC API.
In addition to Marco's comments, how exactly are you doing the DB2 9 load?... Is it truly an insert or is it a "load" operation that is "not logged"?.... Bypassing transaction logging can surely save time. ============================================================ The informat…
Re: Kansas City, gateway to .....
Neil it should be 14 (ish) hours door to door unless you've moved house :-). I normally fly Continental and the flights are typical $600 - it cost me more to fly to Vienna for the European conference Cheers Paul Neil Truby wrote: > Has anyone involved in choosing Kansas City…
RE: Kansas City, gateway to .....
What you guys feel more comfortable wandering around erecting stuff? We're too prudish for that phrase. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Obnoxio The Clown Sent: Thursday, December 20, 2007 4:…
RE: Kansas City, gateway to .....
And here in the midwest we have this thing called weather.... BTW jgp you divide by 1.43 That is that the $1.43 USD gets you 1 Euro. As to driving... >From Boston to Chicago, you're between 14-18 hours depending on how fast you drive, number of breaks and weather. Chicago to …
RE: Kansas City, gateway to .....
I try to work my boss paying for Kansas, so wish me luck. Jean: You need a german driver, you french guys also have a handicap named speed limit, we don´t ;-) regards, Joerg Volz > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-boun…
RE: Kansas City, gateway to .....
I guess I'll land in Boston, ask stuart to pick me up and we'll drive the Corvette to KC, with my driving, it'll take a few hours (of fun)... ;-) -----Original Message----- From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] Sent: Thursday, December 20, 2007 07:2…
RE: Kansas City, gateway to .....
You could fly to Chicago, rent a car and drive down (it's only about a 9 hr drive per mapquest). Might be about the same driving up from Atlanta. All sorts of fun options to get to the middle. ============================================================ The information contained …
RE: Kansas City, gateway to .....
Aaaah ce Neil alors... and you're always travelling biz class, so it's gonna be long but comfortable. it was chosen because it is in the middle of nowhere, sorry, the US... the worse thing is indeed that you need to fly from the Kansas City to Overland Park, it is sooooooo far a…
Kansas City, gateway to .....
Has anyone involved in choosing Kansas City as the venue for the IIUG Conferene ever tried to travel there from "international"? I'll need to leave in early March to get there on time, having first arranged a mortgage to pay for the air-fare ... ;-)…
generic question: update statistics low drop distr
Robert Roussey(IT) wrote: > I thought I remember JM saying that US-medium on a table will drop > distributions and rebuild them anyways? > Well, almost. Medium and HIGH both drop the existing distributions and insert new ones in a single transaction. If the process is interrupte…
Enterprise Gateway Manager
Apologies for double posting but this seemed to get lost going to c.d.i. ! Anyone out there using this product in anger on live servers? I'm trying (with assistance) to get this setup to communicate between IDS 10 on Solaris and/or AIX and $QL $erver 2OO5 on W2K. Any tips/gotcha…
windows-1252?Q52=65=3A=52=65=70=6C=69=63=61=74=69=
You basically have six choices: - Use Informix Enterprise Gateway to access the SQL Server tables as if they are native and use triggers to replicate changes to the IDS tables in the SQL Server tables. - Use the Informix Virtual Table Interface to define the SQL Server tables as…
Replication to SQL Server
On 13/11/2007, KURT BUFFINGTON <kbuffington@gwkinc.com> wrote: > What is the most efficient way to synchronize/replicate from Informix (IDS 9.4 > Solaris) to SQL Server? > > > ******************************************************************************* > Forum Note: Use "Reply…
Replicate1 / DataMirror / etc - Trigger or Log Replication
http://www-306.ibm.com/software/data/informix/tools/egm/ Informix Enterprise Gateway Manager Overview Informix Enterprise Gateway Manager is an SQL-based gateway that allows a customer's Informix tools, applications, and databases to interoperate transparently with non-Informix…
Select without locked row
It is REALLY useful to include the threaded msg to which you are posting for those on the list using DUMB mailers to monitor the list - like me ;-( IB this is the thread with the work queue message table, yes? There are ways of handling that, but let's take a direct approach. N…
Duplicate serial in Informix 7.2.3
On Jul 25, 2:18 pm, pedro <pedro.e.sa...@gmail.com> wrote: > Hi, > > I've developed an webservice application which accesses an informix > database. > When the service is invoked, the application executes some business > logic, opens a transaction inserts values in 3 tables (let'…
IBM Gateway
Has anyone had the opportunity to work with IBMs GATEWAY product to connect DB2 (mainframe) to Informix (Solaris)? Any issues that we should be aware of.…
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…
Question on SHMVIRTSIZE
On 08/05/07, Mary Gregory <mary.gregory@rheem.com> wrote: > I still haven't found a good way to determine whether or not adding more > virtual memory to the instance would speed up queries or not. I think I > might try to add another 128 MB just to see what happens. Also, I am > …
Transaction Question
On 24 Apr 2007 07:28:58 -0700, Dave <In4MixDBA@gmail.com> wrote: > Hello All, > > We have the following transaction situation. Is it possible within a > transaction, "begin work" ......"commit work" to insert records to a > log table and have those records committed regardless o…
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: IDS License Revenue
Serge Rielau wrote: > To get back on topic. The number stated officially in the Q4 call was > +32% new-transaction for "distributed databases". > (That comment by the CFO is verifiable via the webcast and anyone who > doesn't believe it should send a note to SEC...). > > Given …
Email gateway down?
Is the email gateway down? I haven't received any messages from the mailing list since Saturday, and a message that I have sent to the gateway (twice, sorry for the double-post once it shows up) has appeared neither on the mailing list nor in c.d.i. -Carsten…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
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…
Is the gateway working?
I haven't received anything through the informix-list gateway since Thursday. Is this happening to other people or do I have a local problem? regards Malcolm…
Parametro TXTIMEOUT
vesf wrote: > Hola, quisiera saber si alguno de ustedes me puede informar que quiere > decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se > refiere. Gracias de antemano. Salu2... > /Translation Hello, I wanted to know if some of you can tell me what the onconf…
Looking for Replenishment Software
We have a custom Warehouse Distribution system written in 4GL (Fourjs BDL) using an IDS database. About 150,000 part numbers and 10 years of transaction history. Our Parts Replenishment is a hand coded program that lacks intelligence for trends/spikes/etc. Can anyone recommend …
Performance issue after 732 to 94fc6 upgrade
Doug- We discovered when we made a similar transition that temporary tables built and indexed in a program will not use their indexes unless update statistics is run against them. The 9.x engine apparently has a difference in the optimizer which caused this. --EEM > -----Origi…
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?…
Quiet day?
I have not seen any posts on these groups and don't remember having seen any on Friday either. Is it that quiet or is USENET down? Posting to the NG and the email gateway to see where the problem is.... Art S. Kagel…
Quiet day?
I have not seen any posts on these groups and don't remember having seen any on Friday either. Is it that quiet or is USENET down? Posting to the NG and the email gateway to see where the problem is.... Art S. Kagel…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: Configure Informix Enterprise Gateway example
It works. Now I have problem with code page. When I try to insert data with 8 bits content 8859-1 I receive error message, ordinary data works correctly. Do You have any idea ? Pero On Thu, 16 Mar 2006 17:05:59 +0100, Marion Sussujew <marions777@online.de> wrote: >Hi, > >1.…
Re: index duplicate values, how much ?
Well, think you are not right, consider this test: The test runs in a database with unbuffered logging. create table t (id integer, name varchar(20)) in testdbs lock mode row; insert into t(id, name) values (0, 'KARL'); insert into t(id, name) values (1, 'MAX'); insert into t(…
Re: Configure Informix Enterprise Gateway example
Hi, 1. configure Oracle for ODBC This includes defining a datasource and starting a listener. I did it some time ago and don't remember all the details. 2. Configure the informix side: example sqlhosts ---------------- # IDS on940fc7 onipcshm sunny on940fc7 on940fc7tcp ontlit…
Configure Informix Enterprise Gateway example
Does anybody know how sholuld I configure informix enterprise gateway for oracle connection ? Pero…
Re: Informix connection to SQL Server
Hi !! I have a Informix IConnect in the Linux machine and I need to know if exists some kind of product that I can test my connection with SQL Server machine (some thing like ILogin Demo in Client SDK in Windows plataform) ? Tks, Regards, Eduardo Claus Samuelsen escreveu: >…
Informix connection to SQL Server
cboccio@yahoo.com.br wrote: > Hi all, > > Does anyone knows how to connect a SQL Server from an Informix Database > installed on a Linux machine ? > > Tks, > > Regards, > > Eduardo > Informix Enterprise Gateway Manager…
Re: Calling an Oracle procedure
alexis.kyriakides@gmail.com wrote: > Hi, > > We have two databases one Informix 9.4UC4 and another ORACLE 9.2. We > would like to call from an Informix procedure an Oracle procedure. We > don't know hao to achieve this. Any ideas will be more than welcome. > > Thanks > Alexis > …
Aborted Long Transaction
HPUX-11 IDS 9.21.HC4 I have been seeing some weird errors in my online log. 08:32:09 Aborting Long Transaction: tx 0xa2f427f0 no user info due to XA or distributed (2-phase commit) transaction 08:32:09 Aborting Long Transaction: tx 0x9e236188 no user info due to XA or distri…
Calling an Oracle procedure
You can use the Informix Enterprise Gateway Manager to do this Thanks, -Manas On 27 Feb 2006 02:19:56 -0800, alexis.kyriakides@gmail.com < alexis.kyriakides@gmail.com> wrote: > > Hi, > > We have two databases one Informix 9.4UC4 and another ORACLE 9.2. We > would like to call f…
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: Informix to Oracle connection
The Enterprise gateway manager (http://www-306.ibm.com/software/data/informix/tools/egm/) provides connectivity to non Informix DBs. You can use this in direct mode.. Informix ESQL/C app -> gateway -> Oracle Db or in distributed mode Informix ESQL/C App-> Informix server -> gatew…
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: 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: > >…
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.…
Reading DBF from Informix
I found Informix Enterprise Gateway Manager , but my need is to connect to .dbf file running on Windows from Informix running on SCO-Unixware and IBM site told that is not a distribution for Unixware, only AIX, HP-UX,Windows and Solaris. Is there any other product ? cristizaha…
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.
Dirk Moolman said: > > Informix Enterprise Gateway ? Are you just joking, or does it really > exist ? Do they really have a product like Oracle's enterprise > gateway ? They really, really, REALLY do. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut…
RE: IDS Next Version - features wanted.
Exists since a long time. Connects to Oracle (and even Sybase I think) via ODBC. Also there's a Gateway to connect via DRDA to DB2, even to DB2 on mainframe. And the latter one was even working via SNA, before DB2 on mainframe supported TCP/IP. You can connect your client direct…
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…
Re: IDS Next Version - features wanted.
gsturkenboom@lic.co.nz wrote: > You're right. I'm on IDS V7 - don't ask! > > Perhaps you would be good enough to point me at some documentation which > describes how I can do something like ... > > Select a.*, b.*, c.* > from <informix table> a, <oracle table> b, <db2 table> c > …
Re: HELP ME WITH THE FAQ....Please review
mweallans@panacea.co.uk wrote: > David, > I'm qute willing to help with "What exactly is a long transaction" but > it needs a complete rewrite. It currently recommends using "onarchive" > and I'm not sure if that is still distributed. I don't even know if > informix would recom…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: DBTEMP
Dirk Moolman wrote: > I am trying to understand the environment variable DBTEMP better. I am > using DBSPACETEMP in my onconfig, but the DBA who created the system I > work on, also included DBTEMP in the user .profile Outdated. Not really used anymore, replaced with DBSPACETEM…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
How to transfer data from temporary table to permanent table
Hi all, Need help. 1. I have two tables with same schema one is temporary and another is permanent. How do we move all the data from temporary table to permanent table at once. 2.while using dbload command for a file if I have duplicate records in 1st and 4th , 10th and 15th t…
Re: Oracle to Informix migration
"Guy Bowerman" <gbowerman@yahoo.com> schrieb im Newsbeitrag news:AZC4e.25785$k66.6456@trnddc03... > Hello, > > Have you looked at Enterprise Gateway Manager? > http://www-306.ibm.com/software/data/informix/tools/egm/ > > This should handle the connection and allow you to select f…
Re: Oracle to Informix migration
"Guy Bowerman" <gbowerman@yahoo.com> schrieb im Newsbeitrag news:AZC4e.25785$k66.6456@trnddc03... > Hello, > > Have you looked at Enterprise Gateway Manager? > http://www-306.ibm.com/software/data/informix/tools/egm/ > > This should handle the connection and allow you to select f…
Re: Oracle to Informix migration
Hello, Have you looked at Enterprise Gateway Manager? http://www-306.ibm.com/software/data/informix/tools/egm/ This should handle the connection and allow you to select from the Oracle db into Informix tables, though perhaps not quite the fully automatic solution you're looking…
Oracle to Informix migration
Hello, Have you looked at Enterprise Gateway Manager? http://www-306.ibm.com/software/data/informix/tools/egm/ This should handle the connection and allow you to select from the Oracle db into Informix tables, though perhaps not quite the fully automatic solution you're looking…
Re: loadfile with quotation marks -> csv-file
try_and_err wrote: > Jonathan Leffler <jleffler@earthlink.net> wrote > >>Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly >>specify '-i' on the command line with one of those two options. >>However, there's nothing to stop you using a LOAD or RELOAD statement…
Re: loadfile with quotation marks -> csv-file
Jonathan Leffler <jleffler@earthlink.net> wrote > Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly > specify '-i' on the command line with one of those two options. > However, there's nothing to stop you using a LOAD or RELOAD statement. > If you have v77.03 …
Re: loadfile with quotation marks -> csv-file
Jonathan Leffler <jleffler@earthlink.net> wrote > Well, 'sqlcmd -R' is equivalent to 'sqlreload'; you can only directly > specify '-i' on the command line with one of those two options. > However, there's nothing to stop you using a LOAD or RELOAD statement. > If you have v77.03 …
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
RE: orphaned lock process
may be the transaction is not completed, is it a distributed transaction ? if it is, then, one of the option is, - make sure there are no distributed transactions running on the database - issue onstat -x and identify the transaction (the fifth character in the flag will be a 'G…
Update statistics
There is a way to drop distributions without running 'update statistics low' You may use the SQL command: DELETE FROM sysdistrib WHERE tabid = (SELECT tabid FROM systables WHERE tabname = '<the_table_in_question>'); Disadvantage of this approach is that this is a hack rather t…
Isolation level
Hi Gurus I want to read some Informix tables from Oracle , I have Oracle Transparent Gateway but the Oracle isolation default is dirty read and informix is commited read. When Oracle Transparent Gateway send a select to informix it sends a "commited read" and sometimes I got tab…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Re: 4gl development question
Neil wrote: > The way our 4gl application has evolved we make use of system calls to > execute other programs rather than linking in that functionality > directly to the calling program. > > For example this leads to the following type of code > > program1: begin work > …
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…
4gl development question
The way our 4gl application has evolved we make use of system calls to execute other programs rather than linking in that functionality directly to the calling program. For example this leads to the following type of code program1: begin work ....... co…
Re: Oracle ?
Mark Townsend wrote: > Serge Rielau wrote: > >> IBMs primary business is innovation, It is NOT fighting Oracle or >> Microsoft. > > > Tell me one innovative thing that IBM has done with DB2 in the last 5-10 > years. Feel free to use this deinition of innovative - > http://www.hyp…
Re: Isolation levels in Informix vs Oracle
DA Morgan wrote: > Serge Rielau wrote: > >> Sidenote: SEQUENCE is "dirty read" by definition and it is quite >> popular in Oracle :-) >> >> Cheers >> Serge > > > By whose definition? Certainly none I have ever heard. > The freedom of double-quotes Daniel. Open your mind: If you o…
Re: informix-list
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:2ulfj6F2chhd4U1@uni-berlin.de... > Can anyone please shut the gateway down, hopefully for good. > Let everyone post directly thru NNTP newsgroup c.d.i. > > Reason for provocation: To my post about ORacle.com switching from …
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'?…
communication beetween Informix and MySQL
Hi, I need to communicate an Informix database with MySQL. When I update a table in Informix, I must update a table in MySql database. I was reading Enterprise Gateway Manager for SQLServer, Oracle, Sybase and via ODBC. Somebody implemented something like that? May be through a d…
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: IDS9.4/AIX5.2 performace degradation
Dalibor, A piece of tuning advice that has many times hit this list, is that you should have one CLEANER per LRU. So, having LRUS = 8 implies that you should have CLEANERS=8 also, to keep up with the overhead. Ben Thompson wrote: > Dalibor Krleza wrote: > > I may have missed i…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
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…
Re: Problems with locks and committed read
You say the problem only occurs in MODE ANSI databases? this may suggest you don't have any commit or rollback statements. In a non mod ansi daatebse without begn and commit, every sql statement would be treated as a single transaction and would be so the lock would be released i…
Re: IDS 9.3 VIEW into an Orrible db?
The IBM Informix Enterprise Gateway Manager allows you to do both selects/inserts from/to an Oracle database. You can create views on the IDS instance to access the Oracle tables or you can access the table directly using the Gateway in direct or distributed mode. Let me know if …
Remote LONGTX with no userthread in 9.30 UC6 W4
...forgive the long copy and double post on ids (was having problems posting here), but it has been a while, I'll post at the top to save you time... What is the difference in the following commands? onmode -H <address> forget heuristically completed transaction onmode -Z <a…
IDS 9.3 VIEW into an Orrible db?
"Malc P" <malc_p@btinternet.com> wrote in message news:8c28402a.0405180110.5c29eeb9@posting.google.com... > Sorry to do this to you, guys, but unfortunately we're now being > outsourced to a company that has an O***** db, and I've been asked if > our main in-house db (IDS9.3 on H…
Remote LONGTX with no userthread in 9.30 UC6 W4
...forgive the long copy, but it has been a while, I'll post at the top to save you time... What is the difference in the following commands? onmode -H <address> forget heuristically completed transaction onmode -Z <address> heuristically complete specified transaction The admi…
Re: Extracting data from a SQL Server database
Hi Rob, Neil The Enterprise Gateway Manager uses ODBC to access other RDBMS like SQLServer, Oracle etc. Let me know if you need more information. I work on the development team for this product. Thanks, -Manas --- Rob Wilson <rob_wilson_at_@ameritech.net> wrote: > Neil Trub…
RE: Extracting data from a SQL Server database
"Savio Pinto (s)" <spinto@cap.org> wrote in message news:c78dfc$k1r$1@terabinaries.xmission.com... > > sorry, i was thinking you want to extract data from informix, anyway to > extract data from sqlserver you can use the same approach, > 1) create linkserver using odbc source for…
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: Remote LONGTX with no userthread in 9.30 UC6 W4
TBP wrote: > rdtbra wrote: >> We use here IDS 9.30.UC6W4, running in SunOS 5.7. Both Informix >> and Solaris are 32 bits. For the second time we have reached a >> situation where the instance shows a LONG TRANSACTION marked with >> flags --H--G and userthread 0. When this instan…
Remote LONGTX with no userthread in 9.30 UC6 W4
Hello all. We use here IDS 9.30.UC6W4, running in SunOS 5.7. Both Informix and Solaris are 32 bits. For the second time we have reached a situation where the instance shows a LONG TRANSACTION marked with flags --H--G and userthread 0. When this instance is started, after the fas…
Please fix the mailing list gateway!
To whoever is responsible for maintaining the gateway between the newsgroup "comp.databases.informix" and that "Informix List" mailing list: Please, please, please, go and fix the problem with multiple postings of gatewayed messages. It started out with duplicate messages, now w…
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…
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.…
Informix isolation levels
First of I have read the manuals. I am have difficulty with and application that have written to work against Informix or Oracle and the developer is saying that the way Informix handles transactions is wrong. In Oracle, user1 begins a transaction and updates a row, but doesn't…
Re: Informix/ sql server access
ODBC should work Venkatesh Konnur wrote: > > Hi, > I would like to find out about how an Informix data warehouse could access > SQL Server tables remotely. > Is there a way this could be done with one of the datablades.I believe > there is a Datablade capable of doing this... I …
Re: Informix/ sql server access
Venkatesh Konnur wrote: > > Hi, > I would like to find out about how an Informix data warehouse could access > SQL Server tables remotely. > Is there a way this could be done with one of the datablades.I believe > there is a Datablade capable of doing this... I know this could b…
Informix/ sql server access
Hi, I would like to find out about how an Informix data warehouse could access SQL Server tables remotely. Is there a way this could be done with one of the datablades.I believe there is a Datablade capable of doing this... I know this could be done with Enterprise Gateway Manang…
Re: Informix on NT?
Art, thanks for the response. However, the statment "You can export from Informix to flat files and load the data into SQL Server if needed" is troublesome, well, how does one maintain data structure, entity relations etc. system schemas? Someone has suggested using MS DTS. Ma…
News Server down
Jack A wrote: > I think its a problem with my news server. Seriously, does any one > know how to check for this in the outlook newsreader ? I can see you - and the other messages, but I'm not sure how timely. Some news servers are very slow to share with other servers. That is…
Re: two databases -- foreign views
Rob Wilson <rob_wilson@ameritech.net> wrote in message news:<b3QXa.344$Ih1.309090@newssrv26.news.prodigy.com>... > I am not sure about for SQL server but Informix has the Informix > Enterprise Gateway Manager: > > http://www-3.ibm.com/software/data/informix/tools/egm/ > > It can…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Re: A VTI/Access Method for ODBC?
> > Has anyone worked on developing a VTI/External Data Access Method for > > linking to other ODBC data sources? > The Informix Enterprise Gateway Manager fills this need in roughly the > same way. It causes ODBC-sourced tables to look as though they are > inside Informix, much…
A VTI/Access Method for ODBC?
Adam Williams wrote: > Has anyone worked on developing a VTI/External Data Access Method for > linking to other ODBC data sources? > The Informix Enterprise Gateway Manager fills this need in roughly the same way. It causes ODBC-sourced tables to look as though they are inside …
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…
Transaction id and transaction isolation
"Alex" <azp74@hotmail.com> wrote in message news:dca1064b.0307202358.43aac613@posting.google.com... > Hi > > Two questions. I am using Informix IDS 9.4 on Windows. > > 1. I would like to be able to get hold of the transaction id while > still in the tranasction but I have been …
Re: Gateway Down?
"Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:bf21pp$klb$1@terabinaries.xmission.com... > > Mark D. Stock wrote: > > Hi > > > > Is the gateway down or are the 4th July celebrations still going on? > > Haven't seen a post since 11th July. > > Okay, the flood g…
Re: Gateway Down?
Mark D. Stock wrote: > Hi > > Is the gateway down or are the 4th July celebrations still going on? > Haven't seen a post since 11th July. Okay, the flood gates are open again today. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mar…
Gateway Down?
Hi Is the gateway down or are the 4th July celebrations still going on? Haven't seen a post since 11th July. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Myd…
RE: Long transactions
Two other options: 1) set up an HPL job; you can run it from the command line (if you really don't want to use dbload, then this would be my recommendation). 2) switch your database to non-logging, run your load (leave out the "commit"), switch database back to logging, then imme…
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 portfolio
> Do jou have any information, desciption or links about informix : > - support to 2pc and 3pc Presumably you mean distributed transactions (2- or 3- phase commit)? I don't know about 3pc but Informix supports XA as well as a proprietary distributed protocol (when talking direct…
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…
Error NO. 243 and 144
Informix Dynamic Server 7.31UD2R1 on HP-UX 11.0 There are two programs with same syntax tries to run almost at the same time and sometimes end up in getting this error. Any ideas or solutions to avoid this will be highly appreciated. Both are using Committed Read Isolation lev…
oninit: Fatal error in shared memory creation
What messages do you get in the online log? Regards Colin Dawson >What is the problem when your shared memory is not allocating and attatching? > >This is what I get >############################################## >$ oninit -iyv >Checking group membership to determine server …
HELP: DBD::Informix issues
Hey guys, I have the following issues with connecting to my DB using Perl. But first some background: I create my DB like: CREATE DATABASE george_db_upp IN maindbs WITH BUFFERED LOG; I use DBD::Informix version 1.00.PC2 Running IDS 9.3: Here's my script: -----------------…
Re: Informix versus oracle
Brandt Edwin wrote: > my apologies, comment taken out of context... > > the context of which you could not have possibly have known. > > allow me to clarify > > i simply meant that when in an sqlplus session, if I issue the command > update, insert, whatever i have to actually …
Re: Running 4gl over other database
Or you can use the Informix Enterprise Gateway Manager or the Informix Enterprise Gateway with DRDA. -Manas --- "Mark D. Stock" <mdstock@MydasSolutions.com> wrote: > Gustavo Tobares wrote: > > Hi all, and thank's for any idea > > > > Somebody know a way to run 4gl aplications …
Re: DB2 to Informix DB connectivity
> > > Hi All, > > Recently, our company started using DB2 UDB ESE V 8.1, and one of the > projects is already in the development. > Otherwise, all projects are on different flavours of Informix Dynamic > Server. > Now, there is a urgent need for Database connectivity between Info…
Re: DB2 to Informix DB connectivity
Sunil, You can use the Informix Enteprise Gateway Manager or the Informix Enterprise Gateway with DRDA for connectivity to DB2 from Informix Let me know if you need more information. -Manas --- Sunil Inchal <sinchal@fsl.org.jm> wrote: > > Hi All, > > Recently, our compan…
Re: access tables in a db2 database
Richard, What is your application written in? If written using Informix application development tools, the DRDA Gateway is your best bet. With the Gateway you won't have to change your application. Release 7.31 of the Gateway is more versatile and powerful. If you have used…
Re: Export data from Informix to MS SQL
Chris, You can use the Informix Enterprise Gateway Manager to move data to and fro from Informix to MS SQL. Let me know if you need more information. Thanks, -Manas --- Chris <chris_baruffi@yahoo.com> wrote: > I apologize up front if this is a really dumb > question but I am…
Re: Export data from Informix to MS SQL
Chris, You can use the Informix Enterprise Gateway Manager to move data to and fro from Informix to MS SQL. Let me know if you need more information. Thanks, -Manas --- Chris <chris_baruffi@yahoo.com> wrote: > I apologize up front if this is a really dumb > question but I am…
IDS 9.40 3rd party database queries w/Enterprise Gateway
All, I'm reviewing the documentation from the IDS 9.40 announcement and it mentions queries across third-party databases using Enterprise Gateway. Does anyone know or has anyone used Enterprise Gateway to connect to MS SQL (ugh, don't worry I hate to have to mention it)? I have…
Need help, OLTP vs. DSS system
hi! i have one big database(around 500 tbls, 15 tbls foreach over 1 million recs) in one instance which supports many OLTP systems and some DSS systems.The diskIO is extremely busy for some tables which belongs to project AA and resides in one SSA loop. Other tables resides in an…
Row Locks When Transaction Logging is turned off
No --- transaction logging and locking are not the same thing. In fact without transaction logging, the role of locking is even more critical. M.P. "Anthony.Oje...." <Anthony.Ojeda@LW To: ids@iiug.org .com> cc: Sent by: Subject: Row Locks When Transaction Logging is turned off …
WebDatablade can communicate to Oracle?
Is anyone know application written by web-datablade can connect to Oracle database? Is web-database can communicate through ODBC? or just through datablade in informix db? or can it be communicate through enterprise gateway? Thanks for your input Kevin Kim…
Committed Read is not enough for fetching BLOB rows...
Hi, I have committed read isolation level between transaction. But in some cases I found that the select queries got error -164:ISAM err: Blob stamp is incorrect. I read the detailed message of this error and I was very surpprised on that. For example I have a transaction usin…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!
>what were the benchmarks for transaction failure and recovery time? >how about distributed transactions? >what's that? postgesql doesn't have transactional integrity? no Yes, it does have transactions. >distributed transaction support? oh. oh well. i wonder who came up >w…
World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!
what were the benchmarks for transaction failure and recovery time? how about distributed transactions? what's that? postgesql doesn't have transactional integrity? no distributed transaction support? oh. oh well. i wonder who came up with the benchmarks. i need a real dat…
Re: Oracle from Informix
Yes its possible. You need an Informix Enterprise Gateway Manager to access Oracle DB/tables from informix. In article <3a068e24$1_4@news.arrakis.es>, "Oscar Garcia" <oscgarcia@hotmail.com> wrote: > Hi! > > Is it possible to access to an Oracle table from an Informix DB? > I w…
some questions about Informix
> > User1 > > begin work; > > execute function sequence('same_name'); > > User2 > > begin work; > > execute function sequence('same_name'); > > If you use CURSOR STABILITY isolation level, then it is no problems with > multiuser access for 'sequence'. I test and ther…
Insert performance is poor
Have you added any indexes? Have you recently deleted many rows from the table? The reason I mention this is that inserts to a full table which extends the number of pages used, inserting to pages never touched before, is more efficient than inserts which re-use pages deleted fr…
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…
performance with very active threads
During a checkpoint you only have 8 cleaners utilized to flush 63 LRU's. That's 4 passes. Make LRUS=64 and CLEANERS=64. That's one pass. Let the disk subsystem figure out any contention. They're pretty good at that:) Also increase CKPTINTVL to every 30 minutes. Why have a …
Re: FYI: The gateway is down
Maybe they are removing that ridiculous naughty word filter...... > The gateway between informix-list and comp.databases.informix is down. > > As Walt Hultgren sez, > "I suspect it will be fairly obvious when things are working again." > > -- > Colin…
FYI: The gateway to informix-list is down
FYI: Mail going to informix-list is not getting to comp.databases.informix and vice-versa. The gateway between informix-list and comp.databases.informix is down. As Walt Hultgren sez, "I suspect it will be fairly obvious when things are working again." -- Colin Sent via Deja.…
FYI: The gateway is down
The gateway between informix-list and comp.databases.informix is down. As Walt Hultgren sez, "I suspect it will be fairly obvious when things are working again." -- Colin…
LONGTX message during engine startup
Here's the message: Informix Dynamic Server Version 7.30.UC2 -- On-Line (LONGTX) -- Up 00:06:56 -- 323584 Kbytes Blocked:LONGTX From online.log: 15:33:11 Continuing Long Transaction (for COMMIT): tx 0x8fc70cb4 no user info due to XA or distributed (2-phase commit) transact…
Censorship?
Hello all, I noticed that my post quoting Tim's post in full *also* didn't make it out. Is there some censorship going on at the email gateway? I'd be very aggrieved to find out there was. :-( ________________________________________________________________________ Get Your Priv…
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…
Off topic: EMail To: line
Just curious. Is there a glitch with the gateway or is Cheryl Kendricks REALLY prolific today? This is my first day on the listserv and I'm just wanting to make sure that all is well. John Carlson Informix Database Administrator…
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…
Posting from the Informix-list
In article <8k1rhh$uf$1@news.xmission.com>, Lewis, Keith A. <Lewis@timken.com> writes > >Hello, > I have a problem with queries using all of the temp dbspace. We >just moved to IDS 7.31 FC4 from >IDS 7.30 UC3. The same queries run fine under the previous version of >Dynam…
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…
Re: Non-Informix databases
Informix Enterprise Gateway with DRDA. "Colleen M. Morrow" To: informix-list@iiug.org <cmmorrow@jon cc: (bcc: Kernoal Stephens/STS/AUTOZONE) esday.com> Subject:…
Non-Informix databases
i would guess you could do that with the enterprise gateway manager. "Colleen M. Morrow" wrote: > _______________________________________________________________ > > This message and any attachments are intended for the individual or entity > named above. If you are not the in…
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…
Problem with distributed transactions
Hi, We are using an Informix 7.23.UC11 On-Line Database, on HP-UX 10.20 with MC-/Service Guard on two HP9000-K380, and TUXEDO v6.3. Following a crash on one server, due to a hardware problem, we use the second server for he high-availability of the application, we obtain one di…
Informix OLEDB and MTS
Hi all, I using the OLEDB Provider 2.0 from Informix, but I think this Driver doesn't support transaction within MTS. Because of this I used the Informix ODBC Driver 3.30 32Bit wich supports transactions, but this Driver is very slow. Does anybody know if there exist an OLEDB Pr…
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…
Re: Memory problems? Please help.
From: "Vincent Kennedy" <vkennedy@torex.co.uk> > >I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > >They used to be executed during a shell script containing abotu 30 >programs. >However, this was poor for maintenance and distribution so one exe was >com…
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…
informix connect to as400 database
hi... 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 ??/ Thank in advance ~sq…
RE: Personal Oracle 7 -> Informix IDS 7
This product is not free (I think). I send to you link about Informix Enterprise Gateway Manager: INFORMIX-Enterprise Gateway Manager is a member of the INFORMIX-Enterprise Gateway family, a complete set of standards-based gateways that includes INFORMIX-Enterprise Gateway with …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
RE: Shared memory creation during oninit process
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_01BF636D.CCA2C94E Content-Type: text/plain; charset="iso-8859-1" Look in the release notes. There are some kernel para…
Stored procedure locks
Mukund D Shevkar wrote: > > I have 2 stored procedures running simultaneously (written by development > team) and updating same table for some cause. > How can I set another procedure to wait until the time first procedure > completes. > How can I issue a lock on a row instead of…
Shared memory creation during oninit process
I am posting my online.log, onconfig, and sqlhosts files. Hopefully this will help in determining what's wrong. Thanks again in advance! "ONLINE.LOG" ------------------------------------------------------------------------ 17:51:48 shmget: [EEXIST][17]: key 52574801: shared m…
Some questions about Dynamic Server - HELP
Hi, I am preparing a comparision of different RDBMs for my boss. I am curious about some questions (I can't find answers on Informix site). What phisical limitations for database elements does Dynamic Server have? I.e.: maximum count of tables = max size of one table = max size…
Upgrade from 9.12
We wanted to upgrade from 9.12 and received the 9.13 upgrade cd, and 3 dat tapes. On the purchase order we are supposed to receive the gateway manager, sdk, and the ids/udo 9.<upgrade#> ( actually hoping we would get 9.2 but instead got 9.13 UC something...) Anyway i was looking…
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…
Row locking in dynamic server
Rüdiger Breit wrote: > General question: how can I achive row locking in a > multi user environment. Seems not to work for me > > I experiences a problem with row locking with > Dynamic Server 7.3 under Linux. Even a simple > test would not run: > > Databse create with ANSI comp…
Re: checkpoints taking as much as 25 secs
Great answers from Peter, Obnoxio, and Lloyd. Yes you are seeing a bufwaits ratio of around 40% which is horrific, we need to try to get that under 10% with a preference for a value under 7%. Take Lloyd's or Obnoxio's recommendations for LRUS and CLEANERS and the LRU_MIN/MAX_DI…
Re: checkpoints taking as much as 25 secs
Try modifying your LRU's to something like 63. Make your page cleaners equal to your LRU's value. I find I get considerable performance from my server set this way. As well, checkpoints on high end machines running hundreds of users using ~10GIG+ databases range from 1 -2 secs. …
Segmentation faults in Solaris
I just recently started working on a Solaris system (SunOS 5.5.1, INFORMIX-4GL Version 7.20.UD1 INFORMIX-Universal Server Version 9.14.UC6X5 ) and I've been trying to port some programs that have been working just fine on SCO and AIX. Two of them die with a segmentation fault …
Re: I-STAR, OnLine 5.10 & ODBC Question
From: Colin McGrath <cmm@trac3000.ueci.com> > >A client wants to get an ODBC product running with their OnLine 5.10 >engine. >They have been told they will need to purchase I-STAR in order to do that. >I had thought Informix-STAR was needed only when it was desired to work >simul…
Distributions and dostats
In article <81edpn$249$1@nnrp1.deja.com>, kagel@bloomberg.net writes >In article <81cbr3$j13$1@news.xmission.com>, > Dick.Brieck@chase.com wrote: >> >> >> Greetings. I have a few questions regarding using distributions with >IDS. >> We're currently using >> IDS 7.30.UC6 on Sola…
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…
LBU_PRESERVE
When you recycled your instance, you should have seen a line between the time of the recycle and coming online stating the parameter and the old and new value. Did you see this? If not, for some reason, the change did not take effect. The solution would be to recycle the inst…
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…
Re: ANSI mode DB's and DBIMPORT
David Williams wrote: > > In article <7u5mee$qf1$1@news.xmission.com>, Mark D. Stock <mdstock@myda > s.freeserve.co.uk> writes > > > >FProse wrote: > >> > >> Ran into an 'interesting' situation this weekend using > >> dbexport/dbimport to move an ANSI db between two servers (the …
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Gateway
HI folks We have a need to be able to access an Oracle 8 database via our Informix 4GL applications (we are running Informix DSA 7.30). After lots of research (and not much help from Informix) I believe we need: INFORMIX OPEN (this will give us a ODBC Oracle Driver) INFORMIX G…
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…
SPL exception for success?
I have a SPL routine that is giving the following exception for success. The command is (with definition): DEFINE bXtractSuccess BOOLEAN; Let bXtractSuccess = 'T'::BOOLEAN; The trace output is: expression:"T"::boolean evaluates to t let bxtractsuccess = t exception : lookin…
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: informix <--> oracle connectivity
Nick A colleague mentioned using the Oracle extension to Perl (oraperl?) and the DBD::Informix to write a script that reads from one database and write to another. Or you could use Java and JDBC to both Oracle and Informix. They may work out as better (ie non-vendor specific) ap…
Re: informix <--> oracle connectivity
My unit looked into the Informix Gateway product for Informix - Oracle connectivity and found it a bit pricey at US$20,000 +. We decided to pass data using simple unloads and loads. In Oracle unloading Ascii is not as easy as in Informix. We have also considered using somethi…
informix <--> oracle connectivity
Edward Rosenthal wrote: > > In a heterogenous environment ( oracle and informix db's on unix > servers, > solaris and hp ). Its probably oracle 8.X and its informix universal > server 9.12UC2. > I need to find out if the Informix product Enterprise Gateway Manager is > what I wan…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: record locks and timeouts
Mike Cabaniss wrote: > > Two questions on IDS: Good clear newbee questions. > 1. when doing an update a lock placed on the individual record or table > level? Depending on the table's lock mode, row or page (default page), a lock is taken on the data row or the page on which i…
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…
Correct use of the X/Open XA-Interface
Hi everybody! We want to do the transactional publish/subscribe in the context of a X/Open XA distributed transaction. We must think of two application scenarios: 1) the UDR's are called through ESQL, in a global distributed transaction context managed by CORBA OTS 2) the UD…
Join between 32-bit and 64-bit servers
Hi Family! I have been pushing my users to start upgrading to 7.3x and I may have started to make some headway on this. In my environment, most of the queries (and many of the updates) processed by my engine come in from another server, often as part of a join between the databa…
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…
Informix Gateway - outer join
Hi, Any body used outer join using Informix Gateway? Client server -- Informix 7.x ( HPUX) Application server -- DB2 Informix Gateway 7.30 I would like to know whether anybody had any issue using outer join of DB2 tables from Informix client Thanks in advance Dhanesh…
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…
threads + connections (same process)
I've had a problem with a certain database: open two connections within the same process, but different threads (Unix) and try to write to and commit to the same row simultaneously from the two different connections. Not only does table lock not occur correctly, but both thread…
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…
transaction isolation levels, and locking
Say I have two separate transactions. In the first transaction, I update a row in a table, but have not yet committed the change. Now, I would like for the second (and all other) transactions to see the *previous value* (which is the last value committed) of the changed row, u…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Re: Q: How is the transactional behaviour in an Informix DB implemented?
Filip, Informix supports XA if that's what you're after. We use 7.22 with Tuxedo 6.3. There are some restrictions on what statements you can use in your Tuxedo servers, since Tuxedo (or whatever TM) now manages the transactions and the connections: you can't commit, rollback, co…
Q: How is the transactional behaviour in an Informix DB implemented?
Dear all, The X/Open DTP (Distributed Transaction Processing) standard defines the protocols to make a DB transaction capable. Can anyone explain me how these protocols are implemented in an Informix DB system? Are there any general rules which are usually followed when makin…
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…
Re: anyway to optimize this query?
query only. Obnoxio The Clown wrote: > >let's see... > > > >there are 61772773 rows in the table. > > > >The table is indexed on three fields, let's call it f1,f2,f3, it is a > >composite index, the reason I do that is because > >there is also a where clause in the query which…
Re: anyway to optimize this query?
>let's see... > >there are 61772773 rows in the table. > >The table is indexed on three fields, let's call it f1,f2,f3, it is a >composite index, the reason I do that is because >there is also a where clause in the query which uses all three fields as >criterias. > >update satis…
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…
Comparison between the "Key Players"
Greetings ! May be this might help you. Ganesh ---------------------------------------------------------------------------- --------------------------------------------------------------------------- RDBMS Server Feature Comparison Matrix: Version 1.0.2 Copyright 1993 by Dani…
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?…
How setup a database on different host.
Liu Jiachuan wrote: > > Hi, everybody. > > I want to ask you some question. > My environment is that the OS platform is SCO unix release 5.0.4, and the > informix is online 7.3. I don't know whether the informix can support the > distributed database. I have fulfilled that the pr…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: Two-Phase-Commit
You won't be able to do distributed transactions between an ANSI and non-ANSI database. rainer.von-bongartz@dil.de wrote: > I want to set up a two-phase-commit protokoll between an > unbuffered and an ANSI compliant database. > > I only get errors saying "cannot reference exter…
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: any known problem with Data Replication in Informix?
I was involved in the full implementation of HDR ( heterogeneous data rep ) here in the UK for 2 IBM RS6000 F50 & F40 machines using Informix Workgroup Server 7.3. As far as config goes its a piece o' cake. The only initial problem we had was that the application had to be turne…
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…
gatewaying
I have Applixware 4.4.1 and get this error when trying to gateway to Informix from applixdata. Error -354 incorrect database or cursor name format. Any ideas?…
Assertion Failure Message
I am constantly having problems with my informix ver 7.2 database on HP-UX 10.2 which is constantly hanging and gives the following error message in the log file. and dumps the file shmem.101c9b.1 in /tmp. After this the whole system becomes slow and for it to be fast you remove …
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…
Enterprise Gateway
How does this product work. Any experience working with AS400 (OS400)…
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: DS 7.23 performance
Hi Niclas, first, read your Release Notes concerning the SHMBASE settings. You just have about 2000 BUFFERS, that is, 4MB of memory for your cache and about 8MB for the virtual segment. It must be possible to increase your cache. Your complete configuration file looks a bit as …
DS 7.23 performance
We have upgraded from Online 5.06 to Dynamic Server 7.23.FC1 on OSF1 ver 4.0 and have major performance problems. Some applications now are up to 6 times slower. Applications also once in a while receives error -25587 and -25588. I've tried to increase LOCKS and BUFFERS, but th…
Re: Tunning question
In article <6so5p8$rs5$1@nnrp1.dejanews.com>, PabloF@my-dejanews.com () wrote: > > > Hi all, > we have a 2 CPU, Unix Alpha 8200 machine running Informix ODS 7.23.FC4. > onstat -p shows: > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 4966206 17506603 1…
Tunning question
Hi all, we have a 2 CPU, Unix Alpha 8200 machine running Informix ODS 7.23.FC4. onstat -p shows: dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 4966206 17506603 190285614 97.39 338155 613077 18712111 98.19 isamtot open start read write …
Re: Update big tables !
Rok, You can move in two directions: 1. Increase logical log space. 2. Reduce size of the transaction by inserting COMMIT WORK operator(s). If update information comes as a flat file, you can split it and run more than one update process (sequentially or in parallel). No…
Re: Along the lines of SQL server (was:General Questions From Informix Newbie)
NewHorizon wrote: > > I just hate asking dumb questions - doncha hate reading them? - but... > > A customer has an MS-Access database and MS-SQL server. > We've got Netscape's Entprise Server Pro w/Infomix under IRIX. > My level of knowledge doesn't go deeper than SQL. I can't …
Along the lines of SQL server (was:General Questions From Informix Newbie)
I just hate asking dumb questions - doncha hate reading them? - but... A customer has an MS-Access database and MS-SQL server. We've got Netscape's Entprise Server Pro w/Infomix under IRIX. My level of knowledge doesn't go deeper than SQL. I can't seem to get dbaccess to conne…
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: Logical log size
Hi Carlson, first of all, rows that will not be changed during an update operation will not be logged, that is, if you set a field's value to the same value it contained before, this will not be marked as an update and therfore will not be logged in the logical logs. If you cha…
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…
Logical log size
I looked all around and couldn't find any info, so, here goes . . . How much logical log space is used on an update? I will be updating two columns (smallint) of each record on various tables in my system, along the lines of . . . update table_name set upd_a = new_v…
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: Creating Informix Views on Oracle tables/views....
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. Currently there are several permanent/consulting positions available for a programmer/analyst with background such…
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…
Creating Informix Views on Oracle tables/views....
Hi All, Does anyone knows as to how to go about creating views in Informix Database v7.2 for Oracle objects (Tables,Views) v7.3.3... All what we need is a SQL-based gateway that allows Informix tools, applications and databases to interoperate transparently with non-Informix da…
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: Stored Procedure
The following modification should work: > let j = 1; begin work; > foreach cur1 for select testschalter into i from import > if i > 100 and i < 1000 then > update import set testschalter = j where current of cur1; > commit work; begin work; > let j = j + 1…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
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…
TP/XA Informix and Transaction Servers
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
Microsoft Transaction Server & Informix
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
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.…
Re: locking
In <01bd4bfd$5f328f40$6df3e7cc@service.beijing.informix.com> "Birdman" <fanjun@writeme.com> writes: >ANTS <sui@naseej.com> wrote in article <6e1dbo$bpd$1@news.xmission.com>... >> We have a 4GL program whenever it runs it will lock several tables. The >> problem is that the lock…
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.…
Recommend for Informix to Oracle Gateway Products
Can anyone recommend any Gateway products they like (and why) for taking data from an Informix to an Oracle environment? Thanks in advance, Kathy Harris kaharris@nas.edu…
Gateway down?
Is the gateway down? I'm missing my usual flood of mail from CDI. cheers j.…
Connecting to Oracle from Informix
I've perused the IIUG archives and dejanews also. Still have some questions. We're in the midst of negotiations with a retail software company to install a new POS system in our stores. Data will be polled from the individual stores and reside in the Oracle data warehouse, her…
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…
Re: week of year function
> easy. Adjusting for leap years, the DOW for any given date shifts > forward one day from the previous year (2 in a leap year) ... Only if that date in question is after Feb. 28. For instance, March 1, 1995 was a Wednesday, March 1, 1996 was a Friday, two days as stated in yo…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Anthony Mandic <no_sp.am@agd.nsw.gov.au> wrote in article <3490B6CD.202C@agd.nsw.gov.au>... > Johan Andersson wrote: > > > So, *are you listening Anthony*, I propose the following test application, > > with an ever increasing transaction complexity, to show that the finer > > gra…
Re: Couple of problems...
} > Status: R } > } > Hello, } > } > I have two problems not related to each other. } > } > (1) I am using Informix ODS 7.10 and want to extract data onto ASCII files } > after left-padding and right-padding certain fields so that the load files } > working on these files…
Re: Very Severe Performance Problems on my 7.22 UC2
In article <memo.19971026023519.4311A@bew.compulink.co.uk>, Brian Wilkins <bew@cix.co.uk> writes >In article <62lp3v$l86@cssun.mathcs.emory.edu>, >sujata_soman_at_omm-la2-infotech-001@internet.omm.com () wrote: > >> >> Hi everybody, >> I have been having some severe …
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Very Severe Performance Problems on my 7.22 UC2
In article <62lp3v$l86@cssun.mathcs.emory.edu>, sujata_soman_at_omm-la2-infotech-001@internet.omm.com () wrote: > > Hi everybody, > I have been having some severe performance problems on my > development box in the last couple of weeks, and it is obviously > …
Re: How to load table without log
dbload has an option for committing after X number of records. -Bill Adam Sorati wrote: } } Eng: online 7.23.UC1 } OS: AIX 2.4.1 } HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. } DB: 1.3 GIG } } Could someone please advise me of the best way to load } a table without using the …
Re: Very Severe Performance Problems on my 7.22 UC2
In article <62lp3v$l86@cssun.mathcs.emory.edu>, sujata_soman_at_omm- la2-infotech-001@internet.omm.com writes > > Hi everybody, > I have been having some severe performance problems on my > development box in the last couple of weeks, and it is obviously > some…
Very Severe Performance Problems on my 7.22 UC2
Hi everybody, I have been having some severe performance problems on my development box in the last couple of weeks, and it is obviously something I have changed !! If only I know what and why. Some processess went from 2.5 hrs to over 8hrs !! By the w…
Informix Entreprise Gateway
I have users connected on Informix 7.12 on NT. I want them to view some data on Sybase. So I think that Informix Entreprise Gateway is my solution. Does anyone already use it ? And do you have some good tricks ? Thank Luc Vallieres…
XA client support on NT
Does anyone know which level of Informix client do I need to get the XA (distributed transaction processing two phase commit API) support on NT 4.0? I currently have ESQL/C 7.20.TE1 for NT installed, and don't see any of the XA client DLLs. Will the NT client XA support work for…
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…
Know of any good Gateway products??
I am interested in finding products that can provide a gateway to Informix, DB2, and possible ADABAS database tables. I would like to have bi-directional access i.e. Desktop apps like VB accessing Informix on UNIX and DB2 on MVS and conversely MVS Cobol apps accessing both DB2, …
Re: how does ODS uniquely id transactions?
Wanda, I don't have an answer for you but I can back you up with my own little investigations. I tried it myself out of curiosity and got the same results. So this is not an entry in the journal of irreproducible results. I found some other anomalies: - When I specified a us…
Re: Know of any good Gateway products??
Bruce_Farwell@spartanstores.com wrote: > > I am interested in finding products that can provide a gateway to Informix, > DB2, > and possible ADABAS database tables. I would like to have bi-directional > access > i.e. Desktop apps like VB accessing Informix on UNIX and DB2 on MVS…
NEWBIE: LOE to install-configure Oracle gateway-Informix
I'm a mid-level Oracle DBA with no Informix education / experience. I've been tasked with replicating data from Oracle 7.2.2.3.0 to Informix 7.x. After some research I recommended Oracle's Transparent Gateway for Informix. Before my boss makes this recommendation to his boss(es…
NEWBIE: LOE to install, configure Oracle Gateway-Informix
I'm a mid-level Oracle DBA with no Informix education / experience. I've been tasked with replicating data from Oracle 7.2.2.3.0 to Informix 7.x. After some research I recommended Oracle's Transparent Gateway for Informix. Before my boss makes this recommendation to his boss(es…
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…
Enterprise Gateway
Folks, I am looking for a product that will take data from my database instance (informix 7.2) to a Sybase DBMS to update one of their databases. Has anybody out their used "Enterprise Gateway" to do anything like this? Comments on uses of this product would be greatly appre…
Re: Performance degradation question w/transactions
Roger Tomas <tomasr@agcs.com> wrote: :John Cowles wrote: :> :> Test 1: :> ------- :> :> Insert 100,000 rows into the table. :> Each insert is an individual transaction. :> Here is the excerpted SQL file I executed: :> :> begin work; :> insert into rows values ('key…
Re: Performance degradation question w/transactions
Roger Tomas <tomasr@agcs.com> wrote: :John Cowles wrote: :> :> Test 1: :> ------- :> :> Insert 100,000 rows into the table. :> Each insert is an individual transaction. :> Here is the excerpted SQL file I executed: :> :> begin work; :> insert into rows values ('key…
Re: 7.21.UD1 Perf. Problem
In article <5oai41$5ue@dfw-ixnews7.ix.netcom.com>, Kerry <dino@ix.netcom.com> writes >Greetings! > >We are upgrading a Version 5.03 OLTP system to Version 7.21.UD1, also >upgrading to 4GL 6.05 (pre-release due to bugs in 6.04). > >We have a group of programs that are doing a lot …
Re: Performance degradation question w/transactions
John Cowles wrote: > > Test 1: > ------- > > Insert 100,000 rows into the table. > Each insert is an individual transaction. > Here is the excerpted SQL file I executed: > > begin work; > insert into rows values ('key_0', 'anything', '0', 'today', 'today'); > co…
Re: Adjacent Key locking
Denham.M@amstr.com wrote in article <5n70ge$53r@cssun.mathcs.emory.edu>... > Nicholas > > As far as adjacent key locking is concerned, forget it. If my memory serves me correctly > this was an issue with V5 and earlier engines. Not V7. > > I cannot of course vouch for the fact th…
Re: Q: 4GL -> Java good idea?
>> >> Check out http://www.hwsl.co.uk/wdbc >> >Are You sure this URL is correct? Apologies ! It should have been: http://www.hwsl.co.uk/mgw Brainstorm ! Regards Rob --- Rob Tweed Nucleus Design Ltd : http://www.nucleus.co.uk M/Gateway Developments Ltd : http://www.h…
Radical new web gateway technology
+++ Just launched +++ WDBC - The Web DataBase Connector A radically new approach to Web/Database Gateways, featuring: - the highest performance of any gateway available - no more scripting on the web server - ODBC overheads avoided - true stateful mode - and many more benefits…
DATABASE GATEWAYS
Hi there, I am looking for a source(s) of any good database gateway products, preferably these won't use ODBC. An example of whch is the Oracle to MS-SQL Server gatway product that utilises Oracle SQL*Net. Product(s) that I'm looking for will include connectivity to and from :…
EDA/SQL to Oracle?
I am working with an Oracle database (7.3) running on NT4.0. I need information from another product using an Informix database on HP-UX. Informix should be controlling the communications. On Informix's web site I was reading up on the Enterprise Gateway for EDA/SQL product. It a…
open API to write a gateway?
Hi there, I am designing a research project and wondering whether Informix has some open API (similar to Sybase's open server API) which allows the construction of a gateway. This gateway looks exactly like an Informix database server at the Informix CLI level (e.g., clients ca…
Re: What is a long transaction
Hi Stephane, I do this all the time. I use dbload which allows to specify how many rows to load before doing a commit. I suggest taking a look at that utility. A long transaction occurs when you ask the system to log a great of information in one transaction. The engine logs…
Queries on Universal Server - Part II
28/FEB Hi Few more question on Universal Server Expecting your reply With Regards GANESH Image / Sound : How to Insert the Image / Sound in to the table. Should I create the = Image / Sound as a file=20 such as .BMP / GIF (for Image) & .AVI for (Sound) and Insert into the =…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Faxing from Informix running under SCO 4.3v2.3
Kate Juliff wrote: > > I have an application in ISQL that generates letters to customers. i'd > like to be able to automatically fax these. I also have ESQL. Any > pointers on how to do this/ fax software etc.? > > Kate In the past I have used a paging system interface via the S…
Re: Oracle & Informix connectivity/coexisting issues question
Dave Dargo wrote: > > > >4. Does Informix or Oracle provide assists for database access in a > mixed > > >database environment? > > Each supports their own product and ignores the other one. > > Actually, Oracle provides the Oracle Transparent Gateway for Informix. > This produ…
Re: Oracle & Informix connectivity/coexisting issues question
> >4. Does Informix or Oracle provide assists for database access in a mixed > >database environment? > Each supports their own product and ignores the other one. Actually, Oracle provides the Oracle Transparent Gateway for Informix. This product allows Oracle clients to acces…
Defunct processes...
We have an Esql/C application which is causing defunct processes to hang around and this seems to be degrading performance on our system. We have checked the code and it all seems to be okay. I should explain that this C code is compiled as OpenSQL under Ingres, and is going thr…
Re: Cobol gateway
Informix ESQL/COBOL. I have evaluated it on HP-UX, but I'm sure they have a version for SCO as well. >> Does anyone know whether there is an Informix gateway for MicorFocus >> (under SCO Unix) ? >> >> Any help will be appriciated.…
Cobol gateway
Does anyone know whether there is an Informix gateway for MicorFocus (under SCO Unix) ? Any help will be appriciated.…
Re: SQL code -246, ISAM code -154 problem.
On Wed, 22 Jan 1997 15:53:49 -0500, Peter Jennings <peter_jennings*@uk.ibm.com> wrote: >Peter Jennings wrote: >> >> Running OnLine V5.0 under AIX. >> We have a begin/commit process that locks a >> parent record by updating a column with its >> current contents. We find that if t…
Re: SQL code -246, ISAM code -154 problem.
Peter Jennings wrote: > > Running OnLine V5.0 under AIX. > We have a begin/commit process that locks a > parent record by updating a column with its > current contents. We find that if two users > try to update different rows in the same child > table, the first will suceed and t…
Re: FW: SQL code -246, ISAM code -154 problem.
The error and scenario you describe can be cause by one of three problems that I've encountered: 1) bug# 14829 - successive inserts and deletes can lead to negative pn_npdata. This occurs in some 5.0x version of online and is real fun to track …
Re: SQL code -246, ISAM code -154 problem.
P. Jennings wrote: }Running OnLine V5.0 under AIX. }We have a begin/commit process that locks a }parent record by updating a column with its }current contents. We find that if two users }try to update different rows in the same }child }table, the first will suceed and the other …
SQL code -246, ISAM code -154 problem.
Running OnLine V5.0 under AIX. We have a begin/commit process that locks a parent record by updating a column with its current contents. We find that if two users try to update different rows in the same child table, the first will suceed and the other fail with SQL code -246, IS…
FW: SQL code -246, ISAM code -154 problem.
We need more info to help but one thing you may want look at is your Isolation level. if you are not using dirty read you may run into locking problems of this type. Russ... }---------- }From: Peter Jennings[SMTP:peter_jennings*@uk.ibm.com] }Sent: Monday, January 20, 1997 2:…
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…
Re: Oracle vs Informix comparison
David Williams <djw@smooth1.demon.co.uk> wrote: >In article <58if4p$oca@dfw-ixnews2.ix.netcom.com>, Rajashekar >Sundaramurthy <rajsekar@ix.netcom.com> writes >>You wrote: >> >> You are describing a synchronous replication scenario wherein the >>updating transaction waits for the…
Re: Asynchronous Replication
David Williams wrote: > > In article <574i98$4d9@cssun.mathcs.emory.edu>, Carol Davies > <cdavies@csc.com> writes > >We had a demo of beta 7.2.2 from Informix yesterday for CDR. The GUI > >configuration administration is indeed run from a NT PC, and then > >configuration info is…
NO RESPONSE FROM SERVER PROCESS
Montree Saengchannukul wrote: } } Help me,please !!!!! } I use INFORMIX V.7.2 on IBM RISC/6000,AIX V.4.1.4. } (memory 256 MB,2 cpu) } I have some problem: } When my user can't connect to database (through ODBC) he tells me. } And in that time I call "onstat -i" it…
Re: NO RESPONSE FROM SERVER PROCESS
Montree Saengchannukul wrote: } } Help me,please !!!!! } I use INFORMIX V.7.2 on IBM RISC/6000,AIX V.4.1.4. } (memory 256 MB,2 cpu) } I have some problem: } When my user can't connect to database (through ODBC) he tells me. } And in that time I call "onstat -i" it…
Re: Informix / Oracle Gateways
vince.nichols@mci.com (Vince Nichols) wrote: :I am interested in finding Gateway software to connect Oracle and :Informix Databases. I would prefer to use Informix provided products :if possible. Is there any software out there that may suit my needs? :Thank you for your replie…
Informix / Oracle Gateways
I am interested in finding Gateway software to connect Oracle and Informix Databases. I would prefer to use Informix provided products if possible. Is there any software out there that may suit my needs? Thank you for your replies. Vince Nichols…
Re: Gateway for Informix to/from Oracle
Try the Orsacle Gateway tool.…
NewEra - pessimistic locking
I have an application which has two windows, both afcl tabbed windows with a master Supertable and several detail supertables. I want to use pessimistic locking on both the master supertables. Within the application, there is a requirement that the user is able to add a new rec…
Re: MULTIPROCESSOR OPTION 7.13
Allen Jantzen <allenj@ndr.com> wrote in article <327fa20d.27552573@news.netline.net>... > The Informix DSA Administrators Guide, version 7.1, page 10-18 says > > "On some two-processor computers, you should only run one CPU virtual > processor because the overhead of synchronizin…
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…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Re: Is This Behavior Documented?
M. Livenspargar wrote: > > And if so, where?? > > I have a table with one column of datatype serial. The table has 2 > rows when I execute the following SQL in DBAccess: > > set isolation to committed read; > begin work; > insert into table1 values (0); > select count(*) from tab…
Is This Behavior Documented?
And if so, where?? I have a table with one column of datatype serial. The table has 2 rows when I execute the following SQL in DBAccess: set isolation to committed read; begin work; insert into table1 values (0); select count(*) from table1; rollback work; The 'select count(*)…
Enterprise Gateway
Has anyone used the Informix Enterprise Gateway to run an EDA stored procedure with dynamic parameters? The Informix documentation only shows examples using static parameters like the following: execute procedure myrpc("parm"='value'); I'm trying to use a variable for the stor…
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…
Interruption in gatewayed articles
The news server that is used by the gateway software that links the Informix mailing list (informix-list) with comp.databases.informix was down for over a day. It appears to be back up now, so prepare for a surge of gatewayed articles. Walt. -- Walt Hultgren Inter…
Re: Change of Logging Status: Implications?
Will Hartung - Master Rallyeist wrote: > > [ From no logging to logging problems ] > > I, personally, am a big fan of transactions. They let programmers do > all sorts of horrible things to the data, and then when they discover > a problem, they just go "Oops! Just Kidding!" and …
Re: Re[2]: HELP Informix Locks
tvarnas@compulink.gr (Apostolos Varnas) wrote: <snip> >it depends how the data you want to update is distributed on the pages.At the >worst case if it is distributed across 1000 pages you will need 1000 locks. <snip> >Assuming your data is stored contiguous it is then placed o…
Re: Enterprise Gateway
Anthony Larman wrote: > > I am currently on a project that will provides reference data for approx. 40 > distributed servers. These servers will be indifferent environments and have a > permutation of RDBMS/platforms eg. Oracle/Unix or MUMPS/VMS to name a few. > > I would like to…
Re: Enterprise Gateway
I am currently on a project that will provides reference data for approx. 40 distributed servers. These servers will be indifferent environments and have a permutation of RDBMS/platforms eg. Oracle/Unix or MUMPS/VMS to name a few. I would like to provide a generic solutions and …
Re: WWW and cgi and Informix
Robert Stuart (bobs@panews.press.net) wrote: : > "Larry Timmins" <timmins@ix.netcom.com> wrote in article : <01bb5cde.bb160c20$82f0b9cd@the-big-mipper>... : > : > If anyone is also working on distributed applications, involving PCs : with : > browsers : > surfing their Informix …
Re: WWW and cgi and Informix
> "Larry Timmins" <timmins@ix.netcom.com> wrote in article <01bb5cde.bb160c20$82f0b9cd@the-big-mipper>... > > If anyone is also working on distributed applications, involving PCs with > browsers > surfing their Informix database via HTML, Frames, and CGI (*perl, > isqlperl) scri…
Re: Advice for an Oracle Jock
> > Oracle has a bit of a technology edge right now. If the specific problems >you will be asked to address fall in that area AND you must solve it quickly, >then choose Oracle. But, you will pay and pay and pay through the nose for >the convenience. This edge is in the dist…
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…
lock table doesn't!
I've hit a problem with Online v7. I have a 4gl application that allows (some) users to shell out. If I select this option, run dbaccess and run the following sql : begin work lock table update blah blah... commit work Online seems to ignore the lock table and locks each ro…
Re: Logical Logs
Dave writes: > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with …
Re: Log files in Online 5.x
Hi, Unfortunately the only way I know of to change the log file size is to re-initialize. You can however add more log files which will help the long transaction situation. Just add some logs and then do a level 0 archive to enable them. -Bill > > Can anybody tell me an easier …
Re: Log files in Online 5.x
dave, > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with very sm…
4GL WITH HOLD PROBLEMS
This is a multi-part message in MIME format. --------------20645BD73F63 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can anyone help with the following problem? if so, could you post any comments or email me on jonathan@emltd.co.uk Thanks -----…
4GL HANGING PROBLEMS
Situation: I am using a cursor declared WITH HOLD to step through a series of records. I have two other cursors, an update cursor to lock the row and a normal cursor tpo refresh t he screen details, which are used as I step through the rows. All three cursors are prepared at the…
Tips on a highly available & scalable dbms needed
We are trying to select a relational database that will have the following properties: - Windows NT compatible: use native NT threads, and not be just a Unix-port to NT. Plus all of the product (tools, APIs, etc.) must function in the NT environment. - Scalable: up to 100 milli…
Informix Gateway
Hi, Has anybody out there used Informix's Gateway products? How good are there? I've been trying to get an evaluation copy from Informix for a while, but never heard back from them. Any information you can provide me about these products will be appreciated! Jin.…
Re: Is www.informix.com alive and well?
Problem Resolved! First I want to thank Harry Bochner, Mitangi Patel, Kathy Farr (interramp) , and all the other nice folks who contributed their ideas and information to help me resolve this problem. Also, I want to thank all the usenet users here who have been very patient …
NEW Win/NT RDBMS comparison matrix
I ran into a RDBMS comparison matrix recently, but it was out-of-date (last update 1993) and it's scope was too broad in some respects, too brief or narrow in others. This time around, I've decided what's really key for upsizers and downsizers is an NT-centric comparison matrix. …
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
james.lawrence@epamail.epa.gov (Lawrence James) wrote: >In article <1f7cc$c2716.d4@news> Matthew Houseman <mhouseman@arborsoft.com> writes: >>isn't oracle replication simply PL/SQL? it may be easy to >>use, but don't we all feel the need for speed for this sort >>of technology…
Re: HELP! My log is gone and I can't get up
In article <DJMxpo.vo@cuug.ab.ca> kniver@cuug.ab.ca (Roy Knive) writes: >Newsgroups: comp.databases.informix >Path: news.voicenet.com!netnews.upenn.edu!dsinc!spool.mu.edu!howland.reston.ans.net!swrinde!newsfeed.internetmci.com!in2.uu.net!uunet.ca!news.uunet.ca!cuugnet!kniver >Fro…
Gateway to Progress
Hello out there! I hope someone can help me with my problem. I'm trying to make a informix database server communicate with a progress front end application & I'm having problems at the moment. If anyone out there can give me any helpful suggestion pls. do so. Thanks Prosoft…
Re: Query - Two Phase Commit
Hi Suchitra, If you need Two Phase Commit implemented within the DBMS you need to use OnLine, not SE. SE does not have any built in support for distributed transactions. OnLine fully supports distributed transactions, with 2PC. Chris Jenkins Suchitra Rao wrote: > I wish to de…
Re: Market Share
tkyte@us.oracle.com (Thomas J Kyte) wrote: [snip] >No it doesn't. SE is basically a cheap, small database with NO >Multithreaded Server >Parallel Anything >Transaction Logging >BLOB Support >Database Mirroring >Distributed Features >24x7 Support >Row-level Locking >Replication …
Re: Faulty BEGIN COMMIT on Informix 4.1
andro@ibm.net (rk) wrote: > > Need assistance from Informix gurus out there! > > Is there any guarrantee that statements inside a BEGIN-COMMIT would be > done atomically. We are using Informix 4.1 on top of AIX 3.2, and we > have discovered that several times the BEGIN-COMMIT in …
Re: Faulty BEGIN COMMIT on Informix 4.1
On Oct 27, 4:03am, rk wrote: > Subject: Faulty BEGIN COMMIT on Informix 4.1 > Need assistance from Informix gurus out there! > > Is there any guarrantee that statements inside a BEGIN-COMMIT would be > done atomically. We are using Informix 4.1 on top of AIX 3.2, and we > have d…
Faulty BEGIN COMMIT on Informix 4.1
Need assistance from Informix gurus out there! Is there any guarrantee that statements inside a BEGIN-COMMIT would be done atomically. We are using Informix 4.1 on top of AIX 3.2, and we have discovered that several times the BEGIN-COMMIT in our programs missed a statement or tw…
Re: Mainframe Gateway
I have worked on the Gateway products and they are really good and easy to use. They are really, really transparent to the user(client). There are 2 gateway products for accessing the mainframe. 1. Informix-Gateway with DRDA 2. Informix-Enterprise Gateway for EDA/SQL If you n…
Mainframe Gateway
> > Has anyone any experience of using Informix's Mainframe Gateway products? > > Please tell me about it, heartache involved, how well it worked, etc. > > Thanks Please post replies, I'm interested too. cheers j. ________________________________________________________________…
Mainframe Gateway
Has anyone any experience of using Informix's Mainframe Gateway products? Please tell me about it, heartache involved, how well it worked, etc. Thanks akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist,…
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…
Re: Middleware for Informix
Informix has a product called the Enterprise Gateway. This has an SQL based interface to VSAM and other mainframe database sources. Other products exist to move data between operational systems and Informix. These include products from Prism, Platinum, and Praxis.…
US-TX-DFW Database Administrators
Job Opportunity Form Date: 10/18/95 Position Title: Database Administrators Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Database Administrator positions available for candidates…
US-TX-DFW Transaction Processing Developers
Job Opportunity Form Date: 10/18/95 Position Title: Transaction Processing Developers Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Multiple positions at a variety of skill levels…
US-TX-DFW Client/Server GUI Developers
Job Opportunity Form Date: 10/18/95 Position Title: Client/Server GUI Developers Industry: Lottery and Government Services Transaction Processing Systems Position Description / Experience: Years Of Experience: Varied Multiple positions at a variety of skill levels for …
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…
Database Research Position/ Bedford, MA
The MITRE Corporation is an independent, not-for-profit organization operating in the public interest that provides technical assistance, system engineering, and acquisition support to U.S. Government agencies. Located along Route 128 in the Boston area, amid one of highest co…
Re: BUFFERED LOGGING: Is it safe??
In article <42q2ib$9ah@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> wrote: >I want to make some minor amendments to Clem's answer, simply to clarify >the multi-user aspects of buffered logging... Most of your corections were correct, there was one exception how…
Re: transactions lasting over two processes
> kieni@dfki.uni-kl.de (Thomas Kieninger) writes: > Hello out there, > > I have a quite silly question, but I would really like > you to give me serious comments if possible: > > Is it possible to start a transaction from within one > application (process) and stop (rollba…
Distributed database
} Hello everybody. } } I've got a problem with data distribution - distributed database - over } network. We've got a "star network". Each site is connected with central } site. The problem is that the connection is via magnetic tape. } Could You advice me how to manage transacti…
Distributed database
Hello everybody. I've got a problem with data distribution - distributed database - over network. We've got a "star network". Each site is connected with central site. The problem is that the connection is via magnetic tape. Could You advice me how to manage transaction executio…
Re: Distributed Join
In article <3ruiln$1gf@ixnews5.ix.netcom.com> fcasas@ix.netcom.com (Francisco Casas) writes: > >Hi Michael, > >First let me apologize for the �Ingres who?� message. But when you >throw down the gauntlet of �why can�t Sybase do this?� it RUBBED me the >wrong way! I hope you are…
Re: Transaction Logging Multi-DB
>When using multiple databases and transaction logging is needed only >for one(db A), does logging need to be "on" for the other(db B)? The >application programs running in db A do lookups in db B, and vice >versa. We were told that for the "cross lookups" to work, logging >must …
Re: Distributed Join
Hi Michael, First let me apologize for the �Ingres who?� message. But when you throw down the gauntlet of �why can�t Sybase do this?� it RUBBED me the wrong way! I hope you are not an ex-Ingres employee or an existing Ingres customer. If you are, my condulences. Both Oracle …
Re: Distributed Join
Hi Dave Dargo This is new functionlity in the Sybase OmniSQL Gateway. This can be accomplished with no special from the application programmer. It is supported in a heterogenous environment. I believe Sybase and it's subsidiary, MDI, support about 5-6 times the number of gatw…
Re: Distributed Join
Hi Dave Drago, Yes, this is new functionality in OmniSQL Gateway. Francisco In <3rmus7$h4s@inet-nntp-gw-1.us.oracle.com> ddargo@us.oracle.com (Dave Dargo) writes: > >fcasas@ix.netcom.com (Francisco Casas) writes: > >>Ingres who? Why limit yourself to Ingres when most large co…
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…
Re: Distributed Join
fcasas@ix.netcom.com (Francisco Casas) writes: >Ingres who? Why limit yourself to Ingres when most large companies run >their business on at least 5 different databases. Those databases >generally include DB2, Oracle, Sybase, some flat files and hierarchical >databases. Sybas…
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 to Oracle Table Transport
Is there a product (gateway or other) available that will permit cross product transport of table data from Informix Online 4.1 to Oracle 7.1.4?? Having no luck moving Informix "text" datatypes to Oracle Long Raw (or varchar2) datatypes via sqlload.. thanks..…
Re: The truth behind UPDATE STATISTICS...
In article <bpayneD8F2A7.4wn@netcom.com>, bpayne@netcom.com says... >Could ISQL be doing the same sort of thing: >Opening an implicit transaction that needs to be committed before it >(the UPDATE STATISTICS) is actually flushed? Just a thought. It should be fairly easy to show …
Safe Kill
We have a need for a shell which we can distribute to some of our supervisors to kill processes for users who have not logged out of a database. Don't ask why, the reason is ugly. A friend of a friend picked the following shell off the network sometime ago and recommended it's …
PRESS PLATINUM and Informix Form Strategic Partnership
PLATINUM and Informix Form Strategic Partnership; PLATINUM to Support Informix Database With Its System Management Tools Oakbrook Terrace, IL, February 27, 1995 -- PLATINUM technology, inc., and Informix Software, Inc. today announced a joint technical and marketing alliance whe…
Switching Horses - Unix/Informix to NT/MS SQL Server
We're looking hard at this for a high volume, transaction processing application that would front end an Informix accounting/distribution system. Anybody have any good or bad experiences to share? We are evaluating this because of the increasingly better tools on SQL Server, an…
Re: SQL-GAteway for WWW
Seems that folks over in Oracle land are having similar troubles. One of the suggestions there that might apply here is to make sure that your CGI-BIN script has all the apropriate environment settings corect. rick jones I use WWW to front-end a DB, but it is womething called id…
SQL-GAteway for WWW
Hello everybody, Does anybody of you know how to write a SQL-WWW-GAteway for Informix? I have tried to use the CGI, but I have not had success. here is the contents of the cgi-script: PATH="/disk4/usr1/rz/harmlos/www/:$PATH" export PATH # Header: cgiutils -expires now -ct tex…
Questions about Informix Functionality
Hello. I am an ORACLE DBA, but I have been tasked to evaluate a product that uses an Informix RDBMS. I know very little about the Informix world, so forgive me if the answers seem obvious to you. 1. Can Informix support distributed processing, if so, what version? What distrib…
Testing gateway
Testing Newsgroup Gateway -- Bob Smith Supreme Court of Virginia 75151.765@compuserve.com…
informix-list distribution and Usenet gateway
A number of systems are being relocated at Emory University, and the process of moving them may affect the distribution of the Informix mailing list. It will definitely affect the gateway that transfers list messages to/from the Usenet newsgroup comp.databases.informix. I had t…
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…
Which is faster? Cursors or Prepared statements?
I'm in the midst of reviewing an application which runs slowly and currently does not implement any locking (frustration sets in very quickly!). I want to accomplish two things: 1. Implement either COMMITTED READ isolation or CURSOR STABILITY in the main foreach loop FOR HOL…
Re: Shareware like I-Net
: A friend in need is usually on the net ! Veronica helped me find the package last night... What follows is the README file. Looks promising, brought it over to my system this AM. Joel ------------------------------------------------------ DSQL - Distributed SQL Ve…
Re: Informix Gateways to other RDMS
Hi, Informix recently signed a deal with IB ( information builders ) for there gateway products between databases also there are products by technosis called sequlink which will do the job. Graham Twaddle Technical Director Beta Computers (Europe) Ltd beta@cix.compulink.co.uk …
Re: Informix <-> Oracle export/import of tables?
Alex wrote: From adapple@apple.com Fri Sep 23 04:43:17 1994 Received: from apple.com (apple.com [130.43.2.2]) by solomon.technet.sg (8.6.8.1/8.6.6) with SMTP id EAA00989 for <scornd11@solomon.technet.sg>; Fri, 23 Sep 1994 04:43:12 +0800 Received: from babybop.austin.apple.com by…
PRESS INFORMIX SOFTWARE AND TIVOLI SYSTEMS TEAM TO PROVIDE SYSTEMS MANAGEMENT SOLUTION
INFORMIX SOFTWARE AND TIVOLI SYSTEMS TEAM TO PROVIDE SYSTEMS MANAGEMENT SOLUTION Integrated Products Will Simplify Management of Distributed Databases MENLO PARK, Calif., (Aug. 24, 1994) -- Informix Software, Inc. (NASDAQ:IFMX), the leader in parallel processing database techno…
Re: Loading database from script files
>From: sinues@prcd.prc.mrms.navy.mil (John Sinues) >Subject: Loading database from script files >Date: 10 Aug 1994 09:42:32 -0500 >X-Informix-List-Id: <news.8098> >I have an ASCII file containing a number of INSERT-INTO statements. I >want to execute this file and load an Infor…
Announcing ENCTALK (Encina)
Posting this for a friend --------------------------------- enctalk@imc.com Encina Transaction Processing Discussion An unmoderated discussion of transaction processing topics relating to the Encina transaction processing system. Discussions include client/ server architectu…
Announcing TE-TALK (Top-End)
Posting this for a friend: ------------------------------------------------ An unmoderated discussion of transaction processing topics relating to the Top End transaction processing system. Discussions include client/ server architecture, Distributed transaction processing, X/O…
PRESS v[DINFORMIX ANNOUNCES PLAN FOR NEW OPEN ENTERPRISE GATEWAY TO BE BASED ON TECHNOLOGY FROM INFORMATION BUILDERS
INFORMIX ANNOUNCES PLAN FOR NEW OPEN ENTERPRISE GATEWAY TO BE BASED ON TECHNOLOGY FROM INFORMATION BUILDERS Middleware Solution Will Provide Transparent Data Access to More Than 60 Data Sources and 35 Hardware Platforms MENLO PARK, Calif., (July 27, 1994) -- Informix Software,…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server architec…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server arch…
ON-LINE GURU? Part time possible
I am looking for a high volume, large database specialist who knows Informix better than anybody else in the context of distributed, business transaction processing. We are a direct marketing company that works for many of the major PC software companies, processing software upg…
Re: RDBMS Server Feature Matrix (FAQ)
In article <ddrukerCs5Cn3.Ixu@netcom.com>, ddruker@netcom.com (Daniel Druker) writes: |> |> As to emailing copies of the matrix, I am unable to fulfill these |> requests due to a rather catastrophic hard disk failure on my mac. |> Like an idiot, I didn't have a backup and didn't …
Synchronous replication
I see in the Technical Brief for the Dynamic Server 6.0 a mention of the ability to remotely replicate databases both asynchronously and SYNCHRONOUSLY. The latter would be a unique capability. Does anyone know what this really means? -- Jonathan Edwards edwards@intranet.com …
RELEASE INFORMIX TO SIGNIFICANTLY EXPAND CLIENT/SERVER PRODUCT OFFERINGS
INFORMIX TO SIGNIFICANTLY EXPAND CLIENT/SERVER PRODUCT OFFERINGS New Versions of Informix Database Servers and Client Tools To Be Available for Windows, Windows NT, Macintosh and OS/2 Platforms New and Existing Products To Feature Built-In Client/Server Connectivity MENLO PARK…
Anybody wrote a WWW <---> informix gateway program or script?
Hi, I am presently running a WWW server, and would like my WWW server to have access to my informix dbase. Thus, I have been writing a gateway program(WWW<-->informix) and will be getting into ESQL- C soon. Is there anybody doing this too? Cheers...joe joe@peacock.tnjc.e…
Re: Record Locking
bathini@netcom.com (Suresh Kumar Bathini) writes: >Hi There: >I have two clients in their transactions as below. >Client1----> > begin work > fetch a record R1 > > ..... > update R1 > commit work >Client2-----> > begin work > fetch a record R1 > update R1 > commit…
Re: Record Locking
Suresh Kumar Bathini (bathini@netcom.com) wrote: : Hi There: : I have two clients in their transactions as below. : Client1----> : begin work : fetch a record R1 : : ..... : update R1 : commit work : Client2-----> : begin work : fetch a record R1 : update R…
Record Locking
Hi There: I have two clients in their transactions as below. Client1----> begin work fetch a record R1 ..... update R1 commit work Client2-----> begin work fetch a record R1 update R1 commit Work Both the clients fetched the same record but client2 updat…
Re: Two simple questions
>From: charliep@earlham.edu >Subject: Two simple questions >Date: Fri, 13 May 94 10:02:55 -500 >X-Informix-List-Id: <news.6728> > >Two questions from a neophyte: 2? I make it 5. >1. Does Informix support an API to SE and/or OnLine? I am looking for > something like Oracle…
Two simple questions
Two questions from a neophyte: Does Informix support an API to SE and/or OnLine? I am looking for something like Oracle's OCI or Sybase's DB-LIB rather than the pre-compiled ESQL. How is the concept of "user" handled in OnLine? When I looked at the ESQL demo programs there is…
PRESS: SAP and Informix Announce First Joint U.S. Site
SAP and Informix Announce First Joint U.S. Site Applied Micro Circuits Corporation to Use SAP R/3 System with the INFORMIX- OnLine Database Server Menlo Park, Calif. (October 18, 1993) Informix Software, Inc. (NASDQ:IFMX) and SAP America, announced today that they will provide …
Re: 4gl problem
John Musselman writes: > My Prob: The date is updated, BUT if a user updates a row and the does a next > followed by a previous (fetch_next and then a fetch_prev) the data displayed is > the OLD data... but if the user selects the same row on a subsequent query, it > refelects t…
RDBMS Server Feature Matrix
October 26, 1993 - note- This is not updated since the last post... I am working on it but have been pretty busy lately. Attached is the first production draft of the RDBMS Server Comparison Matrix. Please forward any corrections, comments, or additions to me at the address bel…
Acess to "OTHER" Databases from Informix-4GL
I have a requirment to access other database types i.e. Oracle, Ingres, Progress and Sybase etc. from an existing base of Informix 4-GL programs. Are there any products available to facilitate this e.g. gateways etc or does any one know of appropriate program converters to achie…
Mailing List/Gateway Administrivia
I will be away from the office during the period September 20-24. The address "informix-list-request@rmy.emory.edu" will still be the best place to send questions about the Informix mailing list or its gateway with this newsgroup. You can also send mail there regarding the anon…
Reading locked rows
Hey folks, We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We talk to it using inet-pc 4.10 and powerbuilder running on windows. Today's question #1 is about reading locked records. Here's the scenario: buffered logging data base "foo" with table "bozo". …
Re: Recent gateway problems
i second the internet access at the conference request. regards, ------------------------------------------------------------------------------ | . . Bob Baskett …
Recent gateway problems
The gateway between the informix-list and comp.databases.informix now appears to be working smoothly, again. Here's a quick recap of the recent problems: The day I left for IWUC93, the main domain name server for Emory was changed in an attempt to add a new sub-net, which I lea…
concurrency control mechanism
Hi! I need to know what concurrency control mechanism informix 5.01 uses for concurrent distributed transactions. I know that it uses locking. Is that a 2PL? or does the sheduler compromize the serializability? Thanks a lot. sameer…
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 …
RDBMS Server Evaluation Matrix v 1.0.2 - FAQ
Attached is the first production draft of the RDBMS Server Comparison Matrix. As a change to this version, I have included a detailed description of each of the categories at the bottom of the matrix. I have also included numerous corrections, changes, and suggestions from the fo…
Re: Matrix and associated comments... (fwd)
SUBJECT: Re: Matrix and associated comments... (fwd) ==================================================== The following corrections were made for Informix and are indicated by "<<<<". If you have comments and or corrections, send them to me. --Bill ----- Begin Included Message…
Re: RDBMS Server Features Matrix - Beta Draft
In article <1993May24.232720.1603@mic.ucla.edu> ddruker@agsm.ucla.edu (Daniel Druker) writes: >Please find below a Beta Quality draft of the RDBMS Feature Matrix I've been >working on. Many thanks to those who sent suggestions for categories, >and to those who supplied answers fo…
RDBMS Server Features Matrix - Beta Draft
Please find below a Beta Quality draft of the RDBMS Feature Matrix I've been working on. Many thanks to those who sent suggestions for categories, and to those who supplied answers for some of the categories I was not up to speed on for all the products. By Beta Quality I mean I …
TERMCAP for AT386 anyone ??
Hi Is there anybody out there who has a working termcap for the AT386 (SVR4/386) console ??? Thanks for reply by mail ovhe@sw2020.ki.icl.se -- Ove Hedin , ICL Customer Services Phone: +46 (0)31499276 FAX: +46 (0)31499224 X400 Gateway : o.hedin@swe4701.wins.icl.co.uk DOMAIN …
RDBMS Feature Matrix (FAQ in the works !!!)
I thought it might be useful to maintain an On-Line feature comparison matrix of the various major RDBMS products as part of a comp.databases.* faq. It seems to be a repeated theme that people ask for such comparisons and I haven't seen a good one yet. I've included a document b…
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…
Re: Bug while fetching rows in OnLine 5.0
}From: uunet!cocamrd.mel.cocam.oz.au!sms (Steve Szalla) }Subject: Bug while fetching rows in OnLine 5.0 }Date: 10 Mar 93 01:43:25 GMT }X-Informix-List-Id: <news.2807> }There seems to be a bug in OnLine that affects whether rows can be }fetched depending on the isolation level us…
P Publishes Highest Performance for TPC-C Benchmark - Uses INFORMIX-OnLine
On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open systems. Both benchmarks used INFORMIX-OnLine as the database m…
IBM Publishes First TPC-C Benchmark on Open Systems
Subject: IBM Publishes First TPC-C Benchmark on Open Systems On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open sy…
Re: Informix & Tuxedo
Excerpts from netnews.comp.databases.informix: 8-Jan-93 Re: Informix & Tuxedo David Kosenko@informix.c (782) > Note that two phase commit can only be accomplished using OnLine and the > TP/XA product. Two phase commit cannot be accomplished with SE. It > cannot be accomplished w…
Problems at gateway site
There were some network problems here at Emory over the past weekend that caused the system running the gateway between the Informix mailing list and comp.databases.informix to be off the air for a while. Unfortunately that "while" was long enough to cause sendmail to kick back …
Safe Updates of a bazillion rows
Naomi Walker writes: >If I want to update one column (all rows) in a table that has, say, >a million rows, with two indices, and I dont want to blow out my >lock table, or log files, is there a safe way, short of turning >off logging and doing an exclusive lock and begin/commit …
Re: Safe Updates of a bazillion rows
> If I want to update one column (all rows) in a table that has, say, > a million rows, with two indices, and I dont want to blow out my > lock table, or log files, is there a safe way, short of turning > off logging and doing an exclusive lock and begin/commit work? > > We are b…
Looking for info on Informix-Star
Path: emory!swrinde!cs.utexas.edu!uunet!zephyr.ens.tek.com!uw-beaver!ubc-cs!mprgate.mpr.ca!kho From: kho@mpr.ca (Peter Kho) Newsgroups: comp.databases.informix Message-ID: <1991Oct24.201217.10674@mprgate.mpr.ca> Date: 24 Oct 91 20:12:17 GMT References: <1525@das13.snide.com> Send…
Re: Repost: SCO UNIX Informix Development Package FORSALE!
Path: emory!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!wupost!uunet!zephyr.ens.tek.com!uw-beaver!ubc-cs!mprgate.mpr.ca!kho From: kho@mpr.ca (Peter Kho) Newsgroups: comp.databases.informix,misc.computers.forsale Message-ID: <1991Oct24.161645.8009@mprgate.mpr.ca…
Re: XA Compliant RDBMSs
Path: emory!wuarchive!sdd.hp.com!hplabs!hpcc05!hpyhde4!hpycla!hpcuhc!dhepner From: dhepner@hpcuhc.cup.hp.com (Dan Hepner) Newsgroups: comp.databases Message-ID: <2060011@hpcuhc.cup.hp.com> Date: 8 Apr 91 21:22:26 GMT References: <1120@tetrauk.UUCP> Organization: Hewlett Packard, …