Fix Readme
Abstract
Upgrade of DB2 to version 11.5 is not possible for License Metric Tool application updates between 9.2.15.0 and 9.2.18.0. It is caused by an APAR in the DB2 migrator that prevents the License Metric Tool database from being upgraded to version 11.5. This document provides a script that allows to work around the problem.
Content
License Metric Tool application updates from 9.2.15.0 to 9.2.18.0 do not support DB2 11.5. When you plan to upgrade License Metric Tool to version 9.2.19.0 and DB2 to version 11.5, you need to perform the upgrades in the following order to avoid downtime of the system: first upgrade the License Metric Tool server, then upgrade DB2. If for some reason, DB2 needs to be upgraded first, use the following procedure to make the upgrade possible.
Important: If the BigFix server or WebReports run on the same DB2 instance, ensure that those components are in versions that support DB2 11.5 before you upgrade database. If not, upgrade those components before you upgrade DB2. For the list of DB2 versions supported by BigFix components, refer to the BigFix documentation.
- Verify that your License Metric Tool is in version between 9.2.15.0 and 9.2.18.0.
- Stop the License Metric Tool server.
- Go to the computer on which DB2 is installed and log in as a DB2 instance owner (for example, db2inst1).
- Copy the fix_ilmt_db_before_11.5_upgrade.sql file to the local directory.
- Optional: If the name of your License Metric Tool database is different than "temadb", modify the first and last line of the fix_ilmt_db_before_11.5_upgrade.sql file. Substitute the default name of the database with the name of your database.
- Run the following command.
db2 -vf fix_ilmt_db_before_11.5_upgrade.sql -td%
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"ARM Category":[{"code":"a8m0z000000blgDAAQ","label":"ComponentsUpgrade->DatabaseServer"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.2.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
26 April 2021
UID
ibm16217888