Knowledge Collection: InfoSphere Federation Server NNSTAT issues

Technote (FAQ)


Question

This Knowledge Collection is a focused compilation of links to online information and resources related to the NNSTAT issues for InfoSphere Federation Server.

Answer

InfoSphere Federation Server NNSTAT information:

[Information Center version v820] Nickname statistics update facility - overview
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.ii.doc/admin/cfpsts01.htm

[Information Center version v820] Retrieving nickname statistics
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.ii.doc/admin/tfpsts03.htm


[Information Center version 910] Updating nickname statistics
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.websphere.ii.db2udb.nav.doc/navcontainers/iiypnavc_update_stats.html

[Information Center version 910] Retrieving nickname statistics
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.websphere.ii.federation.query.doc/administering/tfpsts03.htm

[Information Center version 950] Updating nickname statistics
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.fed.query.doc/topics/iiyvfed_update_stats.html

[Information Center version 950] Retrieving nickname statistics
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.fed.query.doc/topics/tfpsts03.html

[Infosphere Federation Server support webpage NNSTAT] search results:
http://www-01.ibm.com/support/search.wss?rs=3551&tc=SS2K5T&q=nnstat

[Whitepaper] Performance enhancements in IBM WebSphere Federation Server V9.1, Part 1: Improve performance of federated queries with new WebSphere Federation Server capabilities
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612englert/


[Technotes]

[1264509] NNSTAT returns error after applying a fix pack
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg21264509

[1299148] HIGH2KEY and LOW2KEY statistics are not collected for some DB2 nickname columns
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg21299148


[APARs v820]

[1180871] WebSphere® Information Integrator: nickname statistics utility log file not created (UNIX)
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg21180871

[JR22348] NICKNAME CREATED BY NNSTAT IS NOT DROPPED AFTER NNSTAT FINISHES
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR22348

[JR22381] NICKNAME CREATION FAILS DUE TO HIGH2KEY AND LOW2KEY VALUES.
http://www-01.ibm.com/support/docview.wss?rs=3551&context=SS2K5Tt&uid=swg1JR22381

[JR22986] NNSTAT ERRORS -1227 OR -138 WITH NULL OR BLANK HIGH2KEY OR LOW2KEY COLUMN STATISTIC
http://www-01.ibm.com/support/docview.wss?rs=3551&context=SS2K5T&uid=swg1JR22986

[JR23180] THE NNSTAT STORED PROCEDURE HANGS WHEN COLLECTING STATISTICS
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23180

[JR23198] SYSPROC.NNSTAT() DOESN'T HANDLE A DEADLOCK SITUATION PROPERLY
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23198

[JR23301] NNSTAT DOES NOT INSERT A ROW FOR EACH NICKNAME PROCESSED IN SYSPROC.FED_STATS WHEN USING 'NULL' FOR NICKNAME
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23301

[JR23603] NET8 WRAPPER:NICKNAME IS NOT CREATED CORRECTORY WHEN FEDERATED INDEX USING DOUBLE BYTES CHARACTER FOR INDEX NAME .
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23603

[JR23642] CANNOT CREATE NICKNAME CORRECTLY IF REMOTE INDEX/SCHEMA NAME > 18 BYTES.
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23642

[JR23842] NNSTAT HANGS WHEN COLLECTING HIGH2KEY AND LOW2KEY VALUES.
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR23842

[JR25304] SQL1227N EXECUTING SYSPROC.NNSTAT ON NICKNAMES
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR25304

[JR27002] NNSTAT OF DB2 V8 CAN NOT GET REMOTE TABLE STATISTIC WHEN THE TABLE HAS INDEX (OR PRIMARY KEY).
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR27002

[JR28835] HIGH2KEY AND LOW2KEY ARE TRUNCATED IN DB2 FOR LUW NICKNAMES ON DB2 FOR Z/OS TABLES WITH DECIMAL(14) OR LARGER COLUMNS
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR28835

IY92549: SQL0811N ERROR MAY RESULT FROM RUNNING NNSTAT AGAINST ORACLE NICKNAMES
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1IY92549


[APARs v910/v950]

[JR31449- v910] NNSTAT FAILED WITH ERROR SQL1227N REASON CODE 3
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR31449

[JR31448- v950] NNSTAT FAILED WITH ERROR SQL1227N REASON CODE 3
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR31448

[JR31454 - v950] WHEN COLUMNS OBJECT SPECIFIED IN THE PARAMETER OF NNSTAT, ALL THE OTHER COLUMNS' COLCARD ARE SET TO -1
http://www-01.ibm.com/support/docview.wss?rs=3551&uid=swg1JR31454



Definition of a Knowledge Collection
A Knowledge Collection is a focused compilation of links to documents that share a common theme. Knowledge Collections are navigation aids that organize content to help users quickly find relevant information. Knowledge Collections are not designed to be an all-inclusive list of all documents dealing with the specific theme.

Related information

Collecting Data

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Federation Server
Utilities - NNSTAT

Software version:

9.1, 9.1.1, 9.1.1.2, 9.5

Operating system(s):

AIX, HP-UX, Linux, Linux Red Hat - zSeries, Linux SUSE - zSeries, Solaris, Windows

Software edition:

All Editions

Reference #:

1366395

Modified date:

2009-07-31

Translate my page

Machine Translation

Content navigation