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.

Non logged transaction

3 posts in General Discussion Last posting was on 2011-07-19 10:32:35.0Z
David Posted on 2011-07-19 09:17:03.0Z
Sender: 329d.4e254b4f.1804289383@sybase.com
From: David
Newsgroups: sybase.public.rep-server
Subject: Non logged transaction
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e254b8f.32a5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Jul 2011 02:17:03 -0700
X-Trace: forums-1-dub 1311067023 10.22.241.41 (19 Jul 2011 02:17:03 -0700)
X-Original-Trace: 19 Jul 2011 02:17:03 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8998
Article PK: 841871

Do non logged transactions such as reorg rebuild stop
replication until the database is dumped


Rob V [ Sybase ] Posted on 2011-07-19 09:59:39.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.rep-server
Subject: Re: Non logged transaction
References: <4e254b8f.32a5.1681692777@sybase.com>
In-Reply-To: <4e254b8f.32a5.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: <4e25558b$1@forums-1-dub>
Date: 19 Jul 2011 02:59:39 -0700
X-Trace: forums-1-dub 1311069579 10.22.241.152 (19 Jul 2011 02:59:39 -0700)
X-Original-Trace: 19 Jul 2011 02:59:39 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8999
Article PK: 870166


On 19-Jul-2011 11:17, David wrote:
> Do non logged transactions such as reorg rebuild stop
> replication until the database is dumped

They do not stop replication: all that the ASE Replication Agent does is
look for log records that are marked for replication; it simply ignores
everything else.
But you need to enable the database option 'select
into/bulkcopy/pllsort' in order to perform such minimally logged
operations, and that may be soemthing that is not desired for other
reasons, namely the fact that you cannot dump the transaction log
anymore after a minimally logged operation. That is the reason why you
need to do a full database dump -- if you want to be able to recover
your database in case of a calamity.

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
-----------------------------------------------------------------