Configuration table: SYSMQL.LISTENERS
If you use MQListener, you must create the MQListener configuration table SYSMQL.LISTENERS by running installation job DSNTIJML.
The SYSMQL.LISTENERS table contains a row for each configuration that you create when you issue MQListener db2mqln1 or db2mqln2 configuration commands.
The following table describes each of the columns of the configuration table SYSMQL.LISTENERS.
| Column name | Description |
|---|---|
| CONFIGURATIONNAME | The configuration name. The configuration name enables you to group several tasks into the same configuration. A single instance of MQListener can run all of the tasks that are defined within a configuration name. |
| QUEUEMANAGER | The name of the IBM® MQ subsystem that contains the queues that are to be used. |
| INPUTQUEUE | The name of the queue in the WebSphere® MQ subsystem that is to be monitored for incoming messages. The combination of the input queue and the queue manager are unique within a configuration |
| PROCNODE | Currently unused |
| PROCSCHEMA | The schema name of the stored procedure that will be called by MQListener |
| PROCNAME | The name of the stored procedure that will be called by MQListener |
| PROCTYPE | Currently unused |
| NUMINSTANCES | The number of duplicate instances of a single task that are to run in this configuration |
| WAITMILLIS | The time MQListener waits (in milliseconds) after processing the current message before it looks for the next message |
| MINQUEUEDEPTH | Currently unused |