PM91135: DB2 V9 ZPARM QUERY_ACCEL_OPTIONS CONTAINS INVALID VALUES WHICH ARE SPECIFIC FOR DB2 V10 AND ABOVE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 V9 zparm QUERY_ACCEL_OPTIONS contains invalid values which
  are specific for DB2 V10 and above.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who generate a new Zparm on DB2 9,      *
  *                 10 and 11.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The 'Display Parameters/Generate        *
  *                      DSNZPARM source' option on panel        *
  *                      ADB2Z2Z 'System Parameters' does        *
  *                      not support all the values for the      *
  *                      Zparm QUERY_ACCEL_OPTIONS, and does     *
  *                      not support the new Zparm ACCEL_LEVEL   *
  *                      for DB2 9, and the Zparm COMCRIT for    *
  *                      DB2 11.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 has added 98 and 99 to the list of valid values for the
  QUERY_ACCEL_OPTIONS Zparm and they were not supported by the
  DB2 Admin Zparm function. The function now supports values
  NONE, 1, 98, and 99 for DB2 9, as well as values 2 and 3 for
  DB2 10 and 11.  DB2 also added ACCEL_LEVEL for DB2 9 and
  COMCRIT for DB 11.
  

Problem conclusion

• The problem has been fixed and the DB2 Admin Zparm function will
  support the new values. In addition, Zparms that are no longer
  valid for DB2 11 will no longer be generated for DB2 11.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK95809

Modules/Macros

• ADB2ZZ   ADB2ZZAP ADB2ZZDS ADB2ZZMN ADB2ZZOT ADB2ZZPR ADB2ZZRS
  ADB2ZZSP ADB2ZZST ADB2ZZUT ADB2ZZVA ADB2ZZVB ADB2ZZV9
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK95809

     UP13/07/18 P F307

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.