IBM Support

JR38256: 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

  • User affected:
     Users of Federation Server who use SQL PLAN
    Problem Descripion and Summary:
     See error description.
    

Problem conclusion

  • Problem was first fixed in V91fp11. This fix should be applied
    Federation Server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR38256

  • Reported component name

    WS FA UTILITIES

  • Reported component ID

    5724N9716

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-11-11

  • Closed date

    2011-12-18

  • Last modified date

    2011-12-18

  • 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

  • R910 PSY

       UP

  • R911 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
18 December 2011