 |
|
| Computers Forum Index » Computer - Databases - Informix » How to delete Enterprise Replication... |
|
Page 1 of 1 |
|
| Author |
Message |
| MADS... |
 Posted: Thu Oct 22, 2009 6:10 pm |
|
|
|
Guest
|
Hi everybody!
A client, LONG time ago, configured Enterprise Replication from a main
server to a test server. After they finished their tests, they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test
server doesn't even exist. I tried several cdr commands (cdr remove,
cdr delete server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance! |
|
|
| Back to top |
|
|
|
| Jarrod Teale... |
| Posted: Fri Oct 23, 2009 12:10 am |
|
|
|
Guest
|
Drop the syscdr database on both ends
-----Original Message-----
From: informix-list-bounces at (no spam) iiug.org
[mailto:informix-list-bounces at (no spam) iiug.org] On Behalf Of MADS
Sent: Friday, 23 October 2009 7:11 a.m.
To: informix-list at (no spam) iiug.org
Subject: How to delete Enterprise Replication
Hi everybody!
A client, LONG time ago, configured Enterprise Replication from a main
server to a test server. After they finished their tests, they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test server
doesn't even exist. I tried several cdr commands (cdr remove, cdr delete
server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance!
_______________________________________________
Informix-list mailing list
Informix-list at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
DISCLAIMER:
This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email.
You may not use, disclose or copy this email or its attachments in any way.
Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group.
http://www.fonterra.com/ |
|
|
| Back to top |
|
|
|
| Plugge, Joe R.... |
| Posted: Fri Oct 23, 2009 12:33 am |
|
|
|
Guest
|
You may have to bring down the engine and then bring it back up using oninit -D, which prevents the replication treads from starting, then you should be able to drop the syscdr database. Then depending on how tangled up it was, you may have to grind through each database and make sure that there are no cdr_deltab_xxxxx tables, if there are, drop them.
You can then bounce the engine again, restarting normally.
-----Original Message-----
From: informix-list-bounces at (no spam) iiug.org [mailto:informix-list-bounces at (no spam) iiug.org] On Behalf Of Jarrod Teale
Sent: Thursday, October 22, 2009 3:10 PM
To: MADS; informix-list at (no spam) iiug.org
Subject: RE: How to delete Enterprise Replication
Drop the syscdr database on both ends
-----Original Message-----
From: informix-list-bounces at (no spam) iiug.org
[mailto:informix-list-bounces at (no spam) iiug.org] On Behalf Of MADS
Sent: Friday, 23 October 2009 7:11 a.m.
To: informix-list at (no spam) iiug.org
Subject: How to delete Enterprise Replication
Hi everybody!
A client, LONG time ago, configured Enterprise Replication from a main
server to a test server. After they finished their tests, they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test server
doesn't even exist. I tried several cdr commands (cdr remove, cdr delete
server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance!
_______________________________________________
Informix-list mailing list
Informix-list at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
DISCLAIMER:
This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email.
You may not use, disclose or copy this email or its attachments in any way.
Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group.
http://www.fonterra.com/
_______________________________________________
Informix-list mailing list
Informix-list at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list |
|
|
| Back to top |
|
|
|
| mpruet... |
| Posted: Fri Oct 23, 2009 3:07 am |
|
|
|
Guest
|
On Oct 22, 11:10 am, MADS <mdapo... at (no spam) gmail.com> wrote:
Quote: Hi everybody!
A client, LONG time ago, configured Enterprise Replication from a main
server to a test server. After they finished their tests, they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test
server doesn't even exist. I tried several cdr commands (cdr remove,
cdr delete server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance!
cdr delete server --force <server_name>
cdr remove (if using 9.4).
If you just drop syscdr, then you are not going to get the automatic
cleanup of all of the internal tables.
M.P. |
|
|
| Back to top |
|
|
|
| ... |
| Posted: Fri Oct 23, 2009 5:15 am |
|
|
|
Guest
|
you can also do
cdr delete server |
|
|
| Back to top |
|
|
|
| Habichtsberg, Reinhard... |
| Posted: Fri Oct 23, 2009 12:34 pm |
|
|
|
Guest
|
"cdr start [-c prodserver]" on the production server? Should start without
any replication partner active. Afterwards the other commands should work.
HTH, Reinhard.
Quote: -----Original Message-----
From: informix-list-bounces at (no spam) iiug.org
[mailto:informix-list-bounces at (no spam) iiug.org]On Behalf Of mpruet
Sent: Friday, October 23, 2009 5:08 AM
To: informix-list at (no spam) iiug.org
Subject: Re: How to delete Enterprise Replication
On Oct 22, 11:10 am, MADS <mdapo... at (no spam) gmail.com> wrote:
Hi everybody!
A client, LONG time ago, configured Enterprise Replication
from a main
server to a test server. After they finished their tests,
they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test
server doesn't even exist. I tried several cdr commands (cdr remove,
cdr delete server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance!
cdr delete server --force <server_name
cdr remove (if using 9.4).
If you just drop syscdr, then you are not going to get the automatic
cleanup of all of the internal tables.
M.P.
_______________________________________________
Informix-list mailing list
Informix-list at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
|
|
|
| Back to top |
|
|
|
| MADS... |
| Posted: Fri Oct 23, 2009 2:14 pm |
|
|
|
Guest
|
Thanks to all for your advice.
I'll ask the client to schedule a downtime this Sunday and will test
your advices...
On Oct 22, 2:10 pm, MADS <mdapo... at (no spam) gmail.com> wrote:
Quote: Hi everybody!
A client, LONG time ago, configured Enterprise Replication from a main
server to a test server. After they finished their tests, they stopped
the replication and did nothing else.
Now, years later, I have to alter a replicated table, I get
19989: Enterprise Replication is not in active state
The replication can not be started, due to the fact that the test
server doesn't even exist. I tried several cdr commands (cdr remove,
cdr delete server, cdr delete replicateset) , but I only get
command failed -- Enterprise Replication not active (62)
How can I drop the replication for good?
Thanks in advance! |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Sat Nov 28, 2009 9:46 pm
|
|