How does "use dump marker" work?

[BB]

I just have done a replication test by using definition and
subscription to a particular table. I wish to use dump
marker because I don't want to lose any transaction during
replication initialization period. However I can't make
dump marker work, the transactions do not apply to replicate
site after I activate subscription. Here are my steps
below.

1. Add both Primary and Replicate db into RS by rs_init

2. Make a particular table able to replicate
>sp_setreptable test_table, 'true'

3. Create database definition
>create database replication definition
AIUMELP3SYB01_pubs2_repdef
with primary at AIUMELP3SYB01.pubs2
not replicate DDL
replicate tables in (dbo.test_table)
replicate functions
replicate transactions
replicate system procedures

4. Create subscription
>define subscription AIUMELP3SYB01_pubs2_subs
for database replication definition
AIUMELP3SYB01_pubs2_repdef
with primary at AIUMELP3SYB01.pubs2
with replicate at AIUP3SYB02.pubs2
use dump marker

5. dump database

6. Do some transactions against test_table (I insert couple
of records)

7. load database

8. grant dbo alias to maint user

9. activate subscription

After activation, transaction I did from step 6 didn't apply
to replicate database. New transaction happen from now on
will be applied to replication database.

That's my question, in this case dump marker doesn't seem to
work at this point. Did I miss something to let it work
properly?

[Luc Van der Veurst]

<BB> wrote in message news:4b26ef94.7e8...@sybase.com...

What's the status of the connection to AIUP3SYB02.pubs2 at this point ?
This statement should suspend the connection.

> 5. dump database
>
> 6. Do some transactions against test_table (I insert couple
> of records)
>
> 7. load database
>
> 8. grant dbo alias to maint user
>
> 9. activate subscription

You don't have to activate the subscription.
Normally at this point you just have to resume the connection to
AIUP3SYB02.pubs2

> After activation, transaction I did from step 6 didn't apply
> to replicate database. New transaction happen from now on
> will be applied to replication database.
>
> That's my question, in this case dump marker doesn't seem to
> work at this point. Did I miss something to let it work
> properly?

Except for the remark about step 9, it works as you expect it to work.

Luc.

[BB]

Thanks for reply Luc, please see my comment below.

At this point, both connections' DSI state is "Active" and
for Primary site's Replication Agent State is "Active".

>
> > 5. dump database
> >
> > 6. Do some transactions against test_table (I insert
> > couple of records)
> >
> > 7. load database
> >
> > 8. grant dbo alias to maint user
> >
> > 9. activate subscription
>
> You don't have to activate the subscription.
> Normally at this point you just have to resume the
> connection to AIUP3SYB02.pubs2
>
>
>
> > After activation, transaction I did from step 6 didn't
> > apply to replicate database. New transaction happen
> > from now on will be applied to replication database.
> >
> > That's my question, in this case dump marker doesn't
> > seem to work at this point. Did I miss something to let
> > it work properly?
>
> Except for the remark about step 9, it works as you expect
> it to work.
>
> Luc.
>

I tried not to acitve subscription but it did not work
either, and the state of subscription is "Defined".

I found that without active subscription not only
transactions before loading database won't apply but also
further transactions won't apply either.

[BB]

It's now working beautifully..

I found an issue about this from Sybase support website, if
your Primary/Replicate DB sa password is different from RS
sa one, there will be error happen during materialization
stage and that what I hit.

I simply change sa password to the same as RS sa one then it
works now.