PI16003: PANEL ADB2ELIH 'UPDATE OPTIMIZER HINT' 'INVALID VALUE' WHEN ATTE MPTING TO SPECIFY 'ACCESS TYPE' VALUE OF 'O'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' panel ADB2ELIH 'Update
  Optimizer Hint' issues a message 'Invalid value' when an
  'Access type' of 'O' / 'By a work file scan, as a result of a
  subquery.' is specified.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the 'UH- Update optimizer    *
  *                      hint' line command to update an         *
  *                      optimizer hint on panel ADB2EL          *
  *                      'Rows from '>schema<.PLAN_TABLE',       *
  *                      then specifying an Access type          *
  *                      of 'O' on panel ADB2ELIH 'Update        *
  *                      Optimizer', DB2 Admin issues            *
  *                      an error ISPP195                        *
  *                                                              *
  *                      ISPP195 Invalid value - Enter one of    *
  *                      the listed values.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the 'UH- Update optimizer hint' line command
  to update an optimizer hint on panel ADB2EL 'Rows from
  '>schema<.PLAN_TABLE', then specifying an Access type
  of 'O' on panel ADB2ELIH 'Update Optimizer', DB2 Admin
  issues an error ISPP195:
  
  ISPP195 Invalid value - Enter one of the listed values.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI20543 UI20544

Modules/Macros

•    ADB2ELIH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20543

     UP14/08/20 P F408

• RB10 PSY UI20544

     UP14/08/20 P F408

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.