Sysview for Db2 HISTORY TABLE COLUMN IS NOT DEFAULTABLE

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

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

Resolution

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.