Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
interpreting the ttRepAdmin -showstatus command
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 Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
Can you please post the complete output from both commands plus the full replication scheme definition (i.e. the CREATE REPLICATION statement).
Thanks,
Chris
-
-- 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 Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
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
-
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 Senior Director, In-Memory Technology United KingdomMember Posts: 3,412 Employee
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