HISTORY TABLE COLUMN IS NOT DEFAULTABLE

Document ID:  TEC1486431
Last Modified Date:  07/31/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA SYSVIEW Performance Monitor for DB2 for z/OS

Components

  • CA Insight Database Performance Monitor for DB for z/OS:IDB2
  • Common Insight Services:CIDB
Problem:

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                     

 

 

Workaround:

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. 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >