JR45496: RUN NNSTAT FAILED WITH THE ERROR SQL1227N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • User run NNSTAT failed with the following error
    
    db2 call
    sysproc.nnstat('server','schema','nickname','NULL','NULL',2,'nns
    tat.log::DIAG',?)
    
    Error messages:
    SQL1227N The catalog statistic "NULL" for column "LOW2KEY" is
    out of
    range for its target column, has an invalid format, or is
    inconsistent
    in relation to some other statistic. Reason Code = "3".
    
    or
    
    SQL1227N The catalog statistic "NULL" 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".
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users whose federation server turned on Oracle compatibility *
    * will see this problem.                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server v9.7 fixpack 9 which first fix  *
    * this problem.                                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR45496

  • Reported component name

    ORACLE WRAPPER

  • Reported component ID

    5724N9708

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-22

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95214 JR48044 JR48045

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Federation Server
Data Sources and Wrappers - Oracle

Software version:

970

Reference #:

JR45496

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation