Mandatory and Ingres-Only Standard Catalogs

Mandatory catalogs are those catalogs that are required for all installations, including Enterprise Access and non-Enterprise Access installations. Ingres-only catalogs are required for non-Enterprise Access installations.

Mandatory Catalogs With Entries Required

The following catalogs must be present on both Enterprise Access and non-Enterprise Access installations. These catalogs must contain entries.

• iicolumns
• iidbcapabilities
• iidbconstants
• iisynonyms
• iitables

Mandatory Catalogs Without Entries Required

The following catalogs must be present on both Enterprise Access and non-Enterprise Access installations. However, these catalogs are not required to contain entries.

• iialt_columns
• iiaudit
• iiaudit_tables
• iiconstraint_indexes
• iiconstraints
• iidb_comments
• iidb_subcomments
• iihistograms
• iiindex_columns
• iiindexes
• iikeys
• iiprocedures
• iiref_constraints
• iiregistrations
• iisecurity_alarms
• iistats
• iiviews

Ingres-Only Catalogs

The following catalogs are required by non-Enterprise Access Ingres installations.

• iifile_info
• iiintegrities
• iilog_help
• iimulti_locations
• iipermits
• iirules