Fixes are available
APAR status
Closed as program error.
Error description
SQL901N or trap might occur when running queries containing outer joins and inner joins Users might observe SQL901N or trap when running a query with the following characteristics: 1. there are 2 or more cascaded outer joins 2. the lower outer joins are at the row preserving side of the upper outer joins 3. the null producing side of a lower outer join and the null producing side of a higher outer join reference the same base table 4. there are base tables inner joined with the cascaded outer joins Reason codes shown can be a) SQL0901N The SQL statement or command failed because of a database system error. (Reason "Parent entity not provided".) SQLSTATE=58004 Similar compiler Stack: Compiler error stack for rc = -2144272209: sqlnn_cmpl[370] sqlnr_exe[1140] sqlnq_pdb_analysis[40] sqlnq_qtb::identify_depend[40] sqlnq_qtb::identify_depend[40] sqlnq_qtb::identify_depend[40] sqlnq_qtb::identify_depend[40] sqlnq_qtb::identify_depend[40] sqlnq_qtb::identify_depend[30] sqlnq_record_dependency[20] sqlnq_qunordaftchild::reli[10] b) If using optimization level 0 or 1 SQL0901N The SQL statement or command failed because of a database system error. (Reason "Found zero CLOB.reset".) SQLSTATE=58004
Local fix
Disable Semi-join feature: db2set -im DB2COMPOPT=NOOJSJ (to disable this feature for the whole instance) or attach the guideline shown below at the end of the problematic query to only disable this feature for the query: /*<OPTGUIDELINES> <REGISTRY> <OPTION NAME='DB2COMPOPT' VALUE='NOOJSJ'/> </REGISTRY> </OPTGUIDELINES>*/
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1 Mod 4 Fix Pack 6 * ****************************************************************
Problem conclusion
Problem was first fixed in DB2 Version 11.1 Mod 4 Fix Pack 6
Temporary fix
See LOCAL FIX
Comments
APAR Information
APAR number
IT25969
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-08-14
Closed date
2020-05-04
Last modified date
2020-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022