Oninit cdi / Archive
Talk to an expert →

RE: Serial Field with Replication

Posted in 2000

Topics: High Availability & Replication, Data Types & Schema Design

Robert Stuart — — source: Informix-list mailing list archive (1991-1998)

Serial by itself does not have to be unique. Can you not use a compound key using site and serial? Where site reflects the machine where the record was created. Individual serial numbers will be duplicated, and there will be holes in the site/serial combination where another site has used the serial number - but holes occur in single site operations where inserts are not committed. -----Original Message----- From: Madison Pruet [mailto:mpruet@home.com] Sent: 21 December 2000 04:28 To: informix-list@iiug.org Subject: Re: Serial Field with Replication Sorry... Enterprise Replication. "Sinha, Niraj" wrote: > Are you guys talking about Enterprise replication or HDR ?? > We have HDR and we have not faced any problem with serial data type, > well, atleast uptill now. > Nirja > > -----Original Message----- > From: Madison Pruet [mailto:mpruet@home.com] > Sent: Wednesday, December 20, 2000 2:20 PM > To: informix-list@iiug.org > Subject: Re: Serial Field with Replication > > Oh yes... We are hoping to address this issue with 9.3... > > Ricardo Manzo wrote: > > > Hi all , > > > > Does anyboby have experience with serial field with a Primary Target > > Replication ? Does it really work? > > I have been tested it with no problem even the Tech Manual adivise to > not > > use serial field with replication . > > > > Thank's! > > > > Ricardo > > ricardo_manzo@hotmail.com > > > ________________________________________________________________________ > _ > > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com.

↪ replying to Robert Stuart
Madison Pruet — — source: Informix-list mailing list archive (1991-1998)

Yes, and this is the recommended method of using serial columns in with ER. Robert Stuart wrote: > Serial by itself does not have to be unique. > > Can you not use a compound key using site and serial? > Where site reflects the machine where the record was created. > > Individual serial numbers will be duplicated, and there will be holes in the > site/serial combination where another site has used the serial number - but > holes occur in single site operations where inserts are not committed. > > -----Original Message----- > From: Madison Pruet [mailto:mpruet@home.com] > Sent: 21 December 2000 04:28 > To: informix-list@iiug.org > Subject: Re: Serial Field with Replication > > Sorry... > > Enterprise Replication. > > "Sinha, Niraj" wrote: > > > Are you guys talking about Enterprise replication or HDR ?? > > We have HDR and we have not faced any problem with serial data type, > > well, atleast uptill now. > > Nirja > > > > -----Original Message----- > > From: Madison Pruet [mailto:mpruet@home.com] > > Sent: Wednesday, December 20, 2000 2:20 PM > > To: informix-list@iiug.org > > Subject: Re: Serial Field with Replication > > > > Oh yes... We are hoping to address this issue with 9.3... > > > > Ricardo Manzo wrote: > > > > > Hi all , > > > > > > Does anyboby have experience with serial field with a Primary Target > > > Replication ? Does it really work? > > > I have been tested it with no problem even the Tech Manual adivise to > > not > > > use serial field with replication . > > > > > > Thank's! > > > > > > Ricardo > > > ricardo_manzo@hotmail.com > > > > > ________________________________________________________________________ > > _ > > > Get Your Private, Free E-mail from MSN Hotmail at > > http://www.hotmail.com.

Glossary