Re: ids 11.70.TC1IE limits

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 machine running Windows 2000 until the the mobo died. They could not find a replacement mobo or a system that would boot the win2k disk. They bought this new server but we could not get ids9.4 to be happy on it so we installed the new IDS 11.7 . I don’t think they will want to give IBM any money for a “paid-for” edition since this one is so unstable. Does anyone think the instability is something other than a “feature” that IBM placed there to encourage purchase of a different version? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list