Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-su server option Next Page

-ti server option


Disconnects inactive connections.

Syntax

{ dbsrv10 | dbeng10 } -ti minutes ...

Applies to

All operating systems and servers.

Remarks

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 terminated. The -ti option is provided to disconnect inactive connections, freeing their locks.

The -ti option is very useful when used in conjunction with dbsrv10 since most connections will be over network links (TCP or SPX).

The -ti option is useful with dbeng10 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.

See also