15.00 - LIST - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

LIST

Purpose  

The LIST command outputs the list of node names, their unique node IDs, and the status of nodes in the current mpplist buffer to the STDOUT file.

Syntax  

Usage Notes  

The list shows the nodes in the following format:

IndexId:nodename
nodestatus
 

Component...

Specifies...

IndexId

an arbitrary index number starting from 0 to N-1, where N is the number of nodes in the mpplist file.

nodename

the name of a node.

nodestatus

displays the number of nodes currently online.

Note: If a node is offline, the node appears with a dash (or minus sign) in front of the IndexID in the mpplist as shown below:

-IndexId:nodename

If a node is online, the dash does not appear.

Example  

The following example lists the status and ID of the nodes.

mpp> l

 0:pdetnt5_bynet     1:pdetnt6_bynet     2:pdetnt7_bynet     3:pdetnt8_bynet

 all 4 nodes are online.