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.

does warm standby break up if statements

4 posts in General Discussion Last posting was on 2011-07-13 08:04:12.0Z
David Posted on 2011-07-12 11:05:35.0Z
Sender: 4575.4e1aba4b.1804289383@sybase.com
From: David
Newsgroups: sybase.public.rep-server
Subject: does warm standby break up if statements
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e1c2a7f.6e80.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jul 2011 04:05:35 -0700
X-Trace: forums-1-dub 1310468735 10.22.241.41 (12 Jul 2011 04:05:35 -0700)
X-Original-Trace: 12 Jul 2011 04:05:35 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8983
Article PK: 841867

I know this is a basic question, but we had a third party
release a script into are test warm standby system, they
turned off replication to create a proc, then turned
replication back uo to run the proc and then drop it, the
below statement brought down replication, did replication
try and run the drop proc command even though it was in an
if statement?
if object_id('dbo.sup_BldPolStatByPolId') is not null
begin
drop procedure dbo.sup_BldPolStatByPolId
PRINT '<<< DROPPED PROCEDURE dbo.sup_BldPolStatByPolId >>>'
end
go


Michael Peppler [Team Sybase] Posted on 2011-07-12 15:59:09.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: does warm standby break up if statements
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2011.07.12.15.59.09.480144@peppler.org>
Newsgroups: sybase.public.rep-server
References: <4e1c2a7f.6e80.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 12 Jul 2011 08:59:09 -0700
X-Trace: forums-1-dub 1310486349 10.22.241.152 (12 Jul 2011 08:59:09 -0700)
X-Original-Trace: 12 Jul 2011 08:59:09 -0700, vip152.sybase.com
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8984
Article PK: 870165


On Tue, 12 Jul 2011 04:05:35 -0700, David wrote:

> I know this is a basic question, but we had a third party release a script
> into are test warm standby system, they turned off replication to create a
> proc, then turned replication back uo to run the proc and then drop it,
> the below statement brought down replication, did replication try and run
> the drop proc command even though it was in an if statement?
> if object_id('dbo.sup_BldPolStatByPolId') is not null begin
> drop procedure dbo.sup_BldPolStatByPolId PRINT '<<< DROPPED PROCEDURE
> dbo.sup_BldPolStatByPolId >>>'
> end
> go

No, the if statement is not replicated.

If the body of the if statement got executed on the primary, then it will
get replicated to the standby.

Michael


"Mark A. Parsons" <iron_horse Posted on 2011-07-12 21:45:53.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: does warm standby break up if statements
References: <4e1c2a7f.6e80.1681692777@sybase.com>
In-Reply-To: <4e1c2a7f.6e80.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: <4e1cc091$1@forums-1-dub>
Date: 12 Jul 2011 14:45:53 -0700
X-Trace: forums-1-dub 1310507153 10.22.241.152 (12 Jul 2011 14:45:53 -0700)
X-Original-Trace: 12 Jul 2011 14:45:53 -0700, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:8985
Article PK: 870177

What do you mean by 'brought down replication'?

Did the DSI connection into your RDB (replicate database) go down? If so, did you issue a 'resume connection/skip tran'
or 'sysadmin log_first_tran' ... and if so, did you look in the exceptions log (RSSD : rs_helpexception) to get the text
of the actual command that brought down the DSI? When a DSI goes down you'll usually get an informative message in the
RS errorlog ... did you see anything in the RS errorlog?

Did something else go 'down' other than the DSI, and if so, what?

On 07/12/2011 07:05, David wrote:
> I know this is a basic question, but we had a third party
> release a script into are test warm standby system, they
> turned off replication to create a proc, then turned
> replication back uo to run the proc and then drop it, the
> below statement brought down replication, did replication
> try and run the drop proc command even though it was in an
> if statement?
> if object_id('dbo.sup_BldPolStatByPolId') is not null
> begin
> drop procedure dbo.sup_BldPolStatByPolId
> PRINT '<<< DROPPED PROCEDURE dbo.sup_BldPolStatByPolId>>>'
> end
> go