You can use the ManagementDB / ProfileDB page to create and configure a Management database source connection and multiple Profile database connections to collect performance-related data of your enterprise for various HP BSM applications such as Business Process Monitor (BPM), Real User Monitor (RUM), and HP SiteScope. You can schedule SHR to collect data from the data repositories at specific intervals. In addition, you can view the status of the connection and data collection.
The ManagementDB / ProfileDB page includes:
Field | Description |
---|---|
Host name | IP address or FQDN of the Management database host system. Host name is not displayed when Management DB on Oracle RAC is selected or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. |
Database name | Name of the database. This column appears only if MSSQL is selected as the database type when configuring Management database connection. It does not appear if Oracle is the database type. |
Status | Status of the Management database connection and data collection. |
Connection |
Status of the Management database connection.
|
Collection |
Status of the collection showing the date and time of the latest collection attempt and the current status:
|
Configuration | Modify the existing Management database connection. |
Test Connection | Test the Management database connection. |
Delete | Delete the Management database connection. |
Create New | Create a new Management database connection. |
Save | Save the changes made to the Management database connection parameters. |
Field | Description |
---|---|
Host name | IP address or FQDN of the Profile database host system. |
Enable Collection | Option to enable or disable data collection. |
Database name | Name of the Profile database instance. |
Status | Status of the Profile DB connection and data collection. |
Connection |
Status of the Profile DB connection.
|
Collection |
Status of the collection showing the date and time of the latest collection attempt and the current status:
|
Test Connection | Test the Profile database source connection. |
Select Schedule |
Time to synchronize the SHR database with the Profile database source connection. |
Refresh | Update the list of Profile database source connections. |
Save |
Save the changes made to the Profile DB connection. Note: Set up parameters for the profile management database, only if Profile DB on Oracle RAC is selected, or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. In such an instance, the Create New option under Profile Database is displayed. |
Field | Description |
---|---|
Host name | IP address or FQDN of the Management database server. Host name is not displayed when Management DB on Oracle RAC is selected or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. |
Port | Port number to query the Management database server. Port number is not displayed when Management DB on Oracle RAC is selected. |
Database instance |
System Identifier (SID) of the Management database instance. Database instance is not displayed when Management DB on Oracle RAC is selected. Note: For information about the database host name, port number, and SID, contact your HP Business Service Management administrator. |
Database type | The type of database engine that is used to create the Management database. It can either be Oracle or MSSQL. |
Windows Authentication |
If you have selected MSSQL as the database type, you have the option to enable Windows authentication for MSSQL, that is, the user can use the same credentials to access SQL Server as that of the Windows system hosting the database. |
ManagementDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. If only ManagementDB on Oracle RAC is selected and Profile DB on Oracle RAC is not selected, the profile database details are configured automatically. |
ProfileDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. Configure the profile database parameters only when this option is selected. |
Database name | Name of the database. This field appears only if MSSQL is selected as the database type. |
Service name |
This option appears only if Management DB on Oracle RAC is selected. Note:Service name is displayed instead of the Host name when users select only Management DB on Oracle RAC or both Management DB on Oracle RAC and Profile DB on Oracle RAC |
User name |
Name of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note: If the Windows Authentication option is selected, this field is disabled. |
Password |
Password of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note: If the Windows Authentication option is selected, this field is disabled. |
Collection Station | This option is used for a collector installed on a remote system. |
Field | Description |
---|---|
Host name | IP address or FQDN of the Management database server. Host name is not displayed when Management DB on Oracle RAC is selected or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. |
Port | Port number to query the Management database server. Port number is not displayed when Management DB on Oracle RAC is selected. |
Database instance |
System Identifier (SID) of the Management database instance. Database instance is not displayed when Management DB on Oracle RAC is selected. Note: For information about the database host name, port number, and SID, contact your HP Business Service Management administrator. |
Database type | The type of database engine that is used to create the Management database. It can either be Oracle or MSSQL. |
Windows Authentication | If you have selected MSSQL as the database type, you have the option to enable Windows authentication for MSSQL, that is, the user can use the same credentials to access SQL Server as that of the Windows system hosting the database. |
ManagementDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. If only ManagementDB on Oracle RAC is selected and Profile DB on Oracle RAC is not selected, the profile database details are configured automatically. |
ProfileDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. Configure the profile database parameters only when this option is selected. |
Application |
HP Business Service Management application type. This field is disabled by default. |
Database name | Name of the Management database. This field appears only if MSSQL is selected as the database type. |
Service name |
This option appears only if Management DB on Oracle RAC is selected. Note:Service name is displayed instead of the Host name when users select only Management DB on Oracle RAC or both Management DB on Oracle RAC and Profile DB on Oracle RAC |
User name |
Name of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note : If the Windows Authentication option is selected, this field is disabled. |
Password |
Password of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note: If the Windows Authentication option is selected, this field is disabled. |
Collection Station | This option is used to configure a remote collector. |
Use the ManagementDB / ProfileDB page to: