Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

how many rows in rs_lastcommit

2 posts in General Discussion Last posting was on 2012-09-21 16:56:37.0Z
syb_dba Posted on 2012-09-21 16:19:49.0Z
Sender: 21d6.505c92e9.1804289383@sybase.com
From: syb_dba
Newsgroups: sybase.public.rep-server
Subject: how many rows in rs_lastcommit
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <505c93a5.21f2.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Sep 2012 09:19:49 -0700
X-Trace: forums-1-dub 1348244389 172.20.134.41 (21 Sep 2012 09:19:49 -0700)
X-Original-Trace: 21 Sep 2012 09:19:49 -0700, 172.20.134.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9253
Article PK: 870410

Normally, how many rows does the rs_lastcommit table
contain?
If this table contains 2 rows, does this indicate something
amiss and is there a corrective action to be taken?


Luc Van der Veurst Posted on 2012-09-21 16:56:37.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <505c93a5.21f2.1681692777@sybase.com>
Subject: Re: how many rows in rs_lastcommit
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <505c9c45$1@forums-1-dub>
Date: 21 Sep 2012 09:56:37 -0700
X-Trace: forums-1-dub 1348246597 172.20.134.152 (21 Sep 2012 09:56:37 -0700)
X-Original-Trace: 21 Sep 2012 09:56:37 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9254
Article PK: 870409


<syb_dba> wrote in message news:505c93a5.21f2.1681692777@sybase.com...
> Normally, how many rows does the rs_lastcommit table
> contain?
> If this table contains 2 rows, does this indicate something
> amiss and is there a corrective action to be taken?

It depends. There is one row for each database where there are objects
replicated
from. Say you have server A with databases db1 and db2 and you replicate
tables from both databases to server B database db3, then in db3
rs_lastcommit
will contain 2 rows, one for db1 and one for db2.

If you look at the origin column of rs_lastcommit, you will find the value
of this
column in your rssd_db, table rs_databases column dbid.

The rs_lastcommit table in my databases also have a row with origin = 0.
I don't think this is necessary, but I'm not sure, the origin_time is Jan 1
1900,
but the dest_commit time is Sep 17 2012 in one of the databases I checked.

So if you replicate from only one database, and rs_lastcommit contains 2
rows,
one with origin 0 and one with origin the database id you are replicating
from,
then nothing is wrong.

hth,
Luc.