Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Delivered
Workspace Db2 for z/OS
Created by Guest
Created on Mar 3, 2014

Additional DB2 MQListener Enhancements

We are about to see a ramp-up in the use of the DB2 MQListener in our production environments serving key application/business channels. We are requesting several enhancements that will improve usability and availability to the business process served by MQListener.

The following RFE's are submitted for your consideration:

1. Allow dynamic reloading/activation of the SYSMQL.Listener definitional rows.

Current application processes cannot tolerate the MQListener tasks being down, even for a short time. If we need to reload the SYSMQL.Listener definitions, before we can issue the recycle, we have to fail over the dependant application from the primary to secondary datacenter. This is a process that we do not want to employ unless it's absolutely necessary. The alternative we are proposing is to have a command that would either reload/reactivate all entries from SYSMQL.Listeners, or, have the ability to target a single listener definition and load/reload that one listener process. This would allow a non or minimally disruptive process to alter active listeners. In addition to the obvious example of adding a new listener to an up and running daemon, we might have the need to quickly change the NUMINSTANCES, WAITMILLIS, etc in order to respond to a capacity/performance issue.

Again, bottom line is to provide us with a non-disruptive process to tailor our DB2 MQListeners as need requires.

2. Change default behavior of listener daemon so that it stays up even if a SYSMQL.Listener entry has an error.

Our preference for daemon startup would be to ignore an incorrect listener definition and start normal with some sort of error message that identified the offending SYSMQL.Listener row. We had a recent production issue where this very issue (new SYSMQL.Listener row pointed at an incorrect MQ Instance) prevented the listener daemon from coming up and impacted all of the other ‘good' listeners. This would be very helpful especially in conjunction with item #1 above.
  • Admin
    Janet Figone
    Reply
    |
    Dec 30, 2020

    Dear Robert, We are closing this Idea with the following recommendations posted in the original RFE on Nov 1, 2017:

    For #1 The user can use the the "restart' command to restart the listeners with new definitions of SYSMQL.LISTENERS.

    Example: Listener is running with configuration A1:

    db2mqln2 run -SSID DSNA -config A1 -adminQueue queue1

    -adminQMgr queueMgr1

    NUMINSTANCE is changed by updating of SYSMQL.LISTENERS table for configuration A1.

    Run "restart' command so the Listener can pick up the new change of NUMINSTANCE for configuration A1.

    db2mqln2 admin -adminQueue queue1

    -adminQMgr queueMgr1

    -adminCommand restart

    For #2 There is a new option '-timeRestart' for the run command of MQlistener. The user can use new option: '-timeRestart' with the run command so MQlistener can start up and run even there is one bad stored procedure during the setup time.

    -timeRestart

    If a stored procedure that is specified by -procSchema and -procName fails at MQListener startup time, the number of seconds that threads that are running with that stored procedure suspend before repeating the setup process. MQListener continues startup for threads that do not use that stored procedure. This value must be an integer between 0 and 7200. 0 is the default.

    Example: Listener is running with configuration ACFG and option -timeRestart:

    db2mqln2 run -ssID DSNA -config ACFG -adminQueue ADMIN_Q -adminQMgr MQND -timeRestart 60

    For DB2 11 and 10 the user should install UI39547( db2 10) or UI39548 (db2 11) to use '-timeRestart' option.

    Thank you.

    Db2 for z/OS Development