This table contains the list of databases managed by the Unicenter Database Management tools. It holds the information needed to uniquely identify and connect to these databases (excluding the actual login information).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| server_id | integer | not null | Numeric Id of the database server. |
| server_name | varchar(255) | not null | The discovered database name. This is the universal name and it not unique to UDBM. |
| server_type | char(1) | not null | Database server types. Pre-loaded with: O = Oracle M = Microsoft SQL Server S = Sybase I = Informix U = DB2/UDB G = Ingres |
| server_version | varchar(255) | with null | Version of the database as returned by the RDBMS. |
| host_id | integer | not null | Machine RDBMS is hosted on |
| port | integer | with null | Port number needed to connect to the database. |
| connect_name | varchar(255) | with null | This is the standard name needed to connect to the
database.
Oracle: This is the database connect string. DB2: this is the local database alias. This value is dynamic and is updated when the server list is retrieved from the repository. |
| oracle_sid | varchar(255) | with null | Oracle: This is the standard SID used to identify the database. All other database types: No meaning |
| database_path | varchar(255) | with null | Location of the database libraries on the host associated with this server. For Oracle, this is equivalent to ORACLE_HOME. |
| community | varchar(255) | with null | Oracle: This is the Oracle Community. From the tnsnames.ora file. All other database types: No meaning |
| udb_instance | varchar(255) | with null | DB2: DB2 Instance All other database types: No meaning |
| connect_database | varchar(255) | with null | DB2 Open Systems only: This is the database within the instance. All other database types: No meaning |
| service_name | varchar(255) | with null | Oracle: Service name (NOT the SID) All other database types: This is the port in the form of a string. |
| extended_info | varchar(255) | with null | DB2: Local node name corresponding to the database alias in the serverConnectName field. This value is dynamic and is updated when the server list is retrieved from the repository. All other database types: No meaning |
Product Name: Unicenter Database Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| server_id | mit_server_user | server_id |
| server_id | mit_server_parm | server_id |