15.00 - LIST - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

LIST

Purpose  

The LIST command lists the vprocs and hosts in the current or new configuration.

Syntax  

 

Syntax element …

Specifies …

SHORT

the compact configuration map. This is the default. It displays the contents of the following commands:

  • LIST CLUSTER
  • LIST PE
  • LIST HOST
  • LONG

    the detailed configuration map.

    FROM

    that you will choose the type of configuration map to be displayed.

    CURRENT

    the configuration map that the Teradata Database is using currently. This is the default.

    If you do not specify the FROM keyword, the default map type is CURRENT, and the current configuration map is displayed.

    NEW

    the proposed configuration map.

    Usage Notes  

    When you type the LIST command without any options, the system displays the short form of the default (current) configuration map.

    When you type the FROM option, you must specify the map type. No default type is supplied for this form.

    Example  

    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

    In response to the LIST command, Configuration 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.