search cancel

Migration NSIGMIGA Gets Unexpected result


Article ID: 207712


Updated On:


SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite


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.




Release : 20.0

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


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.