SQL parameters: sqldisconnect

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqldisconnect

Description

This parameter determines when the Service Manager server disconnects from the RDBMS. Normally, the server maintains connections to an RDBMS until the user logs off from Service Manager. Enabling this parameter causes the server to disconnect from the RDBMS when an application reaches a new screen. Such disconnections create extra SQL statements, and therefore require more overhead from the Service Manager server, but also limit the number of processes connected to the RDBMS.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

0

Possible values

0 (Disable)

1 (Enable)

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqldisconnect:1

Initialization file: sqldisconnect:1

Related topics

System parameters
Enter a parameter in the sm.ini file
Database parameters