Category: Operations
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
CreateDate | DATE NOT NULL | YY/MM/DD | Returns the date when the event took place. |
CreateTime | FLOAT NOT NULL | 99:99:99.99 | Returns the time when the event took place. |
EventNum | INTEGER NOT NULL | --,---,---,--9 | Returns the client system event number of the restore operation. |
EventType | CHAR(30) LATIN NOT CASESPECIFIC NOT NULL | X(30) | Returns the type of event that occurred. |
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the username associated with the event. |
LogProcessor | SMALLINT | -(5)9 | Returns the logical processor ID for an AMP not affected by the event. |
PhyProcessor | SMALLINT | -(5)9 | Returns the physical processor ID for an AMP not affected by the event. |
Vproc | SMALLINT | -(5)9 | Identifies the virtual processor for which an event was logged. |
ProcessorState | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Returns D (the event was for all AMPs and the processor was down) or U (the event was for specific AMPs). |
RestartSeqNum | SMALLINT | ---,--9 | Returns an integer (0 through n) to indicate the number of times that the Teradata Database had to be restarted during the event. 0 indicates that no restarts took place. |