IDS Forum

Re: informix 11.70 growth edition features

Posted By: Art Kagel
Date: Friday, 28 June 2013, at 2:54 p.m.

In Response To: RE: informix 11.70 growth edition features (Paul Watson)

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

Messages In This Thread

• informix 11.70 growth edition features
  PUSHPA KUMARA -- Friday, 28 June 2013, at 2:38 a.m.
  • RE: informix 11.70 growth edition features
    Alexandre Marini -- Friday, 28 June 2013, at 7:24 a.m.
    • Re: informix 11.70 growth edition features
      Marcus Haarmann -- Friday, 28 June 2013, at 7:41 a.m.
      • Re: informix 11.70 growth edition features
        Erik Stahlhut -- Friday, 28 June 2013, at 9:51 a.m.
        • Re: informix 11.70 growth edition features
          Marcus Haarmann -- Friday, 28 June 2013, at 10:14 a.m.
          • Re: informix 11.70 growth edition features
            Art Kagel -- Friday, 28 June 2013, at 10:22 a.m.
        • RE: informix 11.70 growth edition features
          Paul Watson -- Friday, 28 June 2013, at 10:45 a.m.
          • RE: informix 11.70 growth edition features
            John Miller iii -- Friday, 28 June 2013, at 11:54 a.m.
            • Re: informix 11.70 growth edition features
              Carlton Doe -- Friday, 28 June 2013, at 12:16 p.m.
              • RE: informix 11.70 growth edition features
                Paul Watson -- Friday, 28 June 2013, at 12:45 p.m.
                • Re: informix 11.70 growth edition features
                  Carlton Doe -- Friday, 28 June 2013, at 1:18 p.m.
                  • RE: informix 11.70 growth edition features
                    Paul Watson -- Friday, 28 June 2013, at 2:10 p.m.
                  • Re: informix 11.70 growth edition features
                    Khaled Bentebal -- Monday, 1 July 2013, at 7:56 a.m.
                    • Re: informix 11.70 growth edition features
                      Marcus Haarmann -- Monday, 1 July 2013, at 8:43 a.m.
                      • RE: informix 11.70 growth edition features
                        Paul Watson -- Monday, 1 July 2013, at 9:29 a.m.
                • RE: informix 11.70 growth edition features
                  John Miller iii -- Friday, 28 June 2013, at 1:57 p.m.
                • Re: informix 11.70 growth edition features
                  Art Kagel -- Friday, 28 June 2013, at 2:56 p.m.
                  • Re: informix 11.70 growth edition features
                    Erik Stahlhut -- Saturday, 29 June 2013, at 7:38 a.m.
                • Re: informix 11.70 growth edition features
                  Marcus Haarmann -- Monday, 1 July 2013, at 5:48 a.m.
                  • Re: informix 11.70 growth edition features
                    Hrvoje Zokovic -- Monday, 1 July 2013, at 7:48 a.m.
                  • Re: informix 11.70 growth edition features
                    Art Kagel -- Monday, 1 July 2013, at 8:35 a.m.
            • RE: informix 11.70 growth edition features
              Paul Watson -- Friday, 28 June 2013, at 12:35 p.m.
              • Re: informix 11.70 growth edition features
                Art Kagel -- Friday, 28 June 2013, at 2:54 p.m.
  • Re: informix 11.70 growth edition features
    Art Kagel -- Friday, 28 June 2013, at 10:05 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.