Defines each data source which is used to connect to different data sources. All components access the database by reading this specific entry. This also has the access permission to the database being accessed.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| db_id | varchar(50) | not null | Unique id for the db object |
| name | varchar(64) | with null | Descriptive name of the db object |
| status | integer | with null | |
| db_class | varchar(64) | with null | The class for the db driver implementation, eg- sun.jdbc.odbc.JdbcOdbcDriver |
| db_url | varchar(256) | with null | The url for the db implementation, example - jdbc:odbc:icandb-mahine1 |
| login_id | nvarchar(50) | with null | The login id credentials to connect to the database |
| password | nvarchar(64) | with null | The password credentials to connect to the database |
| type | varchar(20) | with null | Specifies the type of the database, Eg: Oracle, Ingres |
| version | varchar(20) | with null | Specifies the version of the database, Eg: 9i, 10g etc |
| normalize_timestamps | integer | with null | Specfies if the timestamps have to be normaized |
| dst_id | varchar(30) | with null | Handle to day light savings record |
| host_name | varchar(64) | with null | Hostname where the db server is installed |
| db_name | varchar(64) | with null | Name of the database |
| autocommit | integer1 | with null | |
| time_zone_code | varchar(64) | with null | Time zone code is the code for a particular time zone, Eg- EST, PST etc |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| db_id | usm_report_data | db_id |
| db_id | usm_runtime_component | db_id |