Fixes are available
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
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 crashed with a signal #11 trap while recompiling a query with the APREUSE bind option set. In this case the option was set automatically by the rebind daemon, but this scenario is also possible when the rebind is initiated by a user. Stack traceback excerpt: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAB9085686 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB90852CB ossDumpStackTraceV98 + 0x002b (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB9081477 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB18E6B37 sqlo_trce + 0x03c7 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB1A4CE6C sqloEDUCodeTrapHandler + 0x03ac (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x0000003CD800F7E0 address: 0x0000003CD800F7E0 ; dladdress: 0x0000003CD8000000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x00002AAAB0D6B4AB _Z19sqlno_hint_validateP13sqlno_globalsP19sqlno_plan_operatorP10 sqlno_hintP9sqlno_qtbP13SQLNN_BOOLEAN + 0x041b (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0B67AFE _Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno _setP14sqlno_planlistP10sqlno_hint + 0x189e (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0B713F9 _Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno _setP14sqlno_planlist + 0x0009 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0B6AE92 _Z18sqlno_crule_accessP13sqlno_globalsP9sqlno_qtbP18sqlno_join_c ontext9sqlno_setS5_S5_S5_S5_13SQLNN_BOOLEANS5_PS6_ + 0x0272 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0CEA487 _Z14sqlno_plan_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_ qun + 0x1217 (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0CF8C4F _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ opr + 0x09bf (/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1) ...
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1.1.2.2 * ****************************************************************
Problem conclusion
First fixed in DB2 Version 11.1.1.2.2
Temporary fix
Comments
APAR Information
APAR number
IT20126
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-04-07
Closed date
2017-06-23
Last modified date
2017-06-23
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
Document Information
Modified date:
03 May 2022