SQL Anywhere Mobile - How to keep the mobilink server from timing out

Author

How to keep the mobilink server from timing out

chance

2005-10-27, 8:20 am

9.01 (1752)

I. 10/04 12:32:46. <Main>: Timeout for inactive database connections: 60
minutes

tia,
chance.

David Fishburn

2005-10-27, 8:20 am

"chance" <chance@crwmail.com> wrote in news:434342b6@forums
-2-dub
of sybase.public.sqlanywhere.mobilink:

c> 9.01 (1752)
c>
c> I. 10/04 12:32:46. <Main>: Timeout for inactive database connections:
60
c> minutes

First, is this a bad thing?
This means ML removes this connection from its "pool", and will create a
new one - only if necessary.

Look at the -ct switch.

To make things easier for you, I always do this from a command prompt:
dbmlsrv9 /?

That works for all our tools and displays the usage. Just browse
through the switches.

Or of couse:
MobiLink Administration Guide
MobiLink Synchronization Server Options
MobiLink synchronization server

....
–ct connection-timeout Set the length of time a connection may be
unused before it is timed out. See -ct option.

--
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 (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

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

CaseXpress - to report bugs
http://casexpress.sybase.com

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

Chance

2005-10-27, 8:20 am

Yes, I think it is a bad thing. My understanding from the customer is that
it brings the system down and they have to restart these services to being
syncing successfully again.

I will try and use the ct switch but do you think it has anything to do with
the KeepAliveTime registry entry?

--
Chance
Lead Software Engineer
Research & Development
Computerworks/Booklog
chance@booklog.com

Blog:
http://chance.PBDJMagazine.com
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96E65A935B1F
Ffishburnsybasecom@1
27.0.0.1...
> "chance" <chance@crwmail.com> wrote in news:434342b6@forums
-2-dub
> of sybase.public.sqlanywhere.mobilink:
>
> c> 9.01 (1752)
> c>
> c> I. 10/04 12:32:46. <Main>: Timeout for inactive database connections:
> 60
> c> minutes
>
> First, is this a bad thing?
> This means ML removes this connection from its "pool", and will create a
> new one - only if necessary.
>
> Look at the -ct switch.
>
> To make things easier for you, I always do this from a command prompt:
> dbmlsrv9 /?
>
> That works for all our tools and displays the usage. Just browse
> through the switches.
>
> Or of couse:
> MobiLink Administration Guide
> MobiLink Synchronization Server Options
> MobiLink synchronization server
>
> ...
> -ct connection-timeout Set the length of time a connection may be
> unused before it is timed out. See -ct option.
>
> --
> 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 (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> [url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>

David Fishburn

2005-10-27, 8:20 am

"Chance" <chance@booklog.com> wrote in news:4343d6e2$1@foru
ms-2-dub of
sybase.public.sqlanywhere.mobilink:

C> Yes, I think it is a bad thing. My understanding from the customer is
C> that it brings the system down and they have to restart these services
C> to being syncing successfully again.

No, this should be unrelated.
See the verbose -vcrsn -ot ml.txt output would help.

These defaults are created for good reason, so before we turn them off
it is best to verify the cause.

Most databases will have a default idle disconnect and turf any
outstanding connections that have been inactive. ASA's is 4 hours.
MobiLink will automatically test a connection as it pulls it out of the
connection pool, if it is still alive, it will use it, or create a new
connection.

C> I will try and use the ct switch but do you think it has anything to
C> do with the KeepAliveTime registry entry?

Unrelated.
That affects the communications between the ML clients and the ML
server. So the upload and download process.

--
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 (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

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

CaseXpress - to report bugs
http://casexpress.sybase.com

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

Chance

2005-10-27, 8:20 am

> Most databases will have a default idle disconnect and turf any
> outstanding connections that have been inactive. ASA's is 4 hours.
> MobiLink will automatically test a connection as it pulls it out of the
> connection pool, if it is still alive, it will use it, or create a new
> connection.

So...are you saying it may be the connection to the database that is timing
out and therefore the ML server goes down? I should tell you this only
happens when they are closed or the weekends (i.e. no activity either way)

--
Chance
Lead Software Engineer
Research & Development
Computerworks/Booklog
chance@booklog.com

Blog:
http://chance.PBDJMagazine.com
"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96E678467BE1
1fishburnsybasecom@1
27.0.0.1...
> "Chance" <chance@booklog.com> wrote in news:4343d6e2$1@foru
ms-2-dub of
> sybase.public.sqlanywhere.mobilink:
>
> C> Yes, I think it is a bad thing. My understanding from the customer is
> C> that it brings the system down and they have to restart these services
> C> to being syncing successfully again.
>
> No, this should be unrelated.
> See the verbose -vcrsn -ot ml.txt output would help.
>
> These defaults are created for good reason, so before we turn them off
> it is best to verify the cause.
>
> Most databases will have a default idle disconnect and turf any
> outstanding connections that have been inactive. ASA's is 4 hours.
> MobiLink will automatically test a connection as it pulls it out of the
> connection pool, if it is still alive, it will use it, or create a new
> connection.
>
> C> I will try and use the ct switch but do you think it has anything to
> C> do with the KeepAliveTime registry entry?
>
> Unrelated.
> That affects the communications between the ML clients and the ML
> server. So the upload and download process.
>
> --
> 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 (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
> [url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>

Reg Domaratzki $iAnywhere Solutions$

2005-10-27, 8:20 am

To message you posted simply says that MobiLink has been disconnected from
the consolidated database. This should NOT cause MobiLink to shut down and
should NOT cause synchronizations to fail.

--
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"

"Chance" <chance@booklog.com> wrote in message
news:4343f8e7$1@foru
ms-1-dub...
>
> So...are you saying it may be the connection to the database that is
timing
> out and therefore the ML server goes down? I should tell you this only
> happens when they are closed or the weekends (i.e. no activity either way)
>
> --
> Chance
> Lead Software Engineer
> Research & Development
> Computerworks/Booklog
> chance@booklog.com
>
> Blog:
> http://chance.PBDJMagazine.com
> "David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
> news:Xns96E678467BE1
1fishburnsybasecom@1
27.0.0.1...
services[color=darkr
ed]
>
>

Sponsored Links