Re: Work group edition - Unlimited edition??
A discussion of what IBM Informix Dynamic Server Workgroup Edition licensing actually permits. Older notes listed limits (2 CPUs, no PDQ, fragmentation, parallel backup/restore/load, ER, >2GB RAM); current IBM licence text also excluded HDR. Paul Watson said his UK IBM licensing contact claimed HDR and ER were allowed if the other servers are licensed, and that standby-server licensing rules changed around 9.40/9.50. The poster then got confirmation from IBM Canada that Workgroup does not allow HDR, so the contradiction stood unresolved. A side question about the 'table level restore' claimed on the Workgroup web page also went unanswered; it isn't in the 9.4 backup/restore manual.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:c5kqv3$2t5eu$1@ID-75254.news.uni-berlin.de... > However IBM site mentions that HDR is not allowed in WGS. I thought they > allowed it in the past. I used it for Sears back in 1998/99. > http://www.google.co.uk/groups?q=Workgroup+++group:comp.databases.informix+author:djw%40smooth1.fsnet.co.uk&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=9vrdkp%24so6%241%40newsg2.svr.pol.co.uk&rnum=3 2 CPU, No fragmentation No PDQ, No Enterprise Replication No Large Memory Support (?? >4Gb) http://www.google.co.uk/groups?q=Workgroup+CPU+group:comp.databases.informix&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=7no4m1%247at%241%40news.xmission.com&rnum=5 Components: You are restricted from using ... PDQ, data partitioning, parallel backup, parallel restore, parallel load, parallel unload, optical disks, advanced replication, VLM (more than 2Gb Ram), Microsoft Cluster Server. Advanced Replication become CDR (Continuous Data Replication) become ER (Enterprise Replication). This information is a bit old though..perhaps things have changed? Can someone from IBM confirm? I found this http://www-306.ibm.com/software/data/informix/ids/workgroup/ but nothing there on the differences between Workgroup and the Full product. > Without replication, there is a question mark on high availability. > Does anyone know other replication methods. Wasn't there a product > which goes for Trigger based replication or something. > > >
"David Williams" <djw@smooth1.fsnet.co.uk> wrote > This information is a bit old though..perhaps things have changed? Can > someone from IBM confirm? Here is the latest information where it is mentioned that HDR is not allowed. http://www-306.ibm.com/common/ssi/OIX.wss?DocURL=http://d03xhttpcl001g.boulder.ibm.com This is the relevant information (somewhere in the middle of the page) ==================================== Informix Dynamic Server Workgroup Editions The following restrictions apply: Server limitation ' You may not install or use the program on a server that has more than two processors. Function limitations ' You may not use the following functions of the program: parallel data query, data partitioning, parallel backup, parallel restore, parallel load, parallel unload, optical disks, Enterprise Replication (ER), High Availability Data Replication (HDR), VML (ability to access more than two GB RAM). ====================================== if anyone from IBM is reading this, this is not a good decision. Without HDR, there is nothing on high availability. I hope they change the decision. rk-
The latest license info I've got from 'Head of UK Understanding of Licensing' is both HDR and ER are allowed under Workgroup, you need to license the other servers correctly. I've also been told that the rules have changed, until 9.40 we were allowed to run HDR/ER on a second server and there was no license requirement as long as the server was only in a 'standby' mode. With 9.40 I can't do this, with 9.50 apparently I can. However, on a Tuesday the rules are ..... :-)))) rkusenet wrote: > > "David Williams" <djw@smooth1.fsnet.co.uk> wrote > > > This information is a bit old though..perhaps things have changed? Can > > someone from IBM confirm? > > Here is the latest information where it is mentioned that HDR is not allowed. > > http://www-306.ibm.com/common/ssi/OIX.wss?DocURL=http://d03xhttpcl001g.boulder.ibm.com > > This is the relevant information (somewhere in the middle of the page) > > ==================================== > Informix Dynamic Server Workgroup Editions > The following restrictions apply: > Server limitation ' You may not install or use the program on > a server that has more than two processors. > Function limitations ' You may not use the following functions > of the program: parallel data query, data partitioning, parallel > backup, parallel restore, parallel load, parallel unload, > optical disks, Enterprise Replication (ER), > High Availability Data Replication (HDR), > VML (ability to access more than two GB RAM). > ====================================== > > if anyone from IBM is reading this, this is not a good decision. Without > HDR, there is nothing on high availability. I hope they change the decision. > > rk- -- 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 > The latest license info I've got from 'Head of UK Understanding > of Licensing' is both HDR and ER are allowed under Workgroup, you need > to license the other servers correctly. > > I've also been told that the rules have changed, until 9.40 we were > allowed to run HDR/ER on a second server and there was no license > requirement as long as the server was only in a 'standby' mode. > With 9.40 I can't do this, with 9.50 apparently I can. However, on > a Tuesday the rules are ..... :-)))) In the past Informix always use to charge license fee for both primary and secondary server in a HDR setup.. Only on clustered environment, where one instance is cold (that is not running), is the licensing limited to only one node. However HDR is very important for us, otherwise it is not considering. rk-
In the pre-IBM days I was always charged for the primary license, no secondary license, support on the primary and 50% support for the secondary. When IBM took over the support costs dropped to the primary support only. [This assumes the secondary is in stand-by] rkusenet wrote: > > "Paul Watson" <paul@oninit.com> wrote > > > The latest license info I've got from 'Head of UK Understanding > > of Licensing' is both HDR and ER are allowed under Workgroup, you need > > to license the other servers correctly. > > > > I've also been told that the rules have changed, until 9.40 we were > > allowed to run HDR/ER on a second server and there was no license > > requirement as long as the server was only in a 'standby' mode. > > With 9.40 I can't do this, with 9.50 apparently I can. However, on > > a Tuesday the rules are ..... :-)))) > > In the past Informix always use to charge license fee for both primary > and secondary server in a HDR setup.. Only on clustered environment, > where one instance is cold (that is not running), is the licensing > limited to only one node. > > However HDR is very important for us, otherwise it is not considering. > > rk- -- 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 #
> I found this > http://www-306.ibm.com/software/data/informix/ids/workgroup/ Following this link it states table level restore. I thought the only way a table level restore was possible is by putting the table in its own dbspace. Does IDS now have a true table level restore? -Peter
I've just read that too. I am very interested in this possibility. It also says that the enterprise edition offers all workgroup features plus ... Does anybody know where the document is that shows what has changed for the new release? Malcolm pjddl@yahoo.com (Peter) wrote in message news:<970ddfc5.0404151405.755a9ce2@posting.google.com>... > > I found this > > http://www-306.ibm.com/software/data/informix/ids/workgroup/ > > Following this link it states table level restore. I thought the only > way a table level restore was possible is by putting the table in its > own dbspace. Does IDS now have a true table level restore? > > -Peter
I have just scanned the 9.4 backup and restore guide. It doesn't mention doing a table level restore. Also, carlton doesn't mention it in the white paper, and there is no mention in the spec sheet. That doesn't mean the feature isn't there, but it does mean that it is unlikely. Sad ----:-( malcolm pjddl@yahoo.com (Peter) wrote in message news:<970ddfc5.0404151405.755a9ce2@posting.google.com>... > > I found this > > http://www-306.ibm.com/software/data/informix/ids/workgroup/ > > Following this link it states table level restore. I thought the only > way a table level restore was possible is by putting the table in its > own dbspace. Does IDS now have a true table level restore? > > -Peter
"Paul Watson" <paul@oninit.com> wrote > The latest license info I've got from 'Head of UK Understanding > of Licensing' is both HDR and ER are allowed under Workgroup, you need > to license the other servers correctly. > > I've also been told that the rules have changed, until 9.40 we were > allowed to run HDR/ER on a second server and there was no license > requirement as long as the server was only in a 'standby' mode. > With 9.40 I can't do this, with 9.50 apparently I can. However, on > a Tuesday the rules are ..... :-)))) I got it confirmed from IBM Canada. Workgroup edition does not allow HDR replication. You might want to double check with your source in IBM-England. BTW is it possible for us to buy from IBM UK and use replication :-) rk-