DB2 - Problem description
Problem IT23284 | Status: Closed |
MQFUNCTIONS DO NOT FUNCTION PROPERLY IN DB2 V11.1 ON AIX | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
MQFunctions do not function properly in Db2 v11.1 on AIX. For example, MQSend and MQReceive fail with the following error message. SQL1476N The current transaction was rolled back because of error "-430". SQLSTATE=40506 You can verify if you are encountering the same problem by executing the below command... enable_MQFunctions -n <db> -u <user> -force -p <password> -v all ...then receive output similar to the following: *** Error -- while connecting to DB2MQ_DEFAULT_MQM (reason code -- 2589) *** Problem -- while checking MQ. Please ensure that the user has permission to create/start queue manager. Please ensure that the user has permission to create a queue. Please ensure that MQSeries is installed properly. The call stack for trap is as follows: Stack #1 Signal #4 Timestamp 2017-11-10-11.44.10.873011 0 MQ_Server_OM::~MQ_Server_OM 1 MQ_UnfencedServer::~MQ_UnfencedServer 2 Wrapper::drop_server 3 sqlqgDeleteServer 4 sqlqgFindServer 5 sqlqgAlterServer 6 sqlnq_drop_func_mapping_one 7 sqlnq_drop_funcmap_stmt | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply fix to Db2 server * **************************************************************** | |
Local Fix: | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in version v11.1 FP xx | |
Workaround | |
See local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.11.2017 15.03.2018 15.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |