SUPPORT OF IFCID3 fields When DB2 Zparm ACCELMODEL=No

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

QUESTION:

Prior to using an IDAA appliance  IBM has provided a DB2 Zparm ACCELMODEL=No that you can set that will fill in fields like QWAC_ACCEL_ELIG_CP, QWAC_ACCEL_ELIG_ELA, QWAC_ACCEL_ELIG_SE that were added to the IFCID0003 record which allows you to determine if and how much workload could be directed to the IDAA.  Does Insight R17 support these?

 

ANSWER:

The IFCID3/314 fields QWAC_ACCEL_ELIG_CP, QWAC_ACCEL_ELIG_ELA and QWAC_ACCEL_ELIG_SE are not supported by R17. They are available in R18. 

As to IDAA simulation in general, the zParms should be set as follows (note ACCELMODEL set to YES):

QUERY ACCELERATOR PREFERENCES PANEL            ZPARM Name                       Value

 Query options enabled for accelerator                      QUERY_ACCEL_OPTIONS      NONE 

 Default QUERY_ACCELERATION special reg value     QUERY_ACCELERATION        NONE 

 Modeling of query workloads                                   ACCELMODEL                       YES