15.10 - RCC_ConfigurationV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

EventNum

INTEGER

NOT NULL

--,---,---,--9 (explicit)

RCConfiguration.EventNum (NUPI)

LogProcessor

SMALLINT

-(5)9

RCConfiguration.LogProcessor

PhyProcessor

SMALLINT

ZZZZ9 (explicit)

RCConfiguration.PhyProcessor

Vproc

SMALLINT

-(5)9

RCConfiguration.Vproc

ProcessorState

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

RCConfiguration.ProcessorState

RestartSeqNum

SMALLINT

---,--9 (explicit)

RCConfiguration.RestartSeqNum

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RCEvent
  • DBC.RoleGrants
  • DBC.Roles
  • 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
          .         .           .
          .         .           .