| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC99370 | Status: Closed |
NNSTAT() PROCEDURE MAY RETURN ERROR SQL1131N WHEN USED ON A NICKNAME WITH AN INDEX ON MANY COLUMNS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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 | |
| Problem Summary: | |
**************************************************************** * 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. * **************************************************************** | |
| Local Fix: | |
N/A | |
| available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Solution | |
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.02.2014 22.09.2014 22.09.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.4 |
|