IBM Support

IC78220: DB2TOOL -TW TNAME CAN FIND NO MATCHING TABLES, BUT CAN GENERATE RELATED OBJECTS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • The db2tool -tw tools may incorrectly generate output for views
    which happen to have dependant objects that meet the value
    passed in.  However these object are not tables.
    
    There is possibility to reproduce issue. The issue can be seen
    on then sample database.
    
    db2look -d sample -e -tw v%
    
    produces:
    
    ...
    ...
    -- There are no tables with names that match the pattern
    criteria
    ...
    ...
    -- DDL Statements for Views
    ...
    ...
    
    CREATE VIEW VFORPLA (PROJNO, PROJNAME, RESPEMP, PROJDEP,
    FRSTINIT, MIDINIT, LASTNAME) AS SELECT ALL F1.PROJNO, PROJNAME,
    RESPEMP, PROJDEP, SUBSTR(FIRSTNME,  1,  1),  MIDINIT,  LASTNAME
    FROM VPROJRE1 F1 LEFT OUTER JOIN EMPPROJACT F2 ON F1.PROJNO =
    F2.PROJNO;
    ...
    ...
    
    The object VPROJRE1 is actually a view and NOT a table.  The
    tool prints related object because of association with views
    that fit filter criteria.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * See Error Description                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * See Error Description                                        *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC78220

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-19

  • Closed date

    2012-11-06

  • Last modified date

    2012-11-06

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

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

    IC87907

Fix information

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78220

Modified date: 06 November 2012