Sybase Blog -Anything About Sybase ASE,REP,IQ.

Saturday, January 23, 2010

How to check the Replication Latency manually?

Hi Folks,
For the checking latency between Primary and Replicated DBs , we have several methods.

Here, I am posting the manual method for checking the replication latency. If you have any more thoughts, please comment it out.

Rite Now I am travelling to Delhi, my train got late, so I am spending my time with my fav, with new posting in blog.

For calculating the latency, we can make two tables in PDB and RDB with column as defaut datetime, and setup replication between these two tables.

Before excuting the batch of your's queries, insert the id (only for reference for the point, where we executed the insert statement) and it will update the primary_datetime by default current system date.

After the completing the batch, insert the the next id, automaticaly it will get the finish date in default column.

Now go to RDS and check the diff between primary_datetime and replicate_datetime.

1. IN PDS/PDB Create one table as
create table timer_table(id int, primary_datetime datetime default getdate())

2. In RDS/RDB create same table with one extra coloum
create table timer_table(id int,primary_datetime datetime,replicate_datetime default getdate())

3. Setup the replication between both.

4. Before executing the batch insert the value in table as
insert into timer_table (id) values(100)

5. Execute your batch for queries.

6. After completion, execute the insert statement as
insert into timer_table (id) values(101)

7. Now go in the replicated dataserver(RDS/RDB) and check the diff between primary_datetime and replicate_datetime.
select datediff(ss,min(primary_datetime),max(replicate_datetime)) from timer_table

With the help of id you can check the latency upto that point. Even,You can customize this method for checking the latency.

Thanks,
Source : www & sybooks.
Same Thread @ : http://www.sybaseteam.com/how-to-test-latency-t-692.html

Monday, January 18, 2010

Sybase India Names Inflow Technologies As National Distributor

Sybase Software (India) Pvt. Ltd, the Indian subsidiary of Sybase, Inc., a provider of enterprise infrastructure and mobile software, today announced that it entered into a master reseller agreement with Inflow Technologies Pvt. Ltd in India.

The agreement will enable Inflow Technologies to extend the benefits of Sybase's offerings, particularly analytics and enterprise mobility, to the growing market in India, said a press release.

Inflow Technologies, part of the US$ 5 billion Datatec Group, has presence in more than 12 locations across India and Sri Lanka.
Sources : news, www.