Migration NSIGMIGA Gets Unexpected result

book

Article ID: 207712

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

When running the new migration from v19 to v20 of SYSVIEW for DB2, unexpected results occurred:

The IQL and LOAD statements look correct however the ALTERS do not, for example the column wait_xus_upd_com is not present.

 

 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

The expectation was that the ARMIGUT process would work as designed straight out the box. Feed it v19 libs and v20 and good to go. After creating the alters and applying them the 1st run of the load process failed. There were several but the column used as an eyecatcher wait_xus_upd_com was not there. Some of the load members that are fed into the pgm were missing in v19! For example ARCLAAD.  Copying  what was missing over reran the migration process and it worked.