MapsV[X] - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Category: Schema

Database: DBC

View Column Data Type Format Description
MapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of map.
MapSlot SMALLINT NOT NULL ---,--9 Physical number of map.
MapKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) C for contiguous map, S for sparse map.
SystemDefined CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Y for map created during system initialization (sysinit) or reconfiguration, N for map created by CREATE MAP.
SystemDefault CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Y for system-default map, N otherwise.
ParentMapName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of parent contiguous map for sparse map, NULL for contiguous map.
NumberOfAMPs SMALLINT NOT NULL ---,--9 Number of AMPs in contiguous or sparse map.
ContiguousStartAmp SMALLINT NOT NULL ---,--9 Lowest AMP number in contiguous map or, for a sparse map, in the parent contiguous map.
ContiguousEndAmp SMALLINT NOT NULL ---,--9 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) The username of the user that created the map if the map is a sparse map. This is null for a system-defined map.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS The date and time the map was created.
CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Optional comment on the created map.
FallbackKind CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Specifies D for dedicated fallback or L for legacy fallback.
TotalNumberOfAMPs SMALLINT NOT NULL ---,--9 Total number of AMPs, both primary and fallback.