Does anybody have experience with v10 of Workgroup Edition? Now
that HDR is available as a Workgroup option, we are looking at
saving a LOT of money by migrating down from Enterprise.

Is it the same core engine? Will I have the same performance?
What besides ER (which we don't use) will I be giving up?

Thanks,

--
Jeff
jlar310 at yahoo

"Jeff" <nobody@localhost> wrote

I started off answering this by saying confidentally that I think the code
streams are identical, and that you are left *not* to use the precluded
functionality on an honour basis. Certainly I just checked a PPA download
site for one of my customers who has both Enterprise and Workgroup and there
is not a separate download for the latter. But also I recall some while
back being unable to allocate more than 4 cpu vps with a Workgroup
download - perhaps it was the IIUG freebie. So now I'm not certain!

Anyway you shouldn't use IDS in contravention of its terms because IBM has a
zealous Compliance programme, as is its right.

To answer your question: I have lots of experience in multiple customer
sites, and it's fine so long as you can do without parallel backups and
parallel queries. Typically then this favours small-to-medium database
servers and OLTP applications.

It might also be thought that 4 processor cores and 8g memory - the IDS v10
Workgroup infrastructure limit - is getting a little restrictive the way
hardware is going.

I'm interested to know how you'll save money by "trading down". You can't
get a refund on the Enterprise licences you presumably already own.

On Jun 19, 5:59 am, "Neil Truby" <neil.tr... (AT) ardenta (DOT) com> wrote:

Niel,

I think that with IDS 10 Workgroup, you can use parallel backup/
restore and parallel queries, at least acording to some Redbook I've
read.

It would be bad if there was a limitation of 4 CPU VPs. For example,
with newer SPARCs, there is a need to allocate multiple CPU VPs per
physical CPU to use all the CPU power available.

Darko Krstic

Neil Truby wrote:

The annual support will be cheaper. I don't really know if you can exchange
existing licenses...

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Fernando Nunes wrote:
As it turned out, it will not save any money. Yes the support
would save us money, but it would take many years to make back
the expense of re-purchasing initial licenses. The hardware
limits of Workgroup would not have been a problem for us. We are
a smallish company with pretty basic OLTP needs.

I guess I'll just keep waiting for the day when I can feel
comfortable migrating to an open source database...

"Jeff" <nobody@localhost> wrote

Usually the maintenance renewal cost of EE licence is the same as the cost
of buying a new WGE one, so it might be cost-neutral in year one at best,
but you should be quids in by year two.

Does a smallish company with pretty basic OLTP needs really need a box with
more than 4 cores and 8g of memory?