Disconnects inactive connections.

Syntax

{ dbsrv11 | dbeng11 } -ti minutes ...

Applies to

All operating systems and database 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 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.

See also

• -tl server option
• sa_server_option system procedure
• Adjusting timeout values