Fixes are available
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 number
JR46839
Reported component name
WS FA UTILITIES
Reported component ID
5724N9716
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-06-05
Closed date
2013-10-03
Last modified date
2013-10-03
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 October 2013