Oninit® Archive
Results for “USRC_POOLSIZE”
EXTERNAL TABLE issue?
David, ask for the APAR/Issue number: it is normally a public informix on IBM's website…
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 …
script to check status of dbspaces & chunks
I would use the IBM provided script alarmprogram.sh in onconfig ALARMPROGRAM /opt/informix/etc/alarmprogram.sh…
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Hello removing RALLOC_MODE POOL will not change to overall need for memory. It will only generate less pools. A shorter onstat -g mem can be better to identify pools which are growing when "allocating additional shared memory segments" is ongoing, Support can help here. But suppo…
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". …
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
SHARED MEMORY ALLOCATION
Note that DS_NONPDQ_QUERY_MEM is limited to 25% of DS_TOTAL_MEMORY. Neither DS_TOTAL_MEMORY nor DS_NONPDQ_QUERY_MEM are carved permanently out of SHMVIRTSIZE but are allocated from there as needed and released. I can alleviate Benjamin's fears. The total of DS_NONPDQ_QUERY_MEM u…
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…
identify what is allocating memory
original post: Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I…
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.…
Odd Bufferpool Behaviou
Original post: AIX 6.1 IDS 11.70.FC8X8 I have a new machine with a lot of extra memory. Given that, I added a bunch of new buffers (4k, 8k, & 16k) and went to town testing away. Long story short, with all those new buffers, I get virtual segments added at startup. In onstat -g …
too many statements in memory
Hi, I would say you have to take a look in the java code which is probably not releasing the statements and/or resultsets. The connection pool cannot do that if the client code leaves statements open. This responsibility of the programmer to free everything after usage, unless i…
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)…
shared memory issue
checking 'onstat -g mem' was already mentioned in one of the other responses. Consider collecting this output in intervals after this Informix instance was started. Then you should be able to see if there is a specific memory pool which grows constantly, for example. Also, this…
new bufferpool
original post This concerns ids12.10TC3IE . These are the old lines in my onconfig... #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 #BUFFERPOOL size=4K,buffers=100000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 #BUFFERPOOL size=16K,buffers=…
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…
Buffer Size and Use
Folks, We recently had a conversation with a well-respected name in the Informix world, recently, concerning our bufferpool configuration. When exported, our database takes up only about 18 GB. We had a buffer pool of 12 GB, figuring that the more memory resident, the better. Al…
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…
Help on jboss memory usage for persistant sessions
Hi, the problem is probably in the application, not in the database. When using a JDBC connection, each object should be closed after usage. ResultSet, PreparedStatement, Connection etc. When using a connection pool, the connection.close() method will return the connection to th…
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…
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…
Bufferpool max size in Windows Server 2008 64bit
Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC…
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…
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!…
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 …
Problem with identifying root cause of continual m
original post: Hi to all, I have a problem with identifying root cause of continual memory consuming by db-sessions. Our OS: AIX Our IDS: 11.70.FC3 Application layer is Weblogic Application server and the interface is JDBC driver. During investigating this issue I was able to i…
11.50.FC8 aio memory pool allocation seems high
after upgrading our client from 11.50.FC5 to 11.50.FC8 (aix) , the engine uses aprx 130 meg more of virtual shared memory. By comparing historical onstats between the two versions the increase is in the aio memory pool (~230 meg) , where on FC5 the usage topped around 90 megs... …
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…
tempdbs used by a ghost
Alberto Romeu Pessonio Filho Wrote: -------------------------------------------------------------------------------- Hi guys!!! Sorry to forget this: IDS 11.50 FC7W1GE Linux Redhat x86_64bits Art: My system wasn't in archive mode when the issue happened. I suspect that we are…
Increase buffer pool size
Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page…
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…
Re: 11.70.tc1IE limits
Thanks, Doug. I will try that Monday. Sorry about this email, but Windows Mail says I don’t have a Simple Mapi-compatible mailer installed, so I cannot just hit “reply all” . Hi Bill. There is more than one issue here, but mostly you need to work out what the memory leak is. C…
ids 11.70.TC1IE limits
Hi Bill. There is more than one issue here, but mostly you need to work out what the memory leak is. Can you watch "onstat -g ses" and "onstat -g mem" to spot which session or shared memory pool is growing? If it's a session, use "onstat -g ses session-id" to find out the detail…
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\\\…
why does DS_NONPDQ_QUERY_MEM have the prefix "DS"
Yes. It comes out of DS_TOTAL_MEMORY. Art On Jun 20, 2011 5:09 AM, "YE XIE" <xieye@cn.ibm.com> wrote: > In Informix Administrator's Reference, I see: > Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of > memory that is available for a query that is no…
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…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
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 :-)…
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 …
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…
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…
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…
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 ?…
syspools
>Jacques, > >Thanks very much for the response! > >We are wondering if it can be reused for other purposes if needed. The >concern is, we have total around 800M Virtual segment size, the "mt" >occupied more than 600M( see below). We have had some "out of Memory" >problems . It so…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
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.…
Informix allocating shared segments
It does sound like it could be a server memory leak. What you would want to do is to start monitoring onstat -g mem and onstat -g seg output. In the onstat -g mem output you would want to do comparisons on pool sizes and look for any pool or pools that might be continually growin…
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…
Informix hang
Yaron Reinharts wrote: > Hi, > > We are running a Java application under load which uses Informix JDBC driver > The Informix server is located on another server > > First we tried static connection pool, everything seems to work fine however > for some reason we can not use stati…
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.…
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…
"Dynamically added new Virtual segment "question
> What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!) > First off is onstat -g seg to find the address of the new segment, no > problem. > But once I've done that, what's the next move? > I'm guessing onstat -g mem and find out what processes have a pool > starting…
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: Slow database creation and loading
On Jun 18, 10:50 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > If you are using HPL, that grabs it's own memory. Data does not go through > the normal buffer pool (unless you are using deluxe mode). You might not > want to increase buffers. I need to double check but I…
Memory leak on AIX 5.3
Reading through this my impression is that this APAR talks about authorization functionality and the msc VP growing in size. What Mirek described looks like Informix session memory is growing rapidly within IDS shared memory - if I don't misinterpret what he's saying about the '…
IBM seeking INFORMIX authors
Hi Informix Fellows, maybe someone is interested in this: http://www.informix-zone.com/node/123 Thank you.…
Re: error initializing
Juan Pablo wrote: > Hi: > > when initializing my INFORMIX leaves the following message to me error: > > $ oninit -v > Checking group membership to determine server run mode...succeeded > Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded > Creating /INFORMI…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
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: Virtual shared memory: aio pool
"After restart IDS with unset SECURITY_LOCALCONNECTION, aio pool is not increase." Log a support call with IBM.…
Virtual shared memory: aio pool
http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=DB520&uid=swg21216394&loc=en_US&cs=utf-8&lang=en After set SECURITY_LOCALCONNECTION to 1 on IDS 9.40FC6 (Sun Solaris) , size of aio pool increased to 334 MB over 4 days. After restart IDS with unset SECURITY_…
Re: Stuart strikes again - history is altered!
DE - Simple question - have you ever worked for IBM or Informix? Curious....…
Re: Virtual shared memory: aio pool
After restart IDS size increase to 1MB after 2 day work - total size 168MB free 26MB All connection ipcstr…
Virtual shared memory: aio pool
Hi! IDS 9.40FC6 onstat -g mem | grep aio Pool Summary: name class addr totalsize freesize #allocfrag #freefrag aio V 21e0c6040 670588928 105694536 816895 179934 onstat -g seg Segment Summary: id key addr …
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.…
Does "onmode -F" always work?
Hi, onmode -F does two things: 1) It searches all memory pools and tries to free any freeblks in each memory pool. Those freeblks belong to the memory pool, but are unused. When 'onmode -F succeeds, it returns the memory to the the the free memory in the segment. You should …
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
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.…
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
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…
Re: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
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…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Reading co…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
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: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
JDBC Driver
Where can I get an Informix JDBC driver? The link to it on the IBM website seems broken.…
Connection Pooling for 4GL/dbaccess
Hello all, Our application relies heavily on many short lived 4GL and dbaccess sessions. In the process of some performance tuning, I am noticing that executing a simple query through dbaccess on clients (remote from the DB server using tlitcp), can take anywhere between 100 an…
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
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…
Session memory usage
Hi, does someone know how much memory a user session takes on a Informix database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik…
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…
Intitialization problem
Hi, I have a problem with IDS 7.31 on SCO 5.0.5 When trying to initialize IDS and it hangs. Here is the oninit -v command: # oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/usr/informix/etc/onconfig'...succeeded Creating …
cannot initialize root dbspace
$ 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 server run modesucceeded Reading configuration file '/informix/etc/on…
Memory usage-tm
Hi, informix consumes all machine memory. We have to stop and start informix. Pool with but memory is "TM". onstat -g mem tm Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 15 days 09:44:44 -- 845824 Kbytes Pool Summary: name class addr totals…
Memory usage-tm
Hi, informix consumes all machine memory. We have to stop and start informix. Pool with but memory is "TM". onstat -g mem tm Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 15 days 09:44:44 -- 845824 Kbytes Pool Summary: name class addr totals…
Memory usage-tm
Hi, informix consumes all machine memory. We have to stop and start informix. Pool with but memory is "TM". onstat -g mem tm Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 15 days 09:44:44 -- 845824 Kbytes Pool Summary: name class addr totals…
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…
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
RE: informix session memory usage problem
Yasar, 'res-buff' is a database cache. I've never seen any memory leak in that pool. Memory leaks usually occur in 'V' segments - either 'global' or per-session pools ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: yasarakman@isne…
Re: informix session memory usage problem
"Yasar Akman" <yasarakman@isnet.net.tr> wrote in message news:daa0f8b6.0404062206.46de2f2d@posting.google.com... > Alexey, > Thank you very much for you reply. > > "onstat -g mem" shows that the biggest pool is res-buff. > the details of the pool is: > > E2:/home/opera->onstat -g…
Re: informix session memory usage problem
Alexey, Thank you very much for you reply. "onstat -g mem" shows that the biggest pool is res-buff. the details of the pool is: E2:/home/opera->onstat -g mem res-buff IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line (Prim) -- Up 1 days 13:33:39 -- 4096000 Kbytes Po…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
RE: informix session memory usage problem
Yasar, Please, can You try to analyze the following: 1. Memory allocation by segment: onstat -g seg 2. Total memory allocation: onstat -g mem 3. If You find that some particular pool reported in (2) is very big, please, try to investigate it with onstat -g <pool name|session id>…
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!…
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 …
Re: How can I tell what's eating my global memory pool?
squung@aol.com (Everett Mills) wrote in message news:<b53eea08.0308120717.47d798f3@posting.google.com>... Addenda: I just read this in another forum, sounds like the same problem... From: Alexey Sonkin [mailto:alexeis@grandvirtual.com] Sent: Thursday, August 14, 2003 12:42 PM To…
Severe memory leak in global pool: mgm_query
Hi, everybody, After taking a look at the size of memory pools (onstat -g mem) on our machine, I was shocked : it appeared, that the size of global pool is 138 MB!!! Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line (Prim) -- Up 22 days 14:11:09 -- 1790448 Kbytes Pool S…
AW: Severe memory leak in global pool: mgm_query
P.S. It seems that this problem doesn't reproduce with 9.40 ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Alexey Sonkin > Sent: Thursday, August 14, 2003 12:17 PM > To: 'informix-list@iiug.org' > Subj…
Severe memory leak in global pool: mgm_query
Hi, everybody, After taking a look at the size of memory pools (onstat -g mem) on our machine, I was shocked : it appeared, that the size of global pool is 138 MB!!! Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line (Prim) -- Up 22 days 14:11:09 -- 1790448 Kbytes Po…
How can I tell what's eating my global memory pool?
Guys- We have a pair of (supposed to be) identical IDS servers running in two of our plants. They have similar software, identical hardware, etc. They are both running IDS 7.31.FD4 on HP-UX 11.0. The less busy one, however has a global memory pool that grows until it chews…
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…
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>…
Side Effects of Setting Tables Memory Resident
Dave Thacker wrote in message ... >In an effort to cut down on disk I/0, I have set 8 of our most heavily used >tables to memory resident. The checkpoints have gone through the roof. I >was averaging 1-3 seconds and am now stuck at 8-9, with spikes to 15. >Checkpoint interval …
RE: Problem with memory allocation
Yes, it is. The virtual pool is used for internal tables, session data, thread data, stored procedures caching, sorting. -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Thursday, January 04, 2001 5:20 PM To: John Carlson Cc: informix-list@i…
Re: Problem with memory allocation
John, Thanks for this, Can you please tell me what is this global pool, Is that the pool used for sorting and indexing. Aboo John Carlson wrote: > See comments below . . . . > > -----Original Message----- > From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] > Sent: Wednesda…
RE: Problem with memory allocation
It looks like you're running into KAIO problem (bug). Tell us about your environment. Vivek Chaudhary -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Wednesday, January 03, 2001 6:10 PM Cc: informix-…
RE: Problem with memory allocation
See comments below . . . . -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Wednesday, January 03, 2001 6:10 PM Cc: informix-list@iiug.org Subject: Problem with memory allocatation Hi All, Can anybody please help me with the memory segments…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
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…
GLS memory pool growing
I'm using 7.31 UC4 on HP-UX 10.20. I observed a constantly growing amount of shared memory on my IDS server When I look at the memory pools (onstat -g mem) I see that the GLS memory pool is constantly growing and consumes about 80 % of the whole shared memory. Did anybody else …
Informix in the news
So anybody know what exactly IBM is accusing Informix of doing. Will…
IIF2000 on Linux: Initializing ASF ...FAILED
I am trying to initialize the IIF2000 on my RedHat Linux and I receive this error: oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507'. Can you help me? I tried to run oninit with a lot of verbosity. Here is the output: Checking group members…
Shared Memory Size vs Physical Memory Size
Glynnie wrote in message <7kb1o2$kru$1@nnrp1.deja.com>... >Can somebody please explain the pros and cons of increasing either the >initial virtual memory segment or adding a further segment via "onmode - >a" on a machine that is Informix Dynamic Server dedicated. The rule of thu…
Stored procedure pool in virtual memory
Does Informix 7.xx allocate memory dynamically to the stored procedure pool? How can I determine exactly how much memory the pool occupies? I know about PC_POOLSIZE and onstat -g prc, though not what all the output columns from latter represent. What does PC_HASHSIZE govern?…
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…
Re: Connection pooling
I have the same problem. We have several CORBA objects which make database connections to Informix and the connections are supposed to last until the objects deactivate. All clients need to access data through these objects and the Virtual portion of shared memory grows. I am st…
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…
Server Crash
We're running Online 7.11 on HP UX 9.01 and my server just crashed with the following errors listed in the log: 10:37:06 dynamically allocated new shared memory segment (size 2097152) 10:37:16 Pool = 0xc084c010, Pool name = mt, Blkhdr = 0xc0fb5040 10:37:16 Block magic is -15…
Re: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
Re: JDBC
Ben wrote: >Has anyone gotten JDBC to work with servlets for informix? I have >gotten it to work directly from the UNIX prompt, but whenever I try to >connect more than once to a shared memory connection server, I get >errors about shared memory. When I try to connect to tli, …
Re: HELP! IUS crashes during level 0 dump
In article <19980114025900.VAA02644@ladder02.news.aol.com>, SaTriGuy <satriguy@aol.com> writes > >A couple of other "onmode -f" commands that might come in useful. > >0x1 - run a check on all memory pools with each memory allocation -- This is >really slow. > >0x8 - check the g…
Re: memory pools
bala peddi wrote: > Could Any one Please explain me the memory Pools section of > onstat -g ses 12378 > Is this the normal in informix > INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- > 416472 Kbytes > session #RSAM …
memory pools
Could Any one Please explain me the memory Pools section of onstat -g ses 12378 Is this the normal in informix INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- 416472 Kbytes session #RSAM total used id use…
memory pools of onstat -g ses
Could Any one Please explain me the memmory Polls section of onstat -g ses 12378 Is this the normal in informix INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- 416472 Kbytes session #RSAM total used id us…
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 …
Shared Virtual Memory Usage Question
We have a nice, simple two tier application, with a Powerbuilder based client connecting to a V7.13 engine. New connections start out using very little memory (virtual pool I think) as reported by "onstat -g ses". Then over time it increases, some getting as high at 20+ megab…
Re: Block magic 4114
You don't say which version of 7 you are on. We got messages like this with version 7.12, but when we upgraded to 7.13 they disappeared. Peter Wages wrote: > 4:36:32 Checkpoint Completed: duration was 2 seconds. > 14:37:56 Pool = 0xc2b1b010, Pool name = mt, Blkhdr = 0xc32c8…
Re: Block magic 4114
Peter Wages wrote: > 4:36:32 Checkpoint Completed: duration was 2 seconds. > 14:37:56 Pool = 0xc2b1b010, Pool name = mt, Blkhdr = 0xc32c85e0 > 14:37:56 Block magic is -4114 (BL_MAGIC_FREE), expecting 4 > 14:37:56 Memory block possibly freed twice > 14:37:56 mtshpool.c, lin…
Block magic 4114
One of our servers ( instances ) has suddenly started coming down quite often with the following message. 4:36:32 Checkpoint Completed: duration was 2 seconds. 14:37:56 Pool = 0xc2b1b010, Pool name = mt, Blkhdr = 0xc32c85e0 14:37:56 Block magic is -4114 (BL_MAGIC_FRE…
Re: Informix 7.13 "eating" memory
In article <32844747.22509345@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes > >What I know is, that Informix has two different memory management >routines in the OnLine Server. The one which manages the virtual >portion ( 8KB blocks ) and another one for…
Re: Informix 7.13 "eating" memory
Uhps, I didn't see the loop inside your test program. Could you please place the "onstat -g ses ###" immediately after the "select instit.." statement, and print the different memory pools ? I think it's not neccessary to print all 10,000 reports, just the first 5 outputs. Stef…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
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…
Re: mt.shmpool PANIC
Mickey Mestel (mickey.mestel@etak.com) wrote: : it helps to post a little background info, to even say that you don't : know what specifically was going on when this happened if this was the case. Version and platform could be very helpful, too. : : > -------------------------…
mt.shmpool PANIC
Dear all, does anybody have any experiences with something like below, please ? Thank You. Yours Rasto -------------------------------------------------------------------------- 17:40:40 Pool = 0x18fe020, Pool name = 1070, Blkhdr = 0x19c9d40 17:40:40 Block magic is 107…
Re: 'ralloc' in onstat -g output
Manoj Samel (manoj@green.baan.nl) wrote: : What does the component 'ralloc' indicates in onstat -g ses < session id > output ? : For what purpose is this memory used ? : This is Informix-Online 7.20 : Thanks for any help : Manoj : (manoj@baan.nl) It's the name of a memory poo…
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…
Informix 5.0.1 for IBM RS6000
Does anyone know if this available? If not when will it be available? Rick Hamel…