DB2 FOR LUW / DB2FORLUW / 950 - DB2

The following error was logged in db2dial.log and a dump file 
was generated while running nnstat. 
 
2012-03-19-03.23.56.773360+540 I232756A623        LEVEL: Severe 
PID     : 27239                TID  : 2199216187728PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000         DB   : DBNAME 
APPHDL  : 0-5831               APPID: 
*LOCAL.db2inst1.120318182101 
AUTHID  : DB2INST1 
EDUID   : 8734                 EDUNAME: db2agent (DBNAME) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:275 
MESSAGE : MASTER TIME INFO 
DATA #1 : Hexdump, 32 bytes 
0x000002053D88C080 : 0000 0000 4F65 EA76 0220 0000 0008 4DEE 
....Oe.v. ....M. 
0x000002053D88C090 : C949 CB68 B58F 4107 0000 0000 0000 0000 
.I.h..A......... 
 
2012-03-19-03.23.56.773469+540 I233380A243        LEVEL: Severe 
PID:27239 TID:2199216187728 NODE:000 Title: MASTER TIME INFO 
Dump 
File:/home/db2inst1/sqllib/db2dump/FODC_AppErr_2012-03-19-03.23. 
56.770865_27239_8734_000/27239.8734.000.dump.bin 
 
2012-03-19-03.23.56.773628+540 I233624A847        LEVEL: Severe 
PID     : 27239                TID  : 2199216187728PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000         DB   : DBNAME 
APPHDL  : 0-5831               APPID: 
*LOCAL.db2inst1.120318182101 
AUTHID  : DB2INST1 
EDUID   : 8734                 EDUNAME: db2agent (DBNAME) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 22 
 sqlerrmc: invalid index colnames 
 sqlerrp : SQLRL13D 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFF22      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
 
The -901 error may also occur with the following error message 
returned when user creates a nickname: 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "invalid index colnames".)  SQLSTATE=58004 
 
This is an error raised when there is a remote table which has 
an index defined on lots of columns involved in NNSTAT operation 
or nickname creation. 
 
This error results from a limit on sum of the length of a 
nickname index columns, which is 640-bytes.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v95fp10                                           * 
****************************************************************

Drop the index that has lots of columns on the remote table

v95fp10, the limitation on internal index name length is lifted.

Drop the index that has lots of columns on the remote table

Vorgänger  : APAR is sysrouted TO one or more of the following: IC82547 
Nachfolger : 

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

06.04.2012
08.05.2012
08.05.2012

9.5.FP10