IBM Support

JR42501: 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 user is running enable_MQFunctions.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server v97fp7 or later.                *
    ****************************************************************
    

Problem conclusion

  • The problem was firstly fixed in Federation Server v97fp7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR42501

  • Reported component name

    NONRELATIONAL W

  • Reported component ID

    5724N9713

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-10

  • Closed date

    2012-12-03

  • Last modified date

    2012-12-03

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

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

    JR42852 IC87865

Fix information

  • Fixed component name

    NONRELATIONAL W

  • Fixed component ID

    5724N9713

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Data Sources and Wrappers - Non-Relational Wrapper

Software version: 9.7

Reference #: JR42501

Modified date: 03 December 2012