Disconnects inactive connections.
{ dbsrv11 | dbeng11 } -ti minutes ...
All operating systems and database servers.
Disconnect connections that haven't submitted a request for the specified number of minutes. The default is 240 (4 hours). The maximum value is 32767. A client computer in the middle of a database transaction holds locks until the transaction is ended or the connection is disconnected. The -ti option is provided to disconnect inactive connections, freeing their locks.
The -ti option is very useful when used in conjunction with dbsrv11 since most connections will be over network links (TCP).
The -ti option is useful with dbeng11 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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |