We have a Linux v6.x server with ILMT (v9.2.18) installed on it and it needs to be upgraded to RHEL v7.x; as the RHEL v6.x server will be soon retired. So we copied ILMT to a new VM with RHEL v7.x. We were able to bring up the ILMT application. However, it has 2 BigFix Data Sources; one is DB2 and the other Windows MSSQL. The new BigFix is the MSSQL, and we only want ILMT to connect to just this BigFix. How do we accomplish this?

We stopped the DB2 database , but was unable to log into the ILMT UI. Started it back, and was able to log in again to ILMT. Also, the old BigFix (DB2) server is going to be retired soon as well. I would like to get a Webex scheduled.

Thanks!

You could try to recreate database for LMT

https://www.ibm.com/support/pages/rebuilding-brand-new-temadb-database-without-re-installing-ilmt-v90x-v92x-application

https://www.ibm.com/support/knowledgecenter/SS8JFY_9.2.0/com.ibm.lmt.doc/Inventory/admin/t_creating_new_db.html