A. Data Dictionary Tables : System Catalogs : dd_databases Table
 
Share this page                  
dd_databases Table
The dd_databases table defines each database in the replicated environment:
Column Name
Data Type
Description
database_no
smallint not null
Numeric identifier assigned by the user to uniquely identify the database in the replicated environment. The range is 1-32,767.
vnode_name
char(32) not null
Ingres Net virtual node where the database is located.
database_name
char(32) not null
The name of the database.
database_owner
char(32) not null with default
The name of the owner of the database.
dbms_type
char(8) not null with default
The type of database management system servicing the database, for example, Ingres, Datacom/DB, DB2.
security_level
char(2) not null with default
The security level implemented in the database. Values are Blank, C2, and B1.
local_db
smallint not null with default
Indicates this is the local database. Only one row in this table can have a 1 in this column.
config_changed
char(25) not null with default
The last date and time that a configuration change was made that affected this database.
remark
varchar(80) not null with default
Comments about the database.