On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,579 Users
  • 2,269,760 Discussions
  • 7,916,784 Comments

Discussions

interpreting the ttRepAdmin -showstatus command

2884167
2884167 Member Posts: 5
edited May 22, 2016 5:10AM in TimesTen In-Memory Database

The ttRepAdmin -showstatus command seems to show different and inconsistent results compared to "ttRepAdmin -dsn <DSNNAME> -receiver -list".

We are running timesten in a 4-way classic replication environment, ttversion is "TimesTen Release 11.2.1.9.0 (64 bit Linux/x86_64)"

Why would "ttRepAdmin -showstatus"  show  "Connected"  but "Paused", with additional Entries referencing "PORT 0" when the ttRepAdmin Receiver List command shows all four replication nodes are in "START" status. ?  

e.g. here is an excerpt:showing "PAUSED", and references to PORT 0".

What does PORT 0 mean ?

Replication Peers:

   Name                     : DEG20_DSN_TT

   Host                     : LENXKSDEG-MGMTB3

   Port                     : 17022  (Connected)

   Replication State        : PAUSED

   Communication Protocol   : 29

      Host                     : LESMMODEG-MGMTB4

   Port                     : 0

   Replication State        : STARTED

   Communication Protocol   : 29

   Name                     : DEG20_DSN_TT

   Host                     : LESMMODEG-MGMTB3

   Port                     : 0

   Replication State        : STARTED

   Communication Protocol   : 29

Answers

  • ChrisJenkins-Oracle
    ChrisJenkins-Oracle Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
    edited May 18, 2016 6:17AM

    Can you please post the complete output from both commands plus the full replication scheme definition (i.e. the CREATE REPLICATION statement).

    Thanks,

    Chris

  • 2884167
    2884167 Member Posts: 5
    edited May 19, 2016 1:11PM

    -- Output of ShowStatus command on LENXKSDEG-MGMTB4.

    Note: this shows REPLICATION STATE=PAUSED for hosts LENXKSDEG-MGMTB3 and LENXKSDEG-MGMTB3

    and also shows additional entries with REPLICATION STATE=STARTED but PORT=0 for hosts LESMMODEG-MGMTB4 and LESMMODEG-MGMTB3

    Why is PORT=0 when the specific ports are defined in the sys.odbc.ini configuration file ?

    What causes the rep agent to show "PAUSE" in this command when the Receiver list output, included below,  shows all subscribers are in "START" state.

    @lenxksdeg-mgmtb4 [/tmp/logs/rda]

    >ttRepAdmin -showstatus -connstr "dsn=DEG20_DSN_TT;uid=ttdeg20user;pwd=ttdeg20user";

    Replication Agent Status as of: 2016-05-19 10:45:45

    DSN                         : DEG20_DSN_TT

    Process ID                  : 7605 (Started)

    Replication Agent Policy    : always

    Host                        : LENXKSDEG-MGMTB4

    RepListener Port            : 17025

    Last write LSN              : 199620.661641936

    Last LSN forced to disk     : 199620.661610496

    Replication hold LSN        : 199620.660582072

    Replication Peers:

       Name                     : DEG20_DSN_TT

       Host                     : LENXKSDEG-MGMTB3

       Port                     : 17022  (Connected)

       Replication State        : PAUSED

       Communication Protocol   : 29

       Name                     : DEG20_DSN_TT

       Host                     : LESMMODEG-MGMTB3

       Port                     : 17022  (Connected)

       Replication State        : PAUSED

       Communication Protocol   : 29

       Name                     : DEG20_DSN_TT

       Host                     : LESMMODEG-MGMTB4

       Port                     : 17025  (Connected)

       Replication State        : STARTED

       Communication Protocol   : 29

       Name                     : DEG20_DSN_TT

       Host                     : LESMMODEG-MGMTB4

       Port                     : 0

       Replication State        : STARTED

       Communication Protocol   : 29

       Name                     : DEG20_DSN_TT

       Host                     : LESMMODEG-MGMTB3

       Port                     : 0

       Replication State        : STARTED

       Communication Protocol   : 29

    TRANSMITTER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 625

       Send LSN              : 199620.661633560

       Transactions sent     : 1523596651

       Total packets sent    : 1600366699

       Tick packets sent     : 615426981

       MIN sent packet size  : 1

       MAX sent packet size  : 16384

       AVG sent packet size  : 1183

       Last packet sent at   : 10:45:45

       Total Packets received: 1574109042

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 120

       AVG rcvd packet size  : 119

       Last packet rcvd'd at : 10:45:45

       TXNs Allocated        : 16220

       TXNs In Use           : 0

       ACTs Allocated        : 50570

       ACTs In Use           : 0

       ACTs Data Allocated   : 0

       Most recent errors (max 5):

         TT16137 in transmitter.c (line 7655) at 02:15:13 on 05-11-2016

         TT16032 in transmitter.c (line 1635) at 03:32:22 on 05-11-2016

         TT16060 in transmitter.c (line 6003) at 05:07:33 on 05-11-2016

         TT16122 in transmitter.c (line 3907) at 05:07:33 on 05-11-2016

         TT16032 in transmitter.c (line 1635) at 05:43:54 on 05-11-2016

    RECEIVER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 1

       Transactions received : 145347118

       Total packets sent    : 134807648

       Tick packets sent     : 0

       MIN sent packet size  : 64

       MAX sent packet size  : 120

       AVG sent packet size  : 119

       Last packet sent at   : 10:45:45

       Total Packets received: 937410623

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 1602

       AVG rcvd packet size  : 217

       Last packet rcvd'd at : 10:45:45

       STA Blk Data Allocated: 23104

       STA Data Allocated    : 2957312

       Most recent errors (max 5):

         TT16187 in receiver.c (line 7023) at 10:45:25 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:25 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:25 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:25 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:25 on 05-19-2016

    TRANSMITTER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 285

       Send LSN              : 199620.661633560

       Transactions sent     : 1521390609

       Total packets sent    : 1523250780

       Tick packets sent     : 657903864

       MIN sent packet size  : 1

       MAX sent packet size  : 16384

       AVG sent packet size  : 1229

       Last packet sent at   : 10:45:45

       Total Packets received: 1496920040

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 120

       AVG rcvd packet size  : 119

       Last packet rcvd'd at : 10:45:45

       TXNs Allocated        : 103648

       TXNs In Use           : 0

       ACTs Allocated        : 281087

       ACTs In Use           : 0

       ACTs Data Allocated   : 0

       Most recent errors (max 5):

         TT16122 in transmitter.c (line 3907) at 11:41:35 on 05-16-2016

         TT16032 in transmitter.c (line 1635) at 11:41:49 on 05-16-2016

         TT16060 in transmitter.c (line 6003) at 22:10:19 on 05-16-2016

         TT16122 in transmitter.c (line 3907) at 22:10:19 on 05-16-2016

         TT16032 in transmitter.c (line 1635) at 22:30:50 on 05-16-2016

    RECEIVER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 1

       Transactions received : 300

       Total packets sent    : 11817

       Tick packets sent     : 0

       MIN sent packet size  : 64

       MAX sent packet size  : 120

       AVG sent packet size  : 119

       Last packet sent at   : 05:07:32

       Total Packets received: 13000

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 1602

       AVG rcvd packet size  : 85

       Last packet rcvd'd at : 05:07:32

       STA Blk Data Allocated: 0

       STA Data Allocated    : 0

       Most recent errors (max 5):

         TT16215 in receiver.c (line 13042) at 05:02:04 on 05-11-2016

         TT16187 in receiver.c (line 7023) at 05:02:04 on 05-11-2016

         TT16215 in receiver.c (line 13042) at 05:02:04 on 05-11-2016

         TT16187 in receiver.c (line 7023) at 05:02:04 on 05-11-2016

         TT16060 in receiver.c (line 2875) at 05:07:34 on 05-11-2016

    TRANSMITTER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 280

       Send LSN              : 199620.661633560

       Transactions sent     : 1522372779

       Total packets sent    : 1524874594

       Tick packets sent     : 658566644

       MIN sent packet size  : 1

       MAX sent packet size  : 16384

       AVG sent packet size  : 1228

       Last packet sent at   : 10:45:45

       Total Packets received: 1498527330

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 120

       AVG rcvd packet size  : 119

       Last packet rcvd'd at : 10:45:45

       TXNs Allocated        : 105774

       TXNs In Use           : 0

       ACTs Allocated        : 292686

       ACTs In Use           : 0

       ACTs Data Allocated   : 0

       Most recent errors (max 5):

         TT16032 in transmitter.c (line 1635) at 11:55:10 on 05-13-2016

         TT16032 in transmitter.c (line 1635) at 11:55:20 on 05-13-2016

         TT16032 in transmitter.c (line 1635) at 11:55:30 on 05-13-2016

         TT16059 in transmitter.c (line 6776) at 12:11:26 on 05-13-2016

         TT16121 in transmitter.c (line 3636) at 12:11:26 on 05-13-2016

    RECEIVER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 1

       Transactions received : 309251917

       Total packets sent    : 335343196

       Tick packets sent     : 0

       MIN sent packet size  : 64

       MAX sent packet size  : 120

       AVG sent packet size  : 119

       Last packet sent at   : 04:35:03

       Total Packets received: 1713829462

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 1522

       AVG rcvd packet size  : 214

       Last packet rcvd'd at : 04:35:03

       STA Blk Data Allocated: 0

       STA Data Allocated    : 0

       Most recent errors (max 5):

         TT16215 in receiver.c (line 13042) at 04:34:45 on 03-20-2016

         TT16187 in receiver.c (line 7023) at 04:34:45 on 03-20-2016

         TT16215 in receiver.c (line 13042) at 04:34:45 on 03-20-2016

         TT16187 in receiver.c (line 7023) at 04:34:45 on 03-20-2016

         TT16060 in receiver.c (line 2875) at 04:37:03 on 03-20-2016

    RECEIVER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 1

       Transactions received : 143187557

       Total packets sent    : 110530410

       Tick packets sent     : 0

       MIN sent packet size  : 64

       MAX sent packet size  : 120

       AVG sent packet size  : 119

       Last packet sent at   : 10:45:45

       Total Packets received: 828862712

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 1602

       AVG rcvd packet size  : 225

       Last packet rcvd'd at : 10:45:45

       STA Blk Data Allocated: 9888

       STA Data Allocated    : 1265664

       Most recent errors (max 5):

         TT16187 in receiver.c (line 7023) at 10:45:30 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:30 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:30 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:30 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:30 on 05-19-2016

    RECEIVER thread(s):

    For                     : DEG20_DSN_TT

       Start/Restart count   : 1

       Transactions received : 41643786

       Total packets sent    : 43124600

       Tick packets sent     : 0

       MIN sent packet size  : 64

       MAX sent packet size  : 120

       AVG sent packet size  : 119

       Last packet sent at   : 10:45:45

       Total Packets received: 255514429

       MIN rcvd packet size  : 64

       MAX rcvd packet size  : 1602

       AVG rcvd packet size  : 214

       Last packet rcvd'd at : 10:45:45

       STA Blk Data Allocated: 9472

       STA Data Allocated    : 1212416

       Most recent errors (max 5):

         TT16187 in receiver.c (line 7023) at 10:45:43 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:43 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:43 on 05-19-2016

         TT16215 in receiver.c (line 13042) at 10:45:43 on 05-19-2016

         TT16187 in receiver.c (line 7023) at 10:45:43 on 05-19-2016

    -- Output of Receiver List command showing REPLICATION STATE = "START" for all nodes.

    @lenxksdeg-mgmtb4 [/tmp/logs/rda]

    >ttRepAdmin -dsn DEG20_DSN_TT -receiver -list

    Peer name         Host name                 Port    State  Proto

    ----------------  ------------------------ ------  ------- -----

    DEG20_DSN_TT      LESMMODEG-MGMTB3          17022  Start      29

    Last Msg Sent Last Msg Recv Latency TPS     RecordsPS Logs

    ------------- ------------- ------- ------- --------- ----

    00:00:00      00:00:00         1.52     455       715    1

    Peer name         Host name                 Port    State  Proto

    ----------------  ------------------------ ------  ------- -----

    DEG20_DSN_TT      LESMMODEG-MGMTB4          17025  Start      29

    Last Msg Sent Last Msg Recv Latency TPS     RecordsPS Logs

    ------------- ------------- ------- ------- --------- ----

    00:00:00      00:00:00         1.53     455       715    1

    Peer name         Host name                 Port    State  Proto

    ----------------  ------------------------ ------  ------- -----

    DEG20_DSN_TT      LENXKSDEG-MGMTB3          17022  Start      29

    Last Msg Sent Last Msg Recv Latency TPS     RecordsPS Logs

    ------------- ------------- ------- ------- --------- ----

    00:00:00      00:00:00         1.53     455       715    1

    -- Create Replication Schema output:

    create replication TTDEG20USER.DEG20_DSN_TT_REP

        element REP1_DEG_COMPANION_TOKENS table TTDEG20USER.DEG_COMPANION_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_DEVICE_DATA table TTDEG20USER.DEG_DEVICE_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_ENTITLEMENTS_FC_MAP table TTDEG20USER.DEG_ENTITLEMENTS_FC_MAPPING

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_IMS_DATA table TTDEG20USER.DEG_IMS_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_LIC_LIMITS table TTDEG20USER.DEG_LIC_LIMITS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_SUBSCRIBERS table TTDEG20USER.DEG_SUBSCRIBERS

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_SYS_PARAMETERS table TTDEG20USER.DEG_SYS_PARAMETERS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DEG_TOKENS table TTDEG20USER.DEG_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DROID_AUTH_XML_TEMPLAT table TTDEG20USER.DEGDROID_AUTH_XML_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DROID_SERVICE_TEMPLATE table TTDEG20USER.DEGDROID_SERVICE_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP1_DROID_TOKENS table TTDEG20USER.DEGDROID_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_COMPANION_TOKENS table TTDEG20USER.DEG_COMPANION_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_DEVICE_DATA table TTDEG20USER.DEG_DEVICE_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_ENTITLEMENTS_FC_MAP table TTDEG20USER.DEG_ENTITLEMENTS_FC_MAPPING

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_IMS_DATA table TTDEG20USER.DEG_IMS_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_LIC_LIMITS table TTDEG20USER.DEG_LIC_LIMITS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_SUBSCRIBERS table TTDEG20USER.DEG_SUBSCRIBERS

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_SYS_PARAMETERS table TTDEG20USER.DEG_SYS_PARAMETERS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DEG_TOKENS table TTDEG20USER.DEG_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DROID_AUTH_XML_TEMPLAT table TTDEG20USER.DEGDROID_AUTH_XML_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DROID_SERVICE_TEMPLATE table TTDEG20USER.DEGDROID_SERVICE_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP2_DROID_TOKENS table TTDEG20USER.DEGDROID_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP3_DEG_COMPANION_TOKENS table TTDEG20USER.DEG_COMPANION_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_DEVICE_DATA table TTDEG20USER.DEG_DEVICE_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_ENTITLEMENTS_FC_MAP table TTDEG20USER.DEG_ENTITLEMENTS_FC_MAPPING

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_IMS_DATA table TTDEG20USER.DEG_IMS_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_LIC_LIMITS table TTDEG20USER.DEG_LIC_LIMITS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_SUBSCRIBERS table TTDEG20USER.DEG_SUBSCRIBERS

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_SYS_PARAMETERS table TTDEG20USER.DEG_SYS_PARAMETERS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DEG_TOKENS table TTDEG20USER.DEG_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DROID_AUTH_XML_TEMPLAT table TTDEG20USER.DEGDROID_AUTH_XML_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DROID_SERVICE_TEMPLATE table TTDEG20USER.DEGDROID_SERVICE_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP3_DROID_TOKENS table TTDEG20USER.DEGDROID_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

        element REP4_DEG_COMPANION_TOKENS table TTDEG20USER.DEG_COMPANION_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_DEVICE_DATA table TTDEG20USER.DEG_DEVICE_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_ENTITLEMENTS_FC_MAP table TTDEG20USER.DEG_ENTITLEMENTS_FC_MAPPING

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_IMS_DATA table TTDEG20USER.DEG_IMS_DATA

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_LIC_LIMITS table TTDEG20USER.DEG_LIC_LIMITS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_SUBSCRIBERS table TTDEG20USER.DEG_SUBSCRIBERS

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_SYS_PARAMETERS table TTDEG20USER.DEG_SYS_PARAMETERS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DEG_TOKENS table TTDEG20USER.DEG_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DROID_AUTH_XML_TEMPLAT table TTDEG20USER.DEGDROID_AUTH_XML_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DROID_SERVICE_TEMPLATE table TTDEG20USER.DEGDROID_SERVICE_TEMPLATES

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        element REP4_DROID_TOKENS table TTDEG20USER.DEGDROID_TOKENS

            check conflicts by row timestamp column TT_AUTOTIMESTAMP

                update by system

                on exception rollback work

                report to '/var/TimesTen/SIU_DEG02_TT/LogDir/RepConflictLog/DEG20_Replication_Conflicts.log'

            master DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            subscriber DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            subscriber DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

        store DEG20_DSN_TT on "LESMMODEG-MGMTB3"

            port 17022

        store DEG20_DSN_TT on "LENXKSDEG-MGMTB4"

            port 17025

        store DEG20_DSN_TT on "LESMMODEG-MGMTB4"

            port 17025

        store DEG20_DSN_TT on "LENXKSDEG-MGMTB3"

            port 17022

    ;

    -- end of Create Replication script------

  • ChrisJenkins-Oracle
    ChrisJenkins-Oracle Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
    edited May 20, 2016 6:04AM

    I am looking into this and will report back (may take a couple of days). In the meantime I have two questions:

    1.   Is there some reason why you are not using conflict resolution for the table DEG_SUBSCRIBERS? That seems rather dangerous...

    2.   Is there some reason why you are on such a very old release? 11.2.1.9.0 is extremely old and is also the initial release in the 11.2.1.9.x series. At the very least you should be on the most recent 11.2.1.x.y release and better still on 11.2.2.8.12 (i.e. the 11.2.2 major release stream, latest maintenance release).

    I would not be at all surprised that this is just a reporting bug in ttRepAdmin -showstatus which is likely fixed in a newer release.

    Chris

  • 2884167
    2884167 Member Posts: 5
    edited May 21, 2016 8:49PM

    Thanks  - re; conflict resolution for the table DEG_SUBSCRIBERS? .   I will ask the app-vendor and see.  That's a good question.

    re: upgrades - we're planning the TT upgrades for about 3 months out.  

    I hope to be able to tie one or more specific bugs to the current issues we're seeing.

    Thanks  your time and let me know if you find anything about the show-status command for our current version. 

  • ChrisJenkins-Oracle
    ChrisJenkins-Oracle Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
    edited May 22, 2016 5:10AM

    I checked into this and also told with development. ttRepAdmin -showstatus is a (formatted) live snapshot of some internal memory structures. As a result it may contain old/inconsisitent information especially if various aspects have changed recently. There is nothing abnormal in what you are seeing, they are just reporting anomalies.We did have an open item to tidy up some aspects of this and it may be that has already been addressed in newer releases. I don't have a specific bug number for that; if you want one please contact support so they can research that for you.

    You mentioned issues (plural). Do you have issues other than the one  you reported above?

    Chris

This discussion has been closed.