Hi

I want to delete server in ER but it is not deleted. I'm using following command

cdr del serv sprim

command is taking so much time but not compeleted so I interrupted.
following is log file:

05:13:41 CDR GC: catalog recovery complete
05:13:41 CDR queuer initialization complete
05:13:41 DDR Log Snooping - Snooping started in log 152
05:13:41 CDR connection to server lost, id 8, name <sdev>
Reason: Connect failed reason: 7
05:14:59 CDR GC: WARNING delete server operation will not be broadcast
05:14:59 CDR NIF Shutdown: connections all shutdown.
05:14:59 CDR The NIF sub-component has shut down.

Before that i have used this command so many times successfully.



best regards

wicky

There appeared to be a connection problem between the servers.
Is it resolved?

I have deleted the gdev server.

There is no connection problem both server are ping to each other.

I summrize again, there are two server

prim gprim
sec gsec

I have successfully implemented ER on both of them successfully. I just want to drop the er.

So i gave the following commands

cdr del serv gsec (on sec server) successfully run
cdr del gprim (on prim server) it is not executed.

best regards

wicky

Why don't you use the 'cdr stop' command?

Hi

When i try to stop or del the server it gives the following error

Enterpise replication is not active (62).

When i try to re-create server it gives the following error

Enterpise replication is already active (63).

best regards

wicky

It seems to me you have a big problem and I hope you are doing all this on a test platform.

The database server is working fine there is no problem at its functionality.
It is running for last 5 days.

Is there any way to resolve this problem?

This is how we do it, without problems.
an example:
When deleting servers from ER, you need to run the 'cdr delete server' twice.
The first cdr delete server removes the ER server on the local host and removes
the ER connection to other hosts. The second cdr delete server removes the ER
server from all the other ER hosts.

Here's an example:

3 servers in an ER. Corp_svr, East_svr and West_svr
Corp_svr belongs to the group grp_corp
East_svr belongs to the group grp_east
West_svr belongs to the group grp_west

East and West servers are Synchronzied to Corp server.

To delete the East server from this ER, you need to run the following:

cdr delete server grp_east <--- this deletes the server 'grp_east' (which
contains east_svr) on the local host.

then run:

cdr delete server -c grp_corp grp_east <---- this deletes the server
'grp_east' (which contains east_svr) from the remaining replication host being
grp_corp (which contains corp_svr).

For further information, please have a read through the 'cdr delete server'
command in the Guide to Informix Enterprise Replication. The version I was
referring to was Version 9.2. The pages in particular to deleting servers is
found on pages 11-40 and 12-22. On both pages it explains why the cdr delete
server command must be run twice. I think this was the initial reason why the
syscdr database didn't get deleted from the server. It was only deleted on one
of the two servers.