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. |