JR46839: DB2FMP CRASHES WHEN RUNNING NNSTAT FOR A NICKNAME THAT HAS AN INDEX CONTAINS TOO MANY COLUMNS

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• NNSAT causes procedure fmp process terminated abnormally in turn
  returns -1131 error:
  
  call sysproc.nnstat('SERVERNAME','SCHEMA','NICKNAME',NULL,
  NULL,1,NULL,?)
  
  SQL1131N  A stored procedure process has been terminated
  abnormally. Routine name: "SYSPROC.NNSTAT". Specific name:
  "NNSTAT_EXTENDED".  SQLSTATE=38503
  
  The problem only happens on a Windows box. The problem usually
  happens when running NNSTAT for a nickname that has an index
  contains too many columns.
  
  Steps to recreate the error:
  
  SET PASSTHRU SERV1 ;
  DROP TABLE TESTTABLE;
  create table TESTTABLE(c1 varchar(10),c2 varchar(10),...,c20
  varchar(10));
  CREATE INDEX TESTINDEX ON
  TESTTABLE(C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,c13,c14);
  SET PASSTHRU RESET;
  CREATE NICKNAME NICK1 for "SERV1"."DB2INST1"."TESTTABLE";
  call sysproc.nnstat('SERV1','DB2INST1','NICK1',NULL,
  NULL,1,NULL,?);
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The user is running NNSTAT on V10.1.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Federation Server v10.1 fp3.                      *
  ****************************************************************
  

Problem conclusion

• The problem was firstly fixed on Federation Server v10.1 fp3.
  

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:

Fix information

• Fixed component name

  WS FA UTILITIES

• Fixed component ID

  5724N9716

Applicable component levels

• RA10 PSY

     UP