Lifecycle Query Engine Relational Store (LQE rs)

Authors: ChaoWang, KotTontranakwong
Build basis: Lifecycle Query Engine 7.0.3+, 7.x

This page provides information for those who are looking to install or migrate to Lifecycle Query Engine - Relational store (LQE rs) application. LQE rs is an implementation of the Lifecycle Query Engine that replaces Jena with a relational database. The information in this page can help you determine the topology that fits your requirements.

New LQE RS on an existing LQE server

When to use:

• The LQE Jena server does not have much data and is not under heavy load.

Pros:

• No need to setup a separate LQE instances on a new server.
• Less JRS data sources to manage.
• Less risk when transitioning to LQE RS.
• LQE Jena can be decommissioned after transitioning to LQE RS. (Need to find documentation for decommissioning)

Cons:

• There could be a need to move the server off the powerful machine in the future (after LQE Jena is completely decommissioned). This raises a need for a server rename.

New LQE RS on a separate LQE server

When to use:

• The current LQE has a large index and is under heavy load.
• You do not have LQE in the ELM environment and want to add LQE RS to the environment.

Pros:

• LQE RS does not require as much resources as LQE Jena; therefore, can be installed on a smaller machine.
• LQE RS will not be impacted by the LQE Jena’s performance.
• There could be a need to move the server off the powerful machine in the future (after LQE Jena is completely decommissioned). This can avoid the need for a server rename.

Cons:

• More data sources in JRS to manage

New or Existing data warehouse database?

Use the following links to help in determining whether to use the existing DW database or create a new DW database for LQE RS.

• https://jazz.net/wiki/bin/view/Deployment/LQERSDatabaseSizing

When setting LQE RS with a new DW database, ensure the DW database is not empty.

• You will need to temporarily change DW connection in JTS to point to the new database, use JTS setup to populate the new DW database, then, switch the DW connection in JTS back to the original DW.

When using the same DW, if you need to disable access control, it will be done by unchecking the checkbox in the “Data Warehouse” data source in the Report Builder. This will disable access control for both data warehouse and LQE RS.

Steps to setup LQE RS

1. (NEW LQE only) Install LQE – follow the steps to install and setup LQE
2. Ensure LQE RS connect to the desired DW database:
   1. Go to LQE > Administration > Relational Store > Settings at https:///lqe/web/pgs/settings
   2. Ensure the database connection information under the “Data Warehouse Connection” section is correct and that the connection is successful.
      
      
      

Header 1

Related topics: Deployment web home, Deployment web home

External links:

• IBM

Additional contributors: TWikiUser, TWikiUser