Fixes are available
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:
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