Replication
A DBA asked whether Enterprise Replication (ER) in IDS 11.50.FC5 still requires tables to have primary keys, and whether any release lifts that requirement. The consensus answer: yes, primary keys are still required, and no generally available IDS release removes the requirement. An IBM developer (Madison Pruet) explained why: ER uses the primary key as a global row identifier so the same row can be matched on every participating node, so some key is unavoidable. Question answered; no workaround discussed.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone know if you still have to use primary keys if using ER in v11.50.fc5? If so, is there a release where it is no longer a requirement. Thanks in advance for any info.... Peter Logan Senior Database Administrator Phone: 616/878-8309
Peter_Logan@spartanstores.com wrote: > Does anyone know if you still have to use primary keys if using ER in > v11.50.fc5? If so, is there a release where it is no longer a > requirement. Thanks in advance for any info.... Yes, you still do. No, I don't think there is a version where this requirement goes away. As far as I know, it's a pretty integral part of ER, and there aren't any plans for it to change. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
That is what I thought ... was just thinking somewhere I had heard that this might go away ... Thanks again ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: ids@iiug.org Date: 07/20/2010 08:34 AM Subject: Re: Replication [20591] Sent by: ids-bounces@iiug.org Peter_Logan@spartanstores.com wrote: > Does anyone know if you still have to use primary keys if using ER in > v11.50.fc5? If so, is there a release where it is no longer a > requirement. Thanks in advance for any info.... Yes, you still do. No, I don't think there is a version where this requirement goes away. As far as I know, it's a pretty integral part of ER, and there aren't any plans for it to change. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Peter_Logan@spartanstores.com wrote: > That is what I thought ... was just thinking somewhere I had heard that > this might go away ... Thanks again ... I could be wrong, of course! It has happened once or twice before :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
The answer is, there is no Informix Dynamic Server version that is CURRENTLY AVAILABLE IN GENERAL RELEASE that does not require a primary key for ER replication. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Tue, Jul 20, 2010 at 8:31 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Does anyone know if you still have to use primary keys if using ER in > v11.50.fc5? If so, is there a release where it is no longer a > requirement. Thanks in advance for any info.... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0022152d5fd1d6e006048bd12489
Nice way of putting it :) On Tue, Jul 20, 2010 at 1:51 PM, Art Kagel <art.kagel@gmail.com> wrote: > The answer is, there is no Informix Dynamic Server version that is > CURRENTLY > AVAILABLE IN GENERAL RELEASE that does not require a primary key for ER > replication. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > 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 Tue, Jul 20, 2010 at 8:31 AM, Peter_Logan@spartanstores.com < > Peter_Logan@spartanstores.com> wrote: > > > Does anyone know if you still have to use primary keys if using ER in > > v11.50.fc5? If so, is there a release where it is no longer a > > requirement. Thanks in advance for any info.... > > > > Peter Logan > > Senior Database Administrator > > Phone: 616/878-8309 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0022152d5fd1d6e006048bd12489 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e6567fb06aae97048bd3bcc0
We use the primary key to act as a global rowid. We have to have somet= hing to identify the row on each of the nodes and that is what the primary k= ey is used for. So yes - we have to have a key in order to identify the ro= w. M.P. = = From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore= s.com> = = = To: ids@iiug.org = = = = Date: 07/20/2010 07:31 AM = = = = Subject: Replication [20590] = = = = Sent by: ids-bounces@iiug.org = = = = Does anyone know if you still have to use primary keys if using ER in v11.50.fc5? If so, is there a release where it is no longer a requirement. Thanks in advance for any info.... Peter Logan Senior Database Administrator Phone: 616/878-8309 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =