Previous Topic: DictionariesNext Topic: Logical Components of a Dictionary


Physical Components of a Dictionary

Dictionary Areas

Dictionaries are composed of the following areas:

Area name

Description

DDLDML

Contains the following types of information:

  • DC/UCF system definitions
  • Non-SQL schema and subschema definitions
  • Maps
  • Dialogs
  • Source modules
  • Record and element descriptions
  • IDD users
  • Classes and attributes

DDLDCLOD

Contains load modules associated with entities contained in the DDLDML area; for example:

  • Map load modules
  • Dialog load modules
  • Subschema load modules

DDLCAT

Contains definitions of physical databases (segments, DMCLs, database name tables); at sites with the SQL option, contains definitions of SQL entities (tables, constraints, indexes, and so on)

DDLCATX

Contains indexes defined on entities stored in the DDLCAT area

DDLCATLOD

Contains:

  • DMCL load modules
  • Database name table load modules
  • Access modules at sites with the SQL option

DDLDCMSG

Contains system and user-defined messages