DISABLE SESSION RESERVE - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

Purpose

Causes TDP to release the reserved session capacity so that customer applications can use the maximum session capacity supported by the 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