2 Replies Latest reply: Aug 21, 2012 2:18 PM by 930542 RSS

    Expected output from ttreplicationstatus and ttRepAdmin command

    930542
      Hi:

      I was trying out ttreplicationstatus to check the state of the subscriber database with respect to its master
      I've 4 nodes in the replication scheme. ttnode1,ttnode2,ttnode3,ttnode4

      Even when the subscribe agents at ttnode4 is stoppped, the status at the master(ttnode1) shows "start". Shouldn't the state be "stop".

      At ttnode4
      -----------
      Command> call ttrepstop();
      12027: The agent is already stopped for the data store.
      The command failed.
      Command>


      At ttnode1
      -----------
      Command> call ttreplicationstatus();
      < USR_TT_1122, ttnode2, 0, start , 1, 2, userrep , appadm >
      < USR_TT_1122, ttnode3, 0, start , 1, 2, userrep , appadm >
      < USR_TT_1122, ttnode4, 0, start , 1, 328, userrep , appadm >
      3 rows found.


      Even the ttRepAdmin command at ttnode1 shows the state as "start".

      [timesten@ttnode1 bin]$ ./ttRepAdmin -dsn USR_TT_1122 -receiver -list -scheme appadm.userrep
      Peer name Host name Port State Proto Track
      ---------------- ------------------------ ------ ------- ----- -----
      USR_TT_1122 ttnode2                         Auto Start 35 0

      Last Msg Sent Last Msg Recv Latency TPS RecordsPS Logs
      ------------- ------------- ------- ------- --------- ----
      00:00:02 00:00:01 -1.00 -1 -1 1


      Peer name Host name Port State Proto Track
      ---------------- ------------------------ ------ ------- ----- -----
      USR_TT_1122 ttnode3                     Auto Start 35 0

      Last Msg Sent Last Msg Recv Latency TPS RecordsPS Logs
      ------------- ------------- ------- ------- --------- ----
      00:00:02 00:00:00 -1.00 -1 -1 1


      Peer name Host name Port State Proto Track
      ---------------- ------------------------ ------ ------- ----- -----
      USR_TT_1122 ttnode4                     Auto Start 35 0

      Last Msg Sent Last Msg Recv Latency TPS RecordsPS Logs
      ------------- ------------- ------- ------- --------- ----
      00:02:01 - -1.00 -1 -1 1


      Is my understanding correct ? I waited long enough before checking the status.

      thanks
      vgs