<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head profile="http://internetalchemy.org/2003/02/profile"> <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" /> <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" /> <meta name="dc.title" content="Function: repl_status - Virtuoso Functions Guide" /> <meta name="dc.subject" content="Function: repl_status - Virtuoso Functions Guide" /> <meta name="dc.creator" content="OpenLink Software Documentation Team ; " /> <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" /> <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" /> <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" /> <link rel="parent" href="functions.html" title="Chapter Contents" /> <link rel="prev" href="appendixa.html" title="Appendix" /> <link rel="next" href="functions.html#.html" title="" /> <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" /> <link rel="stylesheet" type="text/css" href="doc.css" /> <link rel="stylesheet" type="text/css" href="/doc/translation.css" /> <title>Function: repl_status - Virtuoso Functions Guide</title> <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" /> <meta name="author" content="OpenLink Software Documentation Team ; " /> <meta name="copyright" content="OpenLink Software, 1999 - 2009" /> <meta name="keywords" content="" /> <meta name="GENERATOR" content="OpenLink XSLT Team" /> </head> <body> <div id="header"> <a name="fn_repl_status" /> <img src="../images/misc/logo.jpg" alt="" /> <h1>22. Virtuoso Functions Guide - repl_status</h1> </div> <div id="navbartop"> <div> <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_repl_stat.html" title="REPL_STAT">Prev</a> | <a class="link" href="fn_repl_subscribe.html" title="REPL_SUBSCRIBE">Next</a> </div> </div> <div id="currenttoc"> <form method="post" action="/doc/adv_search.vspx"> <div class="search">Keyword Search: <br /> <input type="text" name="q" /> <input type="submit" name="go" value="Go" /> </div> </form> <div> <a href="http://www.openlinksw.com/">www.openlinksw.com</a> </div> <div> <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a> </div> <br /> <div> <a href="index.html">Book Home</a> </div> <br /> <div> <a href="contents.html">Contents</a> </div> <div> <a href="preface.html">Preface</a> </div> <br /> <div> <a class="selected" href="functions.html">Virtuoso Functions Guide</a> </div> <br /> <div> <a href="functions.html#admin">Administration</a> </div> <div> <a href="functions.html#aggr">Aggregate Functions</a> </div> <div> <a href="functions.html#array">Array Manipulation</a> </div> <div> <a href="functions.html#bpel">BPEL APIs</a> </div> <div> <a href="functions.html#backup">Backup</a> </div> <div> <a href="functions.html#compression">Compression</a> </div> <div> <a href="functions.html#cursors">Cursor</a> </div> <div> <a href="functions.html#time">Date & Time Manipulation</a> </div> <div> <a href="functions.html#debug">Debug</a> </div> <div> <a href="functions.html#dict">Dictionary Manipulation</a> </div> <div> <a href="functions.html#encoding">Encoding & Decoding</a> </div> <div> <a href="functions.html#file">File Manipulation</a> </div> <div> <a href="functions.html#ft">Free Text</a> </div> <div> <a href="functions.html#hash">Hashing / Cryptographic</a> </div> <div> <a href="functions.html#ldap">LDAP</a> </div> <div> <a href="functions.html#localization">Locale</a> </div> <div> <a href="functions.html#mail">Mail</a> </div> <div> <a href="functions.html#misc">Miscellaneous</a> </div> <div> <a href="functions.html#number">Number</a> </div> <div> <a href="functions.html#phrz">Phrases</a> </div> <div> <a href="functions.html#rdf">RDF data</a> </div> <div> <a href="functions.html#rmt">Remote SQL Data Source</a> </div> <div> <a class="selected" href="functions.html#repl">Replication</a> </div> <div class="selected"> <div> <a href="fn_rdf_repl_graph_del.html">rdf_repl_graph_del</a> </div> <div> <a href="fn_rdf_repl_graph_ins.html">rdf_repl_graph_ins</a> </div> <div> <a href="fn_rdf_repl_start.html">rdf_repl_start</a> </div> <div> <a href="fn_REPL_ADD_CR.html">repl_add_cr</a> </div> <div> <a href="fn_REPL_ADD_DAV_CR.html">repl_add_dav_cr</a> </div> <div> <a href="fn_REPL_ADD_SNAPSHOT_CR.html">repl_add_snapshot_cr</a> </div> <div> <a href="fn_REPL_CREATE_SNAPSHOT_PUB.html">repl_create_snapshot...</a> </div> <div> <a href="fn_REPL_CREATE_SNAPSHOT_SUB.html">repl_create_snapshot...</a> </div> <div> <a href="fn_REPL_DROP_SNAPSHOT_PUB.html">repl_drop_snapshot_p...</a> </div> <div> <a href="fn_REPL_DROP_SNAPSHOT_SUB.html">repl_drop_snapshot_s...</a> </div> <div> <a href="fn_repl_grant.html">repl_grant</a> </div> <div> <a href="fn_repl_init_copy.html">repl_init_copy</a> </div> <div> <a href="fn_REPL_INIT_SNAPSHOT.html">repl_init_snapshot</a> </div> <div> <a href="fn_repl_publish.html">repl_publish</a> </div> <div> <a href="fn_repl_pub_add.html">repl_pub_add</a> </div> <div> <a href="fn_repl_pub_init_image.html">repl_pub_init_image</a> </div> <div> <a href="fn_repl_pub_remove.html">repl_pub_remove</a> </div> <div> <a href="fn_repl_revoke.html">repl_revoke</a> </div> <div> <a href="fn_repl_sched_init.html">repl_sched_init</a> </div> <div> <a href="fn_repl_server.html">repl_server</a> </div> <div> <a href="fn_REPL_SERVER_NAME.html">repl_server_name</a> </div> <div> <a href="fn_REPL_SNP_SERVER.html">repl_snp_server</a> </div> <div> <a href="fn_repl_stat.html">repl_stat</a> </div> <div> <a href="fn_repl_subscribe.html">repl_subscribe</a> </div> <div> <a href="fn_repl_unpublish.html">repl_unpublish</a> </div> <div> <a href="fn_repl_unsubscribe.html">repl_unsubscribe</a> </div> <div> <a href="fn_REPL_UPDATE_SNAPSHOT.html">repl_update_snapshot</a> </div> <div> <a href="fn_repl_disconnect.html">repl_disconnect</a> </div> <div> <a href="fn_repl_new_log.html">repl_new_log</a> </div> <div> <a href="fn_repl_purge.html">repl_purge</a> </div> <div> <a href="fn_repl_server_rename.html">repl_server_rename</a> </div> <div> <a class="selected" href="fn_repl_status.html">repl_status</a> </div> <div> <a href="fn_repl_sync.html">repl_sync</a> </div> <div> <a href="fn_repl_sync_all.html">repl_sync_all</a> </div> <div> <a href="fn_repl_text.html">repl_text</a> </div> <div> <a href="fn_repl_this_server.html">repl_this_server</a> </div> <div> <a href="fn_sub_schedule.html">sub_schedule</a> </div> </div> <div> <a href="functions.html#soap">SOAP</a> </div> <div> <a href="functions.html#sql">SQL</a> </div> <div> <a href="functions.html#string">String</a> </div> <div> <a href="functions.html#txn">Transaction</a> </div> <div> <a href="functions.html#type">Type Mapping</a> </div> <div> <a href="functions.html#uddi">UDDI</a> </div> <div> <a href="functions.html#udt">User Defined Types & The CLR</a> </div> <div> <a href="functions.html#vad">VAD</a> </div> <div> <a href="functions.html#jvmpl">Virtuoso Java PL API</a> </div> <div> <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a> </div> <div> <a href="functions.html#ws">Web & Internet</a> </div> <div> <a href="functions.html#xml">XML</a> </div> <div> <a href="functions.html#XPATH">XPATH & XQUERY</a> </div> <br /> <div> <a href="functionidx.html">Functions Index</a> </div> <br /> </div> <div id="text"> <h2>repl_status</h2> <div class="refpurpose">returns status of a published or subscribed publication</div> <div class="funcsynopsis"> <span class="funcdef"> <span class="function">repl_status</span> </span> (<span class="paramdef">in <span class="parameter">publisher</span> varchar</span>, <span class="paramdef">in <span class="parameter">publication</span> varchar</span>, <span class="paramdef">out <span class="parameter">level</span> integer</span>, <span class="paramdef">out <span class="parameter">stat</span> integer</span>); </div> <div class="refsect1"> <div class="refsect1title">Description</div> <p>Given a publisher and publication name this returns the status of the publication on the local server.</p> </div> <div class="refsect1"> <div class="refsect1title">Parameters</div> <div class="refsect2"> <span class="refsect2title">publisher – </span> Name of the publisher. </div> <div class="refsect2"> <span class="refsect2title">publication – </span> Name of the publication. </div> <div class="refsect2"> <span class="refsect2title">level – </span> If the publisher is the name of the local server this returns the next transaction number to be assigned to a transaction as the level output parameter. If the publisher is other than the local server this returns the transaction number of the last transaction of that publication that has successfully been replicated to the local database as the level output parameter. </div> <div class="refsect2"> <span class="refsect2title">stat – </span> The stat output parameter reflects the current state of the subscription. If the publisher is the local server the stat is always 0. Otherwise it has the following possible values: <ul> <li> <strong>0 - off</strong> The subscription exists but there is no present or past activity..</li> <li> <strong>1 - syncing</strong> - A sync has successfully been requested and transactions are coming from the publisher at the present time.</li> <li> <strong>2 - in sync</strong> - The syncing phase has terminated and and this server is in sync with the publisher. This does not mean all the publisher's published transactions have at all times been replayed but this does mean that the sync request reached the end of the replication transaction log and that the servers were in sync at that moment.</li> <li> <strong>3 - disconnected by remote</strong> - The remote has disconnected this subscriber. This may be for various reasons, including that this subscriber has fallen too far behind in replaying the published transaction and has thus fallen out of sync. This state means that a resync can be retried with the repl_sync() function.</li> <li> <strong>4 - disconnected locally</strong> - This state is set for forward (publisher to subscriber) accounts when the corresponding pushback account is disconnected because of replication queue overflow. This state means that a resync can be retried with the repl_sync() function.</li> <li> <strong>5 - waiting for local disconnect</strong> - Local disconnect is about to happen for this account. This state is set for forward (publisher to subscriber) accounts when corresponding pushback account is disconnected because of replication queue overflow. This state means that "disconnected locally" state will be set for this account when next replication message for this account arrives. This state means that a resync can be retried with the repl_sync() function.</li> </ul> </div> </div> <div class="refsect1"> <div class="refsect1title">Example</div> <a name="ex_repl_status_1" /> <div class="example"> <div class="exampletitle">Retrieving the subscription status</div> <p>This example shows an analogue of the REPL_STAT() function.</p> <div> <pre class="screen"> create procedure MY_REPL_STAT () { declare server, account, status varchar; declare level, stat integer; status := vector ('OFF', 'SYNCING', 'IN SYNC', 'REMOTE DISCONNECTED', 'DISCONNECTED', 'TO DISCONNECT'); result_names (server, account, level, stat); for select SERVER, ACCOUNT from DB.DBA.SYS_REPL_ACCOUNTS do { repl_status (SERVER, ACCOUNT, level, stat); result (SERVER, ACCOUNT, level, aref (status, stat)); } }; </pre> </div> </div> </div> <div class="refsect1"> <div class="refsect1title">See Also</div> <p> <a href="fn_sub_schedule.html">sub_schedule()</a> </p> <p> <a href="fn_repl_disconnect.html">repl_disconnect()</a> </p> <p> <a href="fn_repl_grant.html">repl_grant()</a> </p> <p> <a href="fn_repl_init_copy.html">repl_init_copy()</a> </p> <p> <a href="fn_repl_new_log.html">repl_new_log()</a> </p> <p> <a href="fn_repl_pub_add.html">repl_pub_add()</a> </p> <p> <a href="fn_repl_pub_init_image.html">repl_pub_init_image()</a> </p> <p> <a href="fn_repl_pub_remove.html">repl_pub_remove()</a> </p> <p> <a href="fn_repl_publish.html">repl_publish()</a> </p> <p> <a href="fn_repl_revoke.html">repl_revoke()</a> </p> <p> <a href="fn_repl_sched_init.html">repl_sched_init()</a> </p> <p> <a href="fn_repl_server.html">repl_server()</a> </p> <p> <a href="fn_repl_server_rename.html">repl_server_rename()</a> </p> <p> <a href="fn_repl_stat.html">repl_stat()</a> </p> <p> <a href="fn_repl_subscribe.html">repl_subscribe()</a> </p> <p> <a href="fn_repl_sync.html">repl_sync()</a> </p> <p> <a href="fn_repl_sync_all.html">repl_sync_all()</a> </p> <p> <a href="fn_repl_text.html">repl_text()</a> </p> <p> <a href="fn_repl_this_server.html">repl_this_server()</a> </p> <p> <a href="fn_repl_unpublish.html">repl_unpublish()</a> </p> <p> <a href="fn_repl_unsubscribe.html">repl_unsubscribe()</a> </p> </div> </div> <div id="footer"> <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div> <div id="validation"> <a href="http://validator.w3.org/check/referer"> <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /> </a> <a href="http://jigsaw.w3.org/css-validator/"> <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" /> </a> </div> </div> </body> </html>