Creating a new database

To create a new database without reinstalling BigFix Inventory, 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 BigFix Inventory 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
    SQL Server:
    1. Log in to 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 BigFix Inventory 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.
  6. After the configuration is completed, upload the software catalog to avoid problems with the data import. At this point, there might be some discrepancies between the server and the contents of the database, which will be resolved after the upload.