7. Understanding Ingres Star Catalogs : Ingres Star Catalogs : iidbdb Catalogs : The iistar_cdbs Catalog
 
Share this page                  
The iistar_cdbs Catalog
The iistar_cdbs catalog in the iidbdb is used to store the identities and locations of coordinator databases associated with each distributed database.
This catalog contains an entry for the coordinator database associated with each distributed database. It is used by Ingres Star to determine the identity and residence of the associated coordinator database when a distributed database is invoked.
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
schema_desc
char(32)
Reserved for future use
create_date
char(25)
Date when coordinator database was added
original
char(8)
Reserved for future use
cdb_id
integer4
Contains a unique database identifier corresponding to iidatabase.db_id for the coordinator database entry
cdb_capability
integer 4
Reserved for future use