Migrating the Lifecycle Query Engine database

About this task

The procedure for changing the database vendor for the Lifecycle Query Engine application is different from the other Engineering Lifecycle Management applications. The following steps describe the required procedure to migrate the Lifecycle Query Engine database.

Procedure

  1. Ensure that the Lifecycle Query Engine server is started and then log on to HTTPS://hostname.example.com:9443/lqe/web/admin/home.
  2. In the Backups section, click Edit backup configuration.
  3. In the One Time Backup section, click Backup Now.
  4. In the dialog that opens, select an existing backup directory on the server and click Backup Now. This creates two directories under the backup location: datasets and metadata.
  5. Locate these two directories and copy them to LQE_Install_Dir/server/conf/lqe.
  6. Stop the Lifecycle Query Engine server.
  7. Go to LQE_Install_Dir/server/conf/lqe and open the dbconnection.properties file for editing.
  8. Edit the db.vendor, db.location, and db.password parameters with the new database information. Save and close the file.
    Note: If you are migrating from the Derby database, the db.password parameter does not exist. You can manually add this parameter and specify the password for your database.
  9. Open the lqe.properties file for editing and set lqe.restore parameter to true. Save and close the file.
  10. Start the Lifecycle Query Engine server with the new database and validate that Lifecycle Query Engine is working by navigating to HTTPS://hostname.example.com:9443/lqe/web/admin/home.