HP SIM V5.1 User Guide (356920-009, January 2007)

insight_v1_0
7. For Linux, proceed to step 8. For HP-UX, create user namned mxadmin (with No permission to create
database and user):
./createuser -h 127.0.0.1 -p 50006 -U hpsmdb mxadmin
8. At the HP SIM command line, enter:
For HP-UX:
./psql –q –h 127.0.0.1 –U mxadmin –p 50006 –f saveHPSIMdb -d insight_v1_0
For Linux:
psql –q –h 127.0.0.1 –U mxadmin –p 5432 –f saveHPSIMdb -d insight_v1_0
where saveHPSIMdb is the name of the backup file to be restored.
-p is the port number. To find the port number, open /etc/opt/mx/config/database.props
and look for the property value of hp.database.portNumber.
insight_v1_0 is the HP SIM database name. To find the databse name, open the file
/etc/opt/mx/config/database.props and look for the property value of
hp.database.databaseName.
9. When prompted, enter the password defined in step 6.
10. Using an appropriate file management utility, restore the configuration files listed below.
DescriptionDirectory of file
Directory of configuration files/etc/opt/mx/config
Additional configuration files/var/opt/mx/config/
Shared OpenSSL certificate directory/etc/opt/hp/sslshare/ (for HP-UX)
/opt/hp/sslshare
(for Linux)
Audit file/var/opt/mx/logs/mx.log
Program updates (required if HP SIM is to be reinstalled)/opt/mx/patch
Certificate used by the Command Line Interface (CLI)/opt/mx/bin/server_cert.pem
CLI configuration file/opt/mx/bin/CLIClientConfig
(optional) Contains job result output/var/opt/mx/output
Note: The file permissions must be preserved during the backup process. The Tape Archive (TAR) utility
preservers file permissions.
11. Restore any existing user-supplied (custom) files contained in the HP SIM directory tree, such as tool
definition files (TDEFs), Management Information Bases (MIBs), sign in prompt, and actions.
12. Initialize HP SIM by entering mxinitconfig -a in the command line so that the database and the
restore configuration files are updated in HP SIM.
Related procedure
▲ Windows
Related topic
▲ Backing up and restoring the database
Windows
A Microsoft SQL Server database (MSDE) or an Oracle database is used by HP Systems Insight Manager
(HP SIM) to store all collected information about the systems on your network as well as all configuration
options. Always back up your database using an appropriate backup schedule. In the event of a catastrophic
database problem, this backup can be restored to return HP SIM to operation.
If you must restore your database, stop the HP SIM service from the Services applet before doing the restore.
After the restore is complete, restart the service.
520 Administering systems and events