Re-initializing the Database

CAUTION: Do not use the Database Admin Utility to re-initialize the HP SIM database. Follow the steps in this section to re-initialize the HP SIM database and then the HP Storage Essentials database.

Keep in mind the following:

•Re-initializing the database removes everything from the database. This is not recommended unless you are sure about what you are doing. It is strongly suggested you export the database before you re-initialize it. See ”Exporting the Database” on page 236 for more information on how to save the database.

•When you re-initialize the database, all users are logged out of the management server.

To clear the database:

1.Login to the system as follows:

•Microsoft Windows - Administrator

•Linux - root

2.Stop AppStorManager, which is the service for HP Storage Essentials.

3.Remove the HP SIM connector as described in the Installation Guide.

4.Stop the service for HP SIM.

5.Drop the SEConnectorData table from HP-SIM schema by doing the following:

a.(Linux management servers only) Run the setvars.sh script by entering the following:

./[SE-installDir]/install/setvars.sh"

b.Enter the following:

sqlplus SIM_Manager/quake@appiq

NOTE: The word 'quake' is the default password for SIM_Manager user. Please use the appropriate password if you have changed the password for SIM_Manager user.

c.Enter the following:

Drop table SEConnectorData;

6.Run the HP SIM CLI command 'mxinitconfig -r' to remove the HP-SIM schema.

7.Run the HP SIM CLI command 'mxinitconfig -a' to re-initialize HP-SIM schema. HP SIM restarts automatically after running this command.

8.Ensure that the service for HP SIM has restarted successfully.

9.Re-initialize the HP Storage Essentials database:

a.Access the Database Admin Utility as described in ”Accessing the Database Admin Utility” on page 233.

b.Click Re-initialize Database in the left pane.

238 Database Maintenance and Management