Creating a new database

Edit online

To create a new database without reinstalling License Metric Tool, you must modify the configuration file that stores information about the database. After you do so, you will be able to complete the initial configuration again, and create a new database.

Procedure

  1. Stop the License Metric Tool server.
  2. Delete the current database.
    Note: TEMADB is the default database name. If you are unsure whether it applies to your database, see: Checking the database name.
    DB2:
    1. Log in as the DB2 instance owner, which by default is db2inst1.
    2. Run the following command to check the details of the existing database.
      db2 list db directory
    3. Run the following commands to close the existing connections, deactivate the database, and delete it.
      db2 deactivate db TEMADB
db2 drop db TEMADB
    MS SQL Server:
    1. Log in to MS SQL Server Management Studio.
    2. In the navigation tree, expand Databases.
    3. Right-click on the TEMADB database, and then click Delete.
  3. Go to installation_dir/wlp/usr/servers/server1/config/, and rename the database.yml file to database.yml.bak. This step resets the initial configuration and allows you to create a new database. You will also have to create a new administrative user and specify connections to the BigFix® platform.
  4. Start the License Metric Tool server.
  5. Go to https://hostname:port/setup/database to perform the initial configuration and create a new database. For more information, see: Performing initial configuration on Windows or Performing initial configuration on Linux.