System Catalogs

System catalogs store specific information for Ingres Star. These catalogs are used to get the information needed to operate on distributed objects in the database. Users cannot query these catalogs directly. The standard catalog interface described in the appendix, "Standard Catalog Interface" lets you access data from the system catalogs.

The table names of some Ingres Star system catalogs can be used as arguments to the sysmod command, but these tables are not supported for any other use. The following Ingres Star system catalogs are legal targets for sysmod:

Catalog	Description
iiddb_dbdepends	Dependency tree for a distributed view
iiddb_ldbids	Contains information about each local database known to the distributed database
iiddb_ldb_columns	Map of local table’s column names if the table is registered with user-supplied aliases to the column names
iiddb_ldb_dbcaps	Contains capability data on each local database known to the distributed database
iiddb_long_ldbnames	Contains the full local database name (if it exceeds 32 bytes) and the alias to Ingres Star’s 32-byte name
iiddb_object_base	Used to generate a unique identifier
iiddb_objects	Describes distributed objects known to the distributed database
iiddb_tableinfo	Data on the underlying (local database) objects for distributed objects
iiddb_tree	Used to store Ingres Star-generated trees, such as view definitions

Catalog	Description
iiddb_dxldbs	List of local databases involved in a Ingres Star two-PC transaction
iiddb_dxlog	Log of an Ingres Star two-PC transaction
iiddb_xdxlog	Secondary index on iiddb_dxlog