How do we create a clean UIM database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Some times clients need to create a new clean UIM database for their existing primary hub and ump to work with. This KB article provides a method to accomplish this.

Our SQL server back end crashed and we do not have a good backup.

How do we create a new clean UIM database for our existing primary hub and UMP/OC?

Environment

UIM 9.X and earlier
UMP 9.x and earlier
 

Resolution

METHOD 1

• Setup a new temporary server
• Run the SAME UIM version Primary hub installer as your existing installation
• Run the SAME UMP version instraller as your existing installation
• Test to make sure you can log in to the primary and ump.
• Shut down the Temporary server
• Change the data_engine connection string on your original UIM installation
• Restart the primary hub robot service and UMP robot service

 

This should then be pointing to the new database and work as a clean install

 

METHOD 2

 

1) Delete the existing / bad database

2) create a new database  

2) run the following scripts in the order provided from the following location Nimsoft\nis\sql\<DBTYPE>:

Schema/db create scripts - run order:

<db>_nis_base_create.sql

<db>_slm_create.sql

<db>_dataengine_create.sql

<db>_nis_installer_create.sql

<db>_nis_account_create.sql

<db>_discovery_server_create.sql

<db>_nis_server_create.sql

<db>_ace_create.sql

<db>_webservice_create.sql

NOTES:

• Sometimes it is necessary to use raw edit on the wasp probe to clear the connection = key so the new conneciton string is fetched from the data_engine.
• On the data_engine you may need to run the PU command admin_upgrade_primary. This will tell the data_engine that the old UIM instance is the primary one and not the one from the temporary installation.