DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare scenarios, DB2 might give SQL0901N error message in 
function sqlnq_fixup_src_expr_for_ext_ind 
 
The problem happens when the following conditions are met: 
1. EXTENDED INDICATORS is turned on. 
2. The query is prepared and executed using JDBC 
3. The query is of type update/delete/insert on a view 
containing outer joins 
 
You will come across the following message from db2diag.log: 
 
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: 58 
 sqlerrmc: sqlnq_fixup_src_expr_for_e[125]:rc(     0) 
 sqlerrp : SQLNN067 
 sqlerrd : (1) 0x8031010C      (2) 0x0000010C      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFDA8      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
<StackTrace> 
sqlnn_cmpl[300] 
sqlnp_main[250] 
sqlnp_parser[510] 
sqlnp_smactn[100] 
sqlnq_sem_update[200] 
sqlnq_udi[154] 
sqlnq_fixup_src_expr_for_e[125] 
</StackTrace>

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 970 fix pack 9                        * 
****************************************************************

Disable EXTENDED INDICATORS. 
 
This can be done by passing in the new value through Properties 
as follows: 
String url = "jdbc:default:connection"; 
Properties prop = new Properties(); 
prop.put("enableExtendedIndicators", "2"); 
... 
try {       con = DriverManager.getConnection(url, prop); 
 
Impact of disabling EXTENDED INDICATORS: 
If you do not use any of the methods that are described in this 
following document, then you can safely disable Extended 
Indicators with no impact. 
http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db 
2z10.doc.java/src/tpc/imjcc_c0056853.htm

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
 

Please upgrade to DB2 version 970 fix pack 9

keiner bekannt / siehe Local-Fix

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

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

25.02.2013
06.01.2014
06.01.2014

9.0.,
9.7.0