After executing all the Sysview Performance Management Option for Db2 for z/OS (IDB2) ALTERs for release r19, using the new r19 extract and load cards
and defining the application_daily table as indicated in the r19 hlq.SOURCE(ARCDDL), the load of the above table failed with the following messages:
WORKFILE_BLKS_HWM POSITION(1550) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'WORKFILE_BLKS_HWM' IS NOT DEFAULTABLE
WORKFILE_BLKS_CURR POSITION(1558) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'WORKFILE_BLKS_CURR' IS NOT DEFAULTABLE
PIPE_WAIT_TIME POSITION(1566) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'PIPE_WAIT_TIME' IS NOT DEFAULTABLE
PIPE_WAIT_COUNT POSITION(1574) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'PIPE_WAIT_COUNT' IS NOT DEFAULTABLE
LOBCOMP_WAIT_TIME POSITION(1582) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'LOBCOMP_WAIT_TIME' IS NOT DEFAULTABLE
LOBCOMP_WAIT_COUNT POSITION(1590) DECIMAL NULLIF(NULLS_12_FIELDS='Y'),
FIELD 'LOBCOMP_WAIT_COUNT' IS NOT DEFAULTABLE
What happened here is that the r19 files were used as the "OLD" IQL and LOADs for the migration utility. So the migration utility thought
that everything is up to date. The problem is that r19 migration file does not contain the ALTERs for the new columns.
NSIGMIGA needs the OLD (currently used) IQL and LOAD statements + 2 files from the r19 installation that describe the changes.
It generates new IQL, LOAD statements and ALTER statements.