ClientMaxIdleTime

Synopsis

[SQL]    ClientMaxIdleTime=n

n is the number of seconds that a the system allows for an idle connection between the client and the server before forcing a disconnection. The default value is 0.

Description

When ClientMaxIdleTime is not 0, InterSystems SQL will wait the specified number of seconds before closing an idle connection between a client and a server. This timeout applies to all SQL clients that have been sitting idle, including JDBC, ODBC, and ADO.NET.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), enter a value for the Client maximum idle time (seconds) setting.

You can change ClientMaxIdleTime by using SetOption() or by editing the CPF in a text editor (as described in Editing the Active CPF). In addition, you can change the parameter on the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL) by entering a value for the Client maximum idle time (seconds) setting.