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. |
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the database in which the event occurred. |
ObjectType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | This field gives the level of object that was specified for the event.This is a D is for database level, T for table level,Q for Backup or restore of selected partitions or J for journal. |
AllAmpsFlag | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Returns a code that indicates whether the event was executed on all AMPs, clusters, or processors. |
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. |
OperationInProcess | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Returns a code to indicate whether the event is still processing. The following codes are used: Y = Yes, N = No. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns he name of the table affected by the event. If the object is a database, then the value is set to NULL. |
CheckPointName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the checkpoint name as specified by the user in the CHECKPOINT statement. |
LinkingEventNum | INTEGER | --,---,---,--9 | Returns the terminating event number specified by the user for a rollforward or rollbackward event. |
DataSetName | VARCHAR(44) UNICODE NOT CASESPECIFIC | X(44) | Returns the client system data set name for a dump or restore event. |
LockMode | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns a code to indicate the type of lock used by the event. The codes are as follows: A = ACCESS or Group READ, R = full READ. |
JournalUsed | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns one of the following codes to indicate which part of the journal table was used: C = Current, R = Restored, S = Saved. |
JournalSaved | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns one of the following codes to indicate whether or not the SAVE option was used in the event: Y = Yes, N = No. |
IndexPresent | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns Y (yes) or N (no) to indicate whether or not the INDEX option was used in a dump event. |
DupeDumpSet | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns a code to indicate whether the dump event created a duplicate archive dataset. |