DB2 FOR LUW / DB2FORLUW / 970 - DB2

"CREATE INDEX XXXX ON YYY EXTEND USING ZZZ" fails with SQL0901N 
"Invalid language type (in dec): 15." 
 
For eg: 
 
CREATE INDEX POL.ENCRYPTEDINDEX ON POL.POL_PAYMENT(BILL_ACCTNUM) 
EXTEND USING ENCSTRINGINDEX 
SQL0901N The SQL statement failed because of a non-severe system 
error.Subsequent SQL statements can be processed.  (Reason 
"Invalid language type (in dec): 15.".)  SQLSTATE=58004 
 
 
 
The db2diag shows: 
 
2010-04-16-09.57.39.203000+120 I175738H878        LEVEL: Severe 
PID     : 4672                 TID  : 6028        PROC : 
db2syscs.exe 
INSTANCE: DB2_03               NODE : 000         DB   : SAMPLE 
APPHDL  : 0-34                 APPID: *LOCAL.DB2_03.100416075741 
AUTHID  : L122851 
EDUID   : 6028                 EDUNAME: db2agent (SAMPLE) 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: 35 
 sqlerrmc: Invalid language type (in dec): 15. 
 sqlerrp : SQLNG082 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFF937      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:

**************************************************************** 
* USERS AFFECTED:                                              * 
* All User below V9.7 FP3                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INDEX EXTENSION IN SQL GENERATES SQL0901N.                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to product DB2 V9.7 FP3                              * 
****************************************************************

N/A

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V9.7 FP3

n/a

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

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

03.05.2010
20.01.2011
20.01.2011

9.7.FP3