DB2 - Problembeschreibung
Problem IC89691 | Status: Geschlossen |
ENABLE_MQFUNCTIONS UTILITY SHOWS UNSUPPORTED PARAMETER "-Q" IN USAGE MESSAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When using enable_MQFunctions executable you may see usage message as below: ============================================================ Usage: enable_MQFunctions -n dbName -u uID -p password [-q queuemanager] [-v 0pc|1pc|all] [-novalidate] [-echo] [-force] [-c clobSize] ============================================================ But actually Federation Server does NOT support parameter [-q queuemanager] on v95 or later versions. You can not specify queue manager name to enable your MQ UDF. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * The users who want to enable MQ UDF using their own queue * * manager instead of the * * default one. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Federation Server Version 9.7 and Fix Pack 8. * **************************************************************** | |
Local-Fix: | |
To enable MQ UDF using your own queue manager instead of the default one: 1. Create your own queue manager, create at least a receive queue in it, active it. 2. Run enable_MQFunctions(without -q option) to enable MQ UDF using the default queue manager. 3. Run below SQLs to update the config table to use your own queue manager: 1) UPDATE DB2MQ."MQSERVICE" SET QUEUENAME='<QUEUE_NAME>',QUEUEMGRNAME='<QUEUE_MGR_NAME>' WHERE SERVICENAME='DB2.DEFAULT.SERVICE' 2) UPDATE DB2MQ."MQHOST" SET QUEUEMGRNAME='<QUEUE_MGR_NAME>' 3) ALTER SERVER MQ OPTIONS(SET AMI_QUEUE_MGR_LIST '<QUEUE_MGR_NAME>') NOTE: Where <QUEUE_MGR_NAME> is the queue manager name, <QUEUE_NAME> is name of the queue managered by <QUEUE_MGR_NAME> | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
The problem is firstly fixed in Federation Server V97fp8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.01.2013 02.04.2013 02.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7., 9.7.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |