17.00 - Example: Using RCC_ConfigurationV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The following SELECT statement selects event and processor information from the RCC_Configuration view:

SELECT EventNum, LogProcessor, PhyProcessor
       FROM RCC_ConfigurationV;

Result:

EventNum   LogProcessor    PhyProcessor
--------   ------------    ------------
      21        1           1-0
      75        1           1-0
      88        1           1-0
      .         .           .
      .         .           .
      21        2           1-2
      75        2           1-2
      .         .           .
      .         .           .