JR50016: NNSTAT ERROR SQL1227N:THE CATALOG STATISTIC "XXXXX" FOR COLUMN "FIRSTKEYCARD" IS OUT OF RANGE FOR ITS TARGET COLUMN

DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

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