|
Problem IC84127
|
Status: Closed |
QUERY REFERENCING A TABLE CONTAINING A GENERATED COLUMN MIGHT PRODUCE A -901 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fixpack 1 *
**************************************************************** |
| Local Fix: |
Create another MQT which references the generated column in the
select list. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 Version 10.1 Fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.06.2012
28.03.2013
28.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
