search cancel

DB queries to perform validation after upgrade

book

Article ID: 253406

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Validation like the number of rows that are same or not. And which event ha processed at last? Check the table size. Any stale events?

Environment

Release: 12.0

Upgrade validation from R 11.3.6 SPx to R 12.0

Cause

Question

Resolution

Run the below query to verify the successful upgrade and for the above validation checks.

SELECT * FROM ujo_alamode where type in ('AEDB_VERSION', 'BINARY_VERSION')