Purpose
Causes TDP to release the reserved session capacity so that customer applications can use the maximum session capacity supported by the Teradata Database.
Syntax
Usage Notes
When TDP starts, the Session Reserve is enabled. To subsequently disable Session Reserve, use the DISABLE SESSION RESERVE command.
When Session Reserve is enabled and more than one SP is operational, TDP reserves a number of sessions equal to the capacity of one SP. This is to ensure that if a single SP fails, all user sessions allocated to the failed SP can be “switched” to other SPs that were started by this TDP.
This command affects the value of “DBC/1012 MAXSESS”, as displayed in the output from the DISPLAY TDP command. This is a separate limit from the value of “TDP MAXSESS”, which is controlled by the SET MAXSESS command. The maximum number of sessions that can be logged on through this TDP is the lower of these two values.
When the maximum number of sessions is already logged on to TDP, any new logon request from an application is refused with an error code of CLI0513.
Example: DISPLAY SESSION RESERVE
DISA SESSION RES
Completion Message
TDP0401 SESSION RESERVE HAS BEEN DISABLED