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
.... |
