16.20 - MapsV[X] - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Category: Schema

Database: DBC

View Column Data Type Format Comment
MapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns name of the map.
MapSlot SMALLINT NOT NULL ---,--9 Returns the physical number of the map.
MapKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns MapKind C for a contiguous map S for a sparse map.
SystemDefined CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns Y if the map is created during a system initialization (sysinit) or reconfiguration. It is N for a map created by CREATE MAP.
SystemDefault CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns Y if the map is the system-default map, N otherwise.
ParentMapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns name of the parent contiguous map that a sparse map is based on. It is null for a contiguous map.
NumberOfAMPs SMALLINT NOT NULL ---,--9 Returns the number of AMPs in a contiguous or sparse map.
ContiguousStartAmp SMALLINT NOT NULL ---,--9 Returns the lowest AMP number in a contiguous map or, for a sparse map, in the parent contiguous map.
ContiguousEndAmp SMALLINT NOT NULL ---,--9 Returns the highest AMP number in a contiguous map or for a sparse map, in the parent contiguous map.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns username of the user that created the map if the map is a sparse map. This is null for a system-defined map.
ZoneName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the secure zone name.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time the map was created.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns optional comment on the created map.
FallbackKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Returns D for dedicated fallback or L for legacy fallback.
TotalNumberOfAMPs SMALLINT NOT NULL ---,--9 Returns the total number of AMPs, both primary and fallback.