HISTORY TABLE COLUMN IS NOT DEFAULTABLE

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

After doing all the alters for R19, using the new R19 extract and load cards and defining the application_daily table as indicated in the R19 HGHLVL.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                     

 

 

Environment

Release:
Component: CIDB

Resolution

What happened here is that the R19 files were used as the "OLD" iqls&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) iqls and loads statements + 2 files from the R19 installation that describe the changes. And it generates NEW IQLs, load statements and ALTER statements.