Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2002
    Location
    Pakistan
    Posts
    31

    Unanswered: Deletion of server in ER

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    There appeared to be a connection problem between the servers.
    Is it resolved?
    rws

  3. #3
    Join Date
    Dec 2002
    Location
    Pakistan
    Posts
    31
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Why don't you use the 'cdr stop' command?
    rws

  5. #5
    Join Date
    Dec 2002
    Location
    Pakistan
    Posts
    31
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    It seems to me you have a big problem and I hope you are doing all this on a test platform.
    rws

  7. #7
    Join Date
    Dec 2002
    Location
    Pakistan
    Posts
    31
    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?

  8. #8
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •