IBM Support

PI06723: TABLE NOT FOUND OR COLUMNS NOT FOUND WHEN CREATING AN INDEX FOR THE TABLE WHOSE NAME AND SCHEMA HAVE BEEN ALTERED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Table not found or columns not found when creating an index for
    the table whose name and schema have been altered.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: When the ADB200E 'Table not found'      *
    *                      message is issued on panel ADB21XAR     *
    *                      'Create Index' via the CREATE INDEX     *
    *                      path, the value that follows the 'ON'   *
    *                      clause is blank on the panel.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the ADB200E  'Table not found' message is issued on panel
    ADB21XAR 'Index' via the CREATE INDEX path, the value that
    follows the 'ON' clause is blank on the panel.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI06723

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-22

  • Closed date

    2013-12-11

  • Last modified date

    2014-01-02

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

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

    UI13440

Modules/Macros

  • ADB21XAR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UI13440

       UP13/12/13 P F312

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 January 2014