After upgrading Sysview for Db2 (IDB2) to r20 the archive process fails due to missing table fields

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

After upgrading Sysview for Db2 (IDB2) from r18 to r20 the nightly archive job to populate the IDB2 tables fails due to missing fields in the IDB2 archive tables. 

 

Environment

Release : 20.0

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

Cause

The necessary ARCMIGUT job that invokes the NSIGMIGA utility to upgrade the IDB2 Db2 objects had not been run.

Resolution

The necessary post-install File Tailor (option 2) needed to be performed to process the ARCMIGUT job with the appropriate values and placed in the .SOURCE library via the IDB2SYS job.  It is the ARCMIGUT job that invokes the NSIGMIGA utility to upgrade the IDB2 archive tables.   

 

Additional Information

For more information about the ARCMIGUT job please review:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/configuring/utilities/archive-table-migration-utility-nsigmiga.html