DB2 - Problem description
Problem IT19186 | Status: Closed |
DB2MQ.MQRECEIVEALL TRAPS RESULTING IN AN SQL0430N ERROR. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When using the DB2MQ.MQRECEIVEALL (non-federated) routine with KEEPFENCED=YES, it can intermittently trap/abend producing an SQL0430N error. With coredump enabled we can see the following functions in its stack: Segmentation fault in iconv at line 845 in file "" ($t1) could not read "../../../../../../../src/bos/usr/ccs/lib/libiconv/iconv.c" (dbx) where iconv(cd = 0x0000000110286eb0, inbuf = 0x0fffffffffff80c0, inbytesleft = 0x0fffffffffff80c8, outbuf = 0x0fffffffffff80b8, outbytesleft = 0x0fffffffffff80d0), line 845 in "iconv.c" xcsConvertString() at 0x900000000de18c8 vxtConvertCharsFn() at 0x900000000f646b4 vwb_rf_header_2() at 0x900000000f4d6cc vwaConvert() at 0x900000000f4b7d4 vpiConvertData() at 0x900000000f41e58 amqzsta0.zstMQGET() at 0x9000000011c6234 MQGET_Server_Call() at 0x9000000012549f0 zswMQGET_Call() at 0x900000001264c2c MQGET() at 0x900000000485c60 amMQGET() at 0x900000000700ba4 Receive() at 0x9000000006a55a4 amMaSrvReceive() at 0x900000000687ef0 amRcvReceive() at 0x900000000751318 MQReceiveAll(??, ??, ??, ??, ??, ??, ??, ??) at 0x900000000555924 MQReceiveAll2rArg(??, ??, ??, ??, ??, ??, ??, ??) at 0x9000000005568fc sqlpstub.sqloInvokeFnArgs.fdpr.chunk.1(??, ??, ??) at 0x900000009ea5d8c .@84@sqlerRunRoutine(sqleInvokerCB*,int*)(??, ??) at 0x900000009ea61b0 .sqlejResolveUDFLob.fdpr.chunk.14(??, ??) at 0x900000009ea5f54 sqlerFmpListener.fdpr.chunk.14(??, ??, ??, ??, ??) at 0x900000009e8eff4 main(??, ??) at 0x10000121c | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v10.5, Fix Pack 10 * **************************************************************** | |
Local Fix: | |
set KEEPFENCED=NO | |
Solution | |
Workaround | |
see Local Fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.02.2017 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |