DB2 - Problem description
Problem IT34250 | Status: Closed |
901/TRAP WHEN DB2 QUERY HAS GROUP BY AND OJ WITH UNION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Db2 query may generate 901/trap when the following conditions are met: - there is an Outer Join - a UNION is referenced in the Null Producing side of Outer Join - there is a Group By above UNION - the Tuple Preserving side of Outer Join is smaller than Null Producing Side Similar messages can be seen in the db2diag.log sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 20 sqlerrmc: columnZval not found -- sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 24 sqlerrmc: qncData.doptqncp is null --- sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 41 sqlerrmc: Order cols removed from sort output cols. -- sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 21 sqlerrmc: Found zero CLOB.reset ---- | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Use of one of the following setting either in instance level or with optguidelines: DB2COMPOPT=NO_GBPU or DB2_EXTENDED_OPTIMIZATION='GBPU_EXT OFF' | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.09.2020 15.03.2021 15.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |