PH50662: WHEN SORT COMMAND IS USED IN THE "EDIT/RUN SQL STATEMENT" HELP PANEL ADBHSORT LISTS COMMAND THAT IT SHOULDN'T

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the "Edit/Run SQL Statement" function path is used, panel
  ADB2SORT restricts the command options "SAVE DELETE PROMOTE
  PROMALL". This is by design. However, the associate HELP panel
  ADBHSORT still shows the commands as being valid when it
  shouldn't
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      Help panel ADBHSORT (Sort fields)       *
  *                      includes incorrect information.         *
  *                                                              *
  *                      Issue 2:                                *
  *                      When the "Edit/Run SQL Statement"       *
  *                      option is used, the SORT command        *
  *                      erroneously displays command            *
  *                      options on panel ADB2SORT.              *
  *                                                              *
  *                      Issue 3:                                *
  *                      The command options PROMPT and          *
  *                      PROMALL are inadvertently displayed     *
  *                      on the SORT panel.                      *
  *                                                              *
  *                      Issue 4:                                *
  *                      Reverse video occurs on panel ADB21.    *
  ****************************************************************
  Issue 1:
  By design, panel ADB2SORT restricts the command options
  SAVE, DELETE, PROMOTE, and PROMALL when the
  "Edit/Run SQL Statement" option is used. However, the
  associated help panel, ADBHSORT, still includes information
  about these commands. That information should not be
  included in this context.
  
  Issue 2:
  When the "Show the DB2 Admin action bar" option is enabled
  on panel ADBPPDO 'Panel Display Options', sort panel
  ADB2SORT includes the command options SAVE, DELETE,
  PROMOTE, and PROMAL when those options should be
  hidden, specifically when using the "Edit/Run SQL Statement"
  option.
  
  Issue 3:
  When the "Edit/Run SQL Statement" option is used, the
  command options PROMPT and PROMALL are inadvertently
  displayed on sort panel ADB2SORT.
  
  Issue 4:
  When the value of the "DB2 SQL ID" field on panel ADB21 is
  not the user ID, reverse video highlight of the field extends
  to the next line.
  

Problem conclusion

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

  UI90751 UI90752

Modules/Macros

• ADB21    ADB27C0  ADB2DF   ADB2GEN  ADB2GENB ADB2SORT ADBEDIA1
  ADBEDIAG ADBHSORT ADBPDIA1 ADBPDIAG ADBSCMDL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI90751

     UP23/03/01 P F302

• RD10 PSY UI90752

     UP23/03/01 P F302

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.