DB2 FOR LUW / DB2FORLUW / A50 - DB2

On Windows, if you run the NNSTAT() procedure on a nickname 
which 
has an index on many columns, you may receive the following 
error : 
SQL1131N  A stored procedure process has been terminated 
abnormally. Routine name: "SYSPROC.NNSTAT". Specific name: 
"NNSTAT_EXTENDED".  SQLSTATE=38503 
 
 
 
Example : 
 
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,?); 
SQL1131N  A stored procedure process has been terminated 
abnormally. Routine name: "SYSPROC.NNSTAT". Specific name: 
"NNSTAT_EXTENDED".  SQLSTATE=38503

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW users on Windows using NNSTAT() procedure            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************

N/A

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.02.2014
22.09.2014
22.09.2014