Was this helpful?
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
The following Ingres Star system catalogs exist in a distributed database, but these catalogs are not legal targets for sysmod:
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
Last modified date: 01/30/2023