IBM Support

JR38257: NICKNAME INDEX HAS NO STATISTICS WARNING IN SQL PLAN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Federation server will copy remote table's index and index
    statistics to local during nickname creation. The statistics
    information can be checked in local catalog table
    sysibm.indexes, but user will see "Index has no statistics"
    warning message in SQL plan.
    
    The warning message is similar to the following:
      EXP0022W  Index has no statistics.  The index
      "NICKNAME"."NICKNAME_IDX1" has not had runstats run
      on it.  This can lead to poor cardinality and
      predicate filtering estimates.
    
    DB2 issues this warning message because the "STATS_TIME" column
    of this index in table sysibm.indexes is NULL.
    

Local fix

  • 1) We can ignore this warning because the index statistics info
    will be used by optimizer.
    2) Run nnstat tool for this nickname.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Federation Server User                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Federation server will copy remote table's index and index   *
    *                                                              *
    * statistics to local during nickname creation. The statistics *
    *                                                              *
    * information can be checked in local catalog table            *
    *                                                              *
    * sysibm.indexes, but user will see "Index has no statistics"  *
    *                                                              *
    * warning message in SQL plan.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to federation server version 9.7.0.4                 *
    ****************************************************************
    

Problem conclusion

  • Fiexed in federation server v9.7 fp 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR38257

  • Reported component name

    WS FA UTILITIES

  • Reported component ID

    5724N9716

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-11-11

  • Closed date

    2011-05-13

  • Last modified date

    2011-05-13

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

    JR38255

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

Fix information

  • Fixed component name

    WS FA UTILITIES

  • Fixed component ID

    5724N9716

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Federated Server

Software version: 9.7

Reference #: JR38257

Modified date: 13 May 2011