Was this helpful?
System Catalogs for iidbdb
Following are the table names of DBMS System Catalogs that exist only in the master database (iidbdb). These tables can be used as arguments to the sysmod command. They are not supported for any other use.
The information in these catalogs is accessed by selecting from standard catalogs when connected to the iidbdb database:
Catalog
Description
iicdbid_idx
Index on iistar_cdbs
iidatabase
Various attributes of the databases existing in this installation.
iidbid_idx
Index on iidatabase.
iidbpriv
Contains information about database privileges.
iidbdb_netcost
Contains costing information used by Ingres Star.
iidbdb_nodecost
Contains costing information used by Ingres Star.
iiextend
Information about what locations databases have been extended to.
iigw07_attribute
Ingres Management Architecture (IMA) catalog.
iigw07_index
Ingres Management Architecture (IMA) catalog.
iigw07_relation
Ingres Management Architecture (IMA) catalog.
iilocations
Storage locations defined in this installation.
iiprofile
User profiles defined in this installation.
iirole
Roles defined in this installation
iirolegrant
Information about which grantees have role privileges.
iisecuritystate
Information relating to the security state of this installation.
iistar_cdbs
Information about Ingres Star coordinator databases in this installation.
iiuser
Users defined in this installation
iiusergroup
Group definitions for this installation
Last modified date: 01/30/2023