16.10 - LIST - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The LIST command lists the vprocs and hosts in the current or new configuration, or in a specified contiguous map.

Syntax



SHORT
Displays summarized information from the configuration or contiguous map. This is the default.
LONG
Displays detailed information from the configuration or contiguous map.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Example: Listing of the vprocs and hosts in a configuration

An example output generated by the LIST command is shown below:

-------------
AMP Array
-------------
Vproc-Id Range     Status   Cluster   Vproc-Id Range   Status   Cluster
---------------    -------  -------   ---------------  ------   -------
0,  16,  32, 48    Online     0       1,  17,  33,  49 Online     1
2,  18,  34, 50    Online     2       3,  19,  35,  51 Online     3
4,  20,  36, 54    Online     4       5,  21,  37,  53 Online     5
14, 30,  46, 62    Online    14      15,  31,  49,  63 Online    15
-----------------------------------------------------------------------
-------------
PEs ARRAY
-------------
Vproc-Id Range   Status
--------------   --------
16344-16354      Online
16355            Down
16356-16363      Online
16364            Down
16365-16377      Online
16378            Down
16379-16383      Online
-------------------------
-------------
HOSTs ARRAY
-------------
HostNo Logical HostID   Type   Connected PE Range
------ --------------   ----   ------------------
 52       1076          COP    16368-16383
282        282          IBM    16344-16351
286        286          IBM    16353, 16355, 16357, 16359
                               16361, 16363, 16365, 16367
                               16360, 16362, 16364, 16366
-----
MAPs
-----

      MapName          MapNo            Status
--------------------  -------------    ------------
TD_GlobalMap            1               Online.
TD_DataDictionaryMap    2               Online.
TD_Map1                 1025            Online.
TD_Map2                 1035            Online.
TD_Map3                 1036            Online.

In response to the LIST command, the configuration utility lists all AMPs, PEs, and hosts that are included in the current configuration map. The following table lists the possible status of the vproc in the previous example.

Status Description
Online The vproc is participating in the current configuration.
Down The vproc is not participating in the current configuration.
Hold The vproc was offline during the preceding system execution and is in the process of being recovered to the online state.
Newready The vproc has been initialized but has not been added to the configuration.