IBM Support

IC89691: ENABLE_MQFUNCTIONS UTILITY SHOWS UNSUPPORTED PARAMETER "-Q" IN USAGE MESSAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

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

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>
    

Problem summary

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

Problem conclusion

  • The problem is firstly fixed in Federation Server V97fp8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89691

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-22

  • Closed date

    2013-04-02

  • Last modified date

    2013-04-02

  • APAR is sysrouted FROM one or more of the following:

    JR42852

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 April 2013