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