Problems running IDS 11.70 on Windows Server 2012

Our company is planning to move our Informix 11.70 from the Windows 2008 server it is currently on to Windows server 2012 R2. What problems have you encountered running Informix 11.70 on Windows 2012?

I'm going to recommend that you run your Informix on Linux. Performance will be better and the database will be more stable. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, May 12, 2017 at 4:37 PM, MARY GREEN <mgreen@flyravn.com> wrote: > Our company is planning to move our Informix 11.70 from the Windows 2008 > server it is currently on to Windows server 2012 R2. What problems have you > encountered running Informix 11.70 on Windows 2012? > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

I'd agree with Art, But I don't think that we certified any version of 11.70 on windows server 2012. Gerry On 5/12/17, 3:50 PM, "ids-bounces@iiug.org on behalf of Art Kagel" <ids-bounces@iiug.org on behalf of art.kagel@gmail.com> wrote: I'm going to recommend that you run your Informix on Linux. Performance will be better and the database will be more stable. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, May 12, 2017 at 4:37 PM, MARY GREEN <mgreen@flyravn.com> wrote: > Our company is planning to move our Informix 11.70 from the Windows 2008 > server it is currently on to Windows server 2012 R2. What problems have you > encountered running Informix 11.70 on Windows 2012? > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ::DISCLAIMER:: -------------------------------------------------------------------------------- -------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects. -------------------------------------------------------------------------------- --------------------------------------------------------------------

Dear Mary: My company runs IDS exclusively on Windows servers, as that is what our customers need to run, we have very few issues with performance or stability. We have multiple installations of IDS 11.70.x on both Windows 2008 and Windows 2012 R2 (with an occasional Windows 2012 (non R2)). I suggest if possible that you use the latest build of IDS 11.70.x or at least download the latest FixPacks and iFixPacks. I do recall that with earlier builds having to run the IDS install package in Windows 7 compatibility mode however I do not believe that to be the case with newer builds. Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The information contained herein is intended for the addressee or recipient only. If you are not the addressee, or not the intended recipient, any disclosure, copying, distribution, or use of the contents of this message (including any attachments) is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. (Queues Enforth Development, Inc.) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, May 12, 2017 4:51 PM To: ids@iiug.org Subject: Re: Problems running IDS 11.70 on Windows Serv.... [39171] I'm going to recommend that you run your Informix on Linux. Performance will be better and the database will be more stable. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, May 12, 2017 at 4:37 PM, MARY GREEN <mgreen@flyravn.com> wrote: > Our company is planning to move our Informix 11.70 from the Windows > 2008 server it is currently on to Windows server 2012 R2. What > problems have you encountered running Informix 11.70 on Windows 2012? > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************************** ***** Forum Note: Use "Reply" to post a response in the discussion forum.

Yeah, about that. My company sells a product which currently uses Informix IDS 12.1 (started with 10) on Windows. We have several thousand customers using the product. Every time I try to get something that works seamlessly on ****ix to work properly under Windows, I have some problem or other: - Performance is not as good. I did a test where we replaced the Windows based Informix DB with the same DB on CentOS on the same hardware. Throughput increased 400% - Windows does not do a good job with SMP, doesn't seem to understand it. Does not spread the load over CPUs, just hands any new task to the next CPU according to the clock as opposed to the load. - External tables and loading are not doing well (current problem). In migration situations we have to go back to dbload. - Memory is artificially constrained. Also, you have to be careful not to allow third party products to load into memory where Informix wants to be. - Lots of customers don't like having the Informix account, oh guess you can't use the sysadmin database then - or rather you have to go around your elbow to scratch your posterior. - Third party backup software - I've had more disk corruption caused by these than I've ever seen under any ***ix I could go on at greater length. Windows was a poor choice. j. On 5/12/17 5:13 PM, Martin Graney wrote: > Dear Mary: > > My company runs IDS exclusively on Windows servers, as that is what our > customers need to run, we have very few issues with performance or > stability. We have multiple installations of IDS 11.70.x on both Windows > 2008 and Windows 2012 R2 (with an occasional Windows 2012 (non R2)). I > suggest if possible that you use the latest build of IDS 11.70.x or at > least download the latest FixPacks and iFixPacks. I do recall that with > earlier builds having to run the IDS install package in Windows 7 > compatibility mode however I do not believe that to be the case with newer > builds. > > Best regards, > Martin M. Graney > Queues Enforth Development, Inc. > > This electronic message contains information which may be privileged, > confidential, or otherwise protected from disclosure. The information > contained herein is intended for the addressee or recipient only. If you > are not the addressee, or not the intended recipient, any disclosure, > copying, distribution, or use of the contents of this message (including > any attachments) is prohibited. If you have received this electronic > message in error, please notify the sender immediately and destroy the > original message and all copies. (Queues Enforth Development, Inc.) > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Friday, May 12, 2017 4:51 PM > To: ids@iiug.org > Subject: Re: Problems running IDS 11.70 on Windows Serv.... [39171] > > I'm going to recommend that you run your Informix on Linux. Performance > will be better and the database will be more stable. > > Art > > Art S. Kagel, President and Principal Consultant ASK Database Management > www.askdbmgt.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 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, May 12, 2017 at 4:37 PM, MARY GREEN <mgreen@flyravn.com> wrote: > >> Our company is planning to move our Informix 11.70 from the Windows >> 2008 server it is currently on to Windows server 2012 R2. What >> problems have you encountered running Informix 11.70 on Windows 2012? >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > ************************************************************************** > ***** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Dont hold back, Jack. > On 13 May 2017, at 15:43, Jack Parker <jack.parker4@verizon.net> wrote: > > Yeah, about that. My company sells a product which currently uses > Informix IDS 12.1 (started with 10) on Windows. We have several > thousand customers using the product. Every time I try to get something > that works seamlessly on ****ix to work properly under Windows, I have > some problem or other: > > - Performance is not as good. I did a test where we replaced the > Windows based Informix DB with the same DB on CentOS on the same > hardware. Throughput increased 400% > > - Windows does not do a good job with SMP, doesn't seem to understand > it. Does not spread the load over CPUs, just hands any new task to the > next CPU according to the clock as opposed to the load. > > - External tables and loading are not doing well (current problem). In > migration situations we have to go back to dbload. > > - Memory is artificially constrained. Also, you have to be careful not > to allow third party products to load into memory where Informix wants > to be. > > - Lots of customers don't like having the Informix account, oh guess you > can't use the sysadmin database then - or rather you have to go around > your elbow to scratch your posterior. > > - Third party backup software - I've had more disk corruption caused by > these than I've ever seen under any ***ix > > I could go on at greater length. Windows was a poor choice. > > j. > > On 5/12/17 5:13 PM, Martin Graney wrote: >> Dear Mary: >> >> My company runs IDS exclusively on Windows servers, as that is what our >> customers need to run, we have very few issues with performance or >> stability. We have multiple installations of IDS 11.70.x on both Windows >> 2008 and Windows 2012 R2 (with an occasional Windows 2012 (non R2)). I >> suggest if possible that you use the latest build of IDS 11.70.x or at >> least download the latest FixPacks and iFixPacks. I do recall that with >> earlier builds having to run the IDS install package in Windows 7 >> compatibility mode however I do not believe that to be the case with newer >> builds. >> >> Best regards, >> Martin M. Graney >> Queues Enforth Development, Inc. >> >> This electronic message contains information which may be privileged, >> confidential, or otherwise protected from disclosure. The information >> contained herein is intended for the addressee or recipient only. If you >> are not the addressee, or not the intended recipient, any disclosure, >> copying, distribution, or use of the contents of this message (including >> any attachments) is prohibited. If you have received this electronic >> message in error, please notify the sender immediately and destroy the >> original message and all copies. (Queues Enforth Development, Inc.) >> >> -----Original Message----- >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art >> Kagel >> Sent: Friday, May 12, 2017 4:51 PM >> To: ids@iiug.org >> Subject: Re: Problems running IDS 11.70 on Windows Serv.... [39171] >> >> I'm going to recommend that you run your Informix on Linux. Performance >> will be better and the database will be more stable. >> >> Art >> >> Art S. Kagel, President and Principal Consultant ASK Database Management >> www.askdbmgt.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 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, May 12, 2017 at 4:37 PM, MARY GREEN <mgreen@flyravn.com> wrote: >> >>> Our company is planning to move our Informix 11.70 from the Windows >>> 2008 server it is currently on to Windows server 2012 R2. What >>> problems have you encountered running Informix 11.70 on Windows 2012? >>> >>> >>> ************************************************************ >>> ******************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> ************************************************************************** >> ***** >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >