SET MAXSESS - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Establishes the maximum number of concurrent sessions that TDP allows.

Syntax



The SE abbreviation is deprecated.

where:

number_of_sessions
Maximum number of sessions, in decimal, that can be concurrently logged on to TDP.
This operand can be set to any value between 0 and 4,294,967,295.

Usage Notes

The SET MAXSESS command limits TDP usage of 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 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