Fixes are available
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
DB2 might trap when the following conditions are met: 1. a complex query contains multiple CSEs 2. there are predicates on the CSEs 3. DERPRD_FF is not set for DB2COMPOPT Crash stack: Stack #1 Signal #11 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 __waitpid 6 sqlnq_prd::replace_in_prdpderchd 7 sqlnq_prd::reassign_prdpder 8 sqlnq_prd::drop 9 sqlnq_opr::drop 10 sqlnq_qtb::box_drop_ts 11 sqlnq_mch::merge 12 sqlnq_som::merge_clear_wins 13 sqlnr_form_common_subexprs 14 sqlnr_optprep_chunk1 15 sqlnr_optprep_chunk1_action 16 sqlnr_comp 17 sqlnr_seq 18 sqlnr_rcc 19 sqlnr_exe 20 sqlnn_cmpl 21 sqlnn_cmpl 22 sqlra_compile_var 23 sqlra_find_var 24 sqlra_get_var 25 sqlrr_prepare 26 sqljs_ddm_prpsqlstt 27 sqljsParseRdbAccessed 28 sqljsParse 29 sqljsSqlam 30 sqljsDrdaAsInnerDriver 31 sqljsDrdaAsDriver 32 sqeAgent::RunEDU 33 sqzEDUObj::EDUDriver 34 sqloEDUEntry 35 _L_lock_3599 36 clone
Local fix
- Use the following OPTGUIDELINES: /*<OPTGUIDELINES> <REGISTRY> <OPTION NAME='DB2COMPOPT' VALUE='NO_DERPRD_FF'/> </REGISTRY> </OPTGUIDELINES>*/ - Set the following: db2set -im DB2COMPOPT=NO_DERPRD_FF
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 4 Fixpack 4
Temporary fix
Comments
APAR Information
APAR number
IT22297
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
2017-09-07
Closed date
2018-11-27
Last modified date
2018-11-27
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:
04 May 2022