Highlighted
Absent Member.. HPRB Absent Member..
Absent Member..
74 views

(SM) Support Tip: Enable replicated database.

Generating the reports from the server will consume additional system resources (memory and CPU). Service Manager provides the database replication to preserve Production Database performance.

Before you enable Replicated Database for Service Manager Reports, prepare a database with the same database type and version as the Production Database. For example, if your Service Manager uses an SQL database, the replicated database should be an SQL database of the same version. Perform database synchronization periodically by using the standard database synchronization mechanism.

To enable Replicated Database, follow these steps:

  1. Open the sm.ini file. By default, the file is located on the Service Manager server in the C:\Program Files (x86)\HP\HP Service Manager 9.40\Server\RUN folder.
  2. Add the Replicated Database parameter and value to the file. For example:

[your database type_replicate]

sqldb:sm940db

sqllogin:username/password

dashboardonreplicatedb

Note: The three parameter lines of Replicated Database should be in one block in the sm.ini file.

3. Save the sm.ini file.

The reports can now be run in the replicated database instead of the production database.

NOTE: More information on how to setup this reporting can be found in SM online help.

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.