SQL parameters: sqlbatchcount

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

sqlbatchcount

Description

This parameter defines the number of records the HPE Service Manager server retrieves from the RDBMS during a single select call. You can use this parameter to reduce the number of interactions between HPE Service Manager and your RDBMS. Rather than selecting and returning each record from a record list individually, HPE Service Manager can select and return a batch of records in a single SELECT statement.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

64

Possible values

Number of records

Example usage

Command line: sm -httpPort:13080 -sqldb:dbserver -sqlbatchcount:72

Initialization file: sqlbatchcount:72