IBM Support

PI28906: 'NO ROWS FOUND' MSG RETURNED PANEL ADB23 MORE THAN 1 TB.

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 z/OS V11 CM, AdminTool 11.1 - The performance query on panel
ADB23 option 10 "Table spaces containing more than one table"
returns no rows found even we have tablespace with more than
one table.

Local fix

  • n/a

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of the DB2 Administration Tool for     *
*                 z/OS who use option '10 Table spaces         *
*                 containing more than one table' on ADB23     *
*                 'DB2 Performance Queries' panel.             *
****************************************************************
* PROBLEM DESCRIPTION: When using option 10 'Table spaces      *
*                      containing more than one table' on      *
*                      panel ADB23 'DB2 Performance Queries',  *
*                      DB2 Admin returns 'No rows found' /     *
*                      'ADB262I No rows were fetched,          *
*                      SQL code=  100' error message even      *
*                      if the user has a table space with      *
*                      more than one table.                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When using option 10 'Table spaces containing more than one
table' on panel ADB23 'DB2 Performance Queries', DB2 Admin
returns 'No rows found' / 'ADB262I No rows were fetched,
SQL code= 100' error message even if the user has a table space
with more than one table.

Problem conclusion

  • Problem has been resolved.

Temporary fix

  •

Comments

  •

APAR Information

  • APAR number

    PI28906

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-11-04

  • Closed date

    2015-01-15

  • Last modified date

    2015-02-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI24422 UI24423

Modules/Macros

  •    ADB23    ADB2310

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA20 PSY UI24422

       UP15/01/18 P F501

  • RB10 PSY UI24423

       UP15/01/18 P F501

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 March 2021

Page Feedback