informix 11.70 growth edition features

Hi, i have installed informix 11.70 growth edition, is there any possibility to use the remote database query feature and fragment tables feature with this version. Thanks Pushpa

Hello. The previous Growth Edition is now called Workgroup Edition. According to the official doc: http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ You might see that parallel operations, partitioning, and distributed SQL operations are not allowed. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 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: pushpa@cybersoft.lk > Subject: informix 11.70 growth edition features [30695] > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > Hi, > > i have installed informix 11.70 growth edition, is there any possibility to > use the remote database query feature and fragment tables feature with this > version. > > Thanks > Pushpa > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, just to make sure: He is using 11.70 version GE. In 11.70 Release, distributed query was not restricted for growth edition. this is a new limitation that came with 12.x release. Does this modify the allowed features in a current 11.70 setup ? I don't think so. I would say this is only effective if you upgrade to 12.x, correct ? Same for the restrictions of Innovator Edition, which was limited in disk space in 12.x release. Any clues on the correct answer ? What is the policy of IBM for these questions, not for new customers but for people using 11.50/11.70 etc. ? Best regards, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Alexandre Marini" <alexandre@briug.org> An: ids@iiug.org Gesendet: Freitag, 28. Juni 2013 13:24:10 Betreff: RE: informix 11.70 growth edition features [30696] Hello. The previous Growth Edition is now called Workgroup Edition. According to the official doc: http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ You might see that parallel operations, partitioning, and distributed SQL operations are not allowed. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 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: pushpa@cybersoft.lk > Subject: informix 11.70 growth edition features [30695] > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > Hi, > > i have installed informix 11.70 growth edition, is there any possibility to > use the remote database query feature and fragment tables feature with this > version. > > Thanks > Pushpa > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Marcus, the limitation of distributed query was already prohibited in 11.70. Have a look in the license text: http://goo.gl/ymnGK Cheers Erik 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > Hi, > > just to make sure: He is using 11.70 version GE. > In 11.70 Release, distributed query was not restricted for growth edition. > this is a new > limitation that came with 12.x release. > Does this modify the allowed features in a current 11.70 setup ? I don't > think > so. > I would say this is only effective if you upgrade to 12.x, correct ? > Same for the restrictions of Innovator Edition, which was limited in disk > space > in 12.x release. > > Any clues on the correct answer ? What is the policy of IBM for these > questions, > not for new customers but for people using 11.50/11.70 etc. ? > > Best regards, > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Alexandre Marini" <alexandre@briug.org> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 13:24:10 > Betreff: RE: informix 11.70 growth edition features [30696] > > Hello. > The previous Growth Edition is now called Workgroup Edition. > According to the official doc: > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ > > You might see that parallel operations, partitioning, and distributed SQL > operations are not allowed. > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > 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: pushpa@cybersoft.lk > > Subject: informix 11.70 growth edition features [30695] > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > Hi, > > > > i have installed informix 11.70 growth edition, is there any possibility > to > > use the remote database query feature and fragment tables feature with > this > > version. > > > > Thanks > > Pushpa > > > > > > > > > ******************************************************************************* > > 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. > > --001a11c25daa61e99704e0372be6

No. Those features are not even optional/extra cost for Growth Edition (Workgroup Edition in 12.10 - same thing). Here's a link to the features comparisons for the versions: http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ That's the table for v12.10, but with a couple of changes to the limits on Innovator-C edition, 11.70 is the same. As I said, 11.70 Growth is the same as Workgroup in 12.10. 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, Jun 28, 2013 at 2:38 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hi, > > i have installed informix 11.70 growth edition, is there any possibility to > use the remote database query feature and fragment tables feature with this > version. > > Thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c356e26786f604e0375fab

Hi, there is stated: Distributed query (I-STAR) I am not talking about I-Star, but querying foreign trusted instances, which was in my understanding limited in 12.10. (select .... from database@instance:table where ...) There was a discussion some days ago in this group about this feature (which has been a very old feature, now switched off for the smaller licenses). Distributed SQL operation support The ability for a SQL session connected to a database in one instance to execute a DML operation using data from another database in a different instance. Included Not available Not available Not available Not available Included Included Included Regards, Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Erik Stahlhut" <erik.stahlhut@gmail.com> An: ids@iiug.org Gesendet: Freitag, 28. Juni 2013 15:51:16 Betreff: Re: informix 11.70 growth edition features [30698] Hi Marcus, the limitation of distributed query was already prohibited in 11.70. Have a look in the license text: http://goo.gl/ymnGK Cheers Erik 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > Hi, > > just to make sure: He is using 11.70 version GE. > In 11.70 Release, distributed query was not restricted for growth edition. > this is a new > limitation that came with 12.x release. > Does this modify the allowed features in a current 11.70 setup ? I don't > think > so. > I would say this is only effective if you upgrade to 12.x, correct ? > Same for the restrictions of Innovator Edition, which was limited in disk > space > in 12.x release. > > Any clues on the correct answer ? What is the policy of IBM for these > questions, > not for new customers but for people using 11.50/11.70 etc. ? > > Best regards, > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Alexandre Marini" <alexandre@briug.org> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 13:24:10 > Betreff: RE: informix 11.70 growth edition features [30696] > > Hello. > The previous Growth Edition is now called Workgroup Edition. > According to the official doc: > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ > > You might see that parallel operations, partitioning, and distributed SQL > operations are not allowed. > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > 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: pushpa@cybersoft.lk > > Subject: informix 11.70 growth edition features [30695] > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > Hi, > > > > i have installed informix 11.70 growth edition, is there any possibility > to > > use the remote database query feature and fragment tables feature with > this > > version. > > > > Thanks > > Pushpa > > > > > > > > > ******************************************************************************* > > 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. > > --001a11c25daa61e99704e0372be6 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

IStar is the internal name for remote access out of the server to another server. The name comes because that was the separately purchased module for remote access back in the Informix SE & Online 4 & 5 days before remote access was compiled into the server itself. 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, Jun 28, 2013 at 10:14 AM, Marcus Haarmann <marcus.haarmann@midoco.de > wrote: > Hi, > > there is stated: > Distributed query (I-STAR) > > I am not talking about I-Star, but querying foreign trusted instances, > which > was in my understanding > limited in 12.10. (select .... from database@instance:table where ...) > There was a discussion some days ago in this group about this feature > (which > has been > a very old feature, now switched off for the smaller licenses). > > Distributed SQL operation support > > The ability for a SQL session connected to a database in one instance to > execute a DML operation using data from another database in a different > instance. Included Not available Not available Not available Not available > Included Included Included > > Regards, > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Erik Stahlhut" <erik.stahlhut@gmail.com> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 15:51:16 > Betreff: Re: informix 11.70 growth edition features [30698] > > Hi Marcus, > > the limitation of distributed query was already prohibited in 11.70. > Have a look in the license text: http://goo.gl/ymnGK > > Cheers > Erik > > 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > > > Hi, > > > > just to make sure: He is using 11.70 version GE. > > In 11.70 Release, distributed query was not restricted for growth > edition. > > this is a new > > limitation that came with 12.x release. > > Does this modify the allowed features in a current 11.70 setup ? I don't > > think > > so. > > I would say this is only effective if you upgrade to 12.x, correct ? > > Same for the restrictions of Innovator Edition, which was limited in disk > > space > > in 12.x release. > > > > Any clues on the correct answer ? What is the policy of IBM for these > > questions, > > not for new customers but for people using 11.50/11.70 etc. ? > > > > Best regards, > > > > Marcus Haarmann > > > > ----- Ursprüngliche Mail ----- > > > > Von: "Alexandre Marini" <alexandre@briug.org> > > An: ids@iiug.org > > Gesendet: Freitag, 28. Juni 2013 13:24:10 > > Betreff: RE: informix 11.70 growth edition features [30696] > > > > Hello. > > The previous Growth Edition is now called Workgroup Edition. > > According to the official doc: > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ > > > > You might see that parallel operations, partitioning, and distributed SQL > > operations are not allowed. > > > > Regards. > > > > Alexandre Marini > > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > > > 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: pushpa@cybersoft.lk > > > Subject: informix 11.70 growth edition features [30695] > > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > > > Hi, > > > > > > i have installed informix 11.70 growth edition, is there any > possibility > > to > > > use the remote database query feature and fragment tables feature with > > this > > > version. > > > > > > Thanks > > > Pushpa > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > 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. > > > > > > --001a11c25daa61e99704e0372be6 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133b7dad3502704e0379a36

I suspect most companies can no longer use the growth/workgroup edition due to this limitation Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Erik Stahlhut Sent: Friday, June 28, 2013 8:51 AM To: ids@iiug.org Subject: Re: informix 11.70 growth edition features [30698] Hi Marcus, the limitation of distributed query was already prohibited in 11.70. Have a look in the license text: http://goo.gl/ymnGK Cheers Erik 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > Hi, > > just to make sure: He is using 11.70 version GE. > In 11.70 Release, distributed query was not restricted for growth edition. > this is a new > limitation that came with 12.x release. > Does this modify the allowed features in a current 11.70 setup ? I don't > think > so. > I would say this is only effective if you upgrade to 12.x, correct ? > Same for the restrictions of Innovator Edition, which was limited in disk > space > in 12.x release. > > Any clues on the correct answer ? What is the policy of IBM for these > questions, > not for new customers but for people using 11.50/11.70 etc. ? > > Best regards, > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Alexandre Marini" <alexandre@briug.org> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 13:24:10 > Betreff: RE: informix 11.70 growth edition features [30696] > > Hello. > The previous Growth Edition is now called Workgroup Edition. > According to the official doc: > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ > > You might see that parallel operations, partitioning, and distributed SQL > operations are not allowed. > > Regards. > > Alexandre Marini > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > 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: pushpa@cybersoft.lk > > Subject: informix 11.70 growth edition features [30695] > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > Hi, > > > > i have installed informix 11.70 growth edition, is there any possibility > to > > use the remote database query feature and fragment tables feature with > this > > version. > > > > Thanks > > Pushpa > > > > > > > > > **************************************************************************** *** > > 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. > > --001a11c25daa61e99704e0372be6 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

The "no longer" has me very confused as "I-Star/distributed operations/distributed SQL/accessing data on different computers" has always been limited in workgroup, growth and other non-enterprises editions. I have just double checked the 11.50/11.70/12.10 and they all= have this restriction in the license as I believe earlier version of th= e non-enterprise product do. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM: > From: "Paul Watson" <paul@oninit.com> > To: ids@iiug.org, > Date: 06/28/2013 07:47 AM > Subject: RE: informix 11.70 growth edition features [30702] > Sent by: ids-bounces@iiug.org > > I suspect most companies can no longer use the growth/workgroup editi= on due > to this limitation > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of= Erik > Stahlhut > Sent: Friday, June 28, 2013 8:51 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30698] > > Hi Marcus, > > the limitation of distributed query was already prohibited in 11.70. > Have a look in the license text: http://goo.gl/ymnGK > > Cheers > Erik > > 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > > > Hi, > > > > just to make sure: He is using 11.70 version GE. > > In 11.70 Release, distributed query was not restricted for growth edition. > > > this is a new > > limitation that came with 12.x release. > > Does this modify the allowed features in a current 11.70 setup ? I don't > > think > > so. > > I would say this is only effective if you upgrade to 12.x, correct = ? > > Same for the restrictions of Innovator Edition, which was limited i= n disk > > space > > in 12.x release. > > > > Any clues on the correct answer ? What is the policy of IBM for the= se > > questions, > > not for new customers but for people using 11.50/11.70 etc. ? > > > > Best regards, > > > > Marcus Haarmann > > > > ----- Urspr=FCngliche Mail ----- > > > > Von: "Alexandre Marini" <alexandre@briug.org> > > An: ids@iiug.org > > Gesendet: Freitag, 28. Juni 2013 13:24:10 > > Betreff: RE: informix 11.70 growth edition features [30696] > > > > Hello. > > The previous Growth Edition is now called Workgroup Edition. > > According to the official doc: > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d= oe/ > > > > You might see that parallel operations, partitioning, and distribut= ed SQL > > operations are not allowed. > > > > Regards. > > > > Alexandre Marini > > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > > > 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: pushpa@cybersoft.lk > > > Subject: informix 11.70 growth edition features [30695] > > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > > > Hi, > > > > > > i have installed informix 11.70 growth edition, is there any possibility > > > to > > > use the remote database query feature and fragment tables feature= with > > this > > > version. > > > > > > Thanks > > > Pushpa > > > > > > > > > > > > > > > > ***********************************************************************= ***** > *** > > > Forum Note: Use "Reply" to post a response in the discussion foru= m. > > > > > > > > > > > > ***********************************************************************= ***** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > > > > ***********************************************************************= ***** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > --001a11c25daa61e99704e0372be6 > > ***********************************************************************= ***** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

This restriction also makes sense from a product positioning = perspective. Workgroup Edition, as the name implies, is for environments = with smaller data processing requirements. While logically you can think = of it as an isolated processing environment within a larger enterprise, = I can certainly see some small businesses using it for the entire = processing needs. Workgroup Edition has reduced functionality to meet these types of = reduced requirement workloads *and* to drive price differentiation from = Enterprise Edition. If a data processing environment requires sharing = data between instances through distributed operations, this is an = enterprise-wide environment and should utilize the Enterprise Edition = with all its expanded functionality and scalability. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = wrote: > The "no longer" has me very confused as "I-Star/distributed=20 > operations/distributed SQL/accessing data on different computers" has=20= > always been limited in workgroup, growth and other non-enterprises=20 > editions. I have just double checked the 11.50/11.70/12.10 and they = all=3D=20 >=20 > have this restriction in the license as I believe earlier version of = th=3D=20 > e=20 > non-enterprise product do.=20 >=20 > John F. Miller III=20 > STSM, Lead Architect=20 > miller3@us.ibm.com=20 > 503-747-1366=20 > IBM Informix Dynamic Server (IDS)=20 >=20 > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >=20 >> From: "Paul Watson" <paul@oninit.com>=20 >> To: ids@iiug.org,=20 >> Date: 06/28/2013 07:47 AM=20 >> Subject: RE: informix 11.70 growth edition features [30702]=20 >> Sent by: ids-bounces@iiug.org=20 >>=20 >> I suspect most companies can no longer use the growth/workgroup = editi=3D=20 > on=20 > due=20 >> to this limitation=20 >>=20 >> Cheers=20 >> Paul=20 >>=20 >> -----Original Message-----=20 >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = Of=3D=20 >=20 > Erik=20 >> Stahlhut=20 >> Sent: Friday, June 28, 2013 8:51 AM=20 >> To: ids@iiug.org=20 >> Subject: Re: informix 11.70 growth edition features [30698]=20 >>=20 >> Hi Marcus,=20 >>=20 >> the limitation of distributed query was already prohibited in 11.70.=20= >> Have a look in the license text: http://goo.gl/ymnGK=20 >>=20 >> Cheers=20 >> Erik=20 >>=20 >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>=20 >>> Hi,=20 >>>=20 >>> just to make sure: He is using 11.70 version GE.=20 >>> In 11.70 Release, distributed query was not restricted for growth=20 > edition.=20 >>=20 >>> this is a new=20 >>> limitation that came with 12.x release.=20 >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > don't=20 >>> think=20 >>> so.=20 >>> I would say this is only effective if you upgrade to 12.x, correct =3D= =20 > ?=20 >>> Same for the restrictions of Innovator Edition, which was limited i=3D= =20 > n=20 > disk=20 >>> space=20 >>> in 12.x release.=20 >>>=20 >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= =20 > se=20 >>> questions,=20 >>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>=20 >>> Best regards,=20 >>>=20 >>> Marcus Haarmann=20 >>>=20 >>> ----- Urspr=3DFCngliche Mail -----=20 >>>=20 >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>> An: ids@iiug.org=20 >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>=20 >>> Hello.=20 >>> The previous Growth Edition is now called Workgroup Edition.=20 >>> According to the official doc:=20 >>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= =20 > oe/=20 >>>=20 >>> You might see that parallel operations, partitioning, and distribut=3D= =20 > ed=20 > SQL=20 >>> operations are not allowed.=20 >>>=20 >>> Regards.=20 >>>=20 >>> Alexandre Marini=20 >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>=20 >>> IBM Information Management Informix Technical Professional=20 >>>=20 >>> IBM Infosphere DataStage Technical Professional=20 >>> Informix Senior DBA - Orizon Brasil=20 >>> BRIUG website administrator=20 >>> Informix independent consultant=20 >>>=20 >>>> To: ids@iiug.org=20 >>>> From: pushpa@cybersoft.lk=20 >>>> Subject: informix 11.70 growth edition features [30695]=20 >>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 >>>>=20 >>>> Hi,=20 >>>>=20 >>>> i have installed informix 11.70 growth edition, is there any=20 > possibility=20 >>=20 >>> to=20 >>>> use the remote database query feature and fragment tables feature=3D=20= >=20 > with=20 >>> this=20 >>>> version.=20 >>>>=20 >>>> Thanks=20 >>>> Pushpa=20 >>>>=20 >>>>=20 >>>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>>> Forum Note: Use "Reply" to post a response in the discussion foru=3D=20= > m.=20 >>>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=3D= =20 >=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=3D= =20 >=20 >>>=20 >>>=20 >>=20 >> --001a11c25daa61e99704e0372be6=20 >>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >>=20 > = ***********************************************************************=3D= =20 > ********=20 >=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=3D=20= >=20 >> =3D=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

OK in that case most companies have never been allowed to use Workgroup then :-) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Friday, June 28, 2013 10:54 AM To: ids@iiug.org Subject: RE: informix 11.70 growth edition features [30704] The "no longer" has me very confused as "I-Star/distributed operations/distributed SQL/accessing data on different computers" has always been limited in workgroup, growth and other non-enterprises editions. I have just double checked the 11.50/11.70/12.10 and they all= have this restriction in the license as I believe earlier version of th= e non-enterprise product do. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM: > From: "Paul Watson" <paul@oninit.com> > To: ids@iiug.org, > Date: 06/28/2013 07:47 AM > Subject: RE: informix 11.70 growth edition features [30702] > Sent by: ids-bounces@iiug.org > > I suspect most companies can no longer use the growth/workgroup editi= on due > to this limitation > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of= Erik > Stahlhut > Sent: Friday, June 28, 2013 8:51 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30698] > > Hi Marcus, > > the limitation of distributed query was already prohibited in 11.70. > Have a look in the license text: http://goo.gl/ymnGK > > Cheers > Erik > > 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > > > Hi, > > > > just to make sure: He is using 11.70 version GE. > > In 11.70 Release, distributed query was not restricted for growth edition. > > > this is a new > > limitation that came with 12.x release. > > Does this modify the allowed features in a current 11.70 setup ? I don't > > think > > so. > > I would say this is only effective if you upgrade to 12.x, correct = ? > > Same for the restrictions of Innovator Edition, which was limited i= n disk > > space > > in 12.x release. > > > > Any clues on the correct answer ? What is the policy of IBM for the= se > > questions, > > not for new customers but for people using 11.50/11.70 etc. ? > > > > Best regards, > > > > Marcus Haarmann > > > > ----- Urspr=FCngliche Mail ----- > > > > Von: "Alexandre Marini" <alexandre@briug.org> > > An: ids@iiug.org > > Gesendet: Freitag, 28. Juni 2013 13:24:10 > > Betreff: RE: informix 11.70 growth edition features [30696] > > > > Hello. > > The previous Growth Edition is now called Workgroup Edition. > > According to the official doc: > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d= oe/ > > > > You might see that parallel operations, partitioning, and distribut= ed SQL > > operations are not allowed. > > > > Regards. > > > > Alexandre Marini > > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > > > 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: pushpa@cybersoft.lk > > > Subject: informix 11.70 growth edition features [30695] > > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > > > Hi, > > > > > > i have installed informix 11.70 growth edition, is there any possibility > > > to > > > use the remote database query feature and fragment tables feature= with > > this > > > version. > > > > > > Thanks > > > Pushpa > > > > > > > > > > > > > > > > ***********************************************************************= ***** > *** > > > Forum Note: Use "Reply" to post a response in the discussion foru= m. > > > > > > > > > > > > ***********************************************************************= ***** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > > > > ***********************************************************************= ***** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > --001a11c25daa61e99704e0372be6 > > ***********************************************************************= ***** > *** > 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.

So is the following statement legal or illegal in Workgroup Database db@test; Insert into mytab Select * from db@production:mytab I do not know of a single site that doesn't use that type of SQL from time to time Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Carlton Doe Sent: Friday, June 28, 2013 11:16 AM To: ids@iiug.org Subject: Re: informix 11.70 growth edition features [30705] This restriction also makes sense from a product positioning = perspective. Workgroup Edition, as the name implies, is for environments = with smaller data processing requirements. While logically you can think = of it as an isolated processing environment within a larger enterprise, = I can certainly see some small businesses using it for the entire = processing needs. Workgroup Edition has reduced functionality to meet these types of = reduced requirement workloads *and* to drive price differentiation from = Enterprise Edition. If a data processing environment requires sharing = data between instances through distributed operations, this is an = enterprise-wide environment and should utilize the Enterprise Edition = with all its expanded functionality and scalability. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = wrote: > The "no longer" has me very confused as "I-Star/distributed=20 > operations/distributed SQL/accessing data on different computers" has=20= > always been limited in workgroup, growth and other non-enterprises=20 > editions. I have just double checked the 11.50/11.70/12.10 and they = all=3D=20 >=20 > have this restriction in the license as I believe earlier version of = th=3D=20 > e=20 > non-enterprise product do.=20 >=20 > John F. Miller III=20 > STSM, Lead Architect=20 > miller3@us.ibm.com=20 > 503-747-1366=20 > IBM Informix Dynamic Server (IDS)=20 >=20 > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >=20 >> From: "Paul Watson" <paul@oninit.com>=20 >> To: ids@iiug.org,=20 >> Date: 06/28/2013 07:47 AM=20 >> Subject: RE: informix 11.70 growth edition features [30702]=20 >> Sent by: ids-bounces@iiug.org=20 >>=20 >> I suspect most companies can no longer use the growth/workgroup = editi=3D=20 > on=20 > due=20 >> to this limitation=20 >>=20 >> Cheers=20 >> Paul=20 >>=20 >> -----Original Message-----=20 >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = Of=3D=20 >=20 > Erik=20 >> Stahlhut=20 >> Sent: Friday, June 28, 2013 8:51 AM=20 >> To: ids@iiug.org=20 >> Subject: Re: informix 11.70 growth edition features [30698]=20 >>=20 >> Hi Marcus,=20 >>=20 >> the limitation of distributed query was already prohibited in 11.70.=20= >> Have a look in the license text: http://goo.gl/ymnGK=20 >>=20 >> Cheers=20 >> Erik=20 >>=20 >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>=20 >>> Hi,=20 >>>=20 >>> just to make sure: He is using 11.70 version GE.=20 >>> In 11.70 Release, distributed query was not restricted for growth=20 > edition.=20 >>=20 >>> this is a new=20 >>> limitation that came with 12.x release.=20 >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > don't=20 >>> think=20 >>> so.=20 >>> I would say this is only effective if you upgrade to 12.x, correct =3D= =20 > ?=20 >>> Same for the restrictions of Innovator Edition, which was limited i=3D= =20 > n=20 > disk=20 >>> space=20 >>> in 12.x release.=20 >>>=20 >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= =20 > se=20 >>> questions,=20 >>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>=20 >>> Best regards,=20 >>>=20 >>> Marcus Haarmann=20 >>>=20 >>> ----- Urspr=3DFCngliche Mail -----=20 >>>=20 >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>> An: ids@iiug.org=20 >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>=20 >>> Hello.=20 >>> The previous Growth Edition is now called Workgroup Edition.=20 >>> According to the official doc:=20 >>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= =20 > oe/=20 >>>=20 >>> You might see that parallel operations, partitioning, and distribut=3D= =20 > ed=20 > SQL=20 >>> operations are not allowed.=20 >>>=20 >>> Regards.=20 >>>=20 >>> Alexandre Marini=20 >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>=20 >>> IBM Information Management Informix Technical Professional=20 >>>=20 >>> IBM Infosphere DataStage Technical Professional=20 >>> Informix Senior DBA - Orizon Brasil=20 >>> BRIUG website administrator=20 >>> Informix independent consultant=20 >>>=20 >>>> To: ids@iiug.org=20 >>>> From: pushpa@cybersoft.lk=20 >>>> Subject: informix 11.70 growth edition features [30695]=20 >>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 >>>>=20 >>>> Hi,=20 >>>>=20 >>>> i have installed informix 11.70 growth edition, is there any=20 > possibility=20 >>=20 >>> to=20 >>>> use the remote database query feature and fragment tables feature=3D=20= >=20 > with=20 >>> this=20 >>>> version.=20 >>>>=20 >>>> Thanks=20 >>>> Pushpa=20 >>>>=20 >>>>=20 >>>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>>> Forum Note: Use "Reply" to post a response in the discussion foru=3D=20= > m.=20 >>>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=3D= =20 >=20 >>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum.=3D= =20 >=20 >>>=20 >>>=20 >>=20 >> --001a11c25daa61e99704e0372be6=20 >>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >>=20 > = ***********************************************************************=3D= =20 > ********=20 >=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=3D=20= >=20 >> =3D=20@@

Illegal. A distributed operation is one that occurs between two or more instances. They can be on the same or different physical / virtual servers. Inter-database operations (operations between two or more databases) within the same instance is NOT a distributed operation. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large number of electrons were temporarily inconvenienced. On Jun 28, 2013, at 11:45 AM, "Paul Watson" <paul@oninit.com> wrote: > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > >> The "no longer" has me very confused as "I-Star/distributed=20 >> operations/distributed SQL/accessing data on different computers" has=20= > >> always been limited in workgroup, growth and other non-enterprises=20 >> editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 >> =20 >> have this restriction in the license as I believe earlier version of = > th=3D=20 >> e=20 >> non-enterprise product do.=20 >> =20 >> John F. Miller III=20 >> STSM, Lead Architect=20 >> miller3@us.ibm.com=20 >> 503-747-1366=20 >> IBM Informix Dynamic Server (IDS)=20 >> =20 >> ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >> =20 >>> From: "Paul Watson" <paul@oninit.com>=20 >>> To: ids@iiug.org,=20 >>> Date: 06/28/2013 07:47 AM=20 >>> Subject: RE: informix 11.70 growth edition features [30702]=20 >>> Sent by: ids-bounces@iiug.org=20 >>> =20 >>> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 >> on=20 >> due=20 >>> to this limitation=20 >>> =20 >>> Cheers=20 >>> Paul=20 >>> =20 >>> -----Original Message-----=20 >>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 >> =20 >> Erik=20 >>> Stahlhut=20 >>> Sent: Friday, June 28, 2013 8:51 AM=20 >>> To: ids@iiug.org=20 >>> Subject: Re: informix 11.70 growth edition features [30698]=20 >>> =20 >>> Hi Marcus,=20 >>> =20 >>> the limitation of distributed query was already prohibited in 11.70.=20= > >>> Have a look in the license text: http://goo.gl/ymnGK=20 >>> =20 >>> Cheers=20 >>> Erik=20 >>> =20 >>> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>> =20 >>>> Hi,=20 >>>> =20 >>>> just to make sure: He is using 11.70 version GE.=20 >>>> In 11.70 Release, distributed query was not restricted for growth=20 >> edition.=20 >>> =20 >>>> this is a new=20 >>>> limitation that came with 12.x release.=20 >>>> Does this modify the allowed features in a current 11.70 setup ? I=20= > >> don't=20 >>>> think=20 >>>> so.=20 >>>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 >> ?=20 >>>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 >> n=20 >> disk=20 >>>> space=20 >>>> in 12.x release.=20 >>>> =20 >>>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 >> se=20 >>>> questions,=20 >>>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>> =20 >>>> Best regards,=20 >>>> =20 >>>> Marcus Haarmann=20 >>>> =20 >>>> ----- Urspr=3DFCngliche Mail -----=20 >>>> =20 >>>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>>> An: ids@iiug.org=20 >>>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>> =20 >>>> Hello.=20 >>>> The previous Growth Edition is now called Workgroup Edition.=20 >>>> According to the official doc:=20 >>>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 >> oe/=20 >>>> =20 >>>> You might see that parallel operations, partitioning, and distribut=3D= > =20 >> ed=20 >> SQL=20 >>>> operations are not allowed.=20 >>>> =20 >>>> Regards.=20 >>>> =20 >>>> Alexandre Marini=20 >>>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>> =20 >>>> IBM Information Management Informix Technical Professional=20 >>>> =20 >>>> IBM Infosphere DataStage Technical Professional=20 >>>> Informix Senior DBA - Orizon Brasil=20 >>>> BRIUG website administrator=20 >>>> Informix independent consultant=20 >>>> =20 >>>>> To: ids@iiug.org=20 >>>>> From: pushpa@cybersoft.lk=20 >>>>> Subject: informix 11.70 growth edition features [30695]=20 >>>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 >>>>> =20 >>>>> Hi,=20 >>>>> =20 >>>>> i have installed informix 11.70 growth edition, is there any=20 >> possibility=20 >>> =20 >>>> to=20 >>>>> use the remote database query feature and fragment tables > feature=3D=20= > >> =20 >> with=20 >>>> this=20 >>>>> version.=20 >>>>> =20 >>>>> Thanks=20 >>>>> Pushpa=20 >>>>> =20 >>>>> =20 >>>>> =20 >>>> =20 >>>> =20 >>>> =20 >>> =20 >> = > ***********************************************************************=3D= > =20 >> *****=20 >> =20 >>> ***=20 >>>>> Forum Note: Use "Reply" to post a response in the discussion > foru=3D=20= > >> m.=20 >>>>> =20 >>>> =20 >>>> =20 >>>> =20 >>>> =20 >>> =20 >> = > ***********************************************************************=3D= > =20 >> *****=20 >> =20 >>> ***=20 >>>> Forum Note: Use "Reply" to post a response in the

Paul: The use of the syntax does not constitute a distributed operation. If you are referencing the current database with the full name or another database inside the same instance this is NOT a distributed operation, but rather if you reference a different instance then you are doing distributed work . John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/28/2013 09:45:29 AM: > From: "Paul Watson" <paul@oninit.com> > To: ids@iiug.org, > Date: 06/28/2013 09:47 AM > Subject: RE: informix 11.70 growth edition features [30707] > Sent by: ids-bounces@iiug.org > > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > > > The "no longer" has me very confused as "I-Star/distributed=20 > > operations/distributed SQL/accessing data on different computers" has=20= > > > always been limited in workgroup, growth and other non-enterprises=20 > > editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 > >=20 > > have this restriction in the license as I believe earlier version of = > th=3D=20 > > e=20 > > non-enterprise product do.=20 > >=20 > > John F. Miller III=20 > > STSM, Lead Architect=20 > > miller3@us.ibm.com=20 > > 503-747-1366=20 > > IBM Informix Dynamic Server (IDS)=20 > >=20 > > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 > >=20 > >> From: "Paul Watson" <paul@oninit.com>=20 > >> To: ids@iiug.org,=20 > >> Date: 06/28/2013 07:47 AM=20 > >> Subject: RE: informix 11.70 growth edition features [30702]=20 > >> Sent by: ids-bounces@iiug.org=20 > >>=20 > >> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 > > on=20 > > due=20 > >> to this limitation=20 > >>=20 > >> Cheers=20 > >> Paul=20 > >>=20 > >> -----Original Message-----=20 > >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 > >=20 > > Erik=20 > >> Stahlhut=20 > >> Sent: Friday, June 28, 2013 8:51 AM=20 > >> To: ids@iiug.org=20 > >> Subject: Re: informix 11.70 growth edition features [30698]=20 > >>=20 > >> Hi Marcus,=20 > >>=20 > >> the limitation of distributed query was already prohibited in 11.70.=20= > > >> Have a look in the license text: http://goo.gl/ymnGK=20 > >>=20 > >> Cheers=20 > >> Erik=20 > >>=20 > >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 > >>=20 > >>> Hi,=20 > >>>=20 > >>> just to make sure: He is using 11.70 version GE.=20 > >>> In 11.70 Release, distributed query was not restricted for growth=20 > > edition.=20 > >>=20 > >>> this is a new=20 > >>> limitation that came with 12.x release.=20 > >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > > > don't=20 > >>> think=20 > >>> so.=20 > >>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 > > ?=20 > >>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 > > n=20 > > disk=20 > >>> space=20 > >>> in 12.x release.=20 > >>>=20 > >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 > > se=20 > >>> questions,=20 > >>> not for new customers but for people using 11.50/11.70 etc. ?=20 > >>>=20 > >>> Best regards,=20 > >>>=20 > >>> Marcus Haarmann=20 > >>>=20 > >>> ----- Urspr=3DFCngliche Mail -----=20 > >>>=20 > >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 > >>> An: ids@iiug.org=20 > >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 > >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 > >>>=20 > >>> Hello.=20 > >>> The previous Growth Edition is now called Workgroup Edition.=20 > >>> According to the official doc:=20 > >>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 > > oe/=20 > >>>=20 > >>> You might see that parallel operations, partitioning, and distribut=3D= > =20 > > ed=20 > > SQL=20 > >>> operations are not allowed.=20 > >>>=20 > >>> Regards.=20 > >>>=20 > >>> Alexandre Marini=20 > >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 > >>>=20 > >>> IBM Information Management Informix Technical Professional=20 > >>>=20 > >>> IBM Infosphere DataStage Technical Professional=20 > >>> Informix Senior DBA - Orizon Brasil=20 > >>> BRIUG website administrator=20 > >>> Informix independent consultant=20 > >>>=20 > >>>> To: ids@iiug.org=20 > >>>> From: pushpa@cybersoft.lk=20 > >>>> Subject: informix 11.70 growth edition features [30695]=20 > >>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 > >>>>=20 > >>>> Hi,=20 > >>>>=20 > >>>> i have installed informix 11.70 growth edition, is there any=20 > > possibility=20 > >>=20 > >>> to=20 > >>>> use the remote database query feature and fragment tables > feature=3D=20= > > >=20 > > with=20 > >>> this=20 > >>>> version.=20 > >>>>=20 > >>>> Thanks=20 > >>>> Pushpa=20 > >>>>=20 > >>>>=20 > >>>>=20 > >>>=20 > >>>=20 > >>>=20 > >>=20 > > = > ***********************************************************************=3D= > =20 > > *****=20 > >=20 > >> ***=20 > >>>> Forum Note: Use "Reply" to post a response in the discussion > foru=3D=20= > > > m.=20@

I suspect every installation is illegal then -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Carlton Doe Sent: Friday, June 28, 2013 12:19 PM To: ids@iiug.org Subject: Re: informix 11.70 growth edition features [30709] Illegal. A distributed operation is one that occurs between two or more instances. They can be on the same or different physical / virtual servers. Inter-database operations (operations between two or more databases) within the same instance is NOT a distributed operation. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large number of electrons were temporarily inconvenienced. On Jun 28, 2013, at 11:45 AM, "Paul Watson" <paul@oninit.com> wrote: > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > >> The "no longer" has me very confused as "I-Star/distributed=20 >> operations/distributed SQL/accessing data on different computers" has=20= > >> always been limited in workgroup, growth and other non-enterprises=20 >> editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 >> =20 >> have this restriction in the license as I believe earlier version of = > th=3D=20 >> e=20 >> non-enterprise product do.=20 >> =20 >> John F. Miller III=20 >> STSM, Lead Architect=20 >> miller3@us.ibm.com=20 >> 503-747-1366=20 >> IBM Informix Dynamic Server (IDS)=20 >> =20 >> ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >> =20 >>> From: "Paul Watson" <paul@oninit.com>=20 >>> To: ids@iiug.org,=20 >>> Date: 06/28/2013 07:47 AM=20 >>> Subject: RE: informix 11.70 growth edition features [30702]=20 >>> Sent by: ids-bounces@iiug.org=20 >>> =20 >>> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 >> on=20 >> due=20 >>> to this limitation=20 >>> =20 >>> Cheers=20 >>> Paul=20 >>> =20 >>> -----Original Message-----=20 >>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 >> =20 >> Erik=20 >>> Stahlhut=20 >>> Sent: Friday, June 28, 2013 8:51 AM=20 >>> To: ids@iiug.org=20 >>> Subject: Re: informix 11.70 growth edition features [30698]=20 >>> =20 >>> Hi Marcus,=20 >>> =20 >>> the limitation of distributed query was already prohibited in 11.70.=20= > >>> Have a look in the license text: http://goo.gl/ymnGK=20 >>> =20 >>> Cheers=20 >>> Erik=20 >>> =20 >>> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>> =20 >>>> Hi,=20 >>>> =20 >>>> just to make sure: He is using 11.70 version GE.=20 >>>> In 11.70 Release, distributed query was not restricted for growth=20 >> edition.=20 >>> =20 >>>> this is a new=20 >>>> limitation that came with 12.x release.=20 >>>> Does this modify the allowed features in a current 11.70 setup ? I=20= > >> don't=20 >>>> think=20 >>>> so.=20 >>>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 >> ?=20 >>>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 >> n=20 >> disk=20 >>>> space=20 >>>> in 12.x release.=20 >>>> =20 >>>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 >> se=20 >>>> questions,=20 >>>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>> =20 >>>> Best regards,=20 >>>> =20 >>>> Marcus Haarmann=20 >>>> =20 >>>> ----- Urspr=3DFCngliche Mail -----=20 >>>> =20 >>>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>>> An: ids@iiug.org=20 >>>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>> =20 >>>> Hello.=20 >>>> The previous Growth Edition is now called Workgroup Edition.=20 >>>> According to the official doc:=20 >>>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 >> oe/=20 >>>> =20 >>>> You might see that parallel operations, partitioning, and distribut=3D= > =20 >> ed=20 >> SQL=20 >>>> operations are not allowed.=20 >>>> =20 >>>> Regards.=20 >>>> =20 >>>> Alexandre Marini=20 >>>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>> =20 >>>> IBM Information Management Informix Technical Professional=20 >>>> =20 >>>> IBM Infosphere DataStage Technical Professional=20 >>>> Informix Senior DBA - Orizon Brasil=20 >>>> BRIUG website administrator=20 >>>> Informix independent consultant=20 >>>> =20 >>>>> To: ids@iiug.org=20 >>>>> From: pushpa@cybersoft.lk=20 >>>>> Subject: informix 11.70 growth edition features [30695]=20 >>>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 >>>>> =20 >>>>> Hi,=20 >>>>> =20 >>>>> i have installed informix 11.70 growth edition, is there any=20 >> possibility=20 >>> =20 >>>> to=20 >>>>> use the remote database query feature and fragment tables > feature=3D=20= > >> =20 >> with=20 >>>> this=20 >>>>> version.=20 >>>>> =20 >>>>> Thanks=20 >>>>> Pushpa=20 >>>>> =20 >>>>> =20 >>>>> =20 >>>> =20 >>>> =20 >>>> =20 >>> =20 >> = > ***********************************************************************=3D= > =20 >> *****=20 >> =20 >>> ***=20 >>>>> Forum Note: Use @@D

The restriction is not against accessing the server remotely over the network as a client it is a restriction against the engines talking to each other, so if you have a server-a and a server-b you could not connect to server-a and execute: select * from local_table as l, mydatabase@server-b:remote_table as r where l.key = r.key; If you have a need to gather data from multiple server instances, and you don't need any other Enterprise features, then you can join the data in application/client space by having separate connections to multiple servers. There is no restriction against that. So, the tradeoff is higher licensing costs of Enterprise Edition or higher development costs of slightly more complex code development. 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, Jun 28, 2013 at 12:35 PM, Paul Watson <paul@oninit.com> wrote: > OK in that case most companies have never been allowed to use Workgroup > then > :-) > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John > Miller iii > Sent: Friday, June 28, 2013 10:54 AM > To: ids@iiug.org > Subject: RE: informix 11.70 growth edition features [30704] > > The "no longer" has me very confused as "I-Star/distributed > operations/distributed SQL/accessing data on different computers" has > always been limited in workgroup, growth and other non-enterprises > editions. I have just double checked the 11.50/11.70/12.10 and they all= > > have this restriction in the license as I believe earlier version of th= > e > non-enterprise product do. > > John F. Miller III > STSM, Lead Architect > miller3@us.ibm.com > 503-747-1366 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM: > > > From: "Paul Watson" <paul@oninit.com> > > To: ids@iiug.org, > > Date: 06/28/2013 07:47 AM > > Subject: RE: informix 11.70 growth edition features [30702] > > Sent by: ids-bounces@iiug.org > > > > I suspect most companies can no longer use the growth/workgroup editi= > on > due > > to this limitation > > > > Cheers > > Paul > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of= > > Erik > > Stahlhut > > Sent: Friday, June 28, 2013 8:51 AM > > To: ids@iiug.org > > Subject: Re: informix 11.70 growth edition features [30698] > > > > Hi Marcus, > > > > the limitation of distributed query was already prohibited in 11.70. > > Have a look in the license text: http://goo.gl/ymnGK > > > > Cheers > > Erik > > > > 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de> > > > > > Hi, > > > > > > just to make sure: He is using 11.70 version GE. > > > In 11.70 Release, distributed query was not restricted for growth > edition. > > > > > this is a new > > > limitation that came with 12.x release. > > > Does this modify the allowed features in a current 11.70 setup ? I > don't > > > think > > > so. > > > I would say this is only effective if you upgrade to 12.x, correct = > ? > > > Same for the restrictions of Innovator Edition, which was limited i= > n > disk > > > space > > > in 12.x release. > > > > > > Any clues on the correct answer ? What is the policy of IBM for the= > se > > > questions, > > > not for new customers but for people using 11.50/11.70 etc. ? > > > > > > Best regards, > > > > > > Marcus Haarmann > > > > > > ----- Urspr=FCngliche Mail ----- > > > > > > Von: "Alexandre Marini" <alexandre@briug.org> > > > An: ids@iiug.org > > > Gesendet: Freitag, 28. Juni 2013 13:24:10 > > > Betreff: RE: informix 11.70 growth edition features [30696] > > > > > > Hello. > > > The previous Growth Edition is now called Workgroup Edition. > > > According to the official doc: > > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d= > oe/ > > > > > > You might see that parallel operations, partitioning, and distribut= > ed > SQL > > > operations are not allowed. > > > > > > Regards. > > > > > > Alexandre Marini > > > IBM Informix Certified Professional v10 / v11.50 / v11.70 > > > > > > 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: pushpa@cybersoft.lk > > > > Subject: informix 11.70 growth edition features [30695] > > > > Date: Fri, 28 Jun 2013 02:38:07 -0400 > > > > > > > > Hi, > > > > > > > > i have installed informix 11.70 growth edition, is there any > possibility > > > > > to > > > > use the remote database query feature and fragment tables feature= > > with > > > this > > > > version. > > > > > > > > Thanks > > > > Pushpa > > > > > > > > > > > > > > > > > > > > > > > > ***********************************************************************= > ***** > > > *** > > > > Forum Note: Use "Reply" to post a response in the discussion foru= > m. > > > > > > > > > > > > > > > > > > > ***********************************************************************= > ***** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > > > > > > > > > > > ***********************************************************************= > ***** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > > > > > > --001a11c25daa61e99704e0372be6 > > > > > ***********************************************************************= > ***** > > > *** > > 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. > > --001a11c356e2280e2504e03b66cf

My understanding is that it's legal as long as you are connected to server 'production' but not if you are connected to server 'test'. But bottom line, the outgoing connection code in the engine is disabled, so it just will not work. 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, Jun 28, 2013 at 12:45 PM, Paul Watson <paul@oninit.com> wrote: > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > > > The "no longer" has me very confused as "I-Star/distributed=20 > > operations/distributed SQL/accessing data on different computers" has=20= > > > always been limited in workgroup, growth and other non-enterprises=20 > > editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 > >=20 > > have this restriction in the license as I believe earlier version of = > th=3D=20 > > e=20 > > non-enterprise product do.=20 > >=20 > > John F. Miller III=20 > > STSM, Lead Architect=20 > > miller3@us.ibm.com=20 > > 503-747-1366=20 > > IBM Informix Dynamic Server (IDS)=20 > >=20 > > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 > >=20 > >> From: "Paul Watson" <paul@oninit.com>=20 > >> To: ids@iiug.org,=20 > >> Date: 06/28/2013 07:47 AM=20 > >> Subject: RE: informix 11.70 growth edition features [30702]=20 > >> Sent by: ids-bounces@iiug.org=20 > >>=20 > >> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 > > on=20 > > due=20 > >> to this limitation=20 > >>=20 > >> Cheers=20 > >> Paul=20 > >>=20 > >> -----Original Message-----=20 > >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 > >=20 > > Erik=20 > >> Stahlhut=20 > >> Sent: Friday, June 28, 2013 8:51 AM=20 > >> To: ids@iiug.org=20 > >> Subject: Re: informix 11.70 growth edition features [30698]=20 > >>=20 > >> Hi Marcus,=20 > >>=20 > >> the limitation of distributed query was already prohibited in 11.70.=20= > > >> Have a look in the license text: http://goo.gl/ymnGK=20 > >>=20 > >> Cheers=20 > >> Erik=20 > >>=20 > >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 > >>=20 > >>> Hi,=20 > >>>=20 > >>> just to make sure: He is using 11.70 version GE.=20 > >>> In 11.70 Release, distributed query was not restricted for growth=20 > > edition.=20 > >>=20 > >>> this is a new=20 > >>> limitation that came with 12.x release.=20 > >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > > > don't=20 > >>> think=20 > >>> so.=20 > >>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 > > ?=20 > >>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 > > n=20 > > disk=20 > >>> space=20 > >>> in 12.x release.=20 > >>>=20 > >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 > > se=20 > >>> questions,=20 > >>> not for new customers but for people using 11.50/11.70 etc. ?=20 > >>>=20 > >>> Best regards,=20 > >>>=20 > >>> Marcus Haarmann=20 > >>>=20 > >>> ----- Urspr=3DFCngliche Mail -----=20 > >>>=20 > >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 > >>> An: ids@iiug.org=20 > >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 > >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 > >>>=20 > >>> Hello.=20 > >>> The previous Growth Edition is now called Workgroup Edition.=20 > >>> According to the official doc:=20 > >>> > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 > > oe/=20 > >>>=20 > >>> You might see that parallel operations, partitioning, and distribut=3D= > =20 > > ed=20 > > SQL=20 > >>> operations are not allowed.=20 > >>>=20 > >>> Regards.=20 > >>>=20 > >>> Alexandre Marini=20 > >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 > >>>=20 > >>> IBM Information Management Informix Technical Professional=20 > >>>=20 > >>> IBM Infosphere DataStage Technical Professional=20 > >>> Informix Senior DBA - Orizon Brasil=20 > >>> BRIUG website administrator=20 > >>> Informix independent consultant=20 > >>>=20 > >>>> To: ids@iiug.org=20 > >>>> From: pushpa@cybersoft.lk=20 > >>>> Subject: informix 11.70 growth edition features [30695]=20 > >>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 > >>>>=20 > >>>> Hi,=20 > >>>>=20 > >>>> i have installed informix 11.70 growth edition, is there any=20 > > possibility=20 > >>=20 > >>> to=20 > >>>> use the remote database query feature and fragment tables > feature=3D=20= > > >=20 > > with=20 > >>> this=20 > >>>> version.=20 > >>>>=20 > >>>> Thanks=20 > >>>> Pushpa=20 > >>>>=20 > >>>>=20 > >>>>=20 > >>>=20 > >>>=20 > >>>=20 > >>=20 > > = > ***********************************************************************=3D= > =20 > > *****=20 > >=20 > >> ***=20 > >>>> Forum Note: Use "Reply" to post a response in the

I found a good article with an explanation of distributed queries. http://www.ibm.com/developerworks/data/library/techarticle/dm-0705lee/ In my opinion this restriction doesn´t make sense: - if you connect to another instance you have to own a license for that instance - it is not really possible to control that kind of access - it´s allowed at other vendors dbms - ... Paul ist right! I think we have lots of compliance situations out there, because nobody knows exactly what that restriction means. Cheers Erik 2013/6/28 Art Kagel <art.kagel@gmail.com> > My understanding is that it's legal as long as you are connected to server > 'production' but not if you are connected to server 'test'. But bottom > line, the outgoing connection code in the engine is disabled, so it just > will not work. > > 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, Jun 28, 2013 at 12:45 PM, Paul Watson <paul@oninit.com> wrote: > > > So is the following statement legal or illegal in Workgroup > > > > Database db@test; > > > > Insert into mytab> > > > Select * from db@production:mytab> > > > I do not know of a single site that doesn't use that type of SQL from > time > > to time > > > > Cheers > > Paul > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Carlton Doe > > Sent: Friday, June 28, 2013 11:16 AM > > To: ids@iiug.org > > Subject: Re: informix 11.70 growth edition features [30705] > > > > This restriction also makes sense from a product positioning = > > perspective. Workgroup Edition, as the name implies, is for environments > = > > with smaller data processing requirements. While logically you can think > = > > of it as an isolated processing environment within a larger enterprise, = > > I can certainly see some small businesses using it for the entire = > > processing needs. > > > > Workgroup Edition has reduced functionality to meet these types of = > > reduced requirement workloads *and* to drive price differentiation from = > > Enterprise Edition. If a data processing environment requires sharing = > > data between instances through distributed operations, this is an = > > enterprise-wide environment and should utilize the Enterprise Edition = > > with all its expanded functionality and scalability. > > > > Carlton > > > > ------------------------------------------------- > > Carlton Doe > > Flower Mound, TX > > > > No trees were killed in the transmission of this email, however a large = > > number of electrons were temporarily inconvenienced.=20 > > > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > > wrote: > > > > > The "no longer" has me very confused as "I-Star/distributed=20 > > > operations/distributed SQL/accessing data on different computers" > has=20= > > > > > always been limited in workgroup, growth and other non-enterprises=20 > > > editions. I have just double checked the 11.50/11.70/12.10 and they = > > all=3D=20 > > >=20 > > > have this restriction in the license as I believe earlier version of = > > th=3D=20 > > > e=20 > > > non-enterprise product do.=20 > > >=20 > > > John F. Miller III=20 > > > STSM, Lead Architect=20 > > > miller3@us.ibm.com=20 > > > 503-747-1366=20 > > > IBM Informix Dynamic Server (IDS)=20 > > >=20 > > > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 > > >=20 > > >> From: "Paul Watson" <paul@oninit.com>=20 > > >> To: ids@iiug.org,=20 > > >> Date: 06/28/2013 07:47 AM=20 > > >> Subject: RE: informix 11.70 growth edition features [30702]=20 > > >> Sent by: ids-bounces@iiug.org=20 > > >>=20 > > >> I suspect most companies can no longer use the growth/workgroup = > > editi=3D=20 > > > on=20 > > > due=20 > > >> to this limitation=20 > > >>=20 > > >> Cheers=20 > > >> Paul=20 > > >>=20 > > >> -----Original Message-----=20 > > >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > > Of=3D=20 > > >=20 > > > Erik=20 > > >> Stahlhut=20 > > >> Sent: Friday, June 28, 2013 8:51 AM=20 > > >> To: ids@iiug.org=20 > > >> Subject: Re: informix 11.70 growth edition features [30698]=20 > > >>=20 > > >> Hi Marcus,=20 > > >>=20 > > >> the limitation of distributed query was already prohibited in > 11.70.=20= > > > > >> Have a look in the license text: http://goo.gl/ymnGK=20 > > >>=20 > > >> Cheers=20 > > >> Erik=20 > > >>=20 > > >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 > > >>=20 > > >>> Hi,=20 > > >>>=20 > > >>> just to make sure: He is using 11.70 version GE.=20 > > >>> In 11.70 Release, distributed query was not restricted for growth=20 > > > edition.=20 > > >>=20 > > >>> this is a new=20 > > >>> limitation that came with 12.x release.=20 > > >>> Does this modify the allowed features in a current 11.70 setup ? > I=20= > > > > > don't=20 > > >>> think=20 > > >>> so.=20 > > >>> I would say this is only effective if you upgrade to 12.x, correct > =3D= > > =20 > > > ?=20 > > >>> Same for the restrictions of Innovator Edition, which was limited > i=3D= > > =20 > > > n=20 > > > disk=20 > > >>> space=20 > > >>> in 12.x release.=20 > > >>>=20 > > >>> Any clues on the correct answer ? What is the policy of IBM for > the=3D= > > =20 > > > se=20 > > >>> questions,=20 > > >>> not for new customers but for people using 11.50/11.70 etc. ?=20 > > >>>=20 > > >>> Best regards,=20 > > >>>=20 > > >>> Marcus Haarmann=20 > > >>>=20 > > >>> ----- Urspr=3DFCngliche Mail -----=20 > > >>>=20 > > >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 > > >>> An: ids@iiug.org=20 > > >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 > > >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 > > >>>=20 > > >>> Hello.=20 > > >>> The previous Growth Edition is now called Workgroup Edition.=20 > > >>> According to the official doc:=20 > > >>> > > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > > =20 > > > oe/=20 > > >>>=20 > > >>> You might see that parallel operations, partitioning, and > distribut=3D= > > =20 > > > ed=20 > > > SQL=20 > > >>> operations are not allowed.=20 > > >>>=20 > > >>> Regards.=20 > > >>>=20 > > >>> Alexandre Marini=20 > > >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 > > >>>=20 > > >>> IBM Information Management Informix Technical Professional=20 > > >>>=20 > > >>> IBM Infosphere DataStage Technical Prof

Hi all, Interesting to know. Yes, the definition was not very clear in the past from my point of view (only saying something about I-Star, which is not an active product, but has been in the past), but in the latest list, we get a definition: The ability for a SQL session connected to a database in one instance to execute a DML operation using data from another database in a different instance. This means, you are allowed to query the foreign instance, but not as part of a DML, correct ? So your insert statement would not be allowed, but a select statement, which includes e.g. one table from another instance for reference reasons would be allowed ? Sample: unload to "anyfile" select t1.field1, t2.field2 from local_table t1, foreign_db@foreign_instance:foreign_table t2 where t1.id1 = t2.id1 order by t1.field1; Would that one fit in the license restrictions ? Thank you all for your opinion. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Paul Watson" <paul@oninit.com> An: ids@iiug.org Gesendet: Freitag, 28. Juni 2013 18:45:29 Betreff: RE: informix 11.70 growth edition features [30707] So is the following statement legal or illegal in Workgroup Database db@test; Insert into mytab Select * from db@production:mytab I do not know of a single site that doesn't use that type of SQL from time to time Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Carlton Doe Sent: Friday, June 28, 2013 11:16 AM To: ids@iiug.org Subject: Re: informix 11.70 growth edition features [30705] This restriction also makes sense from a product positioning = perspective. Workgroup Edition, as the name implies, is for environments = with smaller data processing requirements. While logically you can think = of it as an isolated processing environment within a larger enterprise, = I can certainly see some small businesses using it for the entire = processing needs. Workgroup Edition has reduced functionality to meet these types of = reduced requirement workloads *and* to drive price differentiation from = Enterprise Edition. If a data processing environment requires sharing = data between instances through distributed operations, this is an = enterprise-wide environment and should utilize the Enterprise Edition = with all its expanded functionality and scalability. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons were temporarily inconvenienced.=20 On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = wrote: > The "no longer" has me very confused as "I-Star/distributed=20 > operations/distributed SQL/accessing data on different computers" has=20= > always been limited in workgroup, growth and other non-enterprises=20 > editions. I have just double checked the 11.50/11.70/12.10 and they = all=3D=20 >=20 > have this restriction in the license as I believe earlier version of = th=3D=20 > e=20 > non-enterprise product do.=20 >=20 > John F. Miller III=20 > STSM, Lead Architect=20 > miller3@us.ibm.com=20 > 503-747-1366=20 > IBM Informix Dynamic Server (IDS)=20 >=20 > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >=20 >> From: "Paul Watson" <paul@oninit.com>=20 >> To: ids@iiug.org,=20 >> Date: 06/28/2013 07:47 AM=20 >> Subject: RE: informix 11.70 growth edition features [30702]=20 >> Sent by: ids-bounces@iiug.org=20 >>=20 >> I suspect most companies can no longer use the growth/workgroup = editi=3D=20 > on=20 > due=20 >> to this limitation=20 >>=20 >> Cheers=20 >> Paul=20 >>=20 >> -----Original Message-----=20 >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = Of=3D=20 >=20 > Erik=20 >> Stahlhut=20 >> Sent: Friday, June 28, 2013 8:51 AM=20 >> To: ids@iiug.org=20 >> Subject: Re: informix 11.70 growth edition features [30698]=20 >>=20 >> Hi Marcus,=20 >>=20 >> the limitation of distributed query was already prohibited in 11.70.=20= >> Have a look in the license text: http://goo.gl/ymnGK=20 >>=20 >> Cheers=20 >> Erik=20 >>=20 >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>=20 >>> Hi,=20 >>>=20 >>> just to make sure: He is using 11.70 version GE.=20 >>> In 11.70 Release, distributed query was not restricted for growth=20 > edition.=20 >>=20 >>> this is a new=20 >>> limitation that came with 12.x release.=20 >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > don't=20 >>> think=20 >>> so.=20 >>> I would say this is only effective if you upgrade to 12.x, correct =3D= =20 > ?=20 >>> Same for the restrictions of Innovator Edition, which was limited i=3D= =20 > n=20 > disk=20 >>> space=20 >>> in 12.x release.=20 >>>=20 >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= =20 > se=20 >>> questions,=20 >>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>=20 >>> Best regards,=20 >>>=20 >>> Marcus Haarmann=20 >>>=20 >>> ----- Urspr=3DFCngliche Mail -----=20 >>>=20 >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>> An: ids@iiug.org=20 >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>=20 >>> Hello.=20 >>> The previous Growth Edition is now called Workgroup Edition.=20 >>> According to the official doc:=20 >>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= =20 > oe/=20 >>>=20 >>> You might see that parallel operations, partitioning, and distribut=3D= =20 > ed=20 > SQL=20 >>> operations are not allowed.=20 >>>=20 >>> Regards.=20 >>>=20 >>> Alexandre Marini=20 >>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>=20 >>> IBM Information Management Informix Technical Professional=20 >>>=20 >>> IBM Infosphere DataStage Technical Professional=20 >>> Informix Senior DBA - Orizon Brasil=20 >>> BRIUG website administrator=20 >>> Informix independent consultant=20 >>>=20 >>>> To: ids@iiug.org=20 >>>> From: pushpa@cybersoft.lk=20 >>>> Subject: informix 11.70 growth edition features [30695]=20 >>>> Date: Fri, 28 Jun 2013 02:38:07 -0400=20 >>>>=20 >>>> Hi,=20 >>>>=20 >>>> i have installed informix 11.70 growth edition, is there any=20 > possibility=20 >>=20 >>> to=20 >>>> use the remote database query feature and fragment tables feature=3D=20= >=20 > with=20 >>> this=20 >>>> version.=20 >>>>=20 >>>> Thanks=20 >>>> Pushpa=20 >>>>=20 >>>>=20 >>>>=20 >>>=20 >>>=20 >>>=20 >>=20 > = ***********************************************************************=3D= =20 > *****=20 >=20 >> ***=20 >>>> Forum Note: Use "Reply" to pos

I beleive that DML is not mentioned in IBM License Information document for Workgroup: http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B3900 6E4FF8?opendocument&amp;li_select=EF615619D42527C885257B39006E4FF5 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B390 06E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5> In "Prohibited Components" there is only "Distributed Operations" listed (regarding distribution). So I think you are not right - you are not allowed to use ANY distributed operations including SELECT staments.HTH Hrvoje On 1.7.2013. 11:48, Marcus Haarmann wrote: > Hi all, > > Interesting to know. > Yes, the definition was not very clear in the past from my point of view (only > saying something > about I-Star, which is not an active product, but has been in the past), but > in the latest > list, we get a definition: > The ability for a SQL session connected to a database in one instance to > execute a DML operation using data from another database in a different > instance. > > This means, you are allowed to query the foreign instance, but not as part of > a DML, correct ? > So your insert statement would not be allowed, but a select statement, which > includes > e.g. one table from another instance for reference reasons would be allowed ? > > Sample: > unload to "anyfile" > select t1.field1, t2.field2 > from local_table t1, foreign_db@foreign_instance:foreign_table t2 > where t1.id1 = t2.id1 > order by t1.field1;> > Would that one fit in the license restrictions ? > > Thank you all for your opinion. > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Paul Watson" <paul@oninit.com> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 18:45:29 > Betreff: RE: informix 11.70 growth edition features [30707] > > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > >> The "no longer" has me very confused as "I-Star/distributed=20 >> operations/distributed SQL/accessing data on different computers" has=20= >> always been limited in workgroup, growth and other non-enterprises=20 >> editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 >> =20 >> have this restriction in the license as I believe earlier version of = > th=3D=20 >> e=20 >> non-enterprise product do.=20 >> =20 >> John F. Miller III=20 >> STSM, Lead Architect=20 >> miller3@us.ibm.com=20 >> 503-747-1366=20 >> IBM Informix Dynamic Server (IDS)=20 >> =20 >> ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 >> =20 >>> From: "Paul Watson" <paul@oninit.com>=20 >>> To: ids@iiug.org,=20 >>> Date: 06/28/2013 07:47 AM=20 >>> Subject: RE: informix 11.70 growth edition features [30702]=20 >>> Sent by: ids-bounces@iiug.org=20 >>> =20 >>> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 >> on=20 >> due=20 >>> to this limitation=20 >>> =20 >>> Cheers=20 >>> Paul=20 >>> =20 >>> -----Original Message-----=20 >>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 >> =20 >> Erik=20 >>> Stahlhut=20 >>> Sent: Friday, June 28, 2013 8:51 AM=20 >>> To: ids@iiug.org=20 >>> Subject: Re: informix 11.70 growth edition features [30698]=20 >>> =20 >>> Hi Marcus,=20 >>> =20 >>> the limitation of distributed query was already prohibited in 11.70.=20= >>> Have a look in the license text: http://goo.gl/ymnGK=20 >>> =20 >>> Cheers=20 >>> Erik=20 >>> =20 >>> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 >>> =20 >>>> Hi,=20 >>>> =20 >>>> just to make sure: He is using 11.70 version GE.=20 >>>> In 11.70 Release, distributed query was not restricted for growth=20 >> edition.=20 >>> =20 >>>> this is a new=20 >>>> limitation that came with 12.x release.=20 >>>> Does this modify the allowed features in a current 11.70 setup ? I=20= >> don't=20 >>>> think=20 >>>> so.=20 >>>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 >> ?=20 >>>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 >> n=20 >> disk=20 >>>> space=20 >>>> in 12.x release.=20 >>>> =20 >>>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 >> se=20 >>>> questions,=20 >>>> not for new customers but for people using 11.50/11.70 etc. ?=20 >>>> =20 >>>> Best regards,=20 >>>> =20 >>>> Marcus Haarmann=20 >>>> =20 >>>> ----- Urspr=3DFCngliche Mail -----=20 >>>> =20 >>>> Von: "Alexandre Marini" <alexandre@briug.org>=20 >>>> An: ids@iiug.org=20 >>>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 >>>> Betreff: RE: informix 11.70 growth edition features [30696]=20 >>>> =20 >>>> Hello.=20 >>>> The previous Growth Edition is now called Workgroup Edition.=20 >>>> According to the official doc:=20 >>>> http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 >> oe/=20 >>>> =20 >>>> You might see that parallel operations, partitioning, and distribut=3D= > =20 >> ed=20 >> SQL=20 >>>> operations are not allowed.=20 >>>> =20 >>>> Regards.=20 >>>> =20 >>>> Alexandre Marini=20 >>>> IBM Informix Certified Professional v10 / v11.50 / v11.70=20 >>>> =20 >>>> IBM Information Management Informix Technical Professional=20 >>>> =20 >>>> IBM Infosp

HI All, There are several things to look at. There is a difference between*Distributed Database* and *Distributed Processing*; this latter is sometimes called Distributed operations. A *distributed database system* consists of a collection of sites, connected together via some kind of communication network, in which: a. Each site is a full database system site in its own right. b. The sites have agreed to work together so that a user at any site can access data anywhere in the network exactly as if the data were all stored at the user's own site. Informix has 2 concepts: an Instance and a Database. An instance is located totally on a server whether it is physical ot virtual (VMWARE for example). A Database (for Informix of course) is a set of objects (tables, indexes, etc) and is a subset of an instance that can itself have several databases. A database in a fonctional sens can span several servers. This cannot be done in Informix except if you use synonyms. Actually the synonym can point to an external table in a another database located in another instance on another server if we want to. Here is the definition of ISTAR as it was defined a little while ago; is it still the right definition, IBM has to clarify this in a precise manner: *The networking software you need on your server machine. Provides distributed database capabilities including multisite joins and multisite updates with transparent two-phase commit recovery. * That means that you can: - have joins between tables in different sites - have two-phase commits ( single transaction containing UPDATEs , DELETEs or INSERTS to differents databases on different instances: coordinator and participants) So according to this definition, if you join different tables in a single query or you take advantage of a global transaction based on a two-phase commit, you are using ISTAR. Plus it has to be on different sites. Si if you query a table stored on on a different instance on a different site, it is a client/server setup not ISTAR. So one instance is considered the client and the other the server. To me having a *Distributed Database* across different sites whether they are physical or virtual sites should not a breach of contract of the Workgroup Licence . It is the *Distributed Processing* that is not part of the Workgroup Edition (Growth Edition). The question is : is a distributed operation between 2 instances on a single server considered ISTAR? According to the ISTAR definition (see higher) , it is NOT. What if you use *synonyms* that point to other tables located in other databases and other instances, should this be considered a breach of contract of the licence authorized functions. Well, the system resolves the synonyms to the real access path, but if you look at the way you write the syntax, it does not look like you are accessing an external table located in another database on another instance. _*Again, this is a very grey area that needs to be clarified.*_ Plus, I agree with Paul, a lot of customers use INSERT ... SELECT... accross databases on different instances. !!!!!!!!!!!!!! Please find below the software licences contents: -------------------------------------------------------------------------------- -------------------------- The software licenses are as follows: Growth Edition V11.50 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0772187897FA060C8525772D0 082BF24?opendocument&li_select=AB6AE3770248CF238525772D0082BF06> Growth Edition V11.70 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B90 0760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663> Workgroup Edition V12.10 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B390 06E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5> Though the actual text varies, the terms are roughly the same. For example, the text in the V11.50 license says: *2.5) Under a license to the Informix Growth Edition Program, Licensee is not entitled to use any of the following functions:* 2.5.1 - DBSpace Prioritization during backup/restore 2.5.2 - Recovery Time Objective Policy 2.5.3 - Private Memory Cache for VP 2.5.4 - Direct I/O for Cooked Files *2.5.5 - I-STAR* 2.5.6 - Parallel query 2.5.7 - High Performance Loader 2.5.8 - Parallel index build 2.5.9 - Parallel backup/restore 2.5.10 - Table/Index/DBSpace partitioning 2.5.11 - Column level encryption 2.5.12 -- Compression (e.g., the Storage Optimization Feature) -------------------------------------------------------------------------------- -------------------------- Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 28/06/13 19:18, Carlton Doe a écrit : > Illegal. > > A distributed operation is one that occurs between two or more instances. They > can be on the same or different physical / virtual servers. Inter-database > operations (operations between two or more databases) within the same instance > is NOT a distributed operation. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large number > of electrons were temporarily inconvenienced. > > On Jun 28, 2013, at 11:45 AM, "Paul Watson"<paul@oninit.com> wrote: > >> So is the following statement legal or illegal in Workgroup >> >> Database db@test; >> >> Insert into mytab>> >> Select * from db@production:mytab>> >> I do not know of a single site that doesn't use that type of SQL from time >> to time >> >> Cheers >> Paul >> >> -----Original Message----- >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of >> Carlton Doe >> Sent: Friday, June 28, 2013 11:16 AM >> To: ids@iiug.org >> Subject: Re: informix 11.70 growth edition features [30705] >> >> This restriction also makes sense from a product positioning = >> perspective. Workgroup Edition, as the name implies, is for environments = >> with smaller data processing requirements. While logically you can think = >> of it as an isolated processing environment within a larger enterprise, = >> I can certainly see some small businesses using it for the entire = >> processing needs. >> >> Workgroup Edition has reduced functionality to meet these types of = >> reduced requirement workloads *and* to drive price differentiation from = >> Enterprise Edition. If a data processing environment requires sharing = >> data between instances through distributed operations, this is an = >> enterprise-wide environment and should utilize the Enterprise Edition = >> with all its expanded functionality and scalability. >> >> Carlton >> >> -------------------------------------------------@@N

SELECT statements ARE DML! The SQL standard divides all statements into two categories, DDL and DML. Statements that create, destroy, or modify database objects (so modify the system catalog tables) are DDL, everything else is DML. 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 Mon, Jul 1, 2013 at 5:48 AM, Marcus Haarmann <marcus.haarmann@midoco.de>wrote: > Hi all, > > Interesting to know. > Yes, the definition was not very clear in the past from my point of view > (only > saying something > about I-Star, which is not an active product, but has been in the past), > but > in the latest > list, we get a definition: > The ability for a SQL session connected to a database in one instance to > execute a DML operation using data from another database in a different > instance. > > This means, you are allowed to query the foreign instance, but not as part > of > a DML, correct ? > So your insert statement would not be allowed, but a select statement, > which > includes > e.g. one table from another instance for reference reasons would be > allowed ? > > Sample: > unload to "anyfile" > select t1.field1, t2.field2 > from local_table t1, foreign_db@foreign_instance:foreign_table t2 > where t1.id1 = t2.id1 > order by t1.field1;> > Would that one fit in the license restrictions ? > > Thank you all for your opinion. > > Marcus Haarmann > > ----- Ursprüngliche Mail ----- > > Von: "Paul Watson" <paul@oninit.com> > An: ids@iiug.org > Gesendet: Freitag, 28. Juni 2013 18:45:29 > Betreff: RE: informix 11.70 growth edition features [30707] > > So is the following statement legal or illegal in Workgroup > > Database db@test; > > Insert into mytab> > Select * from db@production:mytab> > I do not know of a single site that doesn't use that type of SQL from time > to time > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Carlton Doe > Sent: Friday, June 28, 2013 11:16 AM > To: ids@iiug.org > Subject: Re: informix 11.70 growth edition features [30705] > > This restriction also makes sense from a product positioning = > perspective. Workgroup Edition, as the name implies, is for environments = > with smaller data processing requirements. While logically you can think = > of it as an isolated processing environment within a larger enterprise, = > I can certainly see some small businesses using it for the entire = > processing needs. > > Workgroup Edition has reduced functionality to meet these types of = > reduced requirement workloads *and* to drive price differentiation from = > Enterprise Edition. If a data processing environment requires sharing = > data between instances through distributed operations, this is an = > enterprise-wide environment and should utilize the Enterprise Edition = > with all its expanded functionality and scalability. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large = > number of electrons were temporarily inconvenienced.=20 > > On Jun 28, 2013, at 10:54 AM, John Miller iii <miller3@us.ibm.com> = > wrote: > > > The "no longer" has me very confused as "I-Star/distributed=20 > > operations/distributed SQL/accessing data on different computers" has=20= > > > always been limited in workgroup, growth and other non-enterprises=20 > > editions. I have just double checked the 11.50/11.70/12.10 and they = > all=3D=20 > >=20 > > have this restriction in the license as I believe earlier version of = > th=3D=20 > > e=20 > > non-enterprise product do.=20 > >=20 > > John F. Miller III=20 > > STSM, Lead Architect=20 > > miller3@us.ibm.com=20 > > 503-747-1366=20 > > IBM Informix Dynamic Server (IDS)=20 > >=20 > > ids-bounces@iiug.org wrote on 06/28/2013 07:45:56 AM:=20 > >=20 > >> From: "Paul Watson" <paul@oninit.com>=20 > >> To: ids@iiug.org,=20 > >> Date: 06/28/2013 07:47 AM=20 > >> Subject: RE: informix 11.70 growth edition features [30702]=20 > >> Sent by: ids-bounces@iiug.org=20 > >>=20 > >> I suspect most companies can no longer use the growth/workgroup = > editi=3D=20 > > on=20 > > due=20 > >> to this limitation=20 > >>=20 > >> Cheers=20 > >> Paul=20 > >>=20 > >> -----Original Message-----=20 > >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf = > Of=3D=20 > >=20 > > Erik=20 > >> Stahlhut=20 > >> Sent: Friday, June 28, 2013 8:51 AM=20 > >> To: ids@iiug.org=20 > >> Subject: Re: informix 11.70 growth edition features [30698]=20 > >>=20 > >> Hi Marcus,=20 > >>=20 > >> the limitation of distributed query was already prohibited in 11.70.=20= > > >> Have a look in the license text: http://goo.gl/ymnGK=20 > >>=20 > >> Cheers=20 > >> Erik=20 > >>=20 > >> 2013/6/28 Marcus Haarmann <marcus.haarmann@midoco.de>=20 > >>=20 > >>> Hi,=20 > >>>=20 > >>> just to make sure: He is using 11.70 version GE.=20 > >>> In 11.70 Release, distributed query was not restricted for growth=20 > > edition.=20 > >>=20 > >>> this is a new=20 > >>> limitation that came with 12.x release.=20 > >>> Does this modify the allowed features in a current 11.70 setup ? I=20= > > > don't=20 > >>> think=20 > >>> so.=20 > >>> I would say this is only effective if you upgrade to 12.x, correct =3D= > =20 > > ?=20 > >>> Same for the restrictions of Innovator Edition, which was limited i=3D= > =20 > > n=20 > > disk=20 > >>> space=20 > >>> in 12.x release.=20 > >>>=20 > >>> Any clues on the correct answer ? What is the policy of IBM for the=3D= > =20 > > se=20 > >>> questions,=20 > >>> not for new customers but for people using 11.50/11.70 etc. ?=20 > >>>=20 > >>> Best regards,=20 > >>>=20 > >>> Marcus Haarmann=20 > >>>=20 > >>> ----- Urspr=3DFCngliche Mail -----=20 > >>>=20 > >>> Von: "Alexandre Marini" <alexandre@briug.org>=20 > >>> An: ids@iiug.org=20 > >>> Gesendet: Freitag, 28. Juni 2013 13:24:10=20 > >>> Betreff: RE: informix 11.70 growth edition features [30696]=20 > >>>=20 > >>> Hello.=20 > >>> The previous Growth Edition is now called Workgroup Edition.=20 > >>> According to the official doc:=20 > >>> > http://www.ibm.com/developerworks/data/library/techarticle/dm-0801d=3D= > =20 > > oe/=20 > >>>=20 > >>> You might see that parallel operations, partitioning, and distribut=3D= > =20 > > ed=20 > > SQL=20@

Upps, that would mean a Growth/Workgroup edition could not be part of a XA distributed transaction including other databases on different sites (not necessarily Informix, whatever edition) ? I was thinking that would be only an I-Star function in case the IDS engine itself was the controller of the global transaction, which is established between servers, but initiated by a distributed statement from a client connection to first server. A statement like insert into remote_db@remote_instance:remote_table ...would necessarily start an internal distributed transaction, initiated from the primary server. This is clearly an I-Star functionality. A XA connection only opens up a global transaction, involving possibly many servers, but having a single connection to each of the servers, transaction controlled by an external transaction manager. I-Star has nothing to do in this case. The management of global transactions is not restricted from my point of view. There is not a hint in any documentation. You are right, IBM has to give a better explanation of the restrictions. Well, in the feature comparison list, they restrict this to DML, which would not include just queries from remote sites (no matter if on same hardware or really remote), but it is not clear. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Khaled Bentebal" <khaled.bentebal@consult-ix.fr> An: ids@iiug.org Gesendet: Montag, 1. Juli 2013 13:56:24 Betreff: Re: informix 11.70 growth edition features [30724] HI All, There are several things to look at. There is a difference between*Distributed Database* and *Distributed Processing*; this latter is sometimes called Distributed operations. A *distributed database system* consists of a collection of sites, connected together via some kind of communication network, in which: a. Each site is a full database system site in its own right. b. The sites have agreed to work together so that a user at any site can access data anywhere in the network exactly as if the data were all stored at the user's own site. Informix has 2 concepts: an Instance and a Database. An instance is located totally on a server whether it is physical ot virtual (VMWARE for example). A Database (for Informix of course) is a set of objects (tables, indexes, etc) and is a subset of an instance that can itself have several databases. A database in a fonctional sens can span several servers. This cannot be done in Informix except if you use synonyms. Actually the synonym can point to an external table in a another database located in another instance on another server if we want to. Here is the definition of ISTAR as it was defined a little while ago; is it still the right definition, IBM has to clarify this in a precise manner: *The networking software you need on your server machine. Provides distributed database capabilities including multisite joins and multisite updates with transparent two-phase commit recovery. * That means that you can: - have joins between tables in different sites - have two-phase commits ( single transaction containing UPDATEs , DELETEs or INSERTS to differents databases on different instances: coordinator and participants) So according to this definition, if you join different tables in a single query or you take advantage of a global transaction based on a two-phase commit, you are using ISTAR. Plus it has to be on different sites. Si if you query a table stored on on a different instance on a different site, it is a client/server setup not ISTAR. So one instance is considered the client and the other the server. To me having a *Distributed Database* across different sites whether they are physical or virtual sites should not a breach of contract of the Workgroup Licence . It is the *Distributed Processing* that is not part of the Workgroup Edition (Growth Edition). The question is : is a distributed operation between 2 instances on a single server considered ISTAR? According to the ISTAR definition (see higher) , it is NOT. What if you use *synonyms* that point to other tables located in other databases and other instances, should this be considered a breach of contract of the licence authorized functions. Well, the system resolves the synonyms to the real access path, but if you look at the way you write the syntax, it does not look like you are accessing an external table located in another database on another instance. _*Again, this is a very grey area that needs to be clarified.*_ Plus, I agree with Paul, a lot of customers use INSERT ... SELECT... accross databases on different instances. !!!!!!!!!!!!!! Please find below the software licences contents: -------------------------------------------------------------------------------- -------------------------- The software licenses are as follows: Growth Edition V11.50 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0772187897FA060C8525772D0 082BF24?opendocument&li_select=AB6AE3770248CF238525772D0082BF06> Growth Edition V11.70 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F1336373573852577B90 0760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663> Workgroup Edition V12.10 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257B390 06E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5> Though the actual text varies, the terms are roughly the same. For example, the text in the V11.50 license says: *2.5) Under a license to the Informix Growth Edition Program, Licensee is not entitled to use any of the following functions:* 2.5.1 - DBSpace Prioritization during backup/restore 2.5.2 - Recovery Time Objective Policy 2.5.3 - Private Memory Cache for VP 2.5.4 - Direct I/O for Cooked Files *2.5.5 - I-STAR* 2.5.6 - Parallel query 2.5.7 - High Performance Loader 2.5.8 - Parallel index build 2.5.9 - Parallel backup/restore 2.5.10 - Table/Index/DBSpace partitioning 2.5.11 - Column level encryption 2.5.12 -- Compression (e.g., the Storage Optimization Feature) -------------------------------------------------------------------------------- -------------------------- Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 28/06/13 19:18, Carlton Doe a écrit : > Illegal. > > A distributed operation is one that occurs between two or more instances. They > can be on the same or different physical / virtual servers. Inter-database > operations (operations between two or more databases) within the same instance > is NOT a distributed operation. > > Carlton > > ------------------------------------------------- > Carlton Doe > Flower Mound, TX > > No trees were killed in the transmission of this email, however a large number > of electrons we

It is a lot worse than that :-) I understand why they don't want the Growth/Workgroup/TheNameThisWeek to have the same functionality as Ultimate/Enterprise/TheNameThisWeek. But to restrict the easy movement of data from a production instance to a dev/uat environment ........ Interestingly you can use MySQL to connect to both your Informix Growth/Workgroup/TheNameThisWeek instances and move the data that way. Works just as well with MSSlower as well Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Haarmann Sent: Monday, July 01, 2013 7:44 AM To: ids@iiug.org Subject: Re: informix 11.70 growth edition features [30727] Upps, that would mean a Growth/Workgroup edition could not be part of a XA distributed transaction including other databases on different sites (not necessarily Informix, whatever edition) ? I was thinking that would be only an I-Star function in case the IDS engine itself was the controller of the global transaction, which is established between servers, but initiated by a distributed statement from a client connection to first server. A statement like insert into remote_db@remote_instance:remote_table ...would necessarily start an internal distributed transaction, initiated from the primary server. This is clearly an I-Star functionality. A XA connection only opens up a global transaction, involving possibly many servers, but having a single connection to each of the servers, transaction controlled by an external transaction manager. I-Star has nothing to do in this case. The management of global transactions is not restricted from my point of view. There is not a hint in any documentation. You are right, IBM has to give a better explanation of the restrictions. Well, in the feature comparison list, they restrict this to DML, which would not include just queries from remote sites (no matter if on same hardware or really remote), but it is not clear. Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Khaled Bentebal" <khaled.bentebal@consult-ix.fr> An: ids@iiug.org Gesendet: Montag, 1. Juli 2013 13:56:24 Betreff: Re: informix 11.70 growth edition features [30724] HI All, There are several things to look at. There is a difference between*Distributed Database* and *Distributed Processing*; this latter is sometimes called Distributed operations. A *distributed database system* consists of a collection of sites, connected together via some kind of communication network, in which: a. Each site is a full database system site in its own right. b. The sites have agreed to work together so that a user at any site can access data anywhere in the network exactly as if the data were all stored at the user's own site. Informix has 2 concepts: an Instance and a Database. An instance is located totally on a server whether it is physical ot virtual (VMWARE for example). A Database (for Informix of course) is a set of objects (tables, indexes, etc) and is a subset of an instance that can itself have several databases. A database in a fonctional sens can span several servers. This cannot be done in Informix except if you use synonyms. Actually the synonym can point to an external table in a another database located in another instance on another server if we want to. Here is the definition of ISTAR as it was defined a little while ago; is it still the right definition, IBM has to clarify this in a precise manner: *The networking software you need on your server machine. Provides distributed database capabilities including multisite joins and multisite updates with transparent two-phase commit recovery. * That means that you can: - have joins between tables in different sites - have two-phase commits ( single transaction containing UPDATEs , DELETEs or INSERTS to differents databases on different instances: coordinator and participants) So according to this definition, if you join different tables in a single query or you take advantage of a global transaction based on a two-phase commit, you are using ISTAR. Plus it has to be on different sites. Si if you query a table stored on on a different instance on a different site, it is a client/server setup not ISTAR. So one instance is considered the client and the other the server. To me having a *Distributed Database* across different sites whether they are physical or virtual sites should not a breach of contract of the Workgroup Licence . It is the *Distributed Processing* that is not part of the Workgroup Edition (Growth Edition). The question is : is a distributed operation between 2 instances on a single server considered ISTAR? According to the ISTAR definition (see higher) , it is NOT. What if you use *synonyms* that point to other tables located in other databases and other instances, should this be considered a breach of contract of the licence authorized functions. Well, the system resolves the synonyms to the real access path, but if you look at the way you write the syntax, it does not look like you are accessing an external table located in another database on another instance. _*Again, this is a very grey area that needs to be clarified.*_ Plus, I agree with Paul, a lot of customers use INSERT ... SELECT... accross databases on different instances. !!!!!!!!!!!!!! Please find below the software licences contents: ---------------------------------------------------------------------------- ------------------------------ The software licenses are as follows: Growth Edition V11.50 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/0772187897FA060C85257 72D0082BF24?opendocument&li_select=AB6AE3770248CF238525772D0082BF06> Growth Edition V11.70 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/461F2F133637357385257 7B900760678?opendocument&li_select=1947B9B1AC94F35E852577B900760663> Workgroup Edition V12.10 <http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C0FBB06E64111A1E85257 B39006E4FF8?opendocument&li_select=EF615619D42527C885257B39006E4FF5> Though the actual text varies, the terms are roughly the same. For example, the text in the V11.50 license says: *2.5) Under a license to the Informix Growth Edition Program, Licensee is not entitled to use any of the following functions:* 2.5.1 - DBSpace Prioritization during backup/restore 2.5.2 - Recovery Time Objective Policy 2.5.3 - Private Memory Cache for VP 2.5.4 - Direct I/O for Cooked Files *2.5.5 - I-STAR* 2.5.6 - Parallel query 2.5.7 - High Performance Loader 2.5.8 - Parallel index build 2.5.9 - Parallel backup/restore 2.5.10 - Table/Index/DBSpace partitioning 2.5.11 - Column level encryption 2.5.12 -- Compression (e.g., the Storage Optimization Feature) ---------------------------------------------------------------------------- ------------------------------ Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board