Oninit® Archive
Results for “VP_MEMORY_CACHE_KB”
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 …
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…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
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…
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…
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 --…
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…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
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…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
identify what is allocating memory
Jacques has beaten me to it but the most likely candidate is the CPU VP cache (VP_MEMORY_CACHE_KB) not draining quickly enough, which presumably you're running in DYNAMIC mode. "onstat -g vpcache" needs to be used to see the memory usage and it is hard to decipher without the aid…
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…
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=…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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…
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…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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,…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
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…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Monitoring VP_MEMORY_CACHE_KB effectiveness
Hi folks! Does anybody knows where can I find an official document (or an IIUG presentation) that shows how to set and monitor "onstat -g vpcache" effectiveness?? Thanks in advance, Alberto.…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
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.…
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 …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
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…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
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…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
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…
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…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
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…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
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…
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…
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…
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 …
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
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…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: 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…
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…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
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…
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…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
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 (…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
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
On Apr 8, 11:41 am, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > 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…
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…
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…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
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…
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…
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…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: 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…
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…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
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…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
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…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
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: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: 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: 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…
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…
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: 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…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: 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…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
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…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
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…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
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…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
RE: 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…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
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…
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…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
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: …
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
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 /…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
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 …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
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 '…
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 …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
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…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
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 …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: 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…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
RE: 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…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
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…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
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…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
RE: 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…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
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…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
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...…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
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…
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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
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…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
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 on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: 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'…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: 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: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
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' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
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: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
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…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: 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…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
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: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
Re: 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 …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: 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 …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
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…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: 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] > …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
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…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
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…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: 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…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
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…
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 …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
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…
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,…
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…