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 status3 versus rep agent

2 posts in General Discussion Last posting was on 2011-07-14 09:09:36.0Z
Raj Posted on 2011-07-14 05:09:44.0Z
Sender: d37.4e1d19ec.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: sybase database status3 versus rep agent
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e1e7a18.36a5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Jul 2011 22:09:44 -0700
X-Trace: forums-1-dub 1310620184 10.22.241.41 (13 Jul 2011 22:09:44 -0700)
X-Original-Trace: 13 Jul 2011 22:09:44 -0700, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30342
Article PK: 72519

Hi All, can you help me to understand how sysdatabases
"status3"
is concern with configuration of rep agent for the database.


Rob V [ Sybase ] Posted on 2011-07-14 09:09:36.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sybase database status3 versus rep agent
References: <4e1e7a18.36a5.1681692777@sybase.com>
In-Reply-To: <4e1e7a18.36a5.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e1eb250$1@forums-1-dub>
Date: 14 Jul 2011 02:09:36 -0700
X-Trace: forums-1-dub 1310634576 10.22.241.152 (14 Jul 2011 02:09:36 -0700)
X-Original-Trace: 14 Jul 2011 02:09:36 -0700, vip152.sybase.com
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30345
Article PK: 72523


On 14-Jul-2011 07:09, Raj wrote:
> Hi All, can you help me to understand how sysdatabases
> "status3"
> is concern with configuration of rep agent for the database.

Some of the status bits are documented in the "System tables" section of
the ASE Reference Manual, but not everything is documented. You may be
able to get some insight by looking at the source code for the
sp_help_rep_agent and sp_config_rep_agent procedures in the
'installmaster' script, but there is no guarantee for getting a complete
picture. These status columns are internals, after all, and not always
fully documented in the user documentation.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------