PI17238: DB2 ADMINISTRATION TOOL FOR Z/OS IS MISSING OWNER PREDICATE WHEN DISPLAYING STORED PROCEDURES ON PANEL ADB21O

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS is missing owner predicate
  when displaying Stored Procedures on Panel ADB21O
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who specify the name and owner field    *
  *                 on panel ADB21 'System Catalog', select      *
  *                 the 'H - Schemas' option on panel ADB21      *
  *                 to list all schemas, then specify the 'O -   *
  *                 Stored procedure' line command on panel      *
  *                 ADB21H 'Schemas', to see all stored          *
  *                 procedures on panel ADB21O 'Stored           *
  *                 Procedures'.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS does   *
  *                      not use the owner predicate specified   *
  *                      in the 'OWNER' field of panel ADB21     *
  *                      'System Catalog'.                       *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      From panel ADB21, the user specifies    *
  *                      both the "Name" and the "OWNER"         *
  *                      fields, selects option 'H - Schema',    *
  *                      and on panel ADB21H 'Schemas' the       *
  *                      correct number of procedures are        *
  *                      displayed that meet the filtering       *
  *                      criteria.  However, when entering       *
  *                      the 'O' line command on the panel,      *
  *                      it returns the procedures without       *
  *                      the OWNER filter.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When entering the 'O - Stored procedure' line command on panel
  ADB21H, the owner predicate is not processed correctly and
  causes the wrong stored procedures to be listed.
  

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:

  UI19180 UI19181

Modules/Macros

•    ADB21    ADB21H
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19180

     UP14/06/28 P F406

• RB10 PSY UI19181

     UP14/06/28 P F406

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.