DB2 - Problem description
Problem IT01466 | Status: Closed |
TRAP ERROR IN FUNCTION SQLRXCON_SIMPLE WHILE DO INSERT INTO TEMP TABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Trap file : -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FFFF00A5DBA _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x020a 0x00007FFFF00A5B4B ossDumpStackTraceV98 + 0x002b 0x00007FFFF00A0A73 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x0103 0x00007FFFF3939BC7 sqlo_trce + 0x0407 0x00007FFFF3984DB7 sqloEDUCodeTrapHandler + 0x0277 0x00007FFFF7BCF500 address: 0x00007FFFF7BCF500 ; dladdress: 0x00007FFFF7BC0000 ; offset in lib: 0x000000000000F500 ; 0x0000000000426B10 __intel_ssse3_rep_memcpy + 0x2740 0x000000000041DA56 _intel_fast_memcpy.P + 0x0006 0x00007FFFF15654B2 _Z15sqlrxcon_simpleP8SQLRXNLSP10sqlz_valueS2_ + 0x0062 0x00007FFFF2427F15 _Z23sqlriPDGroupSaveNextRowP8sqlrr_cbP21sqlriPushdownGroupObj + 0x0045 0x00007FFFF481674C _Z8sqlriag2P8sqlrr_cb + 0x043c 0x00007FFFF2428A58 _Z19sqlriExecSargThreadP8sqlrr_cbP12sqlri_opparm + 0x0038 0x00007FFFF242892C _Z30sqlriPDGroupInvokePostPDThreadP8sqlrr_cbP21sqlriPushdownGrou pObjPi + 0x003c 0x00007FFFF242846C _Z8sqlriag1P8sqlrr_cb + 0x011c 0x00007FFFF246881D _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm + 0x007d 0x00007FFFF249B108 _Z21sqlri_handle_slowtempP8sqlrr_cbP9sqlri_taoP10sqlri_evlo + 0x0048 0x00007FFFF4830A9C _Z7sqlritaP8sqlrr_cb + 0x05dc | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 Fix Pack 5. * **************************************************************** | |
Local Fix: | |
The workaround is to turn off pushdown feature, but that can cause some performance impact: db2set DB2_TCG_DEFAULT_OPTIONS="set disable_pushdown on". | |
Solution | |
First fixed in Version 10.1 Fix Pack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.04.2014 27.07.2015 27.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |