Previous Topic: CA-supplied Dictionary DefinitionsNext Topic: Protocols, Nondatabase Structures, and Modules

Dictionaries and Runtime Environments › CA-supplied Dictionary Definitions › Logical Database Definitions

Logical Database Definitions

CA-Supplied Schema

The following table describes the non-SQL schema supplied by CA that describes a dictionary. Its definitions are stored in a dictionary by the IDMSDIRL utility.

Schema

Areas

IDMSNTWK

DDLDML DDLDCLOD DDLCAT DDLCATX DDLDCMSG

CA-Supplied Subschemas

The following table describes subschemas supplied by CA and the CA IDMS products or facilities that make use of them. Most of these subschemas are distributed as object modules only. The source definitions of IDMSNWKA and IDMSNWKG are also stored in a dictionary by IDMSDIRL for user-reporting purposes.

Subschema

Areas

Used By

IDMSCATL

DDLCATLOD
  • Loader processing
  • CLOD DC/UCF system task
  • PUNCH utility statement

Database administrators when executing utilities such asUNLOAD/RELOAD against the DDLCATLOD area

IDMSCATZ

DDLCAT DDLCATX DDLCATLOD
  • The command facility for SQL processing andphysical database definition
  • User applications issuing dynamic SQL requiring automatic recompilation of an access module or issuing SQL DDL statements
  • Database administrators when executing utilities such as UNLOAD/RELOAD against the DDLCAT and DDLCATX areas

IDMSNWKA

DDLDML DDLDCLOD DDLDCMSG
  • IDD DDDL compiler (IDMSDDDL)
  • DC/UCF system generation compiler (RHDCSGEN)
  • DC/UCF startup
  • Schema and subschema compilers (IDMSCHEM and IDMSUBSC)
  • CA IDMS/DC mapping compilers (MAPC and batch)
  • CA ADS compilers
  • CA OLQ
  • CA Culprit
  • The Automatic System Facility (ASF)

IDMSNWKL

DDLDCLOD

Loader processing and the CLOD DC/UCF system task

IDMSNWKT

DDLDML

SQL processing to access non-SQL defined database descriptions

IDMSNWKU

DDLDML DDLDCLOD DDLDCMSG DDLCAT DDLCATX

Database administrators when executing utilities such as UNLOAD/RELOAD against dictionary areas DDLDML, DDLDCLOD, and DDLDCMSG

IDMSNWKG

DDLDML DDLDCLOD DDLDCMSG DDLCAT DDLCATX

IDMSRPTS

IDMSNWK6

DDLDCMSG

System message processing

IDMSNWK7

DDLDCRUN

QUED and QUEM DC/UCF system tasks and queue processing

IDMSNWK8

DDLDML

CLIST and send-message processing

IDMSNWK9

DDLDCLOG

Online print log (OLP) and PRINT and ARCHIVE LOG utility statements

Note: Additional non-SQL schemas and subschemas are supplied at installation time. For more information, see the CA IDMS Security Administration Guide.

SQL Table Definitions

At sites with the SQL option, CA IDMS/DB also provides the table and view definitions that describe the catalog component of the dictionary. These definitions are distributed under two schema names:

Definition

Description

SYSTEM

Contains the catalog table definitions; no changes can be made to any of the entities in the SYSTEM schema

SYSCA

Contains the CA-supplied views of the SYSTEM tables and records in the IDMSNWK schema; these views restrict access to table definition information based on a user's SELECT authority on the table.

Note: For more information and a description of the table definitions, see the CA ADS Reference Guide.