17.00 - Events_MediaV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
June 2020
Programming Reference

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 client system utility dump or restore event.
DataSetName VARCHAR(44) UNICODE NOT CASESPECIFIC X(44) Returns the client system data set name for a dump or restore event.
VolSerialId CHAR(6) LATIN NOT CASESPECIFIC NOT NULL X(6) Returns the unique six character volume serial assigned to a device.
VolSequenceNum SMALLINT ---,--9 Returns the sequence number of the volume, which defines the position of the volume in a multi-volume set.
DupeDumpSet CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns a code to indicate whether the dump event created a duplicate archive dataset.