Home > Archive > SQL Anywhere database replication > January 2006 > ProgIndexCallBack callback (Running dbremote via DBTOOLS)









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ProgIndexCallBack callback (Running dbremote via DBTOOLS)
TPS

2006-01-09, 9:23 am

It appears that this callback is only called via the Scan / Send phase of
the replication. How do you get information on the progress of the recieving
phase?

I have an application that displays a progress bar as the replication takes
place. In the title bar I have messages indicating the beginning of each
phase. (i.e. "recieving, scanning, sending). You can clearly see that the
progress bar does not move until the scanning/sending phase starts.

Any help would be greatly appreciated.

Thanks
TPS


Nick Elson

2006-01-09, 1:23 pm

I would assume that the progress bar is only tied to the "log scanning"
/"send" phases.

That is the way dbremote/ssremote works and I remember that the
callback function was added to facilitate just that.

As an observation, with those phases there is a reasonable expectation
that the utility knows what the upper bound will be. In comparison, with
the receive phase, from start to finish there is a variable number of
messages possible per remote and the utility only looks at 1 remote
at a time [or <n> remotes at a time if using -w <n>].

To implement something like this, you may have to monitor the file
system, gestimate the number of files and increment your progress
bar on the basis of messages applied. Periodic adjustments may be
required to accomidate messages arriving after your utility starts.
[with debug information, the deleted file count may be more accurate]


HTH
"TPS" <ts@scientexlc.com> wrote in message news:43c27a2a$1@foru
ms-2-dub...
> It appears that this callback is only called via the Scan / Send phase of
> the replication. How do you get information on the progress of the
> recieving phase?
>
> I have an application that displays a progress bar as the replication
> takes place. In the title bar I have messages indicating the beginning of
> each phase. (i.e. "recieving, scanning, sending). You can clearly see that
> the progress bar does not move until the scanning/sending phase starts.
>
> Any help would be greatly appreciated.
>
> Thanks
> TPS
>



TPS

2006-01-09, 1:23 pm

On the UI that sybase uses where are they capturing the "recieving messages"
and "applying messages"

TPS


"Nick Elson" < no_span_nicelson@syb
ase.com> wrote in message
news:43c29d2d$1@foru
ms-2-dub...
>I would assume that the progress bar is only tied to the "log scanning"
> /"send" phases.
>
> That is the way dbremote/ssremote works and I remember that the
> callback function was added to facilitate just that.
>
> As an observation, with those phases there is a reasonable expectation
> that the utility knows what the upper bound will be. In comparison, with
> the receive phase, from start to finish there is a variable number of
> messages possible per remote and the utility only looks at 1 remote
> at a time [or <n> remotes at a time if using -w <n>].
>
> To implement something like this, you may have to monitor the file
> system, gestimate the number of files and increment your progress
> bar on the basis of messages applied. Periodic adjustments may be
> required to accomidate messages arriving after your utility starts.
> [with debug information, the deleted file count may be more accurate]
>
>
> HTH
> "TPS" <ts@scientexlc.com> wrote in message news:43c27a2a$1@foru
ms-2-dub...
>
>



Reg Domaratzki \(iAnywhere Solutions\)

2006-01-09, 1:23 pm

Calls are only made to this callback during the log scanning stage and when
dbremote is sleeping between receive phases when running in continuous mode.
If you run the dbremote executable, you'll notice the same thing.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


"TPS" <ts@scientexlc.com> wrote in message news:43c27a2a$1@foru
ms-2-dub...
> It appears that this callback is only called via the Scan / Send phase of
> the replication. How do you get information on the progress of the

recieving
> phase?
>
> I have an application that displays a progress bar as the replication

takes

> place. In the title bar I have messages indicating the beginning of each
> phase. (i.e. "recieving, scanning, sending). You can clearly see that the
> progress bar does not move until the scanning/sending phase starts.
>
> Any help would be greatly appreciated.
>
> Thanks
> TPS
>
>



Nick Elson

2006-01-09, 8:24 pm

On of the other call back routines. I believe that would be the

MSG_CALLBACK msgrtn;

one.


"TPS" <ts@scientexlc.com> wrote in message news:43c2a48c$1@foru
ms-1-dub...
> On the UI that sybase uses where are they capturing the "recieving
> messages" and "applying messages"
>
> TPS
>
>
> "Nick Elson" < no_span_nicelson@syb
ase.com> wrote in message
> news:43c29d2d$1@foru
ms-2-dub...
>
>



TPS

2006-01-10, 3:23 am

That is it... Thanks...

TPS


"Nick Elson" < no_span_nicelson@syb
ase.com> wrote in message
news:43c2f0a3$1@foru
ms-1-dub...
> On of the other call back routines. I believe that would be the
>
> MSG_CALLBACK msgrtn;
>
> one.
>
>
> "TPS" <ts@scientexlc.com> wrote in message news:43c2a48c$1@foru
ms-1-dub...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com