Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: ER queue data

Posted By: Madison Pruet
Date: Wednesday, 2 October 2013, at 4:52 p.m.

In Response To: Re: ER queue data (FRANK)

get onstat -g stk on each of the servers. We want to focus on the data=
sync
(CDRD).

M.P.

=

From: "FRANK" <yunyaoqu@gmail.com> =

=

To: ids@iiug.org, =

=

Date: 10/02/2013 02:18 PM =

=

Subject: Re: ER queue data [31578] =

=

Sent by: ids-bounces@iiug.org =

=

Paul,

The following are the three outputs of the commands. Please Let me know=

if you see some clue.

The ER rejected transactions in ATS/RIS directory is fine to us( we
lived with this for years, we can do manual data sync late, no problem =
at
all).

As long as ER continue to process the new coming transactions,
we would be happy...

But it queues data , does not send data(or intolerably slow) to other
sites.....

Thanks,
Frank

[fqu@maggie bin]$ cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------=

g_ncdcops 22 Active Connected 24142400034 Oct 1 19:04:27
g_ngdcops 23 Active Connected 6495057993 Oct 1 19:07:17
g_nsofops 21 Active Local 0

[fqu@maggie bin]$ onstat -g rcv
IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 5 days
01:16:54 -- 8359540 Kbytes
ServerId: 23
Flags 0x0
ServerId: 22
Flags 0x0
Threads:

Id Name State Handle

6353620 CDRACK_5 Idle 0x143f98cc8

6280008 CDRACK_4 Idle 0x1436b44f8

6229955 CDRACK_3 Idle 0x148ce3028

6229671 CDRACK_2 Idle 0x144acd0d8

6228209 CDRACK_1 Idle 0x14acdb0d8

6228208 CDRACK_0 Idle 0x14acdb4b8
Receive Manager global block 0x1429fb028

cdrRM_inst_ct: 2

cdrRM_State: 00000040

cdrRM_numSleepers: 12

cdrRM_DsCreated: 12

cdrRM_MinDSThreads: 12

cdrRM_MaxDSThreads: 48

cdrRM_DSBlock 0

cdrRM_DSParallelPL 0

cdrRM_DSFailRate 0.000000

cdrRM_DSNumRun: 975682

cdrRM_DSNumLockTimeout 0

cdrRM_DSNumLockRB 123

cdrRM_DSNumDeadLocks 184

cdrRM_DSNumPCommits 22284

cdrRM_ACKwaiting 0

cdrRM_totSleep: 398

cdrRM_Sleeptime: 64965

cdrRM_Workload: 0

cdrRM_optscale: 4

cdrRM_MinFloatThreads: 2

cdrRM_MaxFloatThreads: 7

cdrRM_AckThreadCount: 6

cdrRM_AckWaiters: 6

cdrRM_AckCreateStamp: Wed Oct 2 00:38:19 2013

cdrRM_DSCreateStamp: Wed Oct 2 18:18:10 2013

cdrRM_acksInList: 0

cdrRM_BlobErrorBufs: 0
Receive Parallelism Statistics
Server Tot.Txn. Pending Active MaxPnd MaxAct AvgPnd AvgAct CommitRt

22 473537 0 0 3806 15 34.59 1.45 5.26

23 502145 0 0 2927 17 12.86 1.37 5.58
Tot Pending:0 Tot Active:0 Avg Pending:23.41 Avg Active:1.41
Commit Rate:10.84
Time Spent In RM Parallel Pipeline Levels
Lev. TimeInSec Pcnt.

0 89800 100.00%

1 0 0.00%

2 0 0.00%

[fqu@maggie bin]$ onstat -g ath
IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 5 days
01:17:36 -- 8359540 Kbytes
Threads:
tid tcb rstcb prty status
vp-class
name
2 1412741d8 0 1 IO Idle
3lio* lio vp 0
3 1412962e0 0 1 IO Idle
4pio* pio vp 0
4 1412b72e0 0 1 IO Idle
5aio* aio vp 0
5 1412d82e0 1bc2320 1 IO Idle
6msc* msc vp 0
6 1413092e0 0 1 IO Idle
7fifo* fifo vp 0
7 14137f808 0 1 IO Idle
20aio* aio vp 1
8 1413a02e0 0 1 IO Idle
21aio* aio vp 2
9 1413c12e0 0 1 IO Idle
22aio* aio vp 3
10 1413f7580 13f5ad028 3 sleeping secs: 1
17cpu main_loop()
11 1413e2c48 0 1 running
26soc* soctcppoll
12 1413e9ba0 0 1 running
27soc* soctcppoll
13 14132b4d8 0 1 running
28soc* soctcppoll
14 14132bca8 0 1 running
29soc* soctcppoll
15 141332778 0 1 running
1cpu* sm_poll
16 1414e14c0 0 2 sleeping forever
1cpu* soctcplst
17 141514028 0 2 sleeping forever
10cpu sm_listen
18 141549d00 0 1 sleeping secs: 1
17cpu sm_discon
19 141563178 0 2 sleeping forever
9cpu* soctcplst
20 141576a78 0 2 sleeping forever
10cpu* soctcplst
21 1415906a0 13f5ad870 1 sleeping secs: 1
17cpu flush_sub(0)
22 1415909d8 13f5ae0b8 1 sleeping secs: 1
19cpu flush_sub(1)
23 141590d10 13f5ae900 1 sleeping secs: 1
19cpu flush_sub(2)
24 1415ca0e0 13f5af148 1 sleeping secs: 1
19cpu flush_sub(3)
25 1415ca418 13f5af990 1 sleeping secs: 1
19cpu flush_sub(4)
26 1415ca750 13f5b01d8 1 sleeping secs: 1
18cpu flush_sub(5)
27 1415caa88 13f5b0a20 1 sleeping secs: 1
19cpu flush_sub(6)
28 141658028 13f5b1268 1 sleeping secs: 1
17cpu flush_sub(7)
29 141658360 13f5b1ab0 1 sleeping secs: 1
17cpu flush_sub(8)
30 141658698 13f5b22f8 1 sleeping secs: 1
19cpu flush_sub(9)
31 1416589d0 13f5b2b40 1 sleeping secs: 1
17cpu flush_sub(10)
32 141658d08 13f5b3388 1 sleeping secs: 1
14cpu flush_sub(11)
33 1416f8028 13f5b3bd0 1 sleeping secs: 1
18cpu flush_sub(12)
34 1416f8360 13f5b4418 1 sleeping secs: 1
10cpu flush_sub(13)
35 1416f8698 13f5b4c60 1 sleeping secs: 1
16cpu flush_sub(14)
36 1416f89d0 13f5b54a8 1 sleeping secs: 1
17cpu flush_sub(15)
37 1416f8d58 0 3 IO Idle
1cpu* kaio
38 141811220 0 3 IO Idle
9cpu* kaio
39 141811558 0 3 IO Idle
16cpu* kaio
40 14184f658 13f5b5cf0 2 sleeping secs: 1
14cpu aslogflush
41 1418f9568 13f5b6538 1 sleeping secs: 7
10cpu btscanner_0
42 1419166b8 13f5b6d80 3 cond wait ReadAhead
1cpu readahead_0
72 141f1a360 0 3 IO Idle
18cpu* kaio
74 141f1ad50 13f5b7e10 3 sleeping secs: 1
1cpu* onmode_mon
75 1419336c8 13f5b8ea0 3 sleeping secs: 1
17cpu periodic
82 141c96188 0 3 IO Idle
10cpu* kaio
83 141e688e0 0 3 IO Idle
14cpu* kaio
84 141e68b60 0 3 IO Idle
15cpu* kaio
85 141def028 0 3 IO Idle
11cpu* kaio
86 141def2a8 0 3 IO Idle
19cpu* kaio
87 141def578 0 3 IO Idle
13cpu* kaio
88 141def900 0 3 IO Idle
17cpu* kaio
89 141defc88 0 3 IO Idle
12cpu* kaio
92 141c9a610 13f5ba778 1 sleeping secs: 56
9cpu dbScheduler
93 141ded568 13f5b9f30 1 sleeping forever
11cpu dbWorker1
94 141ceb958 13f5b96e8 1 sleeping forever
11cpu dbWorker2
129 1425704b0 13f5c7680 1 cond wait bp_cond
16cpu bf_priosweep()
1875 1431bccf8 13f5d0b90 1 cond wait netnorm
9cpu sqlexec
1876 143589290 13f5c8f58 1 cond wait netnorm
1cpu sqlexec
1879 1436c69a8 13f5ce228 1 cond wait netnorm
1cpu sqlexec
1880 1437a81e8 13f5c97a0 1 cond wait netnorm
9cpu sqlexec
1883 143840398 13f5cf2b8 1 cond wait netnorm
10cpu sqlexec
1884 143816af0 13f5d2468 1 cond wait netnorm
1cpu sqlexec
1885 1437ff968 13f5d2cb0 1 cond wait netnorm
9cpu sqlexec
1886 14387c148 13f5d34f8 1 cond wait netnorm
9cpu sqlexec
1889 14321c4d8 13f5d4dd0 1 cond wait netnorm
9cpu sqlexec
1890 141cfec28 13f5d5618 1 cond wait netnorm
19cpu sqlexec
1891 142fd1028 13f5d5e60 1 cond wait netnorm
1cpu sqlexec
1892 143a40418 13f5d66a8 1 cond wait netnorm
19cpu sqlexec
1895 143b0d450 13f5d13d8 1 cond wait netnorm
9cpu sqlexec
1901 143c8b028 13f5da8e8 1 cond wait netnorm
9cpu sqlexec
1905 143b13bb0 13f5db978 1 cond wait netnorm
19cpu sqlexec
1915 143c1aa58 13f5dda98 1 cond wait netnorm
10cpu sqlexec
1916 143e95028 13f5de2e0 1 cond wait netnorm
9cpu sqlexec
4584083 1467d1028 14826f250 1 cond wait netnorm
10cpu sqlexec
5824374 14519b4b0 148267e60 1 cond wait netnorm
9cpu sqlexec
6106863 154046d20 148251200 1 cond wait netnorm
9cpu sqlexec
6138651 14a262be8 14461fb50 1 cond wait netnorm
1cpu sqlexec
6178376 154906c68 1445f8e38 1 cond wait netnorm
1cpu sqlexec
6228185 1430801e8 13f5c3440 1 cond wait CDRCparse
10cpu CDRCparse
6228187 144be6528 13f5c1b68 3 sleeping secs: 15
1cpu CDRGfan
6228188 14520caa8 13f5be9b8 3 sleeping secs: 5
19cpu CDRGeval0
6228189 145221338 13f5bf200 3 sleeping secs: 5
19cpu CDRGeval1
6228190 1436d89d8 13f5c1320 3 sleeping secs: 1
19cpu CDRGeval2
6228191 14bdd06f0 13f5bfa48 3 sleeping secs: 1
19cpu CDRGeval3
6228192 146905178 13f5c5560 3 sleeping secs: 5
1cpu CDRGeval4
6228193 148ae7890 13f5c44d0 3 sleeping secs: 5
19cpu CDRGeval5
6228194 1477297e8 13f5c0ad8 3 sleeping secs: 1
14cpu CDRGeval6
6228195 149ca7948 13f5c23b0 3 sleeping secs: 5
9cpu CDRGeval7
6228196 14660b728 13f5c0290 3 sleeping secs: 1
17cpu CDRGeval8
6228197 148400028 13f5c3c88 3 sleeping secs: 1
9cpu CDRGeval9
6228198 148447528 13f5c4d18 3 sleeping secs: 1
1cpu CDRGeval10
6228199 141f3a0b8 13f5c2bf8 3 sleeping secs: 1
1cpu CDRGeval11
6228200 143c7dc08 13f5b8658 3 sleeping secs: 5
10cpu CDRGeval12
6228201 1493c0628 14c939ab0 3 sleeping secs: 1
9cpu CDRGeval13
6228204 147e620e0 13f5bafc0 2 sleeping secs: 1
1cpu ddr_snoopy
6228206 1493e1bf8 1445e00b8 1 sleeping secs: 1
17cpu CDR_Monitor
6228208 145166028 144615df8 1 cond wait CDRAckslp
9cpu CDRACK_0
6228209 143bd6188 13f5be170 1 cond wait CDRAckslp
16cpu CDRACK_1
6229669 147673d20 13f5d87c8 1 sleeping secs: 60
10cpu CDRNsA22
6229670 15001dd20 14461a038 1 cond wait netnorm
10cpu CDRNrA22
6229671 14b1d2d20 1445ee050 1 cond wait CDRAckslp
12cpu CDRACK_2
6229953 145632d20 14823f028 1 sleeping secs: 60
1cpu CDRNsA23
6229954 14ab1ed20 1482702e0 1 cond wait netnorm
10cpu CDRNrA23
6229955 147e72d20 1482400b8 1 cond wait CDRAckslp
11cpu CDRACK_3
6280008 147b19d20 14825f198 1 cond wait CDRAckslp
12cpu CDRACK_4
6300596 143b20528 14825d078 1 cond wait netnorm
9cpu sqlexec
6353620 142a13028 13f5ecac0 1 cond wait CDRAckslp
12cpu CDRACK_5
6370595 146973688 148278760 1 cond wait netnorm
13cpu sqlexec
6649072 142517a70 148253320 1 cond wait CDRDssleep
19cpu CDRD_97
6682040 14197c028 14c9538c0 1 cond wait netnorm
9cpu sqlexec
6682065 14a8e07e8 144602b90 1 cond wait netnorm
10cpu sqlexec
6682082 147f241e8 1446054f8 1 cond wait netnorm
19cpu sqlexec
6682103 144d2bae8 13f5b75c8 1 cond wait netnorm
11cpu sqlexec
6701224 1424fd6b8 1482755b0 1 cond wait CDRDssleep
19cpu CDRD_103
6701236 148911028 13f5d3d40 1 cond wait CDRDssleep
19cpu CDRD_116
6701239 1455f81e8 1445f7560 1 cond wait CDRDssleep
19cpu CDRD_118
6701242 14b4f7628 1445f85f0 1 cond wait CDRDssleep
19cpu CDRD_121
6701243 14a81e1e8 1482797f0 1 cond wait CDRDssleep
19cpu CDRD_122
6722658 145d86178 1445f3b68 1 cond wait CDRDssleep
19cpu CDRD_135
6722660 1437945a0 1445fd8c0 1 cond wait CDRDssleep
19cpu CDRD_137
6722661 14bcc71e8 1445df870 1 cond wait CDRDssleep
19cpu CDRD_138
6750451 143312968 148248538 1 cond wait CDRDssleep
9cpu CDRD_139
6750452 14d7bbc90 1445ed808 1 cond wait CDRDssleep
19cpu CDRD_140
6750453 14abfb568 13f5bd928 1 cond wait CDRDssleep
19cpu CDRD_141
6750691 144d393a8 144604468 1 cond wait netnorm
11cpu sqlexec
6750695 147990028 1445ef928 1 cond wait netnorm
1cpu sqlexec
6750706 149526028 14460d978 1 cond wait netnorm
12cpu sqlexec
6750719 145cab028 14461e278 1 cond wait netnorm
10cpu sqlexec
6750730 146b78468 148241148 1 cond wait netnorm
9cpu sqlexec
6750806 144c727d0 13f5c65f0 1 cond wait netnorm
11cpu sqlexec
6772470 147f24468 144604cb0 1 cond wait netnorm
1cpu sqlexec
6779154 141f84028 14824c778 1 cond wait netnorm
19cpu sqlexec
6779155 14c007028 1445ff198 1 cond wait netnorm
19cpu sqlexec
6779156 146126890 144602348 1 cond wait netnorm
1cpu sqlexec
6779157 1447005e8 148248d80 1 cond wait netnorm
11cpu sqlexec
6779158 14a4ed028 1445e8d80 1 cond wait netnorm
9cpu sqlexec
6779159 1447bd1e8 13f5e56d0 1 cond wait netnorm
10cpu sqlexec
6779160 141a30608 144606dd0 1 cond wait netnorm
1cpu sqlexec
6779161 147d08028 13f5cc108 1 cond wait netnorm
9cpu sqlexec
6779162 1446a7028 14c94b440 1 cond wait netnorm
1cpu sqlexec
6779163 1457b9a38 14827c158 1 cond wait netnorm
9cpu sqlexec
6779164 148374028 1445f2ad8 1 cond wait netnorm
1cpu sqlexec
6779165 1456b7028 144611370 1 cond wait netnorm
11cpu sqlexec
6779166 146d8eb28 14c935870 1 cond wait netnorm
1cpu sqlexec
6779167 1430d2828 13f5e6fa8 1 cond wait netnorm
10cpu sqlexec
6779168 14561cbf8 1445f4bf8 1 cond wait netnorm
11cpu sqlexec
6779169 145356028 14c958348 1 cond wait netnorm
9cpu sqlexec
6779170 146578028 13f5e4640 1 cond wait netnorm
1cpu sqlexec
6779171 14c0fd028 13f5e8038 1 cond wait netnorm
9cpu sqlexec
6779178 14582e2a8 148240900 1 cond wait netnorm
19cpu sqlexec
6779179 143dc44b0 14824bf30 1 cond wait netnorm
19cpu sqlexec
6779210 145cabac8 13f5cfb00 1 cond wait netnorm
1cpu sqlexec
6781018 149967028 1445ef0e0 1 cond wait netnorm
13cpu sqlexec
6781068 1424658a0 148271bb8 1 cond wait netnorm
9cpu sqlexec
6785477 1456b9028 1445e6418 1 cond wait netnorm
11cpu sqlexec
6785487 14a810d98 13f5eb1e8 1 cond wait netnorm
1cpu sqlexec
6785503 1457e6028 1445ea658 1 cond wait netnorm
11cpu sqlexec
6787703 142431028 148259680 1 cond wait netnorm
10cpu sqlexec
6787718 14b8ab8a0 14c940ea0 1 cond wait netnorm
1cpu sqlexec
6787739 14648a028 1445ecfc0 1 cond wait netnorm
10cpu sqlexec
6787740 148368028 13f5dfbb8 1 cond wait netnorm
11cpu sqlexec
6787855 142303028 13f5d7f80 1 cond wait netnorm
11cpu sqlexec
6787952 141949568 144603c20 1 cond wait netnorm
9cpu sqlexec
6787957 1423af028 1446197f0 1 cond wait netnorm
1cpu sqlexec
6788104 1449b2968 13f5ea9a0 1 cond wait netnorm
9cpu sqlexec
6788270 146895028 14c944898 1 cond wait netnorm
19cpu sqlexec
6788286 142fcb7e0 13f5e5f18 1 cond wait netnorm
9cpu sqlexec
6788708 14450faa8 148269f80 1 cond wait netnorm
9cpu sqlexec
6788935 1422ac028 13f5dca08 1 cond wait netnorm
19cpu sqlexec
6789310 14a814b68 1445e2a20 1 cond wait netnorm
9cpu sqlexec
6789322 14b5111e8 148252290 1 cond wait netnorm
10cpu sqlexec
6789329 144635ca0 144607e60 1 cond wait netnorm
9cpu sqlexec
6789334 146a6d838 13f5e1cd8 1 cond wait netnorm
19cpu sqlexec
6789341 1463ffc10 14827e278 1 cond wait netnorm
19cpu sqlexec
6789343 1445526b8 1445e42f8 1 cond wait netnorm
9cpu sqlexec
6789351 14c744028 148244b40 1 cond wait netnorm
19cpu sqlexec
6789352 145103be8 13f5ea158 1 cond wait netnorm
9cpu sqlexec
6789359 148b54028 14c93ab40 1 cond wait netnorm
10cpu sqlexec
6789360 14a97f028 13f5ee398 1 cond wait netnorm
19cpu sqlexec
6789362 146cc0ab8 1445e6c60 1 cond wait netnorm
1cpu sqlexec
6789369 14585c848 148265d40 1 cond wait netnorm
9cpu sqlexec
6789372 14b64a028 13f5c6e38 1 cond wait netnorm
9cpu sqlexec
6789379 146c87028 1445e5388 1 cond wait netnorm
9cpu sqlexec
6789380 1468c8b50 14461c9a0 1 cond wait netnorm
9cpu sqlexec
6789387 144bab028 13f5cc950 1 cond wait netnorm
9cpu sqlexec
6789388 14673b220 1482776d0 1 cond wait netnorm
1cpu sqlexec
6789389 147bb98e8 1445f5c88 1 cond wait netnorm
16cpu sqlexec
6789390 147c40808 14827a880 1 cond wait netnorm
1cpu sqlexec
6789397 14690b8a8 14826a7c8 1 cond wait netnorm
1cpu sqlexec
6789398 14a8e0568 144614520 1 cond wait netnorm
1cpu sqlexec

[fqu@maggie bin]$

On Wed, Oct 2, 2013 at 3:41 PM, Paul Watson <paul@oninit.com> wrote:

> Queues on the source ? The problem is mostly likely the target especi=
ally

> if
> you are generate ris/ats files
>
> Have a look in the logfiles (onlog) and look for cdr rollbacks, if yo=
u
see
> an appreciable number then you are probably getting apply thread
throttling
> on the target. The latest version of the onstat -g recv (?) should sh=
ow
> the
> number of active apply threads, also look at the onstat -g ath
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf =
Of
> > FRANK
> > Sent: Wednesday, October 02, 2013 2:29 PM
> > To: ids@iiug.org
> > Subject: ER queue data [31577]
> >
> > 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 Anywhe=
re).

> > 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
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.=

>
>

--047d7b33d2e4e321d804e7c7bdd7

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

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.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.