Informix upgrade
A user asked whether an Informix 11.70 instance can be upgraded directly to 12.10 Workgroup Edition, including a move from Enterprise to Workgroup Edition. Art Kagel confirmed both are possible. Others warned the real issue is licensing/feature limits: Workgroup caps memory at 16GB, 16 cores/4 sockets, and excludes PDQ, table/index fragmentation, distributed queries, HPL, online schema changes, more than two secondary nodes, etc. (ER/grid is included). So the upgrade works provided you don't rely on Enterprise-only features and resize memory/CPU config accordingly.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?
Yes. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Mon, Feb 17, 2014 at 9:30 PM, CHANATIP LAONGSIRIWONG < chanatip.laongsiriwong@gmail.com> wrote: > Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup > edition directly? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113801a02db70804f2a52491
Meanwhile from enterprise edition to workgroup edition?
Not an issue. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Mon, Feb 17, 2014 at 10:37 PM, CHANATIP LAONGSIRIWONG < chanatip.laongsiriwong@gmail.com> wrote: > Meanwhile from enterprise edition to workgroup edition? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c2489693eb7004f2a6209b
Art Kagel, Thank you very much.
Hello. As Art said, it must not be an issue. The only thing you may take care of would be your SHM configs, since workgroup version allows only 16GB of server memory allocation. In case you are using more than that in enterprise 11.70, you might redimension your memory configurations, to fit the 16GB limit. Other limits, as cpuvps, I think should give you a warning, and may be reduced in engine start time, as cpuvps 16 count. Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: chanatip.laongsiriwong@gmail.com > Subject: Re: Informix upgrade [32514] > Date: Mon, 17 Feb 2014 23:08:30 -0500 > > Art Kagel, Thank you very much. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Only if the Workgroup license doesn't cover something from Enterprise that you actually use. Enterprise replication would be an example. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > CHANATIP LAONGSIRIWONG > Sent: Monday, February 17, 2014 9:37 PM > To: ids@iiug.org > Subject: Re: Informix upgrade [32512] > > Meanwhile from enterprise edition to workgroup edition? > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.
Hello. ER is fully included in WE versions. IBM Informix Workgroup Edition Available on all supported platforms, this edition is perfect for midsize companies or departmental servers in an enterprise deployment. This edition can be deployed on up to 16 cores over a maximum of four sockets and 16 GB of RAM operating from the same Informix Install. Informix Workgroup Edition can be licensed by Authorized User Single Install, PVU, and LU Socket metrics. LU Socket enables licensing by physical processor socket. LU Socket licensing is limited to physical servers with no more than four physical processor sockets. Customers may purchase licenses for up to four physical sockets and use up to 16 processor cores. Customers are not allowed to create a physical or logical partition of up to four processor sockets on a larger server and purchase a LU socket license. Informix Workgroup Edition provides additional database functionality, including unlimited ER/grid cluster nodes of any type to send or receive data updates within the cluster. From a licensing perspective, since ER/grid nodes are stand-alone, each one must be fully licensed. Informix Workgroup Edition supports up to two H/A cluster secondary nodes of any type. As long as the secondary node is only functioning as a backup/failover secondary, it can be deployed without an additional Informix license charge. However, if any H/A cluster secondary node is used for SQL operations (read or write), the secondary node must be fully licensed. From the official link: http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/index.html Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: Everett.Mills@nationalbeef.com > Subject: RE: Informix upgrade [32523] > Date: Tue, 18 Feb 2014 08:42:19 -0500 > > Only if the Workgroup license doesn't cover something from Enterprise that you > actually use. Enterprise replication would be an example. > > --EEM > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > CHANATIP LAONGSIRIWONG > > Sent: Monday, February 17, 2014 9:37 PM > > To: ids@iiug.org > > Subject: Re: Informix upgrade [32512] > > > > Meanwhile from enterprise edition to workgroup edition? > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
- Workgroup Edition (WE) does support Enterprise Replication with no restrictions. However, Everett's basic point stands. If you are not now using features that WE does not support, or can do without them without hurting performance or breaking your applications, then WE is a viable option. If you are using, and must continue to use features not supported by WE, then you have to stay with Enterprise Edition. The features not permitted in WE are: - PDQ (Parallel Data Query) - Table and index fragmentation - More than 2 secondary nodes (ie HDR, RSS, & SDS combined) - Distributed queries between separate instances - OnBar backup/restore dbspace prioritization - Private memory cache for CPU VPs - Online table schema changes - High performance loader - More than 16GB memory used by the server - More than 4 CPU Sockets - More than 16 physical CPU Cores on the server's machine or available to the server's VM environment Art Art S. Kagel, Principal Consultant ASK Database Management 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 Tue, Feb 18, 2014 at 8:42 AM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > Only if the Workgroup license doesn't cover something from Enterprise that > you > actually use. Enterprise replication would be an example. > > --EEM > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > CHANATIP LAONGSIRIWONG > > Sent: Monday, February 17, 2014 9:37 PM > > To: ids@iiug.org > > Subject: Re: Informix upgrade [32512] > > > > Meanwhile from enterprise edition to workgroup edition? > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134cbfcf7cae304f2aefa04
>> Only if the Workgroup license doesn't cover something from Enterprise that you actually use. Enterprise replication would be an example. Everett is wholly correct, but a better example might have been the use of table fragmentation, permitted in Enterprise, not available in Workgroup.