Re: ids 11.70.TC1IE limits

An uninstall is not required. It should just upgrade. I haven't worked the 32 bit version, but have played around with the 64bit over the past several weeks. j. On Jul 17, 2011, at 9:55 AM, Art Kagel wrote: > I don't know. I've only installed Informix on Windows myself once on my laptop. However, installation support is provided by IBM even for Innovator Edition without paid support, so call in. > > 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 organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. > > > > On Sat, Jul 16, 2011 at 9:08 PM, Bill Hamilton <garage_dba@hotmail.com> wrote: > Thanks a lot , Art. > I downloaded 11.70.TC3IE as you suggested but it failed to install, saying that I cancelled it, but I did not. I think it expects me to uninstall TC1 first, but it does not say that. > Do you think that an uninstall is required? > > Install Log Detail: > > Refresh Windows Environment: > Status: SUCCESSFUL > > Get Registry Entry: Key: HKEY_CURRENT_USER\\Software\\Informix\\Environment > Value Name: INFORMIXDIR > Status: SUCCESSFUL > > Install Action: InstallAnywhere Variable > Status: SUCCESSFUL > > Install Action: InstallAnywhere Variable > Status: SUCCESSFUL > > INSTALLATION WAS CANCELLED BY USER DURING PRE-INSTALLATION > > ( I did not cancel anything. ) > > From: Art Kagel > Sent: Friday, July 15, 2011 7:02 PM > To: Bill Hamilton > Cc: iiug > Subject: Re: ids 11.70.TC1IE limits > > If you have paid for support on your IE server, call IBM and see if this is a known issue. If not, you might try installing 11.70.TC3IE or even 11.70.FC3 (64bit) for windows. 11.70.xC3 fixes some problems in .xC1 & .xC2. > > 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 organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. > > > > On Fri, Jul 15, 2011 at 6:13 PM, Bill Hamilton <garage_dba@hotmail.com> wrote: > This question involves IBM Informix Dynamic Server Version 11.70.TC1IE running on Windows Server 2008 Enterprise, service pack 2. > This server uses a new Intel I5 processor with 4gb of ram. > > It seems that IDS freezes several times a day and no programs can get a connection. > Even dbaccess freezes if you try to use it. > > It was my understanding that Innovator-C Edition did not limit connections. > It does, however, limit memory to 2097152 KB . > > What happens when the memory is exceeded? > Does it start dropping connections or refusing them or both? > > I get stuff like this in the log: > 14:13:38 IBM Informix Dynamic Server Started. > 14:13:39 Warning: The IBM IDS Innovator-C Edition license restriction limits > 14:13:39 the total shared memory size for this server to 2097152 KB. > 14:13:39 The maximum allowable shared memory was reset to this size to start the database server. > 14:13:39 Requested shared memory segment size rounded from 32656KB to 32704KB > > 14:55:33 Descriptor 1128 has event 0x1, no longer open > 14:55:59 Dynamically allocated new virtual shared memory segment (size 8192KB) > 14:55:59 Memory sizes:resident:46272 KB, virtual:73664 KB, SHMTOTAL:2097152 KB > 14:56:47 Descriptor 1140 has event 0x1, no longer open > 14:58:16 Descriptor 1124 has event 0x1, no longer open > 14:58:17 Descriptor 1168 has event 0x1, no longer open > 14:58:19 Descriptor 1148 has event 0x1, no longer open > 14:58:20 Descriptor 1180 has event 0x1, no longer open > 14:58:23 Descriptor 1172 has event 0x1, no longer open > 14:58:23 Descriptor 1192 has event 0x1, no longer open > 14:58:23 Descriptor 1188 has event 0x1, no longer open > 14:58:23 Descriptor 1200 has event 0x1, no longer open > 14:58:23 Descriptor 1196 has event 0x1, no longer open > 14:58:24 Descriptor 1208 has event 0x1, no longer open > 14:58:26 Descriptor 1184 has event 0x1, no longer open > 14:58:27 Descriptor 1220 has event 0x1, no longer open > 14:59:39 Checkpoint Completed: duration was 0 seconds. > 14:59:39 Thu Jul 14 - loguniq 95, logpos 0x2c53018, timestamp: 0xb91ddfb Interval: 10290> > What is the “event 0x1” message all about? > > Here are some of the places that we had to restart IDS so far today: > > ** booted ** > 07:54:18 Memory sizes:resident:46272 KB, virtual:40896 KB, SHMTOTAL:2097152 KB > 08:11:16 Memory sizes:resident:46272 KB, virtual:49088 KB, SHMTOTAL:2097152 KB > 08:25:20 Memory sizes:resident:46272 KB, virtual:57280 KB, SHMTOTAL:2097152 KB > 08:33:13 Memory sizes:resident:46272 KB, virtual:65472 KB, SHMTOTAL:2097152 KB > 08:41:33 Memory sizes:resident:46272 KB, virtual:73664 KB, SHMTOTAL:2097152 KB > 08:52:48 Memory sizes:resident:46272 KB, virtual:81856 KB, SHMTOTAL:2097152 KB> > ** booted ** > 09:11:06 Memory sizes:resident:46272 KB, virtual:40896 KB, SHMTOTAL:2097152 KB > 09:14:58 Memory sizes:resident:46272 KB, virtual:49088 KB, SHMTOTAL:2097152 KB > 09:18:26 Memory sizes:resident:46272 KB, virtual:57280 KB, SHMTOTAL:2097152 KB > 09:26:47 Memory sizes:resident:46272 KB, virtual:65472 KB, SHMTOTAL:2097152 KB > 09:29:43 Memory sizes:resident:46272 KB, virtual:73664 KB, SHMTOTAL:2097152 KB > 09:45:34 Memory sizes:resident:46272 KB, virtual:81856 KB, SHMTOTAL:2097152 KB > 09:52:45 Memory sizes:resident:46272 KB, virtual:90048 KB, SHMTOTAL:2097152 KB > 10:01:01 Memory sizes:resident:46272 KB, virtual:98240 KB, SHMTOTAL:2097152 KB > 10:29:40 Memory sizes:resident:46272 KB, virtual:106432 KB, SHMTOTAL:2097152 KB > 10:47:54 Memory sizes:resident:46272 KB, virtual:114624 KB, SHMTOTAL:2097152 KB > 11:02:40 Memory sizes:resident:46272 KB, virtual:122816 KB, SHMTOTAL:2097152 KB> > ** booted ** > 11:41:10 Memory sizes:resident:46272 KB, virtual:40896 KB, SHMTOTAL:2097152 KB > 11:52:22 Memory sizes:resident:46272 KB, virtual:49088 KB, SHMTOTAL:2097152 KB > 12:01:16 Memory sizes:resident:46272 KB, virtual:57280 KB, SHMTOTAL:2097152 KB > 12:05:33 Memory sizes:resident:46272 KB, virtual:65472 KB, SHMTOTAL:2097152 KB > 12:16:51 Memory sizes:resident:46272 KB, virtual:73664 KB, SHMTOTAL:2097152 KB> > ** booted ** > 13:05:23 Memory sizes:resident:46272 KB, virtual:40896 KB, SHMTOTAL:2097152 KB> > As you can see, the SHMTOTAL stays the same (as we should expect since this is the *free* version). > Is this squeezing out connections? How can I find out? > > This client was running IDS9.4 on a dual Zeon mach