Use this command to set the number of sessions that are allowed to the server for processing scheduled operations. This command specifies the maximum number of scheduled sessions as a percentage of the total number of server sessions available.
Limiting the number of sessions ensures that sessions 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 can affect server performance. Increasing the maximum percentage of scheduled sessions can reduce the sessions available for unscheduled operations.
Privilege Class
To perform this task, you must have system privilege.
Syntax
>>-Set MAXSCHedsessions--percent-------------------------------><
Parameters
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.
Examples
Task
The MAXSESSIONS option is set to 80. To permit no more than 20 sessions to be available for scheduled activity, set the percentage to 25.
Related Commands
Table 256. 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. |