7. Understanding Ingres Star Catalogs : Ingres Star Catalogs : iidbdb Catalogs : The iistar_cdbinfo Catalog
 
Share this page                  
The iistar_cdbinfo Catalog
The iistar_cdbinfo catalog provides maps between the distributed database and its underlying coordinator database. It indicates on which node the database was created, who owns it, and when it was created.
This catalog exists only in the iidbdb, not in all distributed databases. This catalog is read-only; you cannot update it.
Column Name
Data Type
Description
ddb_name
char(32)
Name of distributed database
ddb_owner
char(32)
Owner of distributed database
cdb_name
char(32)
Name of coordinator database
cdb_node
char(32)
Name of the coordinator database’s node
cdb_owner
char(32)
Owner of the coordinator database
cdb_dbms
char(32)
Server of coordinator database, for example, INGRES, DB2
cdb_create_date
char(25)
Date when coordinator database was added