IBM Support

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

Subscribe

You can track all active APARs for this component.

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



Document information

More support for: InfoSphere Federation Server
Federated Server

Software version: 9.7

Reference #: JR50016

Modified date: 10 November 2014