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.

drop route with nowait

3 posts in General Discussion Last posting was on 2011-07-07 07:15:46.0Z
Sergio Diogo Posted on 2011-07-05 15:15:04.0Z
Sender: 6dd6.4e130e82.1804289383@sybase.com
From: Sergio Diogo
Newsgroups: sybase.public.rep-server
Subject: drop route with nowait
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e132a78.7504.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jul 2011 08:15:04 -0700
X-Trace: forums-1-dub 1309878904 10.22.241.41 (5 Jul 2011 08:15:04 -0700)
X-Original-Trace: 5 Jul 2011 08:15:04 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8972
Article PK: 870150

Hi,

I have a situation where we did lost the replication server
and the replicated Sybase Server (that also behaves as
primary server - MSA).

The situation is not so bad as we were to decommission both
servers.

However, we need now to drop the route that exists between
that server and another one.

I plan to execute drop route with nowait, once the
replicated server is not available.

My question is, is there anything else to consider? any risk
on doing drop route with nowait?

Thanks in advance,
Regards,
Sergio


Manish Negandhi [TeamSybase] Posted on 2011-07-07 03:11:15.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.rep-server
References: <4e132a78.7504.1681692777@sybase.com>
Subject: Re: drop route with nowait
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e1523d3$1@forums-1-dub>
Date: 6 Jul 2011 20:11:15 -0700
X-Trace: forums-1-dub 1310008275 10.22.241.152 (6 Jul 2011 20:11:15 -0700)
X-Original-Trace: 6 Jul 2011 20:11:15 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8974
Article PK: 870149


<Sergio Diogo> wrote in message news:4e132a78.7504.1681692777@sybase.com...
> Hi,
>
> I have a situation where we did lost the replication server
> and the replicated Sybase Server (that also behaves as
> primary server - MSA).
>
> The situation is not so bad as we were to decommission both
> servers.
>
> However, we need now to drop the route that exists between
> that server and another one.
>
> I plan to execute drop route with nowait, once the
> replicated server is not available.
>
> My question is, is there anything else to consider? any risk
> on doing drop route with nowait?
>
> Thanks in advance,
> Regards,
> Sergio

not any that i know of, you might need to execute sysadmin
purge_route_at_replicate in destination repserver after using drop route in
order to
remove RSSD system table information

-HTH
Manish Negandhi
[TeamSybase]