Oninit cdi / Archive
Talk to an expert →

CDR

Posted in 2008

Topics: Stored Procedures & SPL

Miguel Carbone — — source: IIUG Forums & Mailing Lists

Hi folks, Some one have a query on syscdr to display all the replicates, the servers involved and the replication type ( Primary/Target or Update Anywhere)? Grato, Saluti, Best Regards, Mit Freundlichen Grüssen, Meilleures Salutation Miguel Carbone 13 Years Turning Vision into Reality Miguel Carbone miguel@mcsoftware.com.br +55 11 7832 7160 (Nextel ID: 55*84*23571)

↪ replying to Miguel Carbone
David Griffiths — — source: IIUG Forums & Mailing Lists

Hi, try:- select r.repname, p.table, p.partstate, r.repstate, s.servstate, p.partmode,p.selecstmt from partdef p, repdef r, servdef s as a starter. Dave G --- On Thu, 19/6/08, Miguel Carbone <miguel@mcsoftware.com.br> wrote: From: Miguel Carbone <miguel@mcsoftware.com.br> Subject: CDR [12467] To: ids@iiug.org Date: Thursday, 19 June, 2008, 3:42 PM Hi folks, Some one have a query on syscdr to display all the replicates, the servers involved and the replication type ( Primary/Target or Update Anywhere)? Grato, Saluti, Best Regards, Mit Freundlichen Grüssen, Meilleures Salutation Miguel Carbone 13 Years Turning Vision into Reality Miguel Carbone miguel@mcsoftware.com.br +55 11 7832 7160 (Nextel ID: 55*84*23571) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. __________________________________________________________ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

↪ replying to Miguel Carbone
David Griffiths — — source: IIUG Forums & Mailing Lists

Whoops missed the join off.. select r.repname, p.table, p.partstate, r.repstate, s.servstate, p.partmode,p.selecstmt from partdef p, repdef r, servdef s where p.repid=r.repid and p.servid=s.servid --- On Thu, 19/6/08, Miguel Carbone <miguel@mcsoftware.com.br> wrote: From: Miguel Carbone <miguel@mcsoftware.com.br> Subject: CDR [12467] To: ids@iiug.org Date: Thursday, 19 June, 2008, 3:42 PM Hi folks, Some one have a query on syscdr to display all the replicates, the servers involved and the replication type ( Primary/Target or Update Anywhere)? Grato, Saluti, Best Regards, Mit Freundlichen Grüssen, Meilleures Salutation Miguel Carbone 13 Years Turning Vision into Reality Miguel Carbone miguel@mcsoftware.com.br +55 11 7832 7160 (Nextel ID: 55*84*23571) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. __________________________________________________________ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html