ALL_DATABASES table
The ALL_DATABASES table represents all tenant user databases.
A database has a name which is its catalog name, however that is not directly represented since it can be obtained from the CATSYS system schema table. The clustering key is the DB_UID column which will contain the corresponding catalog UID.
Column number |
Column Name |
Data Type |
Description |
1* |
DB_UID |
LARGEINT |
The catalog UID of the database. Links to CATSYS. |
2 |
SERVICE_UID |
LARGEINT |
A reference to the service for the database. Links to DBS_SERVICES. |
3 |
LOCK_UID |
LARGEINT |
The UID of the DDL Lock for an active utility operation on a database. -1 when no utility operation is active. Links to the OBJECTS and DDL_LOCKS tables. |
4 |
DB_TYPE |
INT |
Reserved for future use. |
5 |
SUM_OF_MAX_SRVRS |
INT |
The sum of the max servers attributes for all MXCS DSs associated with the database. |
6 |
IS_SHARED |
CHAR(2) |
Y/N indication if the database is shared. |
* Indicates primary key |