Re: ids 11.70.TC1IE limits

Just call where? I have been on their crappy website for an hour and cannot find out whom to call. The chat would be ok, but appears broken. From: Art Kagel Sent: Sunday, July 17, 2011 8:55 AM To: Bill Hamilton Cc: iiug Subject: Re: ids 11.70.TC1IE limits 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* versi