Home > Archive > SQL Anywhere database > August 2005 > Disable DB time out









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 Disable DB time out
Severin Holm

2005-08-23, 7:24 am

Hey Guys

I want to disable the db time out which shut down the db after some time out
(i don't know how long exactly).

Thanks
Severin Holm


Joshua Savill

2005-08-23, 11:24 am

The database server should not shut down automatically after a period of in
activity. How are you starting the database? Please provide the command line
and all of the switches. How are the clients connecting? Is AUTOSTOP
specified when starting the database? If the database is set to AUTOSTOP
after the last connection, and that connection times out, then the database
will stop.

Are you talking about the database dropping inactive connections to the
database? If so, then you want to look at the -ti and -tl switches on
dbsrvX. I suggest that you never disable the time out switches, but rather
set theses options to an appropriate period of time.

ASA Database Administration Guide
The Database Server
The database server
Database server options
-ti server option

Online:
http://www.ianywhere.com/developer/...n9/00000198.htm

ASA Database Administration Guide
The Database Server
The database server
Database server options
-tl server option

Online:
http://www.ianywhere.com/developer/...n9/00000199.htm

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Severin Holm" <severin.holm@profline.ch> wrote in message
news:430b0fa4$1@foru
ms-1-dub...
> Hey Guys
>
> I want to disable the db time out which shut down the db after some time
> out (i don't know how long exactly).
>
> Thanks
> Severin Holm
>



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