Oninit® Archive
Results for “onstat -g vpcache”
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…
Upgrade from 10.00.FC6 - 11.70.FC1
Hi, I added more chucks into the dbspaces, and ran the conversion again. Here is the latest message. Any ideas would be appreciated. 11:47:25 Succeeded 11:47:25 Converting Partition Header Page 284:2017. 11:47:25 Converting Partition Header from version 10.00 11:47:25 Succeeded…
Network tuning advice needed
On Oct 9, 10:59 am, Tom <tlow...@munis.com> wrote: > Greetings All, > > I am looking for some advice on a new (to me) configuration. Up until > now, we have always had our engine running on the same server as our > application. That has now changed. We now have a setup with the >…
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Stuart: What do you have VP_MEMORY_CACHE_KB set to? Also, does "onmode -F" remove the unused segments? Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Announcing the passing of Stuart Litel
Stuart. J. Litel passed away on April 19, 2025 at his home in Waban, Massachusetts. Stu was the beloved son of the late Joseph and Barbara E. (Sulkin) Litel of Newton, Massachusetts. Robin Chapman was his loving domestic partner for 20 years in Waban. He was a dear nephew to Barr…
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…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
What prevents a RSS to roll forward as fast as its primary?
Your RSS has less memory and fewer cores. It is no wonder why the secondary cannot keep up with the activity on the primary! Are the ONCONFIG settings identical? If not, more reason why it falls behind. Arr ------------------------------ Art S. Kagel, President and Principal Con…
Informix HA Cluster and CM
OK, here's how it goes. You have two servers, a primary and an HDR secondary, call them node1 on host1 and node2 on host2 and you have a single Connection Manager, call it CM1 on host3. The servers each have a TCP and shared memory connection type defined, call them node1_tcp and…
Want to DROP an empty rootdbs chunk
David: No worries. Except for the catalog tables and a handful of others, nearly all of the "tables" in sysmaster are not actually tables at all, but windows in to memory structures which cache on-disk structures. Those, like the chunk table, dbspace table, etc. are what are upda…
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…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Suresh: You do not have enough logical logs defined. Any transaction or combination of transactions that span more than the percent of logical log space documented in the LTXHWM parameter in your ONCONFIG file will trigger the oldest of the open transactions to roll back with a L…
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…
Memory issue on Informix primary server
Amit: Casey's right, it looks like most of the memory allocated is unused. I had missed that. Here's what I think happened. As I said Solaris is VERY SLOW to allocate shared memory, so when a session needed more memory the engine requested another 3GB segment. It took so long tha…
Shared Memory
Yes, I would increase SHMVIRTSIZE as long as you are confident that the additional 4GB of memory that were added are "normal" and would be allocated again anyway if you didn't increase it. If the additional memory was an anomaly due to some unusual activity, then maybe increase i…
monitoring session memory
Try this one: > select memused, memtotal from sysscblst where sid = 503; memused memtotal 252728 266240 1 row(s) retrieved. Slightly different from the onstat output, but consistent: onstat -g ses 503 | head -7 IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line --…
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…
RE: Upgrade IDS
Thanks Art and Luis for the competent and quick answer. Now I know what happened and what I have to do. Have a good time. Heinz WESTFLEISCH SCE mit beschränkter Haftung, Hauptsitz: Brockhoffstr. 11, 48143 Münster Amtsgericht Münster: Gen.-Reg. 448 Aufsichtsratsvorsitzender: Josef…
Upgrade IDS
I have encountered that error before, also during an upgrade to Informix version 12.10.XC13 ( from version 12.10.XC7 ). What I think that is happening is that there is a correction to the ph_threshold table, in the check constraints: DBSCHEMA Schema Utility INFORMIX-SQL Version 1…
YIKES! 12.x documentation for onstat -g opn does not match the output
ra column is the current readahead for the instance partp is the memory address of the structure that describes the tablespace i.e. partnum Cheers Paul > Hi Folks. > > I'm tyink I've managed to work around my ignorance of the sysmaster tables > in relation to onstat -g opn. Howe…
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". …
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: <some stuff deleted> @Jacques , Thank you for your explanation. Please, can you answer my question below? If I get the sum of the column totalsize of all lines on 'onstat -g mem' (Pool+blkpool), should be close value of the used memory for the segments at 'onst…
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…
IO performance issues
Michael: FWIW, your other post (with onstat -g mgm) doesn't tell us anything useful except that the server's been online for 11 days and 18 hours or 282 hours. Assuming you have not zero'd your stats since startup, I can calculate a rough Buffer Turnover Rate (BTR) across the tw…
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.…
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
IFX_XFER_SHMBASE
Thanks to all that answered. The solution was to change this: BUFFERPOOL size=4K,buffers=100000,lrus=16,lru_min_dirty=20.00,lru_max_dirty=30.00 BUFFERPOOL size=16K,buffers=20000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 to this: BUFFERPOOL size=4K,start_memory=200mb,memory…
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)…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
shared memory issue
onstat -g afr /onstat -g mem. Which pools/sessions are taking up the memory? Regards, David. > On 01 October 2015 at 20:19 Art Kagel <art.kagel@gmail.com> wrote: > > > You should always post your platform and Informix version details so you > don't have to wade through version…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
Linux Processor x Informix 11.5FC5WE
Affinity is OFF by default, the aff= clause in your VPCLASS entry is turning it on and assigning all VPs to processor core #0. Just remove that entry. As far as how many VPs to use, my testing over the years shows that Informix can take advantage of about 450-500MHZ of processor…
RFE request for session details during virtual shm
Hello. I think this might be a very useful RFE, in order to help us to identify abnormal memory session usage, in OLTP systems of high ammount of concurrent sessions (ad-hoc applications). If anyone like, please vote it... https://www.ibm.com/developerworks/rfe/execute?use_case=…
New IDS / performance & stability
To answer your points more generally than in the other replies, I also run some systems as busy as yours. You can probably infer this from the fact we ran into the VP_MEMORY_CACHE_KB issue, which will only be seen on a very busy system. I am disappointed to hear the FC8W1 fix pa…
VERY slow BTS index build
>> Don't remember the thread details. What version? What OS? What is >> VP_MEMORY_CACHE_KB set to? Are you using PDQPRIORITY AND PSORT_NPROCS >> during the build? >> Art Hi Art, Informix 11.5.FC6 running on a Sun Solaris 10 system. PDQ set to 100. PSORT_NPROCS = 8. VP_MEMORY_CAC…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 22:52 John Miller iii <miller3@us.ibm.com> wrote: > > > The two mutex which are directly effected are sh_stamp and po_lock, but > the VP_MEMORY_CACHE_KB speeds up malloc()/free() functionality > which can have an indirect …
Re: spin locks
Added to FAQ. Regards, David. > On 23 September 2013 at 18:47 John Miller iii <miller3@us.ibm.com> wrote: > > > The output of onstat -g spi is so low, it is really not even worth > worrying about. The po_pool lock > is the hottest mutex which has 118 latch waits in over 9 hours…
Re: spin locks
Added to FAQ. Regards, David. > On 22 September 2013 at 02:20 Art Kagel <art.kagel@gmail.com> wrote: > > > IB that is the memory pool latch. You can probably reduce the activity on > it by enabling VP_MEMORY_CACHE_KB so that each CPU VP holds on to some of > the memory from the…
shmget ENOSPC Informix 11.70FC7 on Ubuntu 64 bit
Peter: One thing to note is that in 11.70 IBM changed the way that the VP_MEMORY_CACHE_KB works. In 11.50 the value configured for this parameter is fixed and permanent or static. If a VP needed more memory than the VPCACHE setting it would get that from the central memory pool …
Checkpoints slowing down the insert on Primary
Ok the first thing I´d suggest: activate RTO, instead of using the old feature of frequent checkpoints. Do it and also increase the default value of memory cache for cpu vps. That should let the engine run itself, and runs a checkpoint everytime it need, in order to complete the…
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…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Buffer Size and Use
Thank you for explanations. Could I summarize it like this? RESIDENT speaks to the O/S memory management, and does not affect Informix's management of the buffer cache. That is, the two are orthogonal processes. DG…
spin locks
When I change it with onmode -vf the engine takes it. 11:17:27 Value of VP_MEMORY_CACHE_KB has been changed to 1000. 11:18:21 Current value for VP_MEMORY_CACHE_KB (1000) was saved in config file. And I looked in the config file and it is changed. Now when I do onstat -g vpcache,…
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…
ER network replication state
Hi Madison, that the problem is on the target would explain that we have the same problem on the 2 source servers. But why we cannot see anything on the receive queue? There was no spooling. Or 'full receive queueu' means only the memory queue has to be full to get this blocking …
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…
problem with IDS 11.70FC4 and RedHat 5.6
Hi, What is the output of onstat -g seg ? Its good to tune VP_MEMORY_CACHE_KB 10240 also. rgds schillache…
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
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?…
Monitoring VP_MEMORY_CACHE_KB effectiveness
The only tunable for this is the VP_MEMORY_CACHE_KB, the number of KB of memory to be retained by each CPU VP from the central pool between queries. This parameter and its usage are reported by onstat -g vpvache. The value is shown as: Number of <cpu memory block size> byte memor…
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…
Efficiency of the Informix Virtual Processors
Dear All, IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix) No other instance running on this machine. I was reading a post by john on http://www.jfmiii.com/informix/?p=194 It say that if the efficiency drops below 80% (onstat -g glo output) then there seems to …
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…
Table order in joins for best performance.
Does the order of tables in a join statement make a difference for optimum performance and memory management? I heard that the last join should be the largest table.…
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 …
"IDS seems to have shutdown cleanly"
See below, inline: Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other …
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…
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…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
The memory you specify in SHMTOTAL and SHMVIRTSIZE is specified in KBytes. The memory shown in onstat -g seg in in bytes Informix ideally will not stop when you reach SHMTOTAL, but it's hard to handle low memory conditions (sometimes to rollback you need more memory for example)…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Are you saying I should have SHMTOTAL 6442450944 ? Will the IDS stop if memory exceeds that number? From: Fernando Nunes Sent: Wednesday, September 21, 2011 5:12 AM To: Bill Hamilton Cc: informix-list@iiug.org Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE It …
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
It should not even start... You're saying that the memory limit is inferior to the initial memory allocation! It would be interesting to see the online.log of the instance... Regards On Tue, Sep 20, 2011 at 6:06 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > Many Thanks.…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Many Thanks. We will see if that helps. I now have this in the config ... RESIDENT -1 SHMBASE 0xc000000L SHMVIRTSIZE 130624 SHMADD 26124 EXTSHMADD 26124 SHMTOTAL 6144 SHMVIRT_ALLOCSEG 0,3 Will the IDS stop if memory exceeds 6144kb ? From: Alexandre Marini Sent: Tuesday, Septem…
VPCLASS cpu on sun/oracle M4000 machine
Hello, I have an IDS 11.50.FC6 instance on an M4000 oracle server with 4 CPUs with 4 cores * 2 threads each. The OS (Solaris 10) 'sees' a total of 32 CPUs. The thing is, I'm trying to tune the cpu VPCLASS onconfig parameter so that this instance is able to use more CPU power, but…
Performance Issues
Hello John & All, Thanks for your findings and suggestions: We have increase the memory allocated to informix by 20% VP_MEMORY_CACHE_KB 100000 FASTPOLL 1 The cpuvps are now spining equally, I have not yet changed the NETTYPE as you have suggested but planning to do the same…
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\\\…
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…
Informix Warehouse Accelerator : Memory usage, nec
Hello, I have some questions to understand well the memory management with the IWA : 1/ How to compute the max available shared memory usage for IWA ? I found this formula with my tests : - MAX Available shared memory = SHMMAX * number of worker nodes If the result is greater…
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…
Fatal error in ADM VP at mt.c
I've the following messages in online.log of an 9.40.FC9 informix dataserver : 17:52:55 Fatal error in ADM VP at mt.c:12703 17:52:55 Unexpected virtual processor termination, pid = 1466506, exit = 0x90009 17:52:55 invoke_alarm(): /bin/sh -c '/bases/informix/pcampcam/admin/ontap…
Introduction to the three designer handbags(Chanel,Coach,Prada)
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
Removing semaphore shared memory segment aborts other informixservers
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
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…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
Re: Memory Management
Neil Truby schrieb: > "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message > news:mailman.491.1283968374.1071.informix-list@iiug.org... > Fernando, > >>> More memory means you can do more things and yes... 2000 concurrent >>> sessions could be considered small. ;-) > With …
Re: Memory Management
Ian Michael Gumby schrieb: > > >> From: domusonline@gmail.com >> Subject: Re: Memory Management >> Date: Sun, 5 Sep 2010 23:32:32 +0100 >> To: informix-list@iiug.org >> > >>> Thanks all..great information. I agree that 6 Million is not really >>> that big since the big RDBMSs ca…
Re: Memory Management
Ian Michael Gumby schrieb: > > >> From: neil.truby@ardenta.com >> Subject: Re: Memory Management >> Date: Tue, 7 Sep 2010 21:44:37 +0100 >> To: informix-list@iiug.org >> >> "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message >> news:mailman.480.1283875344.1071.informix-li…
Re: Memory Management
Superboer schrieb: > Hello Fernando, > > I hate to disappoint you, however MS is not easy; try to restore a > complete level 0 backup, you will see what a can of wurms that is. > Besides that monitoring and trying to grab the hottest sql is not > easy(sqlsrv2005); the stuff desc…
Re: Memory Management
On Wed, Sep 8, 2010 at 6:52 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > Fernando, > > More memory means you can do more things and yes... 2000 concurrent > sessions could be considered small. ;-) > I bet you worked a lot with instances with much more than that... > W…
Re: Memory Management
On Wed, Sep 8, 2010 at 6:54 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > If I could talk about some of the stuff I worked on... yes ... memory can > be a concern. > > ;-) > > Honestely I do believe you. But unless those things used Informix it's irrelevant for the discu…
Memory Management
"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message news:mailman.491.1283968374.1071.informix-list@iiug.org... Fernando, >> More memory means you can do more things and yes... 2000 concurrent >> sessions could be considered small. ;-) With more memory you can do things l…
RE: Memory Management
If I could talk about some of the stuff I worked on... yes ... memory can be a concern. ;-) Date: Wed, 8 Sep 2010 13:03:09 +0100 Subject: Re: Memory Management From: domusonline@gmail.com To: informix-list@iiug.org On Wed, Sep 8, 2010 at 12:32 PM, Obnoxio The Clown <obnoxio@se…
RE: Memory Management
Fernando, More memory means you can do more things and yes... 2000 concurrent sessions could be considered small. ;-) With more memory you can do things like in memory database tables for fast response. More memory can be used for advanced processing. (Extensibility that most p…
Re: Memory Management
On Wed, Sep 8, 2010 at 12:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Ian Michael Gumby wrote: > > > > need parallel processing? Maybe not. Do you need to go beyond 16GB most > > likely unless you have a really small system and support a small number > > of users…
Re: Memory Management
On Wed, Sep 8, 2010 at 12:21 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > > > > From: neil.truby@ardenta.com > > Subject: Re: Memory Management > > Date: Wed, 8 Sep 2010 08:55:11 +0100 > > > To: informix-list@iiug.org > > > > > >From the IBM website: > > Ultimate: US$38,…
Re: Memory Management
Ian Michael Gumby wrote: > > need parallel processing? Maybe not. Do you need to go beyond 16GB most > likely unless you have a really small system and support a small number > of users. What is "a small number of users", though? If your application is well-written (a big "if",…
RE: Memory Management
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Fernando Nunes Sent: Tuesday, September 07, 2010 11:19 AM To: informix-list@iiug.org Subject: Re: Memory Management >IDS can't take advantage of multiple indexes on the same query in any GA…
Re: Memory Management
On Tue, Sep 7, 2010 at 5:18 PM, Fernando Nunes <domusonline@gmail.com>wrote: > > > On Tue, Sep 7, 2010 at 5:02 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > >> Really. >> >> So what's missing from Growth that would want you to go >> Enterprise/Ultimate Ed? >> >> Datablad…
Re: Memory Management
On Tue, Sep 7, 2010 at 5:02 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > Really. > > So what's missing from Growth that would want you to go Enterprise/Ultimate > Ed? > > Datablades? > Table Partitioning? > > Can IDS support the use of multiple indexes on a table within…
Re: {Spam?} RE: Memory Management
Ian Michael Gumby wrote: > Really. > > So what's missing from Growth that would want you to go > Enterprise/Ultimate Ed? > > Datablades? > Table Partitioning? Memory and # CPUS for one thing. Unlimited HA nodes. Compression. Parallelism and partitioning. > Can IDS support the u…
RE: Memory Management
Really. So what's missing from Growth that would want you to go Enterprise/Ultimate Ed? Datablades? Table Partitioning? Can IDS support the use of multiple indexes on a table within a query like XPS can? From: art.kagel@gmail.com Date: Tue, 7 Sep 2010 11:55:18 -0400 Subject: …
Re: Memory Management
Growth Edition can have up to three nodes ER or HDR are both supported. No need for Ultinate Edition just for HA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my …
RE: Memory Management
> Date: Mon, 6 Sep 2010 17:19:32 +0100 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: Memory Management > > Ian Michael Gumby wrote: > > > > > > > From: domusonline@gmail.com > > > Subject: Re: Memory Management > > > Date: Sun, 5 Sep 2010 23:32:32…
Re: Memory Management
Ian Michael Gumby wrote: > > > > From: domusonline@gmail.com > > Subject: Re: Memory Management > > Date: Sun, 5 Sep 2010 23:32:32 +0100 > > To: informix-list@iiug.org > > > > > > Thanks all..great information. I agree that 6 Million is not really > > > that big since the …
Re: Memory Management
On 02-09-2010 20:24, shorti wrote: > On Sep 2, 12:06 pm, Andrew Ford<af...@networkip.net> wrote: >>> ok..then I will give you another chance to redeem yourself.....Can >>> anyone tell me what they think of Informix Performance for a larger >>> database...lets say 5-6 + million r…
Re: Memory Management
On 02-09-2010 18:47, Alexandre Marini wrote: > Ok, I can example this: our larger table has > Number of Rows 441.762.945 > > Our cpu idle times: > 12:30:01 PM CPU %user %nice %system %iowait %steal %idle > 12:40:01 PM all 3.39 0.00 0.39 24.61 0.00 71.61 > 12:50:01 PM all 3.08 0…
Re: Memory Management
On 02-09-2010 18:28, shorti wrote: >> >>> Thank you...this is exactly what I was looking for. >> >> I'm clearly losing my touch. >> >> -- >> Cheers, >> Obnoxio The Clown >> > > > ok..then I will give you another chance to redeem yourself.....Can > anyone tell me what they think o…
Re: Memory Management
Ok, I can example this: our larger table has Number of Rows 441.762.945 Our cpu idle times: 12:30:01 PM CPU %user %nice %system %iowait %steal %idle 12:40:01 PM all 3.39 0.00 0.39 24.61 0.00 71.61 12:50:01 PM all …
Memory Management
Hello, I have another question. Again, new to Informix and just doing research for a Linux implementation. Is there a setting that can control the total database memory allowed for Informix to use for all databases and instances (not sure if instance is the right terminology fo…
optimum usage of resources
By Increasing buffer size as mentioned in previous e-mails Regards, Vaibhav S Dantale ___________________________________________________________ Challenge is source of strength QA Manager, Informix Dynamic Server Information Management Address: IBM India Software Labs, Cell: +91…
Help on VP cache tunning
You have two different onstat options below which show two completely different types of information. The onstat -g glo show about the cpu utilization. In fact that the las= t column is Efficiency which is quite low. This column gives you an idea of how well Informix and the ope…
Connections blocked - Connect Timeout Expired
NUMCPUVPS was deprecated in 9.40 and will soon be desupported altogether so don't worry about that one. However, the message about changing NUMCPUVPS from 7 to 1 is worrysome. The VPCLASS cpu should have overridden the default for NUMCPUVPS (ie 1) and set the number of CPU VPs to…
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 :-)…
Initialization of Java virtual processor failed
when trying to install a java udr i'm getting the following nessage: 9444: Initialization of Java virtual processor failed: (cannot create gc file) Can anyone help? Here is the statment: execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar", "env_…
Performance degradation over a period
Hi, what do you mean by some period: seconds, minutes, hours, days, months ? Many indexes on the tables ? New tables/indexes, when the application starts ? Regards, Andreas > ------------------------------------------- SPAR Österreichische Warenhandels-AG Hauptzentrale A - 5…
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…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor is trying to do a majority of the work on a remote server via synonyms. When you look at all the oninit modules running on the remote server, it looks like only one is really taxed: ps -ef |grep oninit hd…
Locks required - Resource overhead..
To reduce the spins on the sh_lock you can enable VP_MEMORY_CACHE_KB in your onconfig. This will setup a private cache of free memory on each cpu vp so that many allocations and free's will not go through this spin lock. To monitor the progress run onstat -g vpcache. This featur…
Re: Sudden Increase in Checkpoint Lengths
Keith Simmons wrote: > Ian > Yes, same place, same package but only two memory segments, Resident > and 1 Virtual, no change from last restart. In that case I'd have a word with the contract managers. If, for instance, daily invoicing is switched from daily to weekly, which i…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
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…
Long Spins
Hi, The IBM IDS document says: "To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features." But wait for other to advice you, I'm sure the IDS guru's will suggest you a so…
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 <<<…
Connection manager parametrs
Thanks for following command: oncmsm -r <connection manager instance name> Web URL is no more valid I think: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adr= ef.doc/ids_adr_0116.htm We have two applications with very different load on databases (i.e.,TPS…
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…
Re: MSC virtual-processor class too loaded aft....
Hi, first of all, thank you very much John and Jacques for your answers. The IDS engine allocated another vp msc (I supose due to the high load of the first one). I have tried without success (at the moment) to catch operations that msc vp is doing with the following command: …
MSC virtual-processor class too loaded after migra
Hi, After migration our DWH from IDS 10FC9 to IDS 11.5FC3 (Under SLES 10 SP2) I found that msc vp class (Miscelaneous System Call) are too loaded, as you can see in the following onstats: Can anybody tell me the reason, or can point me to the correct documentation to understand…
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…
Problema con logs
buenas tardes necesito saber si se puede salvar esta base de datos. tengo el siguiente problema: # oninit -vp # onstat -m 13:20:52 Onconfig parameter VP_MEMORY_CACHE_KB modified from 21822020 to 5455505. 13:20:52 Dataskip is now OFF for all dbspaces 13:20:52 Logical Log Files ar…
Re: Best Use of Free Memory
On 31 Oct, 00:49, "Kevin Cherkauer" <invalid_addr...@nowhere.com> wrote: > David, > > I see the confusion now. The English phrase, "Needs to acquire a buffer," is > too vague. There are really two major cases, but the manual is only > addressing one (the rarer one). The cases are…
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: IDS 11.5 licence question: virtual versus physical processors ?
Martin Thole wrote: > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. > > How many processor licences are neces…
Re: IDS 11.5 licence question: virtual versus physical processors ?
"Martin Thole" <mth@o-b-s.de> wrote in message news:48e3667f$0$6617$9b4e6d93@newsspool3.arcor-online.net... > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual)…
IDS 11.5 licence question: virtual versus physical processors ?
We are planning to migrate our database server to a VMware server. The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 cores), but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. How many processor licences are necessary ? Which database editons (…
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.…
Memory segments grow, and never be freed!!!!
Hello, friends. I need some ideas to solve our problem. Our machine is allocating several memory segments, since the IDS is started. The problem around is that it goes up and up allocating new segments, and never stops (it seems it´s not automatically freeing some segments not us…
Informix allocating shared segments
Ok, my server goes down due to swap going to limit. I have set VP_MEMORY_CACHE_KB to 0. Let's wait to see if it works. Thanks everyone for your help. Regards JACQUES RENAUT wrote: > Hmm, with this being 10.00.FC6 you could be running into a defect with the > introduction of a …
Hardware advice please
Hi all, I am looking for advice on what servers to buy to replace our existing informix db servers. We have to replace them, because they are dinosaurs and could pack up at any moment. Unfortunately I don't really have any idea what would be good to get as I've never been involve…
Analysis of activities during checkpoint.
Hi Vartika, Please check this link. You can add but not drop virtual processors of the AIO, PIO, LIO, TLI, SHM, SOC, and STR classes. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad ref.doc/adref308.htm Thanks.. Amitava E - id : amitacha@in.ibm…
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…
Re: 3 parameter/onstat questions
Floyd Wellershaus wrote: > Thanks for that one Jacques. I will implement the minimum to start off > with. ( 800kb per cpu ). > > I have tested on a demo instance that it does in fact seem to work on my > version. > > Thanks again, > Floyd > > > > > > ----- Original Message ----- …
3 parameter/onstat questions
I just got off the chat-with-labs with John Miller. He left me with 3 questions I am hoping to get more info about, having failed to get anything useful from the version 10 docs. I'm on ids10.0.fc5. 1) He strongly recommended having the chunk mode set to expanded 'always'. He sa…
Informix database virtualization
Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
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.…
IDS 11.10.FC2 crash
ANTHONY JUDISH wrote: > We have just upgraded (a week ago) from IDS 10.xx to IDS 11.10.FC2 on HPUX > 11.11. The databas has crashed (assert failure) three times during this week > due to running out of shared memory. The engine added 10-12 new segments > before it ran out. We nev…
Light append partition after onpload
Thanks for the quick response! > 1. 10.0xC6 is a very problematic version of IDS. Avoid using it. > Upgrade to xC7 or downgrade to xC5 (if you don't use HDR) or xC4. > With xC6, make sure, that you have ' VP_MEMORY_CACHE_KB 0' in your > $ONCONFIG (or have it set to something lik…
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=-…
Memory Performance Tweak
These Settings will fine tune your systems memory, management -at least 512MB of ram recommended, go to start\\run\\regedit -and then to the following key http://software-hacks.blogspot.com/…
Single vs multi cpu ids
Due to the expense of Informix licenseing I was forced to setup a small 300 million row DSS instance for one CPU. To get any meaningful performance out of this arragement I fragmented all the tables by expression an required the users to include the expression in there SQL's. Thi…
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…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…
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…
Vendor JAVA Apps eating up Shared Memory.
We have a couple of Vendor JAVA applications that are eating up shared memory every time they execute there SQL calls. They have their owe pseudo session pooling, but each session increases in shared memory and doesn't reuse pre-allocated memory and gets out of hand. They pointe…
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: Question about Linux VM tuning for IDS
Ian Michael Gumby wrote: > > If Informix acts the way you say, either one of two things. > > 1) You don't have enough memory. > 2) Informix was poorly designed. Not an Informix issue Mickey. Modern UNIX style OS's regard IO cache as primary for performance and feel free to stea…
Re: Question about Linux VM tuning for IDS
Ian Michael Gumby wrote: > > If Informix acts the way you say, either one of two things. > > 1) You don't have enough memory. > 2) Informix was poorly designed. Not an Informix issue Mickey. Modern UNIX style OS's regard IO cache as primary for performance and feel free to stea…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
RE: 10.0 xC6
Hi, everybody, The mystery of enormous memory leak in 10.0uc6 is finally solved. Many thanks to IBM Informix development team, namely John Lengyel, for informal, quick and very professional investigation. It turned out, the problem was introduced by the new functionality: 'Priv…
Re: Anybody seen a very fast wild cat out there?
david@smooth1.co.uk wrote: > > Question > > - Since this 11 Beta includes the onconfig parameter > VP_MEMORY_CACHE_KB I would expect it to based off 10.00.xC6 source > however > onconfig parameter SINGLE_USER_MODE_WITH_DBSA is not listed in the > documentation for this beta. W…
IBM seeking INFORMIX authors
Hi Informix Fellows, maybe someone is interested in this: http://www.informix-zone.com/node/123 Thank you.…
VP error
IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…
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: Database Encryption
Adam Tauno Williams wrote: > > In our case the application uses the user's credentials to acquire a/the > key from a key repository, and then connects to the database with the > user's credentials and uses the acquired key to get or update data in > the database. The key never l…
Re: VP memory cache (was IFX_FOLDVIEW)
Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…
IFX_FOLDVIEW
> What is this "Virtual Processor Memory Cache"?? This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > We could probably dedicate 10Gb of memory to stuff that is not buffers/sort memory! Start with the minimum, 800 (…
Re: Stuart strikes again - history is altered!
DE - Simple question - have you ever worked for IBM or Informix? Curious....…
Recommendation on DBA Tools
Do you have any recommendations on database management tools which helps DBA to monitor and manage the system, and have the flexibility of adding add-ons (bring in other tools, like shell scripts, etc.). Something that would collect and analyze the system performance, monitoring…
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…
HP-UX KAIOON
Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…
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: cannot start with 4 AIO virtual processor
On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …
Re: cannot start with 4 AIO virtual processor
informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…
Re: cannot start with 4 AIO virtual processor
BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…
Re: cannot start with 4 AIO virtual processor
"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…
cannot start with 4 AIO virtual processor
Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…
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: MULTIPROCESSOR settings on a multiple CPU server with
>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…
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…
FW: Informix versus Oracle Spatial
This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…
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.…
Crash of the instance
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Posting from the Informix-list
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
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: update statistics
tomcaml@yahoo.com wrote: > Hello, > > We recieved this message from a cron job over the weekend: > > 564: Cannot sort rows. > > 179: ISAM error: no free disk space for sort > Error in line 50 > Near character position 44 > > > question - does Informix always go straight to di…
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: Solaris memory management
Dirk, I run 7.31.FD4 on Solaris 9. there is a line in the release notes (filename IDS_7.3) "The maximum size of any shared memory segment is 4294967295 bytes(approx. 4GB)." I use RESIDENT -1, SHMVIRTSIZE 4096000 and SHMADD 2048000 and have 7 segments allocated (total 16Gb). Wit…
RE: Solaris memory management
Dirk, I run 7.31.FD4 on Solaris 9. there is a line in the release notes (filename IDS_7.3) "The maximum size of any shared memory segment is 4294967295 bytes(approx. 4GB)." I use RESIDENT -1, SHMVIRTSIZE 4096000 and SHMADD 2048000 and have 7 segments allocated (total 16Gb). Wit…
RE: Solaris memory management
Hi Dirk. Limitation Solaris 32bit is 4GB(unsigned inteter). Limitation Solaris 64bit is unsigned long. See http://developers.sun.com/solaris/articles/tuning_solaris.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Dirk Moolman" <DirkM@mxgroup.co.za> >To: …
RE: Solaris memory management
Hi Dirk. Limitation Solaris 32bit is 4GB(unsigned inteter). Limitation Solaris 64bit is unsigned long. See http://developers.sun.com/solaris/articles/tuning_solaris.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Dirk Moolman" <DirkM@mxgroup.co.za> >To: …
RE: Solaris memory management
The release notes I am looking at on Sun's site are showing that that parameter is obsoleted, of course then they define it. So maybe this web page will give you what you need. I like the System Admin collection of manuals. http://docs.sun.com/app/docs/doc/806-7009/6jftnqskt?a=v…
RE: Solaris memory management
The release notes I am looking at on Sun's site are showing that that parameter is obsoleted, of course then they define it. So maybe this web page will give you what you need. I like the System Admin collection of manuals. http://docs.sun.com/app/docs/doc/806-7009/6jftnqskt?a=v…
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
Re: Solaris memory management
Martin Fuerderer wrote: > Dirk Moolman wrote on 11.04.2005 13:35:51: >>I am trying to find out what the limit is on contiguous memory in >>Solaris. Can I grab one segment of 20G, or will Solaris break the >>segment down into smaller pieces ? >> >>For example, if I run onstat -g …
Re: Solaris memory management
Hi, On UNIX systems INFORMIX reserves memory in blocks( this is 8k each one). Your 20Gg of Memory are 20 Gb / 8Kb of contigous blocks. If you see in your onstat -g seg one virtual value, there are one contiguos Virtual segment. Otherwise, remember that INFORMIX manage a RESIDENT…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
JDBC Driver
Where can I get an Informix JDBC driver? The link to it on the IBM website seems broken.…
Re: Multiple virtual segments
Neil Truby wrote: > "Paul Watson" <paul@oninit.com> wrote in message > news:cutjmk$5s9$1@thorium.cix.co.uk... > >>Madison Pruet wrote: >> >> >>>Solaris is not all that vunurable to the IPCSHM issue... >> >>But Solaris is tuned for 4 segments > > > can you exapnd on that please, …
More CPUVPs than processors
Mark wrote: I've always found that for any CPU faster than about 400MHZ (~600 for x86 CPUS) you can run at least 2 CPU VPs per CPU. Now that CPUS are MUCH faster and multi-pipelined and multi-virtual CPU's, you can likely make that 3 or 4 or 5 times # physical CPUs. I think th…
Could not fork a virtual processor: errno = 12
Hello The past week I had a problem with a memory bank of my SUN450 with solaris 8 The problem is already fixed, but I try to rebuilt a secondary instance with HDR y it is no possible, the steps are the same i had used alltimes: onstape -s -L 0 in the primary server in stanard …
DB-Crash
Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…
CPU Binding
Hello Everyone, I just wanted to clarify how does IDS determine the number of processors a UNIX box have? Our new server(Sun Fire E6900) uses the UltraSPARC IV processor, which is using the Chip Multithreading(CMT) technology. Through CMT, 20 additional virtual processors are sp…
How many physical processors we need to support 32K THREADS in IDS.
Hi Team, Informix IDS supports upto 32K threads according to most IDS realease notes. My question is What sort of a machine you are looking at to support this many threads?? This came to my mind when considering max. num of threads(or connections that matter) that each CPU or NE…
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…
Re: Unexpected Virtual Processor Termination - HELP!
On Tue, 18 May 2004 08:13:07 -0400, Joel wrote: Bounce both engines. Remote synonyms are usually more trouble than they are worth. Could be better to use ER to replicate the needed data on the other server in a separate local database and access it from there. Art S. Kagel >…
Unexpected Virtual Processor Termination - HELP!
We have two SCO-Unix servers, one runs our order entry and acct software, the other runs the warehouse/inventory control software. Each server has an Informix DB, IDS version 7.30 UC2. The inventory control DB uses synonyms to provide access to data in the order entry DB, and vi…
Setting up JVM on 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…
Setting up JVM on IDS 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…
RE: Virtual Processors and CPU-Load
Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…
RE: Virtual Processors and CPU-Load
Dont post MIME Have you run the correct update stats? In Informix monitor users -- onstat -u the ready queue -- onstat -g rea the sqls -- onstat -g ses {session number} You need to determine which sessions or parts of the application are causing the load. With 200 users you…
Virtual Processors and CPU-Load
Hi all, we are a little bit confused concerning the CPU-Load of our Informix-Database-Server. (9.4 UC3, RH9 2.4.20) We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at 99.9%! All tables and indexes (DBSpaces, Extents, ...) are optimized to the best of our knowledg…
how to tune buffer allocated to index data?
The profile you have (Data 12%, Index 86%) could point to the need to increase BUFFERS. Index pages tend to stick around in memory because they are usually used more often than data, especially in OLTP systems where data is almost always accessed through an index (sometime 2 or 3…
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: RES: Pentium 4 hyperthreading
Linux has support, IDS does not care whether the CPU is physical or a hyperthreaded virtual CPU. It will use it if you tell it to. Art S. Kagel Julio Cesar wrote: > Speaking on Affinity Processors, does anyone know if the IDS 9.40 has > support for this feature on Linux? > AF…
Reduce # of CPU: license cost
IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
drop a column
Hi, ALTER TABLE <tablename> DROP <column name> ; should do (in most cases). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "GANESH RAM" <ganesh.r@fmr.com> Sent by: forum.subscriber@iiug.org 03.12.2003 10:39 To: ids@iiug.org cc: …
Engine's re-setting
Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…
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…
ER problem 9.3.UC2 / linux
My line manager has been doing some experiments with ER on Linux and this may be the problem he experienced. He logged a case with IBM Informix technical support on this issue. Their response is that there is an issue with raw IO and logical logs on Linux. Using cooked files for …
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…
oninit: Fatal error in shared memory creation
Joe; The most frequent cause of this error is when the shared memory segments you are trying to create when starting the engine already exist. Look in the online log for an error 17 - that means the segments already exists. That means either the engine is already running (run '…
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>…
memory increase
He's right in theory, but not in practice. Informix will dynamically add memory segments up to and beyond physical memory ( into swap space ). But this is not something you want to happen. It's better to plan for the memory requirements and set the initial shared memory segmen…
Re: Dynamically allocated new extension shared memory
If you are using datablades you will "EXTENSION" memory segments ... "EXTENSION" is memory segment class used within the source. Other classes are RESIDENT, MESSAGE and VIRTUAL. I believe you will see a VX when you do a onstat -g seg in your instance. HTH Thanx much, Rajib Sar…
Re: Dynamically allocated new extension shared memory
If you are using datablades you will "EXTENSION" memory segments ... "EXTENSION" is memory segment class used within the source. Other classes are RESIDENT, MESSAGE and VIRTUAL. I believe you will see a VX when you do a onstat -g seg in your instance. HTH Thanx much, Rajib Sar…
Shared mem connections and semaphores
HeadingDescriptionFormatvpThe virtual processor ID.DecpidThe system process ID for the process running this virtual processor.DecclassThe class of virtual processor.StrsemopsThe number of times this virtual procesor went idle and performed a semaphore operation to wait for work.D…
=?gb2312?B?tPC4tDogUmUuIFNoYXJlZCBNZW1vcnkgUGFyYW1ldGVycyBbODA1XSA=?=
The UC portion of the release level means this is a 32 bit build. A 64 bit version is identified as an FC release level. We are running on Solaris 2.6 which is a 32 bit OS. As I understand it, 3.75 GB is the threshold limit on the total amount of memory a 32 bit engine can manag…
balancing virtual processors
How do I get the kio's to be more balanced? I'm on a Proliant 7000 4-cpu box using NT4.0. C:\\\\WINNT\\\\system32>onstat -g iov Informix Dynamic Server Version 7.31.TC2 -- On-Line -- Up 08:00:59 -- 1643008 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy …
Informix Lockup (Wierd)
----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…
RE: # of instances per machine
I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…
HPUX 11.0 memory management and IFMX
IDS 7.30uc7 OS HPUX 11.0 I'm in the process of troubleshooting a minor issue since we've upgraded to HPUX 11.0. When the engine comes up, the following messages show up in the online. log: 13:25:03 shmat: [EINVAL][22]: shared memory base address illegal 13:25:03 usi…
RE: # of instances per machine
It depends. What version are you running? If version 5 then perhaps that might be a good rule. I would not consider running 7.x+ on less than 4 CPUs. It also depends on whether these instances will all be active at the same time, if they can swap out...... However. I am hig…
# of instances per machine
If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…
FW: what does lngspins mean?
Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
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…
Fw: Redbrick Memory Management & Statistics
----- Original Message ----- From: exformix <exformix@hotmail.com> To: Leonardo F. Cardoso <lfcardoso-nospam@hotmail.com> Sent: Tuesday, November 07, 2000 12:02 AM Subject: Re: Redbrick Memory Management & Statistics > Hi, > > There is no concept of updating statistics in Redbri…
Redbrick Memory Management & Statistics
Hi, How can I control the amount of shared memory redbrick uses? I can�t find any parameter in the configuration file. Another question: Is statistics automatically maintained in RedBrick? Is there some SQL command like "update statistics"? Thanks in advance …
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: Maximum Instance
On Tue, 26 Sep 2000, watZki wrote: >Is there a limit on number of DB Instance Online? Not explicitly. Computer resources (CPU, memory, disk) are usually the limiting factors. >Is there a connection w/ my memory? Yes (assuming you're referring to the memory on the computer, ra…
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…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
Re: Oninit & Instance
Found in "onstat -g glo" Individual Virtual Processors Section -- Class CPU. Neil, Stephen & Edward, thanks for your help. Nick Kataria <kataria.nick@emeryworld.com> wrote in message news:8jdblp$c3e$1@news.cnf.com... > Hi All, > > If I have a process ID of an oninit process (fr…
Re: SE 7.X installation on WIN98 ignore
Please ignore . I was using wrong protocol Thanks stumbde <stumbde@email.msn.com> wrote in message news:... > I am trying to install SE on Win98. When i run dbaccess i get following > error > when i am trying to connect > Error 25567 Internal communications buffer management err…
SE 7.X installation on WIN98
I am trying to install SE on Win98. When i run dbaccess i get following error when i am trying to connect Error 25567 Internal communications buffer management error detected. This error is usually caused by memory corruption or wrong use of buffer management routines. Make sur…
RE: Page Size on Solaris (Informix 7.31)
Solaris onlys has an 8K page size on certain architectures, the rest are 4K. Basically the sun4u's are 8 and the sun4m are 4K. The page size wrt to the OS is determined via the hardware abstraction layer which is typically one of the few machine code areas of the kernel and uniq…
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
Memory problems? Please help.
I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. They used to be executed during a shell script containing abotu 30 programs. However, this was poor for maintenance and distribution so one exe was compiled and the routines seem to get slower and slower as…
Informix in the news
So anybody know what exactly IBM is accusing Informix of doing. Will…
when informix-server down ?
Andreas Lommel wrote: > > Hi,- I think it`s better when I bring the informix db-server from time > to time down and start the server new. My question: Can I see when > it`s the right time (memory, ..) PLATFORM and VERSION info? There should be no need to bounce the engine perio…
RE: Assert Failed: Unexpected virtual processor termination
> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtu…
Assert Failed: Unexpected virtual processor termination
Hi gurus, IUS Version 9.14.UC6 O/S = HP-UX 10.2 Way back in August before I stumbled across this list IUS crashed and the online.log showed: "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" closely followed by: "Assert Failed: Unexpected virtual processor termin…
RE: Loading into Shared Memory...
Try SET TABLE table-name MEMORY_RESIDENT Needs to be done by user informix, so best to put it into some startup script for the Informix server, unless you only want it on occassion. HTH Vasudev > -----Original Message----- > From: Marshall Turner [SMTP:t-tech@home.com] > Sent:…
Loading into Shared Memory...
No, you don't have explicit control over what is in the shared memory buffers. Informix manages the buffers based on a 'least recently used' (LRU) scheme that keeps in memory data it expects to be used again and flushes what is not. Marshall <anandpa@my-deja.com> wrote in mess…
Informix Server & the Blue Screen of Death
David Henry <henryd@net-gong.com> wrote in message news:7ld2ud$hvn$1@news2.inter.net.il... > I am running (or trying to) version 7.3 on a 2 CPU Intel box with NT4 > service pack 4. > The machine crashes at random times and in random places, even if there is > no database activity…
Memory Usage on Informix 7.24
LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…
Re: Informix and multiple instances
> >The OS is HP-UX 11, 64 bit > >The DB is Informix 7.30 FC 6-1 I'd recommend an upgrade to at least 7.30.FC7 or 7.31...there's a nasty shared memory bug that could cause you immense headaches, especially if the system is managing shared memory segments for multiple instances...…
Informix 7.3 on NT Slow when replication across WAN
Hi, I have recently setup a Informix Replication server from Informix 7.3 running on Solaris 2.6 to a new Single PII 450 processor box running NT SP3 (256 MB Mem). When replication starts the processor sits at 100% for up to 20 mins Even though There were only 3 entries in the t…
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…
Datablade memory management ?'s
We're using the dmi library and I was needing some info on memory management. For exampe, when using mi_next_row do I need to nuke the MI_ROW * that is returned? If so do I use mi_row_free (MI_ROW * row)? Any help would be appreciated. Thanks, Tim…
Recommended value for SHMMAX
Can anyone recommend a good value for SHMMAX based on the following: We're on HPUX 10.2 with Informix 7.30 with 784MB memory. The current value of SHMMAX on our platform is 67MB. After I bring Informix up, an ipcs -m shows that there's 3 segments for resident memory for a total…
Informix ODBC on Caldera Open Linux
I am attempting to implement a development system on Linux with with the free SE download from Intraware. Using the Intersolv 3 ODBC drivers. I'm getting the errno# -25567 with says: "Internal communications buffer management error detected. Memory corruption or incorrect use o…
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…
Re: Memory Leak
In article <78a8dj$1h7$1@nnrp1.dejanews.com>, joel_anderson@prosolution.com writes >We just installed our first customer with Informix 7.30 TC5 on an NT server. >With only a few users on the system for a few hours, the memory usage on the >Informix server goes from a few meg to o…
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: IDS & Workgroup Edition
John H. Frantz wrote in message <366D3928.E7586C67@rl.is>... >I'm finding it hard to determine what the essential differences in >functionality are between plain IDS and the Workgroup Edition. I've >gathered the following information from various sources, but I'm not >sure if it'…
Re: POWER MANAGEMENT FAILS AFTER IFMX INSTALL
David Williams wrote: > > In article <364F133C.67A6B386@deistersoft.com>, V.Salvador <nospam_vsalv > ador@deistersoft.com> writes > >On Solaris 2.6, power management daemon (powerd) fails with shmget > >error, after modifying the /etc/system file as the informix release > >notes …
Re: about virtual processors
> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …
Re: about virtual processors
Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …
Re: about virtual processors
Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…
Re: about virtual processors
Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…
Re: about virtual processors
For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…
about virtual processors
hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…
Total memory & used memory in onstat -g ses
The onstat -g ses commands displays total memory and used memory by session. Does anyone know how I can reproduce this display using sysmaster tables? I am trying to determine which host(s) are initiating sessions using larger amounts of memory. This onstat command shows only …
Re: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
Re: Need help with informix memory management
Matthias Kuespert wrote: > > Hi, > > we encountered a strange problem using Informix on Sun Solaris 2.5.1: > > If we connect to the DB (via E-SQL-C CONNECT statement) we cannot > allocate more than appr. 7 MB with our application. After that > size malloc() returns a NULL pointer…
Need help with informix memory management
Hi, we encountered a strange problem using Informix on Sun Solaris 2.5.1: If we connect to the DB (via E-SQL-C CONNECT statement) we cannot allocate more than appr. 7 MB with our application. After that size malloc() returns a NULL pointer and errno says: not enough space. If …
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Running Informix and Oracle on the same Unix box
Last time we tried to that we ran into tough waters and had to abort. The two engines need different kernel parameters, and they also have memory conflicts. Most importantly, find out if you'll be able to tech support from either one of them in this kind of a situation :-) (more…
Running Informix and Oracle on the same Unix box
Folks -- For various and sundry reasons, we're going to try to run both an Informix instance and an Oracle instance on the same AIX 4.3 box. We'll be running Informix 7.3, and Oracle 7.2.2.3. Are there any gotchas that we should know about? My guess is that the biggest pro…
Re: Virtual Processors
I had the same problem. It happens with big queries and you cant stop it really. The VP usually uses what it needs. The best option is to turn NOAGE off, so that the processes age and allow the OS some use of the CPU. Rgds, Jason On Mon, 08 Jun 1998 11:46:55 GMT, darren@syste…
RE: Virtual Processors
Darren, You might check your NOAGE and AFF_SPROC / AFF_NPROCS settings, and then see what your release notes say about those parameters. If this is just occurring when you run specific programs, what is the PDQ_PRIORITY that you are using when you run them? HTH. Paul Mosser O…
Connect to Informix 7.2
Hello! I'm attempting to connect to an Informix 7.2 backend. I loaded the INET stuff but my profile generates a -25567 error which translates to: -Internal communications buffer management error detected. -Memory corruption or incorrect use of buffer-management routines usually…
Re: Virtual Processors
You need to send us some more info. Is this a SMP box? How many CPU's? What applications are causing the problem? CPU bound Informix engine is not necessarily a bad thing, but if the entire system is slowing down then you need to tune a few things. What to tune depends on wha…
Re: Virtual Processors
darren@systeam.co.uk wrote: : I have a problem with a customer's site with a CPU virtual processor which : seems to be running out of control. It occours when I run one or two : programs, the CPU VP is taking about 90% of the system CPU time, and therefore : bring the system to a…
Virtual Processors
I have a problem with a customer's site with a CPU virtual processor which seems to be running out of control. It occours when I run one or two programs, the CPU VP is taking about 90% of the system CPU time, and therefore bring the system to a general go slow. The Informix engi…
Re: AIO virtual processor
Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …
AIO virtual processor
Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …
Re: Goodbye to compiling and linking. Every Database guy must know this!
What color do you want your database to be? ;) Ping Liu wrote: > Are there any degugging tools available for perl? > > gold_bag@yahoo.com wrote in article <352BCE60.53BF@yahoo.com>... > > I hope this helps the software professionals/managers like you.... > > > > Computer speed…
Re: Goodbye to compiling and linking. Every Database guy must know this!
Are there any degugging tools available for perl? gold_bag@yahoo.com wrote in article <352BCE60.53BF@yahoo.com>... > I hope this helps the software professionals/managers like you.... > > Computer speeds are doubling every 4 months, hence it makes sense to > program in scripting…
Re: "Changing Data structure...."
On 9 Apr 98 at 16:58, Steve Romankiw wrote: > When doing an onstat, we often see "Changing data structure forced...". > What causes this message to display? Is shared memory changing? It's probably something like a new chunk of Virtual Memory being added. HTH. -- Ciao, Bil…
Re: slow performance
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <yuten3wab3j.fsf@mew.corp.sgi.com>, Pablo Sanchez <pablo@sgi.com> writes >>>>>> "David" == David Williams <djw@smooth1.demon.co.uk> writes: >David> >David> The latency would be different? > >Sure, the respective lock managers need to deal with >different issues due t…
Informix CLI & NT
Hi, I'm running NT4, IIS3, service pack 3 & Informix CLI 2.5. Service pack 3 upgrades the ODBC manager to v3 but when you Install Informix CLI 2.5 it then downgrades it to a lesser version which in turn breaks all the ASP & ODBC capabilities on the web server. If I re-install …
RE: NewEra 3 Memory leak?
We had the same problem. Fortunately, we have a connection manager class that we can call to connect and disconnect from the database. By doing this, we release the connection and the memory. We tried disconnecting after 3 transactions and found that the average amount of memo…
Re: gfd virtual processor class...
June - sounds reasonable, thanks. I'll have to count tomorrow & see if they jive. Greg (from my alter ego at home...) June Tong wrote: > > : I was looking through the output of "onstat -g ioq", and it occurs to me > : I don't have a clue what VP type "gfd" is (see snippet belo…
Re: Cannot fork a virtual processor
Mark D. Stock wrote: > > Enigma wrote: > > > > Hi, > > My informix ODS went down when I tried to put it to online. I'm > > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > > online.log is > > Cannot fork a virtual processor errno=12. > > This hap…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Cannot fork a virtual processor
Hi, My informix ODS went down when I tried to put it to online. I'm running a informix 7.14 on a IBM AIX 4.2 machine. The error in the online.log is Cannot fork a virtual processor errno=12. This happens only intermittently. It seems to indicate there is insuffici…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
gfd virtual processor class...
I was looking through the output of "onstat -g ioq", and it occurs to me I don't have a clue what VP type "gfd" is (see snippet below). Can anybody clue me in?? plsaphp1:informix 1> onstat -g ioq INFORMIX-OnLine Version 7.21.UD3 -- On-Line -- Up 26 days 06:59:37 -- 175552 K…
Re: Informix crashing UNIX on HP
On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" <mdstock@informix.com> wrote: >Silvester_Valiente@tnt.com.au wrote: >> >> Has anyone had an experience where Informix 7.23 UC4 caused Unix to >> Panic and shutdown. >> >> We are experiencing the problem when the virtual portion…
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 …
RE: Error with ODBC drivers
Alberto, Believe it or not, simply go to SETNET and redefine everything, it should fix your problem assuming you have configured your communication properly ( the type of connections, server name user and password correctly ) . Regards, Mario Estrada =============Reply Separa…
Error with ODBC drivers
Hi, trying to connect with ODBC drivers to a SE on Windows 95 I get the following error message: -25567 Internal communications buffer management error detected. This error is usually caused by memory corruption or wrong use of buffer management routines. Make sure there is no…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
Re: HELP !!!!!
In reply to Igor Andjelkovic's email about HELP !!!!!, on 1 May 97 Hi Igor, > I have a two error messages before my 4GL starts up > Actually , it is only one. > tbmode: forced-resident shared memory error > tbmode: shmctl: errno = 1. > > Please if anybody can help me out, k…
Re: Informix 5 Performance Issues
Remember - YMMV, etc: On 16 Apr 97 at 17:04, Phantom173 wrote: > We have been told by a consultant that a move to Informix 7 would > benefit us because (a) Informix 7 would reduce the number of connects > (and therefore processes) associated with the elephants, and (b) it > wou…
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
Paul Leskinen wrote: > > I was hoping that someone out there has encountered this problem: > > We have an online transaction-processing application that stays resident > and processes financial transactions using Informix. The problem is that > Informix Online keeps allocating m…
Re: MULTIPROCESSOR OPTION 7.13
In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…
Re: MULTIPROCESSOR OPTION 7.13
Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…
MULTIPROCESSOR OPTION 7.13
The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…
Re: Query Retrieval
Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…
Query Retrieval
Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…
lastest compare against oracle
can anyone provide some new information on the rdbms wars between informix and oracle. I know oracle blasts informix for the poor performance, transaction logging, record locking mechanisms and informix touts the performance gains on the methodology for using threads instead of p…
HP K200 and Online 7
We are experiencing SEVERE performance problems trying to upgrade from Online 5 to Online 7. Online 7 runs about 400 percent slower than Online 5 up until +- 400 processes. (Confirmed by Informix S.A). Online 7 performance never degraded even when the load went above 400 process…
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…
Re: unexpected virtual processor termination
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…
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: Blobs n ESQL/C for Windows
In article <4l6oi7$c20@news2.delphi.com> TYNEELY@news.delphi.com (TYNEELY@DELPHI.COM) writes: >cse@wetware.com (Scott Ellard) writes: > >>In article <4l2l2j$s5m@news2.delphi.com> TYNEELY@news.delphi.com (TYNEELY@DELPHI.COM) writes: >>>I have a WFW 3.11 app that read/writes BLOBS …
Re: unexpected virtual processor termination
Sounds like someone issued a Kill -9, while it was holding locks? Anyway I suggest you turn on your montoring program/script (if you do not have one, I got one to watch engine and another one to watch user's) and see what processes are actually occuring at that time. If you want …
unexpected virtual processor termination
We use Online 7.11 on IBM RS6000 AIX 4.xx (32 MB RAM) for development tasks. Often, while 4GL program is being compiled, Online shuts down. In online.log file one writes: "unexpected virtual processor termination, attempting to bring system down". This virtual processor is msc. …
Re: realloc equivalent in C++
se4pm@dmu.ac.uk (Piers Myers) wrote: >In article <311BDA8A.1462@ctp.com>, Ian Flint (iflin@ctp.com) writes: >> Honbo Zhou wrote: >> > >> > Is there anything in C++ equvalent to realloc in C which can be used >> > to increase allocated memory? Can't find this even in C++ books wh…
Re: realloc equivalent in C++
In article <4fgir1$pri@theory.tc.cornell.edu>, Honbo Zhou <hzhou@r26n05.tc.cornell.edu> wrote: >Is there anything in C++ equvalent to realloc in C which can be used >to increase allocated memory? Can't find this even in C++ books which >talk about memory management specifically. …
Re: realloc equivalent in C++
In article <311BDA8A.1462@ctp.com>, Ian Flint (iflin@ctp.com) writes: > Honbo Zhou wrote: > > > > Is there anything in C++ equvalent to realloc in C which can be used > > to increase allocated memory? Can't find this even in C++ books which > > talk about memory management specif…
Re: realloc equivalent in C++
In article <4fgir1$pri@theory.tc.cornell.edu> hzhou@r26n05.tc.cornell.edu (Honbo Zhou) writes: Is there anything in C++ equvalent to realloc in C which can be used to increase allocated memory? Can't find this even in C++ books which talk about memory management specifi…
Re: realloc equivalent in C++
hzhou@r26n05.tc.cornell.edu (Honbo Zhou) wrote: >Is there anything in C++ equvalent to realloc in C which can be used >to increase allocated memory? Can't find this even in C++ books which >talk about memory management specifically. Thanks. Honbo If you "malloc" in C++, you can …
Re: realloc equivalent in C++
Honbo Zhou wrote: > > Is there anything in C++ equvalent to realloc in C which can be used > to increase allocated memory? Can't find this even in C++ books which > talk about memory management specifically. Thanks. Honbo Yes. realloc. - Ian Flint…
realloc equivalent in C++
Is there anything in C++ equvalent to realloc in C which can be used to increase allocated memory? Can't find this even in C++ books which talk about memory management specifically. Thanks. Honbo…
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
Re: processes sspawned by 7.1
>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…
Re: processes sspawned by 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …
Re: Informix dual processor scalability
In article <DJ6CHK.5zx@dsbc.icl.co.uk> smb@oasis.icl.co.uk "Stuart Britt" writes: > Using Informix on 1 processor we achieve good performance. If we switch to > 2 processors, then our performance actually degrades. We have been given > some advice on tuning the system for dual…
Re: Informix dual processor scalability
According to my rusty memory, the reason for this is something about the overhead necessary to handle multiple processors only being overwhelmed by the performance increase after three processors. So you should tune as tho' you only have a single processor... :-( HTH. }Does any…
Re: Informix dual processor scalability
Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processor…
Re: Informix dual processor scalability
: smb@oasis.icl.co.uk (Stuart Britt) writes: : Does anyone have any info on the following problem? We are using Informix : version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP : machines. : : Using Informix on 1 processor we achieve good performance. If we…
Informix dual processor scalability
Does anyone have any info on the following problem? We are using Informix version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP machines. Using Informix on 1 processor we achieve good performance. If we switch to 2 processors, then our performance actually degra…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
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…
filemakerpro & images??? If not what???
How well does filemaker pro handle records that include a image? I know that each file is limited to 32 megs. Since scans tend to hog memory it seems to me that this memory constraint would be a problem. I work for a company that has a library of about 5000 images that we would l…
7.1 - Unable to free unused shared memory
If anyone has struck and/or resolved the following problem then any advice that could be offered would be appreciated. Environment: Sparc1000 running 7.1 DSA. 512 Meg Ram. Not a dedicated Informix Server. Problem1: When physical ram (as opposed to swap) gets down to near zer…
Online/Optical
Hello, I'm running into some problems while configuring Online/Optical Version 5.0. It is running in conjunction with Plexus Storage Manager and a SONY jukebox. When I attempt to load a TEXT column into the optical storage I always get the following: 600: Cannot create blob.…
I-NET problem
I have some connecting questions for use of INFORMIX-NET and Powerviewer using TCP/IP. Will FTP's OnNet 1.1 PC/TCP work with INET-PC? If not, are there any '100% dll' or VxD TCP/IP packages supported for connection to INFORMIX on UNIX? -my concern here is memory management ...u…
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: Optimem Error
paulw@dev.jcdc.eta.gov wrote: : According to the people we talked to at Informix, the invalid memory : pointer error is a known bug. We get it after we execute a PIF file to : run some DOS commands we need. Do you have details of the bug?? Such as bug number, patch/fix, and a …
Optimem Error
One of my friend recently ran into the following error while using 4GL/Win. The message he got was: Invalid memory pool passed to Optimem Library After pressing the OK button a few times, Windows hung, and the application have to be exit(ed) abnormally. He has also encountere…
On-line engine startup failure
Is the machine a sparc running sunos 4.1.2? If so, then you need to force shared memory to be resident. Took me ages to work that one out :-) ----------------------------------------------------------------------------- Steve Lacey, IS Engineering Manager, The Bishop's Manor,…
Informix 5.0.1 for IBM RS6000
Does anyone know if this available? If not when will it be available? Rick Hamel…
Re: How to setup Datalink under Windows
In <MTan.43@uci.edu> MTan@uci.edu (Mary Tan) writes: > Anyone out there using Datalink 1.1, I-NET driver version 1.01 and >Windows? > Have you got thrown out to the c:\\> after selecting LOG ON in the It took me quite a while to get the DOS Wingz working after finding t…
Macintosh memory management
The external functions that I'm loading require more memory than is available from the stack ( usaully limited to about 2-4 K, with an absolute max of 16k). I'm using MPW C on a Mac IIci with 16M, Wingz ver 1.1, Finder 6.0.5, Multi Finder 6.1b9 There is no relevant documemtaion…