search cancel

What is the query that is being executed during the UIM Upgrade to 9.0.2 to validate if enviromment is ready to be upgraded?

book

Article ID: 202288

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Hi,

I need your support for check our production environment of CA Unified Infrastructure Management for upgrade to 9.0.2 version, Is there any query that allow verify if the environment is ready for upgrade to 9.0.2. Next some details of the platform:

UIM Server: current version 8.51 sp1

install_date: 2016-05-04T11:46:17, product_name_abbrev: UIMServer, product_version: 8.4, uimserver_lib_module_version: 8.4.0, uimserver_lib_build_date: 2016-01-26T10:15:57
install_date: 2018-05-17T02:49:00, product_name_abbrev: UIMServer, product_version: 8.51, uimserver_lib_module_version: 8.5.1.1, uimserver_lib_build_date: 2017-08-29T16:25:50

UMP Server: current version 8.51 sp1

Version      = 8.5.1Build Label  = UMP_851_GABuild Date   = February 22, 2017 06:23:59 PM -0700Build Number = 150093

Thanks, regards.

 

Environment

Release : 9.0.2

Component : UIM - INSTALL

Resolution

1. strTableExistQuery
select count(*) as counta from SSRV2ConfigValue

if count <=0, continue install as SSR tables do not exist
if count >0, check for strMcsOrNotQuery

 

2. strMcsOrNotQuery 
select count(*) as counta from ssrv2version where component = 'mon_config_service';

if count <=0, abort install as mcs does not exist which means ssr created these tables
if count >0, check for strDuplicateCheckQuery


3. strDuplicateCheckQuery 
select count(*) as counta from (select COUNT(*) as duplicates from SSRV2ConfigValue WHERE field IS NOT NULL group by profile, field) a where a.duplicates > 1;

if count <=0, continue install as duplicate entries do not exist 
if count >0, abort install as duplicate entries exist

 

 

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/upgrading/ca-uim-upgrade-step-1-evaluate-the-existing-environment.html