DISPLAY SP - Teradata Director Program

Teradata Director Program Reference

Product
Teradata Director Program
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
hwt1488824663348.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Displays the status of session processors (SPs) that are assigned to this TDP.

Syntax



The DI and DIS abbreviations are deprecated.

where:

xxxx
A four-character hexadecimal SP id for which information is to be displayed.
If omitted, all information for all SPs is displayed.
SESSIONS
Indicates that a list of all sessions for the SP is to be displayed.
NODETAIL
Indicates that no diagnostic information for the SP is to be displayed. This is the default.
DETAIL
Indicates that diagnostic information for the SP is to be displayed.
This option is intended for use in consultation with Teradata customer support personnel.
The associated information requires internal knowledge of TDP to properly interpret. Without such knowledge, misleading conclusions are probable. Time can be saved by heeding this recommendation.

Usage Notes

The following information is always displayed, as applicable:

  • SP number.
  • SP Status, as follows:
    Status Definition
    NOT OPERATIONAL The Teradata Database indicates that the SP is down.
    OPERATIONAL The Teradata Database indicates that the SP is up.
    USABLE Operational and the TDP state has been synchronized with that of the Teradata Database.
    DELAYED Operational but requests are being delayed while synchronization is in progress for this SP.
    SERIALIZED Operational and in use for a synchronization request for an SP.
  • If sessions are allocated:
    • The total number of sessions
    • The number of these sessions that are using the Monitor partition
    • The number of these sessions that are in-doubt but whose original application is no longer using the session
  • If any allocated sessions are waiting the response to a Logoff.
  • If any allocated sessions are involved in switching sessions from a down SP to an operational SP.

The following information is displayed, according to the options specified in the command:

IF you select this option . . . THEN this information is displayed . . .
DETAIL IF . . . This information is displayed . . .
synchronization is in progress, whether a Host Start or Session Information request has been sent and which SP is being used.
this SP has an affinity for CP, the extended affinity id and a list of CPs.
this SP is dependent upon a CP, the intended dependency id and a list of CPs.
SESSIONS For each session allocated on this SP, the session number, job name and state, as follows:
State Definition
IDLE No request is active.
ACTIVE A request is active.
STARTING The session is being established.
ENDING The session is to be logged off.
SWITCH PENDING The session is to be switched to an operational SP.
SWITCH ACTIVE The session is being switched to an operational SP.
Session number for each in-doubt session whose application is no longer using the session.

Example: DISPLAY SP

D SP

Completion Message

TDP1260 SPNUM 000F: OPERATIONAL, USABLE
TDP1261   SESSIONS: 2 (MONITOR: 0, INDOUBT: 1)
TDP1260 SPNUM 000E: OPERATIONAL, USABLE
TDP1261   SESSIONS: 2 (MONITOR: 0, INDOUBT: 0)