A fix is available
APAR status
Closed as program error.
Error description
You may receive SQL1227 with message "THE CATALOG STATISTIC "xxxxx" FOR COLUMN "FIRSTKEYCARD" IS OUT OF RANGE FOR ITS TARGET COLUMN" when using NNSTAT to update the nickname with an index. The reason for the problem is that the remote table card is lower than the first key card or the full key card of index on this table. You can found possible abnormal information in the nnstat log after adding ::DIAG when calling NNSTAT For example: Suppose FIRSTKEYCARD and FULLKEYCARD is 1000 and TBALE CARD is 500 The information of two temp table, you can find fullkeycard=tablecard<firstkeycard Session.NNSTAT_Tables ----schema----nickname----card----fpages----npages---overflow--- - DB2INST1 | N1 | 500 | -1 | -1 | -1 Session.NNSTAT_Indexes ----tabschema----tabname----indschema----indname----nleaf----nle vels---clusterratio----clusterfactor---firstkeycard---fullkeycar d--- DB2INST1 | N1 | DB2INST1 | IND1 | 50 | -1 | -1 | 0 | 1000 | 500
Local fix
Check if the remote statictis are correct specially for table card , fistkeycard and fullkeycard.
Problem summary
**************************************************************** * USERS AFFECTED: * * User who use NNSTAT to update the statistics of a nickname * * with indexes * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v9.7fp10 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR50016
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
2014-04-17
Closed date
2014-11-10
Last modified date
2014-11-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
JR50019 IT01155
Fix information
Fixed component name
WS FA UTILITIES
Fixed component ID
5724N9716
Applicable component levels
R970 PSN
UP
R970 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.7","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 November 2014