dbTalk Databases Forums  

How to find out if database is involved in replication

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss How to find out if database is involved in replication in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Deepali
 
Posts: n/a

Default How to find out if database is involved in replication - 10-20-2009 , 09:32 AM






How can we find out if ASA 7 database is involved in
replication.

Reply With Quote
  #2  
Old   
Reg Domaratzki [Sybase iAnywhere]
 
Posts: n/a

Default Re: How to find out if database is involved in replication - 10-20-2009 , 09:47 AM






Deepali wrote:
Quote:
How can we find out if ASA 7 database is involved in
replication.
By "replication" do you mean SQL Remote, Rep Server, MobiLink or any of
the above?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"

Reply With Quote
  #3  
Old   
Deepali
 
Posts: n/a

Default Re: How to find out if database is involved in replication - 10-20-2009 , 10:06 AM



Hi Reg
Quote:
I really don't have an idea about replication..
I am testing reloading my ASA7 database and I want to find
out if that is involved in any replication.

Deepali wrote:
Quote:
How can we find out if ASA 7 database is involved in
replication.

By "replication" do you mean SQL Remote, Rep Server,
MobiLink or any of the above?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange:
DCX.sybase.com SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN
ALL MONTHS"

Reply With Quote
  #4  
Old   
Reg Domaratzki [Sybase iAnywhere]
 
Posts: n/a

Default Re: How to find out if database is involved in replication - 10-20-2009 , 10:47 AM



Deepali wrote:
Quote:
Hi Reg
I really don't have an idea about replication..
I am testing reloading my ASA7 database and I want to find
out if that is involved in any replication.

Deepali wrote:
How can we find out if ASA 7 database is involved in
replication.
By "replication" do you mean SQL Remote, Rep Server,
MobiLink or any of the above?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange:
DCX.sybase.com SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN
ALL MONTHS"
select db_property( 'LTMTrunc' ),
db_property( 'RemoteTrunc' ),
db_property( 'SyncTrunc' )
from SYS.DUMMY;

If any of the three values returned are NOT 2^64 - 1 ( i.e.
18446744073709551615 ), then your database is involved in some sort of
replication or synchronization.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"

Reply With Quote
  #5  
Old   
Deepali
 
Posts: n/a

Default Re: How to find out if database is involved in replication - 10-20-2009 , 12:05 PM



Quote:
Thank You Reg,
My all three values returned are 18446744073709551615.
That means my database is not involved in replication..
right..

Thanks & Regards... Deepali

Deepali wrote:
Quote:
Hi Reg
I really don't have an idea about replication..
I am testing reloading my ASA7 database and I want to
find out if that is involved in any replication.

Deepali wrote:
How can we find out if ASA 7 database is involved in
replication.
By "replication" do you mean SQL Remote, Rep Server,
MobiLink or any of the above?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange:
DCX.sybase.com SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms
IN >> ALL MONTHS"

select db_property( 'LTMTrunc' ),
db_property( 'RemoteTrunc' ),
db_property( 'SyncTrunc' )
from SYS.DUMMY;

If any of the three values returned are NOT 2^64 - 1 (
i.e. 18446744073709551615 ), then your database is
involved in some sort of replication or synchronization.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange:
DCX.sybase.com SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN
ALL MONTHS"

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.