DB2 FOR LUW / DB2FORLUW / B10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply fix to Db2 server                                      * 
****************************************************************

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in version v11.1 FP xx

See local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.11.2017
15.03.2018
15.03.2018