SET MAXSCHEDSESSIONS (Set maximum scheduled sessions)

Use this command to set the number of sessions that the server can use to process scheduled operations. This command specifies the maximum number of scheduled sessions as a percentage of the total number of available server sessions.

Limiting the number of sessions ensures that some are available for unscheduled operations, such as backup or archive. You can increase either the total number of sessions (with the MAXSESSIONS parameter) or the maximum percentage of scheduled sessions. Increasing the total number of sessions available, however, can affect server performance. Increasing the maximum percentage of scheduled sessions can reduce the sessions available for unscheduled operations.

Privilege class

To issue this command, you must have system privilege.

Syntax

Read syntax diagramSkip visual syntax diagramSet MAXSCHedsessionspercent

Parameters

percent (Required)
Specifies the percentage of total server sessions that can be used for scheduled operations. You can specify an integer from 0 to 100. The MAXSESSIONS parameter in the server options file determines the maximum number of total available server sessions.

If you set the maximum percentage of scheduled sessions to 0, no scheduled events can begin. If you set the maximum percentage of scheduled sessions to 100, the maximum number of scheduled sessions is the value of the MAXSESSIONS option.

Tip: If the maximum number of scheduled sessions do not coincide with the percentage that you set in the SET MAXSCHEDSESSIONS command, run the SET MAXSCHEDSESSIONS command again. Look in the MAXSESSIONS option and determine the number that is specified there. If the MAXSESSIONS option number changed and you did not issue the SET MAXSCHEDSESSIONS command since the change, the maximum number of scheduled sessions can change.

Set a maximum of 20 sessions for scheduled activities

The MAXSESSIONS option has a value of 80. If you want no more than 20 sessions to be available for scheduled activity, set the percentage to 25.
set maxschedsessions 25

Related commands

Table 1. Commands related to SET MAXSCHEDSESSIONS
Command Description
QUERY OPTION Displays information about server options.
QUERY STATUS Displays the settings of server parameters, such as those selected by the SET commands.