PH60775: INCORRECT SCHEMA AND SCHEMA ALIAS INFO IN EXPLAIN MAINTENANCE PANEL CAUSES ERRORS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect schema and schema alias info in EXPLAIN maintenance
  panel causes errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 Administration Tool for z/OS 13.1 users  *
  *                 who use the EXPLAIN tables                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an incorrect value is entered in   *
  *                      the Schema or Schema alias input        *
  *                      fields on panel ADB2EM1, no error       *
  *                      message is returned.                    *
  ****************************************************************
  This APAR addresses the following issues:
  - When the same value is specified in the Schema and Schema
    alias input fields, the primary command RUN on panel
    ADB2EM1 causes SQLCODE -601. This APAR adds the new message
    ADBE019E to warn about this incorrect value in the input
    field.
  - When the Schema and Schema alias input fields have
    the incorrect value for the EXPLAIN tables, the primary
    commands RUN and PREVIEW on panel ADB2EM1 result in message
    DSNA601I from the stored procedure ADMIN_EXPLAIN_MAINT. This
    APAR adds the new messages ADBE020E and ADBE021E for the
    incorrect value.
  
  Keywords: EXPLAIN, SQLCODE601N, MSGDSNA601I
  

Problem conclusion

• The 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:

  UI96564

Modules/Macros

• ADB2E    ADB2EM1  ADBE01   ADBE02   ADBEEM1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI96564

     UP24/04/23 P F404

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.