SQL parameters: sqllimit

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

Parameter

sqllimit

Description

This parameter defines the time limit for requests to the RDBMS. If a particular request exceeds the time limit defined by this parameter, then the HPE Service Manager server writes a message to the HPE Service Manager log file documenting the name of the user making the request, how long it took, and the actual SQL query.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

5

Possible values

Number of seconds

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqllimit:10

Initialization file: sqllimit:10