Dependencies, Reconfiguring the cms to use a different database, Warning – HP Systems Insight Manager User Manual
Page 93: Warning dependencies, Changing the database associated with the cms
Dependencies
All of the following must be true:
•
Systems Insight Manager is installed and configured on a Windows operating system host,
using Microsoft SQL.
•
All credentials are know.
•
The database credentials provided by the user during this command are valid for the CMS
database.
Reconfiguring the CMS to use a different database
Use the mxreconfig —m sqlredirect command to reconfigure the CMS to use a different
database. This command updates the CMS to associate a new Microsoft SQL database residing
on a different server. If the database previously associated with Systems Insight Manager must be
changed, use this command to specify the new database server and database name. You can
optionally specify the database port number on which Systems Insight Manager communicates
with the new database, and the username credential that Systems Insight Manager uses to access
the new database.
NOTE:
The parameters —s,—a and —b and their arguments are required. The parameter —p and
its argument is optional.
IMPORTANT:
This command is applicable to Systems Insight Manager only.
This command does the following:
•
Stops all installed Systems Insight Manager partner services.
•
Redirects the CMS to use the new SQL database.
•
Modifies the Systems Insight Manager configuration files and ODBC data source to reflect the
new SQL server name.
•
Restarts all installed Systems Insight Manager partner services.
To change the database associated with the CMS, perform the following:
Procedure 22 Changing the database associated with the CMS
1.
Open a command prompt on the CMS and navigate to the install directory of Systems Insight
Manager.
2.
Enter the following and then press Enter.
> mxreconfig -m sqlredirect -s <db-server-name>
3.
Enter the database password when prompted, and then press Enter.
Warning
Verify that all Systems Insight Manager operationsn are complete before running this command.
Dependencies
All of the following must be true:
•
The database to be associated with Systems Insight Manager has been copied and setup on
a differentn SQL server.
•
Systems Insight Manager is installed and configured on a Windows operating system, using
Microsoft SQL.
Reconfiguring the CMS to use a different database
93