Oninit® Archive
Results for “onstat -g lap”
EXTERNAL TABLE issue?
David, ask for the APAR/Issue number: it is normally a public informix on IBM's website…
script to check status of dbspaces & chunks
I would use the IBM provided script alarmprogram.sh in onconfig ALARMPROGRAM /opt/informix/etc/alarmprogram.sh…
Column ti_flags in systabinfo
As you know, systabinfo is a view on sysptnhdr. In $INFORMIXDIR/etc/sysmaster.sql you will see inserts into flags_text for sysptnhdr: { Partition Header } insert into flags_text values ('sysptnhdr', 1, 'Page Level Locking'); insert into flags_text values ('sysptnhdr', 2, 'Row Le…
Recently appended logged partitions
Hi John, the problem is that this flag is set when light append operation is used but it is not unset after level 0 backup is done so I cannot differentiate among tables which are writeble from those for which level 0 backup is still required – this was my goal in order to ident…
IBM Informix CSDK licensing
Hi all, IBM ILMT detects IBM Informix Client SDK 4.50 installations and identifies the licensing metric as " Authorised User Single Install", however I am pretty sure there has never been the possibility of purchasing a licence nor a requirement to keep a record of installations …
Informix 15 is out! Well sort of...
David: According to the Actian Webinar recording about the HCL-Informix v15 release, OneDB has been replaced with HCL Informix and IBM and Actian have agreed the beginning with the v15 releases, IBM Informix and HCL Informix will be identical (except for the branding). HCL Inform…
Informix future...
Benjamin: See my post to David's question below about OneDB and how it stands versus IBM Informix. HCL Informix is, has been, and will continue to be identical to IBM Informix in every way except for licensing and the name on the package. ------------------------------ Art S. Kag…
V14.10.FC9 installer missing librarie(s)?
Andreas, I have same problem (libisi file is missing). Both tar files in gskit directory don't have deb package. Anyhow, unpacking rpm packages show no trace of libisi: root@mate2004:/home/informix/i1410fc9/gskit/tmp# rpm2cpio gskcrypt64-8.0.55.26.linux.x86_64.rpm | cpio -idmv ./…
Informix 14 Certification
That's up to you. The IIUG is administering the Informix v14.10 Badge Exam developed in cooperation with IBM. IBM Partners are required to maintain current badges (IBM no longer offers certifications, but the partner requirements remain), but for users it is optional though valua…
Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)
Art, I have created a request but I could not find Informix in the product list... So I have used IBM AIX, https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=142665 I suspect IBM removed Informix from the product list since HCL took over. https://www.virtual-d…
Informix 14.10 documentation
Art, So who does the documentation now? Surely IBM should be ensuring that the documenation for IBM Informix (as opposed to HCL Informix) is maintained? Regards, David. ------------------------------ David Williams ------------------------------…
IBM Champions 2020
IBM Champion nominations are now open but only until November 4, 2019! Remember this MUST be done annually , so if you are currently an IBM Champion, you must renew. If you are not an IBM Champion or wish to nominate someone else please follow the links below. For Champion renewa…
New version Informix 14.10
We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…
4gl not ending FOR loop thru file for IDS ver 12.1
Update from IBM: 14 May 2019 3:24 PM I'm wondering if it's related to this defect which was fixed in 4GL 7.51.xC1: APAR IC93179 - 4GL: BEHAVIOR OF CLIPPED HAS CHANGED FROM VERSION 7.32 TO 7.50 Error Description -----------------------------------------------------------------…
4gl version 7.2 connection to ids 11 ?
PerLuigi, I have connected pre-IBM Informix real-life applications to Informix 12.10 without any kind of problem So yes, this is possible, and you did it!…
IBM Informix RFE gone?
Hi, Where we should request new features? Informix just vanishes from IBM RFE pages. There is no option to filter or submit new RFE. Regards…
HCL Informix vs. IBM Informix
I'm just mildly unclear on what is happening with Informix. Is IBM in process of slow-motion divestment? I now see a mix of references to the product. For example, for AWS, I see "HCL Informix". Also, tech support comes from HCL. But, I still see references to "IBM Informix". …
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…
Moving from AIX 6.1 to AIX 7.1
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/W6461741b f7e8_47d7_89fc_a0a9233f3ca9/page/IBM%20Informix%20on%20POWER7…
Issue in transactions with informix using DRDA
Hi Satyan, It works. It means that we can't be use synonyms in informix? It changes the way we programming. Previously, we used Informix IBM Informix .Net provider, with no problems, but it doesn't support LINQ. The IBM DataServer .Net provider is the promise of IBM for LINQ…
Re: upgrade and onbar
Hi Art the file pointed by BAR_BSALIB_PATH (ibsad001_64.so) in onconfig file exists but i have the error message when running /opt/IBM/informix/bin/onbar_d -b -p -w (-43231) An unexpected error occurred: 0509-022 Impossible to load the module /opt/IBM/informix/lib/ibsad001_64.o.…
External table problem
There are conditions where express can't be used - only deluxe. Been so long I can't remember them - indexes exist, rows larger than a page, and a few others. Do what John suggested during the load to verify express ... onstat -g lap. A "light append" (lap) bypasses the buffer ca…
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)…
What is all this I/O when doing a light append to
I definitely see output for light appends in onstat -g lap when loading from external tables to raw tables, so I know it can be done even if the manuals say it can't. I'm not seeing the behavior at the moment which is making me wonder if my attempt to force a checkpoint before l…
IBM Data Server Provider - Db_Locale/Client_Locale
Unfortunately, I would not like to go back to CSDK since IBM is not supporting it for the future. >>The IBM Informix .NET Provider is also referred to as the CSDK .NET Provider. >>It is available for download as part of the Informix Client SDK. This .NET >>provider works only wi…
raw table and light appends
11.50.FC8 AIX I am loading up several large raw tables (they all contain one part blob column) using insert into raw_table select * from table and wondering if there is a way other than using HPL to have the engine use light appends for the load. (the row size of these tables ar…
IBM Informix 11.7 life cycle....
Hi Guys! Will IDS 11.70 be the last version of the product? This is making some noise lately! Have you heard anything on the future of IDS? Is it going to be any more development of IDS down the road. Please advise! jp…
How to install ISL?
Hi, How to install ISL(IBM INFORMIX INTERNATIONAL LANGUAGE SUPPLEMENT) in informix 11.70 TC1IE? How to add Marathi language(Indian Language) in GLS?…
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…
WOW, can't believe how slow iiug.org website is!
IMHO, I feel this website is the most important for Informix related topics and perhaps should be funded by IBM so that it can be properly function!…
Informix 10.00.TC5 CKPT REQ Logica Log Full
I hav'nt direct support from IBM Informix because I have Informix as a service from a supplier. My supplier support is very slow so I want to find a solution by me. Do you now how to reach directly IBM Informix support by mail od phone? Thanks…
VP Notify Message
ok, your case is totally different situation what append with me... AFAIK there is no trap to use... try write some script to identify when the "vp notify" appear on you log and capture fews of onstat -g act" and "onstat -g stk" over the threads what are running over the VP ... …
Informix is now on facebook
Dear Informix fans, Did you know that IBM Informix is now on facebook? Stay on top of all the latest News related to IBM Informix. Hear about the latest announcements from IBM and IIUG, contests, interesting blogs, best practices, resources, as well as engage with us on top…
Transaction mode on ids 11.50
Thanks for fast respone. Database is on windows machine. I try to run that comand and im getting nothing, no error, no nothing... C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>ontape -s -B C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\…
Query to list temporary tables
Thanks !! Sysmaster.sql { Partition Header } insert into flags_text values ('sysptnhdr', 1, 'Page Level Locking'); insert into flags_text values ('sysptnhdr', 2, 'Row Level Locking'); insert into flags_text values ('sysptnhdr', 4, 'System Catalog Table'); insert into flags_…
Smarter Questions for IBM
Folks, just discovered a new website that demonstrates how serious IBM is about Informix: http://smarterquestions.org In fact almost all questions are asked and answered by IBM itself and there isn't a single one that is covering Informix - just DB2. Well done, IBM (:- I just…
Moving from Informix SE to Innovator-C
I'm currently using Informix 4GL 7.50.UC4 with Informix SE 7.25.UC6R1 on Linux and I have two databases set up with the same database name, but each in a different path, this is because the database name is specified in the 4GL programs with the DATABASE statement. I then use th…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
IBM Informix pages - the wrong pages....
Hi, Just putting out... Still there several pages on IBM site (US and BR) referencing to "Informix Dynamic Server" and Enterprise , Workgroup and Express Editions!! Very very very very confusing for who is starting with Informix now!!! Yesterday I have downloaded the Innovator…
IBM buys 4J's ?
There is a lot of new documents and articles on IBM Informix Support about "IBM Informix Genero" and how convert IBM 4GL to IBM Informix Genero https://www-304.ibm.com/support/docview.wss?uid=swg21474179 https://www-304.ibm.com/support/docview.wss?uid=swg27021002 Great news! b…
This looks almost like a new datablade
http://www.fuzzyl.com/news/press-releases/fuzzy-logix-and-ibm-unveil-in-database-analytics-for-ibm-informix/ -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.…
IBM Advertising
No, we won't ever ever advertise individual products: http://db2news.wordpress.com/2011/03/01/new-ibm-db2-vs-oracle-database-advertising-campaign/ This is surely true for Informix and others. However there is a single product named DB2 where we are always happy to make exceptio…
Problems with demo database
I have a problem with creating demo database on Windows 7. I have installed informix client in c:\\\\program Files\\\\Ibm\\\\Informx\\\\client-SDK directory and Ibm Informix Dynamic Server in c:\\\\program Files\\\\Ibm directory. I set the INFORMIXDIR to c:\\\\Program Files\\\\I…
Informix Products Installation
I have always installed the oldest to the new product. I also never install the engine in the same directory as the 4gl and ISQL, but that is a matter of preference. When you install them all together it is messy to upgrade only one part. So if everything is 11.5 FC4 the order i…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
NTP configuration in HDR environment
Thanks for the response. Here we are using IDS 11.5 (update 6) i.e., IBM Informix Dynamic Server Version 11.50.FC6WE. And the DRAUTO is set to 2. Regards, Sridip…
esql and cygwin
Dear Art, I think that will bring on the right way, but all DOS path entries are available in cygwin. But they are changed from C:\\\\Program Files\\\\IBM\\\\Informix\\\\Client-SDK\\\\bin to /cygdrive/c/Program Files/IBM/Informix/Client-SDK/bin for example. And I think they are c…
IBM Informix Strategy
Folks, I think it would be interesting to see the mood of the worldwide Informix community after IBM published it's ambitious plans regarding a new Informix positioning and marketing strategy. Please vote here: http://www.informix-zone.com/your-opinion-about-ibms-renewed-strat…
New Informix Blog
Folks, this might be interesting: http://informix-zone.com/bruce-weed-informix-blog Please also remember the two important Informix events that are happening soon: http://informix-zone.com/ibm-virtual-event Thank you.…
IBM Data Management Magazine Survey
Here is the chance to vote for more Informix content in the IBM DB2 Advertising Magazine: http://www.surveymonkey.com/s.aspx?sm=BMNOoeAiELQjyeKwxwPoFA_3d_3d Pardon - I meant the IBM Data Management Magazine :-)…
Where is informix in IBM now?
Hi All, Just want to post this question: 1. Where is informix DB in IBM organization now? 2. Are they planning to port everything to DB2? 3. I've seen some latest version in IBM website and it's downloadable but for 3 months use only. I'm worried as i've been using informix fo…
HPL Deluxe mode
Hi all, IDS 11.10 FC3 on solaris 10 I am trying to unload and load all the tables from a database using HPL!!! I have filetered out tables with unsupported datatypes and referenced by other tables (yet to create a mapping etc) and successfully completed my unload using: onploa…
Driver ODBC ibm Informix 3.34
Hello on internet....i can FInd the Driver ODBC ibm Informix 3.34 ?? Ori can find only trial ? Tanks to All Cekke was HERE! ------------ >>> www.ceccherini.net <<<…
Help : Assertion Failure Type: CRASH
I've already had a look at files : /opt/IBM/informix/tmp/af.41edc39 /opt/IBM/informix/tmp/af.41bdc38 But nothing strange to me except what I've paste before is from the second file :(…
IBM to relegate DB2 to the mainframe and IDS (Informix) to LUW
> IBM will lead with Informix! Way ahead of you - here's the latest Oracle Training Course - http://www.youtube.com/watch?v=ByZqx30OvVs…
How many Informix Employees are Left?
Of the 2100 or so Informix employees that were taken on by IBM, how many are left? Anyone have any idea? > 100 < 100 ? -- }(:…
Informix Warehouse Feature
> > IBM announce today the availability of Informix Warehouse Feature: Why no Informix based BCU ?…
IBM 10year plan for Informix
Dear all Our client is insisting on some official document from IBM stating the 10 year plan / roadmap that they have for Informix. Apparently they got something like that from Oracle, and apparently the Oracle consultants is saying that IBM have no plan for Informix. I need s…
LIGHT_APPENDS=FORCE ???
Light Appends are used under the following conditions with HPL (high performance loader): non-logged table (can be non log db or raw table) no indexes on table If you meet those 2 conditions and your using the HPL, then, feel free to file a defect. On Feb 24, 3:25 pm, LIGHT SCA…
IDS FC3 on Windows Vista Business x64...
Hi Jean Georges, If you type "whoami /all" from that prompt, does it say you are a member of the Informix-Admin group? If the answer is no, logoff and log back in again to refresh your token information. If the answer is yes, can you paste the "PRIVILEGES INFORMATION" here. G…
dbcopy.ec compile on AIX5.3 gcc 4.1.1
Dbcopy.ec : Revision 1.58 AIX : 5.3 gcc : 4.1.1 esql : IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC3 A lot of error message display after I modify some and go further. Is anyone compile succeeded ? Or where I can get the binary file for AIX 5.3 ?…
IBM Informix Object Interface for C++
I am using the IBM Informix Object Interface for C++...or I suppose I should say that I am "trying to use" it. I'm on Windows XP and I have version 3.5. I have no problem with building the example programs I can connect to a database and in a very basic sense I can send queries…
Informix Virtual Appliance
Fernando Nunes wrote: > IBM has made available a virtual appliance with SLES 10 SP2 and the > following IBM products installed and configured: > > IBM Informix Dynamic Server 11.50.UC2DE > IBM Informix Client SDK 3.50.UC2 > IBM Informix JDBC Driver 3.50.UC2 > IBM Informix Spatial…
Re: IBM To Sell Informix
> Yes, you are correct. a parody. But a poor one at that. Suppose that > it was actually picked up on a news report? Yeah suppose. People might actually see the product's name in print. Perhaps you should make a video about it: http://www.rootstelevision.com/players/player_dear…
IBM To Sell Informix
FOR IMMEDIATE RELEASE (AP) Armnonk, NY -- In what appears to be a complete reversal of fortune for the beleagured database division of IBM known as Informix, IBM today announced that they will indeed start marketing the entire product line of database products under the Informix…
IDS as a "legacy" system...
I'd like to know if there are 100 ( or more ) IBM customers actually using Informix. It would be great to see a list of 100 IBM customers that are using Informix.…
Just FYI on the Mac front.
Jonathan Leffler's dbaccess replacement : i.e. sqlcmd compiles and run's with almost no difficulties. There was a brief moment of PEBKAC as yours truly forgot about the following environment variable. DYLD_LIBRARY_PATH Which until I included /Applications/IBM/informix/lib and…
Informix and AIX P6
Anybody running Informix on IBM P6 Hardware? Has it been smooth? We are looking at it and want to know the user community has experienced. David Link…
Please! What is the IBM Informix Help Line Phone?
Does anyone know what the IBM Informix phone line is for emergencies? Please help if you know.…
Light append partition after onpload
Hi all. The other day I ran into trouble at a customer site running 10.00.TC6 on Windows Server 2003. The database had been migrated and reorganized using onpload with overall success. At this point, an ontape level 0 was taken to file and then the customer started running some b…
Re: Google Ads for Informix at IBM
Jonathan Leffler wrote: > I did a Google search that mentioned Informix; I got an Google Ad from > IBM for Informix that led to http://www.ibm.com/software/data/informix > (OK, it added a -306 to the www bit - but it got to the right place > within IBM). > > -=JL=- And can we h…
Re: Google Ads for Informix at IBM
My favorite is: www.informix.com It's like going home..... and finding out the parents moved and didn't tell you. ;-)…
Google Ads for Informix at IBM
I did a Google search that mentioned Informix; I got an Google Ad from IBM for Informix that led to http://www.ibm.com/software/data/informix (OK, it added a -306 to the www bit - but it got to the right place within IBM). -=JL=-…
IBM Informix Support Exchange Program
IDS 11.10 - Monitor and analyze recent SQL statements Suma Vinod December 13th - 2007, 11am ET For Webcast and dial in details please see http://www.iiug.org/news/announcements/partner_training.php…
Guy Boewerman, IBM and SAP , and Informix.
I read in Guy's blog that IDS 11 is now certified for SAP, and wrote immediately to my customer - perhpas the most famous broadcasting company in the world? - who has felt obliged to migrate away from IDS She wrote by reply: "Alas, that's only for the older SAP versions - thoug…
Informix DBA Job Opening in Lenexa, KS
On Thu, 2007-10-04 at 12:21 +0000, Zachi wrote: > In Lenexa, KS and no one from IBM-Informix there wants to join??? I imagine it would be a step down for an IBM-Informix developer to become a DBA. -- Carsten Haese http://informixdb.sourceforge.net…
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.…
Re: Pb with Krakatoa on Linux
You should have at least the following lines in the /etc/ld.so.conf.d/informix.conf file: /opt/IBM/informix/extend/krakatoa/jre/bin /opt/IBM/informix/extend/krakatoa/jre/bin/classic /opt/IBM/informix/extend/krakatoa/jre/lib Sorry for not being precise in my first reply.…
Pb with Krakatoa on Linux
Thanks Claus, Well, it's better: > EXECUTE PROCEDURE sqlj.remove_jar('statbuilder', 0); SQL Error (-9431): Can't find system class or method or library (/opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so). But not perfect... Of course... geo:/opt/IBM/informix # ll /opt/IBM/…
RE: Transaction Question
Hi The following paragraph might help you, over the query you are dealing with. RAW Tables RAW tables are nonlogging permanent tables and are similar to tables in a nonlogging database. RAW tables use light appends, which add rows quickly to the end of each table fragm…
IBM seeking INFORMIX authors
Hi Informix Fellows, maybe someone is interested in this: http://www.informix-zone.com/node/123 Thank you.…
JDBC license query
Hello A potential customer of mine is running Informix and I want to approach them with a proposal to develop software for them which would connect to their Informix DB using JDBC. I understand that the JDBC client and server ships with Informix and a trial version is available t…
Whither Informix?
And it wasn't even mentioned at IBM Software Live - an IBM Software division event this week in London. But they did give pride of place to DB2 9. However, we mustn't be downhearted. Informix training in the UK is still almost impossible to find on the IBM web-site and is stil…
Re: Insider #75: Highlights: IBM Information On Demand 2006,The Next Informix IDS Release...
Davorin Kremenjas wrote: > > Seriously, we realize it is expensive, but it's an investment. > > An investment? > Who is supposed to come to Vienna? End-users who are using Informix and > Business Partners who are supporting them doing that. > Well, end-users already made an inves…
Re: Informix in the press...
eric@herber-consulting.de wrote: > Sometimes wonders take a little bit longer: > > http://www.marketwire.com/mw/release_html_b1?release_id=154242 > > A press release from IBM mentioning Informix. Great !! Go Ron Flannery! Go Cindy Lichtenauer! Go IBM! Go Informix! Art S. Kag…
Re: Informix business grew by double digits in 2006 (Q1+Q2)
>> Yelling, ranting and complaining will not grow the Informix business and >> will not change IBM's behavior. Yes, you're right, I know. That's why I concentrate my spending on increasing Ardenta's market share amongst the existing, but declining, client base. This is quite a…
Re: Stuart strikes again - history is altered!
DE - Simple question - have you ever worked for IBM or Informix? Curious....…
IDS versions & there full forms
Hi Guys , jst was looking for all the Abbreviation of Informix stuff. Can;t see an stuff at the IBM site.It was redirecting me but no page displays What all are there diff forms UC : FC SE :STandard engine rgds…
Re: Informix marketing request list
The Informix marketing request list has been updated reflecting the progress IBM made on our proposals: http://www.herber-consulting.de/cgi-bin/IfxMarkReq.pl…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
RE: IDS for Solaris x86
> The response from that IBM rep *is* interesting! It conflicts with > IBM's updated support for Solaris x86. > > IBM announced last year that they now support IDS 7.31UD7 on Solaris > 2.6, 8, 9 and 10 x86. > http://www-306.ibm.com/software/data/informix/ids/requirements/solaris…
data model
IBM Informix online manuals are pretty good! Check out : http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst81.htm?resultof=%…
Re: IDS 10
BigVinnie wrote: > I'm about 24hrs away from saying the heck with IBM/Informix and > converting everything to another database. Come on in the waters fine.…
Re: Informix in the news!
Michael Segel wrote: > Finally and most importantly, No mention of Informix at all within IBM's IM > strategy or product announcement.... > > -G Unfortunately: No one that came to IBM with Informix will be surprised. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washingto…
Re: IBM & Informix
DA Morgan said: > > Obnoxio The Clown wrote: > >> I'll have to keep an eye out for this "Laphroig" stuff. > > When you have nothing of substance resort to corrrrrecting > spelling errors? Impressive! At least I'm not the one waving his cock around, trying to pretend he's so suav…
Re: IBM & Informix
Obnoxio The Clown wrote: > I'll have to keep an eye out for this "Laphroig" stuff. When you have nothing of substance resort to corrrrrecting spelling errors? Impressive! -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)…
RE: IBM & Informix
Dirk- > -----Original Message----- > From: Dirk Moolman [mailto:DirkM@caretech.co.za] > Sent: Wednesday, November 30, 2005 2:55 AM > To: Everett Mills > Subject: RE: IBM & Informix > > Do you have a link where I can read more ? > > Dirk It's mentioned in Stuart's blurb in the l…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Mark D. Stock Sent: 27 November 2005 02:34 PM To: Traveller Cc: informix-list@iiug.org Subject: Re: IBM & Informix >I agree that it would be nice to hear about some o…
RE: IBM & Informix
> -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydassolutions.com] > Sent: Sunday, November 27, 2005 6:34 AM > To: Traveller > Cc: informix-list@iiug.org > Subject: Re: IBM & Informix > > Traveller wrote: > > Much as I like Informix and used it for over 10 yea…
Re: IBM & Informix
DA Morgan said: > > Actually Glenmorangie. Though I've three bottles of Laphroig in the > larder. ;-) Yes, Glenmorangie, made by taking the piss of people who drink real Scotch bottling it. I can definitely see you drinking it. I'll have to keep an eye out for this "Laphroig" s…
Re: IBM & Informix
Michael Segel wrote: > Obnoxio The Clown wrote: > > >>DA Morgan said: >> >>>And far too little sailing, scuba diving, drinking scotch, and writing. >> > Drinking Scotch? > LOL...I bet you just love Johnny Walker, Cutty Sark and Dewers. On thr > Rocks! Actually Glenmorangie. Thou…
Re: IBM & Informix
DA Morgan wrote: > I spend approximately 60 hours a week doing ... 1/10 that teaching. A 60 hour work week and you claim Oracle is easy to use? Sorry couldn't resist.... Seriously though work life balance is private thing. 66hrs/week would not be for me. Cheers Serge -- Serge R…
Re: IBM & Informix
> I spend approximately 60 hours a week doing ... 1/10 that teaching. As these 6 hours a week probably do not earn you a living, does Oracle pay for your remaining time to be on an Oracle defense team in Informix newsgroups ? Do you cover other newsgroups as well, like DB2, Syba…
Re: IBM & Informix
DA Morgan said: > > And far too little sailing, scuba diving, drinking scotch, and writing. If you count posting useless shit on Usenet as writing, then I think you have more than enough time for writing. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fe…
Re: IBM & Informix
M Segel wrote: > Whats that they say... Those who can... Do. Those who can't... teach? > ;-) That's what some say. But then they often also end up saying "Do you want fries with that" too. I spend approximately 60 hours a week doing ... 1/10 that teaching. And far too little…
RE: IBM & Informix
Personally I would choose anything ahead of SQL Server, I need my DBMS to run 24 x 7 and nothing I have seen convinces me SQL Server even comes close. I've never used Oracle, but would need a lot of convincing to convert from the ease of use of IDS. As I have a major influence in…
Re: IBM & Informix
You are right. They have had no bad press. Just no press and as you say when you do not the know the furture of a product , would you as a business make a decision to buy in Informix as a database when you have the choice of Oracle and MS-SQL server. I say nothing about DB2 beca…
Re: IBM & Informix
On 25 Nov 2005 17:42:08 -0800, david@smooth1.co.uk wrote: > >OK I substantiate it then...just wait until next week. OK? With real numbers and such . . . . ? I'm all ears . . .. JWC…
Re: IBM & Informix
Dirk Moolman wrote: > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Captain Pedantic > Sent: 25 November 2005 10:40 AM > > >>Contact your IBM representative? Right! > > > > > Sadly, in my case this is the sa…
Re: IBM & Informix
Traveller wrote: > Much as I like Informix and used it for over 10 years, I have not heard > of any new sales wins for IBM Informix in Europe. This causes rumours > and speculation to circulate and not in a good way, while also making > existing users of Informix even more nervou…
Re: IBM & Informix
OK I substantiate it then...just wait until next week. OK?…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malcolm weallans Sent: 25 November 2005 12:15 PM To: 'Traveller'; informix-list@iiug.org Subject: RE: IBM & Informix >Just because you haven't heard of any significan…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Captain Pedantic Sent: 25 November 2005 10:40 AM > >Contact your IBM representative? Right! Sadly, in my case this is the same, haven't seen my IBM account manager …
RE: IBM & Informix
Just because you haven't heard of any significant wins for IBM Informix it doesn't mean to say they aren't happening. I happen to know that there are some big wins for IBM involving Informix, including a very public win for a 2006 sports event - but the IBM marketing machine mig…
Re: IBM & Informix
Much as I like Informix and used it for over 10 years, I have not heard of any new sales wins for IBM Informix in Europe. This causes rumours and speculation to circulate and not in a good way, while also making existing users of Informix even more nervous. As a result I am anoth…
Re: IBM & Informix
Dirk Moolman wrote: > An interesting article about IBM and Informix > > > http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ But this article is now over a year old. IBM have now dropped the DB2 brand, or so they tell us. It left with JP. Of course it could take a long t…
IBM & Informix
An interesting article about IBM and Informix http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ sending to informix-list…
VMware edition
Do you know which version of VMware are supported by IBM for an implementation of Informix architecture? (the installation with Informix ER) Still thank you, Francesco…
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.…
Using Informix Storage Manager (ISM)
Bob Kruse wrote: > Greetings, > > > > My group is considering using ISM for archiving our XPS 8.5 instances. I'd > like to configure it so the archives are written to disk and I can run a > filesystem backup to store the images to tape. > > > > Does anyone have any experience us…
RE: IBM .net Driver for Informix vs MSSQL .net driver
the issue here is that the .net provider for Informix is not native but a wrapper which uses ODBC in order to fix this problem IBM would need to develop a native .net provider…
Informix Upgrade Optons for an ancient Informix system
Might be able to get a Linux/Informix package deal from IBM. They were running some prgrammes toward the end of last year, not sure if they are still running.…
IDS License Terms and Conditions
Hi, Does anyone have a copy of the License Terms and Conditions for IDS (especially the Workgroup edition) as of the time IBM took over Informix? Thanks, Alan…
IBM Informix HA Agent for SUN Cluster
Hello is there anybody who has experince with IBM Informix HA Agent for SUN Cluster? Waht kind of software is nessary ? Thanks in advance Steve…
IBM Informix HA Agent for SUN Cluster
Hello, is there anybody, who experince with IBM Informix HA Agent for SUN Cluster? Which software is nessary ? Thanks in advance Stefan…
Re: Passport Advantage: Conclusion
Any chance you could stayt with IBM if I can get them to work better with you? I talked to the north europe salesman for Informix Databases today and I've got contacts in IBM now... I'M HAPPY TO REVERSE ENGINEER THE IBM CORPORATE STRUCTURE AND GET THEM TO WORK BETTER WITH CUSTOM…
Free(Open) Informix DSA
Hi. Are there any communities which develop free(open) Informix DSA over GPL or BSD licenses. How IBM looks for this. Best regards, Konstantine…
Informix IBM oledb driver
has anyone tried the Informix OleDb driver provided by IBM? I need to connect to an Informix DB and wondering how good are those driver, and need some information on how to use them. Thanks Andy -- Message posted via http://www.dbmonster.com…
Re: informix vs oracle
Christopher wrote: > utkanbir compared IDS and that other thing: > >>3. Nologging operations: > > > IDS also allows non-logged tables, called RAW tables: > > The following is from the IDS 10 doc, because I can link directly to > the appropriate passage, but is true for IDS 7.31,…
Re: informix vs oracle
Christopher wrote: > utkanbir compared IDS and that other thing: > >>3. Nologging operations: > > > IDS also allows non-logged tables, called RAW tables: > > The following is from the IDS 10 doc, because I can link directly to > the appropriate passage, but is true for IDS 7.31,…
Re: informix vs oracle
utkanbir compared IDS and that other thing: > 3. Nologging operations: IDS also allows non-logged tables, called RAW tables: The following is from the IDS 10 doc, because I can link directly to the appropriate passage, but is true for IDS 7.31, 8.x, and 9.3 and higher (not cer…
informix vs oracle
utkanbir compared IDS and that other thing: > 3. Nologging operations: IDS also allows non-logged tables, called RAW tables: The following is from the IDS 10 doc, because I can link directly to the appropriate passage, but is true for IDS 7.31, 8.x, and 9.3 and higher (not cer…
JDBC Driver
Where can I get an Informix JDBC driver? The link to it on the IBM website seems broken.…
clarification of parallel query on informix and oracle
this is some time ago; if i recall correctly: there is an env var called export LIGHT_SCANS=FORCE and there are restrictions on it; check the manual for it; it may also be dependant on your isolation level; if dirty read then light_scans ?? monitor it using onstat -g lsc th…
RE: Copying across databases
looks like you may need to tune your ONCONFIG parameters, or force the engine to do LIGHT APPENDS by setting LIGHT_APPENDS=FORCE in the env variable (informix engine needs to be bounced after setting this env variable). -----Original Message----- From: owner-informix-list@iiug.o…
Re: Copying across databases
--0-252203315-1092150249=:40842 Content-Type: text/plain; charset=us-ascii It established one connection/session and maintains that session untill the work is done, it is an implicit transation. The approach I like to use is: Capture all aspects of the target table, indexes, c…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
Mission Critical Database Rating
See http://www.sdtimes.com/news/103/special1.htm - there is a chart that actually compares/lists IBM Informix. -- Scott MacKenzie - Dine' College ISD. sending to informix-list…
Can someone provide link for Informix techinfo on IBM site
Can someone provide link for Informix techinfo on IBM site…
IBM Informix ODBC driver
I'm looking for IBM Informix ODBC driver for windows. There are two different package available out there: CSDK.2.81.TC1.WIN.zip CSDK.2.81.TC2.zip (they even have the same release date) What's the difference between them ? Which one should I use ? Thanks a lot!…
Re: Releasing extents from a table.
I had forgotten that 9.x had a raw table type - thanks for pointing that out. You will get light appends with this - which is the whole point of doing the HPL song-and-dance. Looks like the FAQ may need updating. Speaking of which - since it is STILL languishing waiting for inc…
Re: Releasing extents from a table.
I had forgotten that 9.x had a raw table type - thanks for pointing that out. You will get light appends with this - which is the whole point of doing the HPL song-and-dance. Looks like the FAQ may need updating. Speaking of which - since it is STILL languishing waiting for inc…
Re: Spurious error 197?
--0__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: multipart/alternative; Boundary="1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1" --1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: text/plain; charset=US-ASCII Content-tran…
Re: Question about index performance for a "...where x > 'y
Art, Thanking you again for your help. I guess this may be a development environment issue and so you may not have enough information for an answer. BUT, when I run SET EXPLAIN ON I get error -534, -1. We are using Solaris, and I am using dbaccess to test out certain queries …
Re: High Performance Loader.........
Because you will not get light appends on IDS without going through the high performance loader. Unlike XPS. cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "Dirk Moolman" <Dir…
Re: Large delete
Guess I wasn't clear enough. If you delete that many rows from a table, you will wind up with all sorts of holes in the table, the space will not be reclaimed. The run time for such a delete will be measured in tens of hours or days. If you re-write the table, the finished pro…
Informix customer support outside U.S
Hi Does IBM stopped supporting informix in middle east, since they have closed down informix middle east, customer support never heard of informix when contacted at IBM M.E. Regards…
Re: Fw: Company thought DB2 will be better than Oracle.
> Perhaps the biggest mistake Informix made was not hiring Mark There's a rumour that Informix (and now IBM) are actually paying my salary at Oracle.…
Customers ARE staying with IBM Informix
ALL: I can positively assert that according to a blind independent study of a statistically significant group of customers and business partners around the world, they are surely NOT migrating away from Informix in droves. In fact, 80% of respondents, in this survey which has …
IBM TO WINDOWS INFORMIX MIGRATION
Hello all. We are currently running the following on an IBM AIX box: ESQL/C 7.24.UC7 4GL RDS 7.20.UD6 4GL 7.20.UD6 SQL 7.20.UD6 SE 7.24.UC1 and need to port over to a WINDOWS 2000 box. Would anyone with information, experiences, and recommendations email me. Thanks. <<Sm…
IIUG Insider #31 - Highlights: IIUG in HTML, Chris St. Aubin, LUG News and More...
Fans of Informix, the latest IIUG Insider has published via e-mail and will soon be available online at http://www.iiug.org/news/insider.html. Please feel free to pass on this information to colleagues and management as you see fit. This issue's table of contents includes: 1) I…
PAM & Informix Article @ IBM
The IBM site now has a nice article on PAM & IDS. Looks like something finally happened on this front. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0306mathur/0306mathur.html#section3 sending to informix-list…
HPL Unloading error
You did not show the Value of SHMTOTAL. This may be the limit you are hitting. Informix will report out of shared memory ( regardless of what is available on the machine ) if you have SHMTOTAL set, and reach that size. This parameter is most likely the limit you are hitting. If y…
IBM Informix IDS Benchmarking.
Hi, So what's the story with IBM and TCO. I know the whole game is a silly PC vs. MAC contest and that its all about what works for you but.... There seems to be a push on for DB2 benchmarks from recent review of tpc.org although SQL Server seems to just beat the posted mark 10…
RE: IBM Targets Low-End Database Market
> In nutshell, > IBM seems to be doing what even Oracle failed to do: kill informix completely. Perhaps Janet is Larry in drag ? <shudder>…
what is light append??
hello, can any one tell me exactly the definition for light append and what does that mean?? bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
RE: Comments please on performance - table to table copy
Oh dear - crappy day for long posts from me - too much else going on. 1 - 10 seconds to do a table to table for 1 million rows under Linux ain't bad. 2 - fragmentation is two way - you get faster access (although not according to the ICP exam !!!) because you are reading in para…
Re:Informix on IBM SAN?
That is true. DBA job made simple. SAN and NAS are meant for these. They have huge cache built into them so that always you write to the cache. You dont have to worry about which physical fragmentation. You just have to worry about logical fragmentation. Bottleneck is your ne…
RE: Informix on IBM SAN?
I know Informix does support them and these are usually NFS mounts, so raw devices are out of the question. -----Original Message----- From: Martin, Wayne E. [mailto:WMartin@kmart.com] Sent: Tuesday, October 03, 2000 10:37 AM To: 'd_weber@telocity.com'; informix-list@iiug.org Su…
RE: Informix on IBM SAN?
Hi Doug, I basically had the same issue a couple of months back. And if I had my way I would have stuck with using good'all raw devices. There is definitely overhead whenever you use SAN or for some vendors NAS (network attached storage). Primary of which is network traffice. Y…
RE: Informix on IBM SAN?
Does Informix support these devices as most installs use raw devices? Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: d_weber@telocity.com [mailto:d_weber@telocity.com] Sent: Monday, October 02, 2000 11:35 PM To: informix-list@iiug.o…
Re: Informix on IBM SAN?
From: d_weber@telocity.com (Doug Weber) > >Does anyone have experience running Informix (or any database, for >that matter) on the new IBM SAN (storage area network) equipment? My >company is proposing that we move our Informix database tables to SAN, >and I've got some concerns…
Informix on IBM SAN?
Hello! Does anyone have experience running Informix (or any database, for that matter) on the new IBM SAN (storage area network) equipment? My company is proposing that we move our Informix database tables to SAN, and I've got some concerns. Seeing as these new devices abstrac…
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >Why don't you re-read the whole thing from the beginning. I did. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not every >possible inc…
RE: Informix for IBM S/390
From: kirk.waterhouse@cibavision.Novartis.com > >Why don't you re-read the whole thing from the beginning. No thanks, I'm bored with it. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not e…
RE: Informix for IBM S/390
Why don't you re-read the whole thing from the beginning. I was describing one of the possible ways, method 3 in the list, to run Informix on Linux on a S/390 mainframe - as I understood it - not every possible incantation of mainframe configurations. I am a UNIX guy and I was …
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >I don't know that much about the S/390. Just what I read on IBM's web site >about them running 41,000 instances of Linux on a single box - Just >because they could. > >It simply seems to be a lot of layers between Informix a…
RE: Informix for IBM S/390
I don't know that much about the S/390. Just what I read on IBM's web site about them running 41,000 instances of Linux on a single box - Just because they could. It simply seems to be a lot of layers between Informix and the metal if you run it in the mode I described - and I…
Re: Informix for IBM S/390
From: mbeattie@sable.ox.ac.uk (Malcolm Beattie) > >It might be interesting if Informix was the next out since >they were one of the first vendors to take Linux/Intel seriously. This must be a new meaning of "to take seriously", of which I was not previously aware.... (Interesti…
RE: Informix for IBM S/390
Since IBM released Linux for the S/390, maybe you can run Informix for Linux =:-) A database running on a operating system running on a virtual machine running on an operating system running on a mainframe. The performance would have to be phenomenal. Kirk > -----Original Messa…
Re: Informix for IBM S/390
From: "AM" <amatus@poznan.uw.gov.pl> > >My question is: >what Informix products are currently available for use with db management >systems running on IBM S/390 and what dbms would be of best use for those >products? I don't think *any* Informix products run on an S/390, except …
Informix for IBM S/390
My question is: what Informix products are currently available for use with db management systems running on IBM S/390 and what dbms would be of best use for those products? Best regards, Alicja Matusiak…
latch contention
I wanted to open discussion on some of the info from onstat -g spi and what might alleviate contention for certain resources. Here is a list of latches which I have an interest in and my thoughts on what they might mean. --shmcb sh_lock From what I have read on cdi, I think th…
FWD: latch contention
I wanted to open discussion on some of the info from onstat -g spi and what might alleviate contention for certain resources. Here is a list of latches which I have an interest in and my thoughts on what they might mean. --shmcb sh_lock From what I have read, I think this migh…
Help! Ontape running very slow.
Ooops. (sorry for the misspellings in my post - it's early). :( That reminds me of a poem: I have a spelling checker. It came with my PC. It plane lee marks four my revue Miss steaks aye can knot see. Eye ran this poem threw …
RE: Load Performance problems
Are you using HPL (High Performance Loader) to do your loads? If so, are you running in express mode? When you use HPL in express mode, the engine does "light appends", which bypass the buffers. IIRC, this means that the physical log will NOT fill up, thus, checkpoints will no…
Re: Light Scans and Light Appends (Light Scans/Appends)
From: KENDRICKS.CHERYL@notes.heb.com > >{\\rtf1\\ansi\\ansicpg1252\\deff0\\deftab720{\\fonttbl{\\f0\\fswiss MS Sans Serif;} >{\\f1\\froman\\fcharset2 Symbol;}{\\f2\\froman Times New Roman;}{\\f3\\fmodern >Courier New;}{\\f4\\fswiss\\fprq2 Arial;}{\\f5\\fswiss\\fprq2 System;}} >{\…
poor (?) perf on NT
> My questions are: > > 1) Based on the chunk writes from onstat -F (201053) and the total page > writes from onstat -p (427893), the average > chunk write is only 2 pages. I have seen over 6 pages per write on > my unix systems. Is 2 pages per chunk write > too lo…
Informix in the news
So anybody know what exactly IBM is accusing Informix of doing. Will…
Re: Database Comparison
I will also like to contribute my two cents. My company is a big Oracle Shop but for all Datawarehouse projects & Data Blade projects we use Informix Technology. I have couple of Datawarehouse projects on XPS 821.UD4 on Solaris E10000 boxes. It's a real fun to work with XPS. I h…
Posting from the Informix-list
1. Create your table as 'RAW' 2. Try to use Light Appends. onstat -p will tell you about light appends progress. 3. Use external table to load (HPL, XPS version) 4. Use PDQ PRIORITY (in range) It will help you in starting your job ASAP when the min required resoureces are free. …
Light Scans and Light Appends (Light Scans/Appends)
Has anyone figured how to capture this information. Can you see it occur during an HPL Load? I've entered the commands: onstat -g lap and onstat -g lsc I do not getting any information except the headings...is it some OS Environment or Informix Configuration Variable that ne…
Light Scans and Light Appends (Light Scans/Appends)
{\\rtf1\\ansi\\ansicpg1252\\deff0\\deftab720{\\fonttbl{\\f0\\fswiss MS Sans Serif;}{\\f1\\froman\\fcharset2 Symbol;}{\\f2\\froman Times New Roman;}{\\f3\\fmodern Courier New;}{\\f4\\fswiss\\fprq2 Arial;}{\\f5\\fswiss\\fprq2 System;}} {\\colortbl\\red0\\green0\\blue0;} \\deflang10…
re: HPL performance tuning
For those that are interested, a great deal of time is spent discussing HPL performance in the Advanced Performance Tuning Masters class..... Of course, express is much faster than deluxe mode for loads, as it bypasses much of the inner workings of the engine. I'm not sure how …
light append
What is the meening of light append in Informix? Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.…
Errors in Log file
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_01BEEB2A.E305DEC0 Content-Type: text/plain I note the following errors in out Informix Online message log file: 17:24:4…
Re: 2xRe: urgent : inknown problem
All that I'm aware of. Tried Solaris, DGUX on m88k and intel myself. Whether this is a 'bug' of a 'problem' and therefore insoluble is an open question since Informix will not or cannot test it in an SMP production environment. The question comes down to whether the problem is…
Light Appends: How besides HPL?
Folks I thought you could get use of light append buffers on loads by simply reducing the buffer cache < table size and setting ISOLATION... (like with light scan buffers). Can you get this without using HPL? Thanks Paul Johnson paul.johnson@aethos.co.uk…
Informix Online on IBM Netfinity
Hi, we want to buy an IBM Netfinity 5500 M20 (2 PIII Xeon) and run Online 5.02.UC6 on it under SCO-UNIX 3.2v5.0.5. Has anybody run this constellation? I've read in this Forum about troubles with Informix and RAID. Is it so? Any warnings, considerations and/or comments a great…
Informix on AIX
We are an AF site wishing to run Informix 7.3 on IBM's AIX on a RS6000 Are there any FAQ's or pointer or gotchas that would be useful in this environment??? thanks steve…
Informix & IBM Data Joiner
Hi all, Does anybody use Informix DS and IBM Data Joiner If the answer positive what are the pluses and mineses Thanks ahead, Alex ---------------- TERN Technical Support mailto:alexs@tern.ru…
RE: Version IDS 7.xx for AIX 4.2.1
Doris, We are running IDS 7.30.UC3X3 on AIX 4.2.1. This version works great for us. We have set the following environment variables in /etc/environment to circumvent known problems. 1. NO_SUBQF=1 2. LIGHT_SCANS=off The NO_SUBQF variable is a workaround for defect 95376 which is …
Re: Indexing & data warehousing
Doug Johnson wrote: > > I don't think it's quite that simple. > > 1. Informix uses lots of indexes for their TPC-D benchmarks. We've been handed a lot of the latest information which counters the above assertion. I'd like to see some documentation that shows the above statement…
Informix Online & IBM HACMP
Does anybody have any experience setting up Informix Online 7.x in an IBM HACMP environment? I am thinking about setting up a 2 node R/40 system to support a multi-database environment with about 3 to 4k users. Has anybody done this? Does it work? Is it as complex as IBM and …
AN INFORMIX WISH LIST - DRAFT - NOT FINAL TILL JULY 18, 1997
INFORMIX WISH LIST 07/01/97 DRAFT :-) --------------------------------------------------------------------------- The following wishes are a collection and summation of request from Informix Users around the globe. They are edited for format…
Re: Light Appends
On 16 Jun 1997, Manoj wrote: > Does anyone know what light appends are (onstat -a). [You know, I almost ran this? Geez, its early] BTW: $onstat -- | grep light lap Print light append information $ 1. Pull up Frameviewer, load Informix documentation. 2. Search, "light a…
Re: Illustra locking an Index ?
Hi Mark, Don't forget that Illustra uses No-Overwrite storage. That means that EVERY update to a row is, in effect, an 'update' in-place to the system columns of the 'Old' version of the row to tag it as deleted, followed by Insert of the 'New' version of the row (actually appe…
Re: Light Appends
}>From ilist@rmy.emory.edu Mon Jun 16 10:51:01 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id KAA09901; Mon, 16 Jun 1997 10:50:04 -0600 }>Received: (from ilist@localhost) by rmy.…
Light Appends
Does anyone know what light appends are (onstat -a). Thanks, Manoj Schroff, Two Way TV Ltd, UK +44(0)181 996 8221 manoj@mailhost.twowaytv.co.uk http://www.twowaytv.co.uk…
Re: autochangers and ontape
We use IBM RS/6000 J30 informix 6.0 with autoloader. I have the same question and hope to know how to use the autoloader in ontape or onarchive. EricSze…
Informix-4GL and Informix-CGI
is there any one using Informix-4gl with Informix-CGI on a IBM RISC/6000? i have serious problems with libraries compilation.... camara@mula.mur.hnet.es…
DRDA - HELP !!!
If there are anyone who have used Informix DRDA to link to the IBM DB2 please contact men via email. Any information on this issue is highly appreciated.…
AS400 v. DB2
Does anyone have any information comparing IBM's DB/2 to Informix?…
Re: informix & IBM's AIX
Andrej Urbanc <andrej_urbanc@at.ibm.si> writes: >Hello there, >Could comebody give me an answer on which versions of informix run >on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 >and ver. 7.1 on AIX 4.1 (with SMP support) or not? >Thanks & kindest regards, Andr…
informix & IBM's AIX
Hello there, Could comebody give me an answer on which versions of informix run on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 and ver. 7.1 on AIX 4.1 (with SMP support) or not? Thanks & kindest regards, Andrej…
Informix on IBM 9121
The machine of our customer is IBM 9121. IBM offers for it AIX-ESA or AIX-370. The local Informix people don't know if there is or not an Informix version for that configuration. What do you know? THANKS. --- Andres Marianovsky andres@dia.edu.ar…
Informix products in IBM SP2?
Will Informix support the IBM Scalable Power Parallel System (SP2)? A trade article (RiSc World Vol. 4, No. 5) claims Oracle 7.1 and Sybase Navigation Server will be available on this platform. curtis@crl.com…
Re: Simple Unix Text Editor
In <2dl6hfINNngc@emory.mathcs.emory.edu> alan@po.den.mmc.com (Alan Popiel) writes: >This reply is NOT intended to restart the one-true-editor holy wars!! Nor this, just some thoughts having seen many users use vi. Also, note I'm a true addict and fan of vi. >However, since yo…
Re: Simple Unix Text Editor
->To: informix-list@rmy.emory.edu ->From: mac.avid.com!tlahey@avid.com (Tom Lahey) ->Organization: Avid Technology, Inc. ->Date: Wed, 01 Dec 1993 17:23:23 EST ->Subject: Simple Unix Text Editor -> ->I am looking for a simple text editor that I can call from a 4gl program ->that w…
Informix 5.0.1 for IBM RS6000
Does anyone know if this available? If not when will it be available? Rick Hamel…