Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Mobilink causing database to lock

3 posts in General Discussion Last posting was on 2007-11-15 14:08:55.0Z
Herman Posted on 2007-11-14 20:54:42.0Z
Sender: 5e8a.473b6036.1804289383@sybase.com
From: Herman
Newsgroups: ianywhere.public.general
Subject: Mobilink causing database to lock
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <473b6092.5e97.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Nov 2007 12:54:42 -0800
X-Trace: forums-1-dub 1195073682 10.22.241.41 (14 Nov 2007 12:54:42 -0800)
X-Original-Trace: 14 Nov 2007 12:54:42 -0800, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6563
Article PK: 3146

When Mobilink runs the database locks while trying to save
data. What would cause this? And how can I remedy?


Reg Domaratzki (iAnywhere Solutions) Posted on 2007-11-15 13:46:44.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <FirstName.LastName@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <473b6092.5e97.1681692777@sybase.com>
Subject: Re: Mobilink causing database to lock
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rdomarat-xp.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-xp.sybase.com
Message-ID: <473c4dc4$1@forums-1-dub>
Date: 15 Nov 2007 05:46:44 -0800
X-Trace: forums-1-dub 1195134404 10.25.99.188 (15 Nov 2007 05:46:44 -0800)
X-Original-Trace: 15 Nov 2007 05:46:44 -0800, rdomarat-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6566
Article PK: 3150

If any application (remember that the MobiLink Server is just another ODBC
application as far as the consolidated database is concerned) is executing
an update of a row, then a write lock will be placed on the row until a
commit is executed. This is true of any RDBMS, and the lock will be
released when the MobiLink Server commits the upload stream.

--
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/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Herman> wrote in message news:473b6092.5e97.1681692777@sybase.com...
> When Mobilink runs the database locks while trying to save
> data. What would cause this? And how can I remedy?


David Fishburn Posted on 2007-11-15 14:08:55.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink causing database to lock
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <473b6092.5e97.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns99E95CE98B497fishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: fishburn-m20.sybase.com
X-Original-NNTP-Posting-Host: fishburn-m20.sybase.com
Date: 15 Nov 2007 06:08:55 -0800
X-Trace: forums-1-dub 1195135735 10.25.98.137 (15 Nov 2007 06:08:55 -0800)
X-Original-Trace: 15 Nov 2007 06:08:55 -0800, fishburn-m20.sybase.com
Lines: 38
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6572
Article PK: 4821

Herman wrote in news:473b6092.5e97.1681692777@sybase.com
of ianywhere.public.general:

H> When Mobilink runs the database locks while trying to save
H> data. What would cause this? And how can I remedy?

Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng10 -v).

Are you referring to the MobiLink server (mlsrv10.exe)
or the MobiLink client (dbmlsync.exe)?

What is it locking on? What table or action?

Providing some output from one of these utilities (when running in
verbose mode) often helps us answer questions more effectively.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList