17.10 - Events_MediaV[X] - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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.