DB2 - Problem description
Problem IT36104 | Status: Closed |
DB2ADVIS WILL THROW A SQL0901N ON A QUERY THAT IS ORDERED BY AN EXPRESSION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
The compiler stack may resemble the following: Compiler error stack for rc = -2144272209: sqlnn_cmpl[380] sqlno_exe[900] sqlno_planning_phase[200] sqlno_planning_scan[400] sqlno_scan_utils_qgm[200] sqlno_each_qur[400] sqlno_top_qtb[100] sqlno_each_opr[200] sqlno_walk_qun[100] sqlno_each_opr[200] sqlno_walk_qun[100] sqlno_each_opr[1100] sqlno_plan_qun[300] sqlno_crule_access[100] sqlno_advise_indexes[575] sqlno_advise_best_indexes[150] sqlno_advise_order_append[110] | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.03.2021 21.06.2021 28.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |