ER - How many times a table has been replicated

Posted in 2012

Summary

Andrew Ford asked how to find which tables are most active in Enterprise Replication (11.70.xC4 replicating to 11.50.xC3). Paul Watson only commented on xC4. Madison Pruet answered to use onstat -g rcv full, where each replicate maps to a table. Andrew confirmed it was something obvious he had missed.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: High Availability & Replication

ANDREW FORD — Thu, 08 Nov 2012 20:28:20 — source: IIUG Forums & Mailing Lists

I'm trying to find out which tables are most active in Enterprise Replication, anyone have any ideas? Am I just missing something really obvious? Thanks, Andrew

↪ replying to ANDREW FORD

ANDREW FORD — Thu, 08 Nov 2012 20:32:24 — source: IIUG Forums & Mailing Lists

This might be important: 11.70.xC4 replicating to 11.50.xC3 Andrew

↪ replying to ANDREW FORD

Paul Watson — Thu, 08 Nov 2012 20:37:19 — source: IIUG Forums & Mailing Lists

xC4 - yuck :-( Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANDREW FORD Sent: Thursday, November 08, 2012 2:32 PM To: ids@iiug.org Subject: Re: ER - How many times a table has been repli.... [28746] This might be important: 11.70.xC4 replicating to 11.50.xC3 Andrew **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to ANDREW FORD

Madison — Thu, 08 Nov 2012 20:48:18 — source: IIUG Forums & Mailing Lists

onstat -g rcv full. the replicate maps to a table From: "ANDREW FORD" <aford@networkip.net> To: ids@iiug.org, Date: 11/08/2012 02:33 PM Subject: Re: ER - How many times a table has been repli.... [28746] Sent by: ids-bounces@iiug.org This might be important: 11.70.xC4 replicating to 11.50.xC3 Andrew ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Madison

Andrew Ford — Thu, 08 Nov 2012 20:56:58 — source: IIUG Forums & Mailing Lists

So, it was something obvious I was missing. Thanks everyone, Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Thursday, November 08, 2012 2:48 PM To: ids@iiug.org Subject: Re: ER - How many times a table has been repli.... [28749] onstat -g rcv full. the replicate maps to a table From: "ANDREW FORD" <aford@networkip.net> To: ids@iiug.org, Date: 11/08/2012 02:33 PM Subject: Re: ER - How many times a table has been repli.... [28746] Sent by: ids-bounces@iiug.org This might be important: 11.70.xC4 replicating to 11.50.xC3 Andrew ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary

Enterprise Replication (ER/CDR)