Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC79077 Status: Closed

QUERY REFERENCING A TABLE CONTAINING A GENERATED COLUMN MIGHT PRODUCE A
-901

product:
DB2 FOR LUW / DB2FORLUW / 950 - 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:                                              * 
* problem fixed in DB2 V9.5 Fixpack 9                          * 
****************************************************************
Local Fix:
Create another MQT which references the generated column in the 
select list.
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC79679 IC84127 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.10.2011
26.04.2012
26.04.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.