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.

replication and dboptions

2 posts in General Discussion Last posting was on 2012-10-24 11:32:13.0Z
JT Posted on 2012-10-24 10:48:03.0Z
Sender: 731d.5087c698.1804289383@sybase.com
From: JT
Newsgroups: sybase.public.ase.general
Subject: replication and dboptions
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5087c762.7341.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 24 Oct 2012 03:48:03 -0700
X-Trace: forums-1-dub 1351075683 172.20.134.41 (24 Oct 2012 03:48:03 -0700)
X-Original-Trace: 24 Oct 2012 03:48:03 -0700, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31469
Article PK: 74358

Hi

I have a replicated database(warm standby) which has the
dboptions "select into", "trunc log" set. Question is as the
replication has been stable, can I conclude no non logged
operations occur and turning off these 2 options on database
will impact.

Thanks for any insight


Rob V Posted on 2012-10-24 11:32:13.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: replication and dboptions
References: <5087c762.7341.1681692777@sybase.com>
In-Reply-To: <5087c762.7341.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: <5087d1bd$1@forums-1-dub>
Date: 24 Oct 2012 04:32:13 -0700
X-Trace: forums-1-dub 1351078333 172.20.134.152 (24 Oct 2012 04:32:13 -0700)
X-Original-Trace: 24 Oct 2012 04:32:13 -0700, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31470
Article PK: 74362


On 24-Oct-2012 12:48, JT wrote:
> Hi
>
> I have a replicated database(warm standby) which has the
> dboptions "select into", "trunc log" set. Question is as the
> replication has been stable, can I conclude no non logged
> operations occur and turning off these 2 options on database
> will impact.
>
> Thanks for any insight
>

You cannot conclude that.
Replication will work with these options enabled. The "trunc log on
chkpt" option just means the log gets automatically truncated but this
will never go beyond the LTM trunc point that is maintained by the
RepAgent; so it has no impact on replication.
The "select into" option allows minimally logged operations to occur.
However, such operations are not replicated anyway (leaving aside one
particular aspect of SQL Statement replication in RS 15.2 and ASE
15.0.3). So if you do a fast BCP-in operation, the rows inserted into
the table will not be replicated since their inserts are not in the
transaction log. The RepAgent simply ignores the log records for such
operations.
If you want to guarantee no minimally logged operations occur, you must
switch off the "select into" option.

--
HTH,

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

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"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
-----------------------------------------------------------------