Workgroup Edition or Enterprise
Question: how to tell whether a running Informix instance is Workgroup or Enterprise Edition. Replies said there's no reliable way from the engine itself — you check the licence/media or ask IBM. Suggested practical test: try creating a fragmented table, since Workgroup Edition doesn't support fragmentation. Posters disagreed on what actually differs: one said IBM claims the binaries are identical and only the licence differs, another claimed PDQ is absent, and a final post clarified PDQ is available in all engines while fragmentation is the real restriction. No definitive resolution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
How can I tell if I'm running Workgroup or Enterprise edition?
AFAIK you can't you need to check with IBM to see what the license is (or look on the label on the media) Jay B wrote: > > How can I tell if I'm running Workgroup or Enterprise edition? -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #
"Paul Watson" <paul@oninit.com> wrote in message news:3FBBAB25.9B99B35@oninit.com... > AFAIK you can't you need to check with IBM to see what the license > is (or look on the label on the media) > > Jay B wrote: > > > > How can I tell if I'm running Workgroup or Enterprise edition? > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com # Try to create a fragmented table and you get errors on the Workgroup Edition since it does not support using fragmentation!
David Williams wrote: > "Paul Watson" <paul@oninit.com> wrote in message > news:3FBBAB25.9B99B35@oninit.com... > >>AFAIK you can't you need to check with IBM to see what the license >>is (or look on the label on the media) >> >>Jay B wrote: >> >>>How can I tell if I'm running Workgroup or Enterprise edition? >> >>-- >>Paul Watson # >>Oninit Ltd # Growing old is mandatory >>Tel: +44 1436 672201 # Growing up is optional >>Fax: +44 1436 678693 # >>Mob: +44 7818 003457 # >>www.oninit.com # > > > Try to create a fragmented table and you get errors on the Workgroup Edition > since > it does not support using fragmentation! > > Have you actually tried that? IBM tells me that the only difference is in the license agreement and the code is the same. Regards, Michael
Nope. Between other features, PDQ is not available. "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> a 'crit dans le message de news:3FBC0B9C.5030103@sqlcanada.com... > David Williams wrote: > > "Paul Watson" <paul@oninit.com> wrote in message > > news:3FBBAB25.9B99B35@oninit.com... > > > >>AFAIK you can't you need to check with IBM to see what the license > >>is (or look on the label on the media) > >> > >>Jay B wrote: > >> > >>>How can I tell if I'm running Workgroup or Enterprise edition? > >> > >>-- > >>Paul Watson # > >>Oninit Ltd # Growing old is mandatory > >>Tel: +44 1436 672201 # Growing up is optional > >>Fax: +44 1436 678693 # > >>Mob: +44 7818 003457 # > >>www.oninit.com # > > > > > > Try to create a fragmented table and you get errors on the Workgroup Edition > > since > > it does not support using fragmentation! > > > > > > Have you actually tried that? IBM tells me that the only difference > is in the license agreement and the code is the same. > > Regards, > > Michael >
Olmedo Monteverde wrote: > Nope. Between other features, PDQ is not available. Actually, I think it's more subtle than that - Fragmented tables are not available, but PDQ is. Fragmented tables are the premier beneficiary of PDQ with large queries, however PDQ does have other uses, and is available for all engines. It's a common misconception that PDQ means fragmented tablesm but in fact they are really two separate features.