DB2 - Problem description
Problem IT25935 | Status: Closed |
FODC APPERR AFTER APPLYING FIXPACK10 ON V10.5 for queries against Created Global Temporary Tables | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Started getting FODC AppErr after apply fixpack10 of V10.5 for queries against Created Global Temporary Tables (CGTTs). In order to be exposed to this issue the query would also have to reference a routine (e.g. a User Defined Function). Symptoms for this APAR are similar to IT26828 but root cause is different. Sample db2diag.log entries : 2018-07-24-19.27.16.948849-300 E46077625E589 LEVEL: Severe PID : 8135 TID : 46982856880320 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : MYDB APPHDL : 0-4422 APPID: AUTHID : MYID HOSTNAME: myhost EDUID : 182 EDUNAME: db2agent (MYDB) 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:200 MESSAGE : ADM0001C A severe error has occurred. Examine the administration notification log and contact IBM Support if necessary. ... 2018-07-24-19.27.16.949581-300 I46078215E903 LEVEL: Severe PID : 8135 TID : 46982856880320 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : MYDB APPHDL : 0-4422 APPID: AUTHID : MYID HOSTNAME: myhost EDUID : 182 EDUNAME: db2agent (MYDB) 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 38 sqlerrmc: USERTEMP env doesn't match current app sqlerrp : SQLRA097 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFF9B6 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: =================================== stack in AppErr : FODC_AppErr_2018-07-24-19.19.15.469320_8125_326_000 .... 0x000000396980BE32 pthread_kill + 0x0032 (/lib64/libpthread.so.0) 0x00002AAAB0CEE5C2 sqloDumpEDU + 0x0052 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAFCBE269 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 0x0b39 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEE32706 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0a36 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAF4A9F9C address: 0x00002AAAAF4A9F9C ; dladdress: 0x00002AAAAAAD0000 ; offset in lib: 0x00000000049D9F9C ; (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAF4A9D78 _Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x01c8 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEE95144 sqlrrSqlCode + 0x0104 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEF6D1C3 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x1d03 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEE3A4E3 address: 0x00002AAAAEE3A4E3 ; dladdress: 0x00002AAAAAAD0000 ; offset in lib: 0x000000000436A4E3 ; (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEE36741 _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x01c1 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF8F81A _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x08ca (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB1C4B216 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x03c6 (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF7C1EC _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x036c (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF76779 address: 0x00002AAAADF76779 ; dladdress: 0x00002AAAAAAD0000 ; offset in lib: 0x00000000034A6779 ; (/home/db2insp1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF761B9 _Z19sqljsDrdaAsSPDriverP14db2UCconHandleP17SQLCC_COMHANDLE_TPPhl + 0x0489 .... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 11 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT27702 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.08.2018 25.02.2020 25.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |