Purpose
Establishes the maximum number of concurrent sessions that TDP will allow.
Syntax
where:
- number_of_sessions
- Maximum number of sessions, in decimal, that can be concurrently logged on to TDP.
Usage Notes
The SET MAXSESS command limits TDP usage of Teradata Database resources by limiting the number of sessions that it can control.
When the maximum number of sessions is already logged on to TDP, any new logon request from an application is rejected.
If this command is not used, the maximum number of concurrent sessions that TDP will allow is the same as the maximum number currently supported by the Teradata Database.
Unless IRF disabled, two internal sessions are established upon TDP startup that are used for Two-phase commit. Establishing these sessions cannot be prevented by setting the MAXSESS number to 0. These two internal sessions can only be disabled using the DISABLE IRF command, either by entering it manually or including it in the TDPPARM data set.
Example: SET MAXSESS
SET MAXs 25
Completion Message
TDP0544 TDP MAXIMUM SESSION LIMIT NOW SET TO: 25