IDS Forum

ER queue data

Posted By: FRANK
Date: Wednesday, 2 October 2013, at 3:29 p.m.

Folks,

IDS11.70 FC7, RedHat Linux 5

These days, we are really struggling with Informix ER replication, it
just queues data there ( see below, a three site replication Anywhere).
The problem started after we upgraded from IDS11.50 FC8 .

We were happy with IDS11.50 FC8 and had no such problem with it for
years ! But frustrated now :-(

Thanks,
Frank

[informix@maggie ~]$ cdr view servers
SERVERS
Server Peer ID State Status Queue Connection Changed
---------------------------------------------------------------------------
g_ncdcops g_ncdcops 22 Active Local 0

g_ngdcops 23 Active Connected 2019393999 Oct 1 19:29:47

g_nsofops 21 Active Connected 1150 Oct 1 19:04:27
g_ngdcops g_ncdcops 22 Active Connected 1981723906 Oct 1 19:29:48

g_ngdcops 23 Active Local 0

g_nsofops 21 Active Connected 0 Oct 1 19:07:16
g_nsofops g_ncdcops 22 Active Connected 24168402804 Oct 1 19:04:27

g_ngdcops 23 Active Connected 10582241649 Oct 1 19:07:17

g_nsofops 21 Active Local 0

It takes 10 minutes to run the follwoing command !!

[informix@walter ~]$ time cdr view profile
ER PROFILE for Node g_ncdcops ER State Active
DDR - Running SPOOL DISK USAGE
Current 80834:513060864 Total 20000000
Snoopy 80834:513057208 Metadata Free 727416
Replay 80834:512827416 Userdata Free 18653710
Pages from Log Lag State 30594741

RECVQ
SENDQ Txn In Queue 0
Txn In Queue 10 Txn In Pending List 0
Txn Spooled 0
Acks Pending 0 APPLY - Running

Txn Processed 4051709
NETWORK - Running Commit Rate 46.31
Currently connected to 2 out of 2 Avg. Active Apply 2.57
Msg Sent 6825365 Fail Rate 0.00
Msg Received 12119333 Total Failures 154
Throughput -10690.02 Avg Latency 0.00
Pending Messages 0 Max Latency 0

ATS File Count 9106

RIS File Count 9106
---------------------------------------------------------------------------
ER PROFILE for Node g_ngdcops ER State Active
DDR - Running SPOOL DISK USAGE
Current 174170:575250432 Total 20000000
Snoopy 174170:575246448 Metadata Free 225676
Replay 174170:571887840 Userdata Free 18153712
Pages from Log Lag State 30579558

RECVQ
SENDQ Txn In Queue 0
Txn In Queue 12 Txn In Pending List 0
Txn Spooled 0
Acks Pending 0 APPLY - Running

Txn Processed 4018341
NETWORK - Running Commit Rate 46.02
Currently connected to 2 out of 2 Avg. Active Apply 2.85
Msg Sent 7053004 Fail Rate 0.00
Msg Received 12032857 Total Failures 619
Throughput -10645.47 Avg Latency 0.50
Pending Messages 0 Max Latency 1

ATS File Count 34

RIS File Count 34
---------------------------------------------------------------------------
ER PROFILE for Node g_nsofops ER State Active
DDR - Running SPOOL DISK USAGE
Current 114575:129708032 Total 20000000
Snoopy 114575:129704600 Metadata Free 0
Replay 114575:129020424 Userdata Free 18653710
Pages from Log Lag State 30688333

RECVQ
SENDQ Txn In Queue 0
Txn In Queue 37 Txn In Pending List 0
Txn Spooled 0
Acks Pending 0 APPLY - Running

Txn Processed 961994
NETWORK - Running Commit Rate 10.97
Currently connected to 2 out of 2 Avg. Active Apply 2.83
Msg Sent 20369608 Fail Rate 0.00
Msg Received 10048584 Total Failures 307
Throughput -3332.02 Avg Latency 0.00
Pending Messages 0 Max Latency 0

ATS File Count 17

RIS File Count 17
---------------------------------------------------------------------------

real 10m49.626s
user 0m0.228s
sys 0m0.040s

--047d7b33d79c62f11d04e7c71687

Messages In This Thread

• ER queue data
  FRANK -- Wednesday, 2 October 2013, at 3:29 p.m.
  • Re: ER queue data
    FRANK -- Wednesday, 2 October 2013, at 4:16 p.m.
    • Re: ER queue data
      Madison Pruet -- Wednesday, 2 October 2013, at 4:52 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.