Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: informix 11.70 growth edition features

Posted By: John Miller iii
Date: Friday, 28 June 2013, at 1:57 p.m.

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

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
> >>>>=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
>
>
****************************************************************************

> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.