ASA Database Administration Guide
Disconnect inactive connections.
{ dbsrv9 | dbeng9 } -ti minutes ...
All operating systems and servers.
Disconnect connections that have not submitted a request for the specified number of minutes. The default is 240 (4 hours). The maximum value is 32767. A client machine in the middle of a database transaction holds locks until the transaction is ended or the connection is terminated. The -ti option is provided to disconnect inactive connections, freeing their locks.
The -ti option is very useful when used in conjunction with dbsrv9 since most connections will be over network links (TCP or SPX).
The -ti option is useful with dbeng9 only for local TCP/IP connections. Using -ti has no effect on connections to a local server using shared memory.
Setting the value to zero disables checking of inactive connections, so that no connections are disconnected.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.