17.00 - MapsV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.