MultiVersionInfoTblV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: Cloud

Database: DBC

View Column Data Type Format Description
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database name of the OFS table.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of the OFS table.
OFSStartVersionNumber BIGINT --,---,---,---,---,---,--9 Vrsion number of the first root generated in the transaction.
OFSStartBasePUID CHAR(36) LATIN NOT CASESPECIFIC X(36) BasePUID of the first root generated in the transaction.
OFSEndVersionNumber BIGINT --,---,---,---,---,---,--9 Version number of the last root generated in the transaction.
OFSEndBasePUID CHAR(36) LATIN NOT CASESPECIFIC X(36) BasePUID of the last root generated in the transaction.
VersionTimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Timestamp value corresponding to the version number.
SaveCount INTEGER NOT NULL --,---,---,--9 Number of times a table is saved. Value >0 indicates a saved version and cannot be deleted. Default value is 0 and can be deleted.
ReorganizeTimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Timestamp of reorganize operation for REORGANIZE versions, or NULL otherwise.
BackupCount INTEGER NOT NULL --,---,---,--9 Number of times a table is archived. A value greater than 0 indicates an archived version and cannot be deleted. The default value is 0 and can be deleted.