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.

Rep agent problem

3 posts in Replication Agent Last posting was on 2005-12-16 06:41:54.0Z
pradeep Posted on 2005-04-27 23:13:15.0Z
Sender: 3fb6.42700dc0.1804289383@sybase.com
From: Pradeep
Newsgroups: sybase.public.rep-agent
Subject: Rep agent problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42701c85.40a1.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 27 Apr 2005 16:13:09 -0700, 10.22.241.42
Lines: 5
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Apr 2005 16:13:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Apr 2005 16:13:15 -0700
X-Trace: forums-1-dub 1114643595 10.22.108.75 (27 Apr 2005 16:13:15 -0700)
X-Original-Trace: 27 Apr 2005 16:13:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:797
Article PK: 862395

I have rep agent running on ASE 12.5.1 the repagent is
always latent , the tran log queues up in gb dbcc getttrunc
show that the secondary trun page moves slowly any idea ,
waht i want is to make the rep agent read faster from log
any idea would be appreciated


Eric Simbozel Posted on 2005-05-02 15:23:56.0Z
From: Eric Simbozel <esimboze.externe@m6.fr>
Reply-To: esimboze.externe@m6.fr
Organization: M6
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: fr, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: Rep agent problem
References: <42701c85.40a1.1681692777@sybase.com>
In-Reply-To: <42701c85.40a1.1681692777@sybase.com>
Content-Type: multipart/alternative; boundary="------------070408060607000901040701"
X-Original-NNTP-Posting-Host: 110.12-14-84.ripe.coltfrance.com
Message-ID: <42764607@forums-2-dub>
X-Original-Trace: 2 May 2005 08:23:51 -0700, 110.12-14-84.ripe.coltfrance.com
Lines: 64
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 May 2005 08:23:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 May 2005 08:23:56 -0700
X-Trace: forums-1-dub 1115047436 10.22.108.75 (2 May 2005 08:23:56 -0700)
X-Original-Trace: 2 May 2005 08:23:56 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:798
Article PK: 862390

Hi, Pradeep
this is may be  cause RepAgent to process some "Forward Scan" in the DB log to search for old table schema.
You can try to increase RepAgent parameter "schema cache growth factor" from "1" (default value) to "4", then stop and restart RepAgent.
and run sp_help_rep_agent <dbname>, 'scan'

Pradeep a écrit :

I have rep agent running on ASE 12.5.1 the repagent is always latent , the tran log queues up in gb dbcc getttrunc show that the secondary trun page moves slowly any idea , waht i want is to make the rep agent read faster from log any idea would be appreciated


Vivek Posted on 2005-12-16 06:41:54.0Z
Sender: 4dc0.43a25a03.1804289383@sybase.com
From: Vivek
Newsgroups: sybase.public.rep-agent
Subject: Re: Rep agent problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43a25f7a.4dec.1681692777@sybase.com>
References: <42701c85.40a1.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 15 Dec 2005 22:32:26 -0800, 10.22.241.42
Lines: 42
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Dec 2005 22:32:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Dec 2005 22:41:54 -0800
X-Trace: forums-1-dub 1134715314 10.22.108.75 (15 Dec 2005 22:41:54 -0800)
X-Original-Trace: 15 Dec 2005 22:41:54 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:829
Article PK: 862415

Hi,

I know i am postinbg a reply quite late. But still it may
help in future.


Try out the following:

1.Increase the ra parameter "scan_batch_size" .

IN PDB, do ra_config "scan_batch_size" and check the value
for the same. The default value is 1000. Increasinbg this
value to 20,000 or higher has generally increased the RA
performance by 20% or higher. But for this , you need to
take care about the size of the transaction log. Increasing
this parameter, instructs the RA to ask for secondary
truncation point at a latter stage thereby reducing the
context switching calls at hthe OS level .That means the
secondary truncation point changes after a longer period in
the syslogsholds table.

2.Decrease the ra parameter "retry timeout: : You can
decrease it from default 60 seconds to say 10 sec or 5sec.

3.Try increasing the priority: Again this parameter can
affect the performance of other applications. The values are
4,5,6 standing for high,medium and low priority.

4.Reduce ra poarameter "scan timeout":You can reduce it from
default of 15 seconds to say 5 seconds.


Regards,
Vivek

> I have rep agent running on ASE 12.5.1 the repagent is
> always latent , the tran log queues up in gb dbcc
> getttrunc show that the secondary trun page moves slowly
> any idea , waht i want is to make the rep agent read
> faster from log any idea would be appreciated