replicating databases in the same instance
The poster asked whether Enterprise Replication can replicate selected tables between two databases living in the same Informix instance, after getting "duplicate server or replicate (53)". His reason: two databases formerly on separate machines/instances had been merged into one instance, and he wanted replication as a stopgap so the application wouldn't have to be repointed. Madison Pruet answered that ER cannot do this — you'd need triggers to copy rows to another table in the same instance. Keith Simmons suggested synonyms as the simpler fix for the pointing problem.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone know if you can replicate databases in the same instance ? From the mesage i am getting it looks like you cant see error message below replicate: res_accept_survey command failed -- duplicate server or replicate (53) there is no replicate of that name so I assume that it refers to the server name being duplicate
I don't see how you could replicate databases in the same instance unless they shared the same dbspaces because everything has to be the same. That being the case, what would it buy you to have 2 databases using the same space? > To: ids@iiug.org > From: karl.oliver@maf.govt.nz > Subject: replicating databases in the same instance [19899] > Date: Tue, 27 Apr 2010 16:50:06 -0400 > > Does anyone know if you can replicate databases in the same instance ? > >From the mesage i am getting it looks like you cant > see error message below > > replicate: res_accept_survey > command failed -- duplicate server or replicate (53) > > there is no replicate of that name so I assume that it refers to the server > name being duplicate > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I forgot to say we are using enterprise replication and only want to replicate some tables
On 27 April 2010 21:50, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > Does anyone know if you can replicate databases in the same instance ? > >From the mesage i am getting it looks like you cant > see error message below > > replicate: res_accept_survey > command failed -- duplicate server or replicate (53) > > there is no replicate of that name so I assume that it refers to the server > name being duplicate > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > I'm not sure the question is 'can you' as much as 'why would you want to'? What are your trying to achive by holding your data twice in the same place? Keith
no. You would need to use triggers to replicate to another table on the sam= e instance. = From: "KARL OLIVER" <karl.oliver@maf.govt.nz> = = To: ids@iiug.org = = Date: 04/27/2010 03:50 PM = = Subject: replicating databases in the same instance [19899] = = Sent by: ids-bounces@iiug.org = = Does anyone know if you can replicate databases in the same instance ? >From the mesage i am getting it looks like you cant see error message below replicate: res_accept_survey command failed -- duplicate server or replicate (53) there is no replicate of that name so I assume that it refers to the se= rver name being duplicate ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
why we wnat to replicate tin the same instance is because we had the 2 databases in diffrent instances on diffrent unix machines in diffrent zones. One inside the firewall one outside the fire wall. We have merged the databases into one instance on one machine.Howevber the application still ponting to the datbase that was inside the firewall. So as a temp measure we wanted to replicate some tables to save changing the application to point at the other database
thanks for that information Madison
Karl Synonyms would seem to be the solution for which you are searching. Keith On 28 April 2010 21:29, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > why we wnat to replicate tin the same instance is because we had the 2 > databases in diffrent instances on diffrent unix machines in diffrent zones. > One inside the firewall one outside the fire wall. > We have merged the databases into one instance on one machine.Howevber the > application still ponting to the datbase that was inside the firewall. So as a > temp measure we wanted to replicate some tables to save changing the > application to point at the other database > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >