ASA Database Administration Guide
The Database Server
The database server
Database server options
Disconnect inactive connections.
{ dbsrv9 | dbeng9 } -ti
minutes ...
All operating systems and servers.
Disconnect connections that have not submitted a request for minutes. The default is 240 (4 hours). 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 TCPIP connections. Using -ti
has no effect on connections to a local engine using shared memory.
Setting the value to zero disables checking of inactive connections, so that no connections are disconnected.
sa_server_option system procedure