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 to filter the work of RAOracle

2 posts in Replication Agent Last posting was on 2004-06-08 15:41:00.0Z
Claudia Posted on 2004-06-08 13:11:24.0Z
Sender: ff7.40c4ecb6.1804289383@sybase.com
From: Claudia
Newsgroups: sybase.public.rep-agent
Subject: How to filter the work of RAOracle
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40c5bb41.1bfa.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 8 Jun 2004 06:12:33 -0700, 10.22.241.42
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Jun 2004 06:08:59 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Jun 2004 06:11:24 -0700
X-Trace: forums-1-dub 1086700284 10.22.108.75 (8 Jun 2004 06:11:24 -0700)
X-Original-Trace: 8 Jun 2004 06:11:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:680
Article PK: 862333

Hi,

I am triying to implement a replication from Oracle using a
RAO 12.5.

The most important table has 450.000.000 rows and a rate of
400.000 insert by day.

HOWEVER they want to replicate only a 2% filter by ID column
=10....

How can I filter the work of Rep_agent ? As I know the RAO
write all information to XLOG tables ! and the send it to
replication...

Can I filter at trigger level? Can I modify the trigger?
What is the best option ?

Any suggestion.

Thanks in advance.
CLaudia


Wanda Beck Posted on 2004-06-08 15:41:00.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <40c5bb41.1bfa.1681692777@sybase.com>
Subject: Re: How to filter the work of RAOracle
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <40c5de63$1@forums-2-dub>
X-Original-Trace: 8 Jun 2004 08:42:27 -0700, wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Jun 2004 08:38:34 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Jun 2004 08:41:00 -0700
X-Trace: forums-1-dub 1086709260 10.22.108.75 (8 Jun 2004 08:41:00 -0700)
X-Original-Trace: 8 Jun 2004 08:41:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:681
Article PK: 862335

Hi, Claudia,

I suggest you do the following in RepAgent:

* first create the XLog:

pdb_xlog create

* turn off the automatic execution of scripts

ra_config pdb_auto_run_scripts, false

* mark your desired table

pdb_setreptable my_table, mark

* turn on the automatic execution of scripts

ra_config pdb_auto_run_scripts, true

Now locate the mark.sql in $SYBASE/rax-12_5/<instance>/scripts/my_table.
Edit the mark.sql, then manually execute the script in Oracle.

When editing, be sure that the columns of the shadow table (not the blob
shadow table) and the columns of the last statement (insert) of the shadow
row procedure match up, and that the parameters of the shadow row procedure
and the parameters in the call to the shadow row procedure in all three
triggers match up. Be sure not to change anything else that's already there,
but you can certainly add logic to do the desired filtering.

I hope this helps.

Thanks,
Wanda

<Claudia> wrote in message news:40c5bb41.1bfa.1681692777@sybase.com...
> Hi,
>
> I am triying to implement a replication from Oracle using a
> RAO 12.5.
>
> The most important table has 450.000.000 rows and a rate of
> 400.000 insert by day.
>
> HOWEVER they want to replicate only a 2% filter by ID column
> =10....
>
> How can I filter the work of Rep_agent ? As I know the RAO
> write all information to XLOG tables ! and the send it to
> replication...
>
> Can I filter at trigger level? Can I modify the trigger?
> What is the best option ?
>
> Any suggestion.
>
> Thanks in advance.
> CLaudia