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 | |