DB2 FOR LUW / DB2FORLUW / 950 - DB2

Under rare scenarios, DB2 might produce a SQL0901N if the 
following conditions are true: 
 
- The query references a table with one or more generated 
  columns 
- The same table is part of one or more MQTs 
- The generated column(s) are not referenced in the MQT 
 
In the db2diag.log, the issue appears as 
 
20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxx      LEVEL: Severe 
PID     : xxxxx                TID  : xxxxxxxxxxxx PROC : 
db2sysc 1 
INSTANCE: xxxxxxxx             NODE : 001          DB   : xxxxxx 
APPHDL  : 1-5889               APPID: 
xx.xxx.xxx.xxx.xxxxx.xxxxxxxxxx 
AUTHID  : xxxxxx 
EDUID   : 93402                EDUNAME: db2agent (xxxxxx) 1 
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: 30 
 sqlerrmc: Bad Plan; Unresolved QNC found 
 sqlerrp : SQLNG032 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x000000B9      (5) 0xFFFFFC1E      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
 
<dumping into FODC> 
 
20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxxx     LEVEL: Info 
(Origin) 
PID     : xxxxx                TID  : xxxxxxxxxxxx PROC : 
db2sysc 1 
INSTANCE: xxxxxxxx             NODE : 001          DB   : xxxxxx 
APPHDL  : 1-5889               APPID: 
xx.xxx.xxx.xxx.xxxxx.xxxxxxxxxx 
AUTHID  : xxxxxx 
EDUID   : 93402                EDUNAME: db2agent (xxxxxx) 1 
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650 
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : String, 723 bytes 
Compiler error stack for rc = -2145779603: 
sqlnn_cmpl[420] 
sqlng_main[2790] 
sqlng_main[1656] 
sqlng_build_thread[10] 
sqlng_process_return_op[50] 
sqlng_process_pipe_op[30] 
sqlng_process_mate_op[1735] 
sqlng_process_TQ_op[30] 
sqlng_build_thread[40] 
sqlng_scan_derived_table[40] 
sqlng_build_thread[10] 
sqlng_process_sort_op[20] 
sqlng_process_nljn_op[50] 
sqlng_build_thread[10] 
sqlng_process_hsjn_op[60] 
sqlng_build_thread[10] 
sqlng_process_nljn_op[50] 
sqlng_build_thread[10] 
sqlng_process_TQ_op[30] 
sqlng_build_thread[40] 
sqlng_process_nljn_op[140] 
sqlng_build_thread[10] 
sqlng_process_f_iscan[110] 
sqlng_build_TA_op[110] 
sqlng_build_thread[100] 
sqlng_walk_BF_chain[25] 
sqlng_process_BF_node[20] 
sqlng_process_parse_tree_n[994] 
 
<followed by ADM5570W>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* problem fixed in DB2 V9.5 Fixpack 9                          * 
****************************************************************

Create another MQT which references the generated column in the 
select list.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

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

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

05.10.2011
26.04.2012
26.04.2012

9.5.FP9