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
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.
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
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. |