A. System Catalogs : Standard Catalog Interface : Standard Catalogs for iidbdb : iidatabase_info Catalog
 
Share this page                  
iidatabase_info Catalog
This catalog describes attributes for a database.
Column Name
Data Type
Description
database_name
char(32)
Name of the database
database_owner
char(32)
Owner of the database
data_location
char(32)
Default data location for this database
work_location
char(32)
Default work location for this database
ckp_location
char(32)
Default checkpoint location for this database
jnl_location
char(32)
Default journal location for this database
dump_location
char(32)
Default dump file location for this database
compat_level
char(4)
The compatibility level of the Ingres database
Currently 9.04
compat_level_minor
integer
Unused; defaults to 0
database_service
integer
Database services available (such as: Is the database distributed? Can it be accessed through gateways?)
Bitmask of database attributes:
 
 
0x00000000
Default
 
 
0x00000001
Distributed database
 
 
0x00000002
Coordinator database for a distributed database
 
 
0x00000004
Gateway database
 
 
0x00010000
Regular IDs are translated to upper case
 
 
0x00020000
Database created with LP64
 
 
0x00040000
Delimited IDs are translated to upper case
 
 
0x00080000
Delimited IDs are not translated
 
 
0x00100000
Real user IDs are not translated
 
 
0x00200000
Unicode types in Normal Form C can be stored in database
 
 
0x40000000
Database forced consistent by verifydb
 
 
0x80000000
Unicode types in Normal Form D can be stored in database
security_label
char(8)
Empty string
This column is deprecated.
access
integer
Bitmask of database access attributes.
The bit mask is set only if Ingres utilities are used to change the access rights to the database. Using a grant [no]access on database dbname to public statement does not change the access from global to private or vice versa in iidatabase_info.
Bitmasks as follows:
 
 
0x00000000
Database is private
 
 
0x00000001
Database is globally accessible
 
 
0x00000002
Unused
 
 
0x00000004
Database was/is in process of being destroyed
 
 
0x00000008
Database was/is in process of being created
 
 
0x00000010
Database is operational, i.e. is accessible to users
 
 
0x00000020
Database was created in an earlier Ingres release and has not yet been upgraded
 
 
0x00000040
Database was created via an earlier Ingres version and is in the process of being upgraded or the upgrade attempt was made and failed
 
 
0x00000080
Database created with B1 security
 
 
0x00000100
Do not wait during destroydb if the database is busy
 
 
0x00000200
Production mode
 
 
0x00000400
No online checkpoints
 
 
0x00000800
Database is read only
database_id
integer
Unique numeric identifier for this database in the installation