Collection Contents Index -su server option Next PDF

SQL Anywhere® Server - Database Administration  > The Database Server  > The SQL Anywhere database server  > Database server options

-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

Collection Contents Index -su server option Next PDF