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.

Checking unprocessed transactions from RAO 12.5 transaction log

2 posts in Replication Agent Last posting was on 2006-03-16 13:46:26.0Z
mskr Posted on 2006-03-14 14:20:30.0Z
Sender: 6de3.4406e603.1804289383@sybase.com
From: MSKR
Newsgroups: sybase.public.rep-agent
Subject: Checking unprocessed transactions from RAO 12.5 transaction log
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4416d12e.6026.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Mar 2006 06:20:30 -0800
X-Trace: forums-1-dub 1142346030 10.22.241.41 (14 Mar 2006 06:20:30 -0800)
X-Original-Trace: 14 Mar 2006 06:20:30 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:849
Article PK: 862424

How can we check the transactions that are not replicated
from RAO 12.5 transaction log to Replication
Server/Replicate Database (Sybase).

Is the any field in RA_TRAN_LOG_ ?


mskr Posted on 2006-03-16 13:46:26.0Z
Sender: 5c5.44195bf1.1804289383@sybase.com
From: MSKR
Newsgroups: sybase.public.rep-agent
Subject: Re: Checking unprocessed transactions from RAO 12.5 transaction log
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44195c5a.5cb.1681692777@sybase.com>
References: <4416d12e.6026.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 16 Mar 2006 04:38:50 -0800, 10.22.241.42
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Mar 2006 04:38:53 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Mar 2006 05:46:26 -0800
X-Trace: forums-1-dub 1142516786 10.22.108.75 (16 Mar 2006 05:46:26 -0800)
X-Original-Trace: 16 Mar 2006 05:46:26 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:850
Article PK: 862426


> How can we check the transactions that are not replicated
> from RAO 12.5 transaction log to Replication
> Server/Replicate Database (Sybase).
>
> Is the any field in RA_TRAN_LOG_ ?

in Oracle, excute

select * from RA_TRAN_LOG_ where PROCESS_SEQ = 0

-- list the transactions which are not yet replicated to
RS/RDS.