SQL parameters: sqlfetchs

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

sqlfetchs

Description

This parameter determines the number of primary keys HPE Service Manager retrieves during one connection to the RDBMS.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

500

Possible values

Number of primary keys to fetch

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqlfetchs:750

Initialization file: sqlfetchs:750