How to remove replication agent

Gary Wong

unread,

Sep 18, 2007, 8:35:38 PM9/18/07

to

Hi

I'm using Replication 12.6 and get the problem on the deletion in database
subscription. I'm using the GUI to delete but generate core dump eveything.
Any experience can give me helping hands?

Gary

Manish Negandhi

unread,

Sep 19, 2007, 12:32:32 AM9/19/07

to

Hi Gary

Can you please be more specific about the problem ?
Are you trying to drop subscriptions, what is the exact error message ?

Thanks
Manish

On 18 Sep 2007 17:35:38 -0700,
in sybase.public.rep-server

Gary Wong

unread,

Sep 19, 2007, 2:13:18 AM9/19/07

to

Hi Manish

Thanks for you reply. When I drop subscription in Sybase Central, I have
below message in Replication Server log:

2007/09/19 14:02:38. REPLICATE Replication Server: Dropping subscription
<pos_1> for database replication definition <pos_1> with replicate at
<aixdev02.pos>
E. 2007/09/19 14:04:38. ERROR #60024 USER(sa) - ul/alarm.c(1595)
Synchronization model CONDITION VARIABLE, element Timer TSD Cond Var
310bd2a0 was interrupted waiting for a lock. (4107)eneric/useful/sync.c.
I. 2007/09/19 14:04:38. No Sybase library information is available.

I'm using AIX platform 5.3 with Replication server 12.6 with ASE12.5.4
(Aserver) in the same machine and another AIX 5.3 running ASE 12.5.4
(Bserver) I want to replicate all data from Aserver to Bserver. But can't
establish replicate due to unable to drop wrong subscription. Any idea?
Please advise.

Gary

"Manish Negandhi" <nospam_mani...@yahoo.com>
???????:46f0a660@forums-1-dub...

Rob Verschoor

unread,

Sep 19, 2007, 5:27:58 AM9/19/07

to

Can you try dropping the sub through ISQL with the full repserver command?
In case of doubt, always step away from the GUI and run the manual command
to make sure the GUI isn't a factor here. If you get the same error msg with
the manual command, stop and restart repserver before trying again. If that
doesn't help, you should really contact Sybase Techsupport.

HTH,

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

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 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"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Gary Wong" <gary...@lcx.com.hk> wrote in message
news:46f0bdfe@forums-1-dub...

Gary Wong

unread,

Sep 19, 2007, 11:08:49 PM9/19/07

to

Thanks Rob. I'm new to the repserver, would you mind show me how to drop
sub in isql command base?

Regards,
Gary

"Rob Verschoor" <r...@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> 撰寫於郵件新聞:46f0eb9e$1@forums-1-dub...

Isabella

unread,

Sep 24, 2007, 12:04:17 PM9/24/07

to Gary Wong

Here is the syntax:

drop subscription subscription
for {table_rep_def | function_rep_def | article article_name in pub_name |
publication pub_name | database replication definition db_repdef
with primary at data_server.db }
with replicate at data_server.database
[without purge
[with suspension [at active replicate only ]] |
[incrementally] with purge]

Please see the Sybase Rep books on line for more details:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.jconnjdbc_6.05.jconnig/html/jconnig/title.htm&toc=/com.sybase.help.jconnjdbc_6.05/toc.xml

Isabella

Gary Wong

unread,

Sep 24, 2007, 10:13:14 PM9/24/07

to

Thanks Isabella, that's useful for me.

Gary

"Isabella" <isabella...@nrc-cnrc.gc.ca>
???????:46F7E000...@nrc-cnrc.gc.ca...