Dictionaries and Runtime Environments › Defining New Dictionaries › Defining New Catalog Components

Defining New Catalog Components

Physical Characteristics

The segment definition for all catalog components must have the following characteristics:

• The names of the areas must be DDLCAT, DDLCATX, and DDLCATLOD
• The page size of the areas should be at least 4856 plus page reserve

All other physical characteristics can be chosen based on processing requirements, hardware configuration, and standard database design techniques. For example, choose an access method and page size appropriate for your disk devices and consider using a page reserve on the DDLCATX area.

Catalog Components for Non-SQL Use

Without the SQL option, only a system dictionary requires a catalog component. When defining the corresponding segment, specify FOR NONSQL (or take the default).

Catalog Components For SQL Use

If the SQL option has been installed at your site, one or more of your application dictionaries will have an associated catalog component in order to define tables and views. The corresponding segment must have the following attributes:

• FOR SQL specification on the segment
• STAMP BY AREA for the DDLCAT and DDLCATLOD areas
• STAMP BY TABLE for the DDLCATX area

The catalog associated with the system dictionary can also be defined with these attributes. If it is, SQL can be used to examine the physical database definitions stored in the system dictionary.

When a new SQL catalog component is defined, take the following steps after the new segment has been formatted:

1. Define the system tables and views in the new catalog using the TABLEDDL and VIEWDDL members in the installation source library
2. Issue the UPDATE STATISTICS utility statement against the new DDLCAT area
3. Grant appropriate authorities to permit authorized users to create schemas in the new dictionary