upgrading the uim database

book

Article ID: 242637

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We want to upgrade our MS SQL 2014 Always On Cluster to 2019. Do we need to do anything on the UIM?

 

Environment

Release : 20.3

Component : UIM - DATA_ENGINE

Resolution

Before you begin the upgrade.

Verify that the database version you want to upgrade to is supported:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-4/installing/product-compatibility/ca-uim-compatibility-matrix.html#concept.dita_3e0b025267e987b38f84e5c201b1b6f9da447ad5_ComponentSupportMatrix

deactivate the data_engine on both the primary and HA servers.
backup the database
upgrade the database
activate the data_engine probes as needed on the primary and HA servers