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.

Sybase Database automatic recovery

2 posts in replicator Last posting was on 2005-12-12 19:49:00.0Z
Shenese Posted on 2005-12-06 11:35:29.0Z
From: "Shenese" <SheneseK@yahoo.co.uk>
Newsgroups: sybase.public.ase.replicator
Organization: 196.26.21.196
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Sybase Database automatic recovery
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <43957584@forums-2-dub>
X-Original-Trace: 6 Dec 2005 03:27:00 -0800, web110.discountasp.net
Lines: 7
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Dec 2005 03:27:00 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Dec 2005 03:35:29 -0800
X-Trace: forums-1-dub 1133868929 10.22.108.75 (6 Dec 2005 03:35:29 -0800)
X-Original-Trace: 6 Dec 2005 03:35:29 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:115
Article PK: 103353

Does anyone know how to automatically bring up Sybase Replication Server if one
of the threads has gone down? This is necessary for weekends or nights or
vacations if the Rep Server has lost a connection.
Thanks

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Jason L. Froebe [Team Sybase] Posted on 2005-12-12 19:49:00.0Z
From: "Jason L. Froebe [Team Sybase]" <jfroebe@froebe.net>
Organization: Team Sybase
User-Agent: Thunderbird 1.5 (Windows/20051025)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: Sybase Database automatic recovery
References: <43957584@forums-2-dub>
In-Reply-To: <43957584@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: c-67-175-232-244.hsd1.il.comcast.net
X-Original-NNTP-Posting-Host: c-67-175-232-244.hsd1.il.comcast.net
Message-ID: <439dd42c$1@forums-1-dub>
Date: 12 Dec 2005 11:49:00 -0800
X-Trace: forums-1-dub 1134416940 67.175.232.244 (12 Dec 2005 11:49:00 -0800)
X-Original-Trace: 12 Dec 2005 11:49:00 -0800, c-67-175-232-244.hsd1.il.comcast.net
Lines: 17
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:119
Article PK: 103352


Shenese wrote:
> Does anyone know how to automatically bring up Sybase Replication Server if one
> of the threads has gone down? This is necessary for weekends or nights or
> vacations if the Rep Server has lost a connection.
> Thanks
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp

I would create a cron job that logs into the repserver looking for down
or suspended DSI/RSI connections and resuming them as needed. For DSIs
that are down due to duplicate rows, I would have someone resume these
manually once it was verified that the row could be skipped.

Jason L. Froebe
Team Sybase
http://jfroebe.livejournal.com