Fixes are available
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Error is in the nnstat log file, simmilar to below text: An attempt to select all the nicknames failed. An error was returned when opening a cursor on syscat.taboptions. SQL1227N The catalog statistic "+1.00000000000000E-001" for column "HIGH2KEY" is out of range for its target column, has an invalid format, or is inconsistent in relation to some other statistic. Reason Code = "3". Planned for fp4.
Local fix
none. special build provided.
Problem summary
Users affected: Users of the DB2 for LUW Homogeneous Federation Feature or InfoSphere Federation Server Problem description and summary: See error description.
Problem conclusion
Problem was first fixed in Version 9.5, FixPak 4 (s090429). This fix should be applied on the federation server.
Temporary fix
Comments
APAR Information
APAR number
JR31448
Reported component name
WS FA UTILITIES
Reported component ID
5724N9716
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-15
Closed date
2009-05-30
Last modified date
2009-05-30
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
R950 PSN
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.5","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
30 May 2009