SET LIMIT (Deprecated by the CONFIG XP MAXNORSP command) - 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

Changes limits used by TDP.

Syntax



where:

nnnn
The number of consecutive requests that have been sent to the database on a CP without receiving any responses that TDP will consider excessive. At this limit TDP will consider the CP as unresponsive and use other CPs to send subsequent requests. If no other functional CPs exist, requests will continued to be queued for this one. A value of zero indicates that TDP will never consider a CP unresponsive.

Usage Notes

The operand of this deprecated command changes the same value as the CONFIG XP MAXNORSP command.

If this command is not used, a value of 75 is assumed.

The current value can be displayed using the DISPLAY CONFIG XP DETAIL command.

Because SQL requests can run for unbounded time so there is no certain way to know when a response is not forthcoming, this command is intended for use in consultation with Teradata customer support personnel.

Example: SET LIMIT

SET LIMIT NORESP 100