|
Problem IC75053
|
Status: Closed |
A QUERY REFERENCING A REPLICATED MQT MIGHT FAIL WITH A SQL0901N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Description:
A query might fail with a SQL0901N error code if the following
are true:
1. The MQT definition is simply a select from one base table or
multiple base tables joined together
2. The user has enforced replicate MQT through either one of :
i. optguidelines
ii. DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE
In the db2diag.log an error message such as the following may be
seen:
2011-02-02-00.37.29.943200-300 E671418998E802 LEVEL: Info
(Origin)
PID : 28374 TID : 47901128517952PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB : SAMPLE
APPHDL : 1-57167 APPID:
10.139.25.214.32786.11030715355
AUTHID : DB2INST1
EDUID : 5407 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
"unexpected error but state is OK"
DATA #1 : String, 257 bytes
Compiler error stack for rc = -2144272209:
sqlnn_cmpl[370]
sqlnr_exe[1200]
sqlnr_rcc[100]
sqlnr_seq[100]
sqlnr_comp[110]
sqlnr_optprep_action[100]
sqlnr_optprep[2240]
sqlnr_compute_matchinfo[600]
sqlnq_som::compute_matchin[360]
sqlnq_mch::cleanUpForOpt[50] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query that has an MQT definition as a select from one base *
* table or multiple base tables joined together and where the *
* user has enforced replicate MQT through optguidelines or *
* DB2_EXTENDED_OPTIMIZATION=FORCE_REPLICATED_MQT_MERGE may *
* result in a SQL0901N error. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
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
|
| Solution |
First fixed in Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.03.2011
03.01.2012
03.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
