PI14287: PANEL ADB21K SQ OPTION GENERATES INCORRECT RESULTS WHEN INVOKED FROM PANEL ADB21P 14/03/26 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS function SQ on Panel
  ADB21K incorrectly generates message "No rows returned" when
  Panel ADB21K is invoked from Panel ADB21P
  

Local fix

• Invoke Panel ADB21K directly from Panel ADB21
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration and DB2      *
  *                 Object Comparison Tool for z/OS who use      *
  *                 the 'SQ - SQL in package' line command       *
  *                 to see SQL statements in a package.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The 'No rows returned' message is       *
  *                      incorrectly generated and displayed     *
  *                      on panel ADB21K 'Packages' when         *
  *                      invoking the 'SQ' line command          *
  *                      from panel ADB21P 'Application          *
  *                      Plans'.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program should be updated to make sure that line command 'SQ'
  on panel ADB21P can find the correct information for all the
  packages in this selected plan.
  

Problem conclusion

• Program has been updated to fix this problem.
  

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:

  UI17031

Modules/Macros

• ADB21P
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI17031

     UP14/04/16 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.