|
Home > Archive > SQL Anywhere Mobile > June 2005 > dbmlsync table locks
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 |
dbmlsync table locks
|
|
|
| Hi all,
ASA 9.0.1.1883
I am using an SQL server as a consolidated and ASA as a remote.
mobilink is used to sync the two.
The ASA is used as a consolidated for other remotes.
My problem:
The SQL-ASA sync is a long one. During this sync, all of the tables are
locked on the ASA,
and the ASA's remotes can't sync.
How can I make sure that the mobilink only lock the tables for the duration
of that table handling?
For example:
Mobilink syncs tables: a,b,c,d. all of those are locked until the sync is
over. how can I release a when a download is complete?
Thanks in advance,
R
| |
| Reg Domaratzki 2005-06-29, 7:24 am |
| See the LockTables extended option.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
"Rs" <rs@nospam> wrote in message news:42c2853c@forums
-2-dub...
> Hi all,
> ASA 9.0.1.1883
>
> I am using an SQL server as a consolidated and ASA as a remote.
> mobilink is used to sync the two.
> The ASA is used as a consolidated for other remotes.
> My problem:
> The SQL-ASA sync is a long one. During this sync, all of the tables are
> locked on the ASA,
> and the ASA's remotes can't sync.
> How can I make sure that the mobilink only lock the tables for the
duration
> of that table handling?
> For example:
> Mobilink syncs tables: a,b,c,d. all of those are locked until the sync is
> over. how can I release a when a download is complete?
>
> Thanks in advance,
> R
>
>
| |
|
| Hi,
Thanks for your answer.
Two questions:
1. Is there any way to cause mobilink to drop a lock after it finish working
on that table and move to the next?
2. Is it acceptable to use "off" in the extended option lt? could it cause
any problems? (as the db itself should manage the locks in the row level)
thanks in advance,
R
"Reg Domaratzki" <nospam.please@sympatico.ca> wrote in message
news:42c299ab$1@foru
ms-1-dub...
> See the LockTables extended option.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Certified SQL Anywhere Associate
> Please reply only to the newsgroup
>
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
>
>
> "Rs" <rs@nospam> wrote in message news:42c2853c@forums
-2-dub...
> duration
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-29, 9:24 am |
| 1. No.
2. The following section of the docs should answer this question :
MobiLink Clients
Adaptive Server Anywhere Clients
Initiating synchronization
Concurrency during synchronization
--
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 "Platform Preview" and "Time Frame" to ALL
"Rs" <rs@nospam> wrote in message news:42c2a3e8$1@foru
ms-1-dub...
> Hi,
> Thanks for your answer.
> Two questions:
> 1. Is there any way to cause mobilink to drop a lock after it finish
working
> on that table and move to the next?
> 2. Is it acceptable to use "off" in the extended option lt? could it cause
> any problems? (as the db itself should manage the locks in the row level)
> thanks in advance,
> R
>
>
>
> "Reg Domaratzki" <nospam.please@sympatico.ca> wrote in message
> news:42c299ab$1@foru
ms-1-dub...
is[color=darkred]
>
>
|
|
|
|
|