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.

Empty inbound queue

2 posts in Replication Agent Last posting was on 2003-09-08 14:33:30.0Z
Tamás Sváb Posted on 2003-08-28 12:43:46.0Z
Reply-To: "Tamás Sváb" <tamas@svab.hu>
From: "Tamás Sváb" <tamas@svab.hu>
Newsgroups: sybase.public.rep-agent
Subject: Empty inbound queue
Lines: 25
Organization: Artsoft Ltd.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Original-NNTP-Posting-Host: xena.hungexpo.hu
Message-ID: <3f4df933@forums-2-dub>
X-Original-Trace: 28 Aug 2003 05:44:35 -0700, xena.hungexpo.hu
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Aug 2003 05:42:08 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Aug 2003 05:43:46 -0700
X-Trace: forums-1-dub 1062074626 10.22.108.75 (28 Aug 2003 05:43:46 -0700)
X-Original-Trace: 28 Aug 2003 05:43:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:615
Article PK: 862269

Hello !

My problem is:

The replication system is working right, but the MSSQL repagent's inbound
queue is bigger day by day.
How can I set the inbound queue's size to 0 ? I have to add more and more
stable queue.

The ra_config parameter is:

truncation_interval int 60
truncation_type String INTERVAL

I've already tried to run command pdb_truncate_xlog.


Thanks for your answer

Tom


Greg Carter Posted on 2003-09-08 14:33:30.0Z
Message-ID: <3F5C929B.3000708@workmail.com>
From: Greg Carter <greg.carter@workmail.com>
Reply-To: greg.carter@workmail.com
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
To: =?ISO-8859-1?Q?Tam=E1s_Sv=E1b?= <tamas@svab.hu>
Subject: Re: Empty inbound queue
References: <3f4df933@forums-2-dub>
In-Reply-To: <3f4df933@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vpn-dub-109.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-109.sybase.com
Date: 8 Sep 2003 07:33:30 -0700
X-Trace: forums-1-dub 1063031610 10.22.120.109 (8 Sep 2003 07:33:30 -0700)
X-Original-Trace: 8 Sep 2003 07:33:30 -0700, vpn-dub-109.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:621
Article PK: 862274

Tom,

Is it the inbound queue in RepServer or the simulated transaction log in
MS-SQL Server that is the problem. In the first case, a slow Distributor
thread in RepServer would be indicated. In the second, a slow RepAgent.

--
Thanks,
G.Carter
Sybase Replication Server Engineering
mailto:greg.carter@workmail.com

Tamás Sváb wrote:

>Hello !
>
>My problem is:
>
>The replication system is working right, but the MSSQL repagent's inbound
>queue is bigger day by day.
>How can I set the inbound queue's size to 0 ? I have to add more and more
>stable queue.
>
>The ra_config parameter is:
>
> truncation_interval int 60
> truncation_type String INTERVAL
>
>I've already tried to run command pdb_truncate_xlog.
>
>
>Thanks for your answer
>
>Tom
>
>
>
>
>
>
>