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.
This is how we do it, without problems.
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.
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.