CA SYSVIEW for DB2 Unload/Load Utilities got several error messages.

Document ID : KB000010566
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

After an upgrade to a new Release CA SYSVIEW for DB2 Unload/Load Utilities got several error messages in IBM DB2 Load Utility related to attributes in several fields.
 
...
DSNU329I -DB2P 230 08:32:32.98 DSNURWUF - FIELD 'PROFMON_PROFILE_ID' IS NOT DEFAULTABLE
DSNU650I -DB2P 230 08:32:32.98 DSNURWI - PROFMON_COND_TYPE POSITION(4442) CHAR(1) NULLIF(NULLS_10_FIELDS='Y'))
DSNU329I -DB2P 230 08:32:32.98 DSNURWUF - FIELD 'PROFMON_COND_TYPE' IS NOT DEFAULTABLE
DSNU012I 230 08:32:32.99 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
...

Instructions:

The CA SYSVIEW for DB2 database changes over releases, some columns might be added and other altered, the Archive Table Migration Utility (NSIGMIGA) documented in CA SYSVIEW Performance Management Option for DB2 manual has to be run but when it fails then you have to double check manually the DDL for the CA SYSVIEW for DB2 database is the right one from HLQ.SOURCE(ARCDDL) member and the ARCL* members in your HLQ.SOURCE Library are in sync from the right Release.