replmerge batch options need good explanation 
Author Message
 replmerge batch options need good explanation

I need clarification on the following options and how to use them in
ReplMerge

-BCPBatchSize 100000
-Changes per History 100
-DownloadGenerationsPerBatch 20
-DownloadReadChangesPerBatch 100
-DownloadWriteChangesPerBatch 100

The above has values defined for a merge profile slow connection.. Can
someone explain the pros and cons to each of these settings? What is
considered a slow connection?

What is BCPBatchSize defined in? bytes?
What does changes per history mean?
What is considered a generation?
What is considered a batch?
Why would I want to change read changes or write changes per batch?



Sat, 28 Feb 2004 19:16:58 GMT
 replmerge batch options need good explanation

You should use the slow link profile.
bcpbatchsize is used when applying snapshot.  It is a way to say commit
after 10000 records
changes per history is how many history log entries you would get per set of
changes.  By default after every 100 changes, one history record is logged
in MSmerge_history
downloadgenerationsperbatch is how many generations are committed in a batch
Similarily read and write changes perbatch.


Quote:
> I need clarification on the following options and how to use them in
> ReplMerge

> -BCPBatchSize 100000
> -Changes per History 100
> -DownloadGenerationsPerBatch 20
> -DownloadReadChangesPerBatch 100
> -DownloadWriteChangesPerBatch 100

> The above has values defined for a merge profile slow connection.. Can
> someone explain the pros and cons to each of these settings? What is
> considered a slow connection?

> What is BCPBatchSize defined in? bytes?
> What does changes per history mean?
> What is considered a generation?
> What is considered a batch?
> Why would I want to change read changes or write changes per batch?



Sun, 07 Mar 2004 13:38:31 GMT
 replmerge batch options need good explanation
Thanks for response,

What is considered a batch?
What is considered a generation per batch?

Quote:

> You should use the slow link profile.
> bcpbatchsize is used when applying snapshot.  It is a way to say commit
> after 10000 records
> changes per history is how many history log entries you would get per set of
> changes.  By default after every 100 changes, one history record is logged
> in MSmerge_history
> downloadgenerationsperbatch is how many generations are committed in a batch
> Similarily read and write changes perbatch.



> > I need clarification on the following options and how to use them in
> > ReplMerge

> > -BCPBatchSize 100000
> > -Changes per History 100
> > -DownloadGenerationsPerBatch 20
> > -DownloadReadChangesPerBatch 100
> > -DownloadWriteChangesPerBatch 100

> > The above has values defined for a merge profile slow connection.. Can
> > someone explain the pros and cons to each of these settings? What is
> > considered a slow connection?

> > What is BCPBatchSize defined in? bytes?
> > What does changes per history mean?
> > What is considered a generation?
> > What is considered a batch?
> > Why would I want to change read changes or write changes per batch?



Mon, 08 Mar 2004 20:05:42 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Question on using replmerge -validate 1 option

2. Sorting counting summing to a table - Better explanation

3. Two tables, one Grid? (better explanation)

4. Q: Record out of range - a better explanation

5. better explanation to my formula problem

6. while loops and stuff - better explanation

7. PL/SQL Developer (better explanation)

8. problems with ODBC drivers and BDE alias: I need explanation

9. Explanation needed...

10. transportable tablespaces - violation explanation needed

11. Need explanation for an error msg...

12. HELP! Need Explanation of this Trace


 
Powered by phpBB® Forum Software