WebSphere MQ configuration parameters

When you configure your MQ user-defined functions, the information is maintained in tables that are available in DB2® Version 9.1.

The WebSphere® MQ messaging interface is available to your application by using the column values in the DB2 configuration tables. Some of the parameters that are available in the tables including the following parameters:
Sender service
Represents a destination such as a WebSphere MQ queue to which messages are sent.
Receiver service
Represents a source from which messages are received.
Publisher
Contains a sender service where the destination is a publish/subscribe broker.
Subscriber
Contains a sender service to send subscribe and unsubscribe messages to a publish/subscribe broker and a receiver service to receive publications from the broker.
Policy
Defines how to handle the message, including items such as priority, persistence, and whether it is included in a unit of work.
All WebSphere MQ user defined functions are implemented by using the configuration table parameters. When you use the user defined functions, the parameters are created automatically and populated as needed with values from the configuration tables. When you configure the message environment, the information is stored in the configuration tables. The configuration tables are part of schema DB2MQ.

MQService

The MQService table maintains various types of service point entries and the associated attributes. There are sample values for most of the attributes.

Table 1. The MQService table with pre-defined values in the table
Column name Type Default Value Allowable Value Sample value
serviceName varchar(48) not null, primary key Not applicable Not applicable 'DB2.DEFAULT.SERVICE'
queueName varchar(48) NOT NULL Not applicable Not applicable 'DB2MQ_DEFAULT_Q'
queueMgrName varchar(48) NOT NULL '' Not applicable 'DB2MQ_DEFAULT_MQM'
ccsid varchar(6) NOT NULL '' Not applicable ''
description varchar(400) '' Not applicable 'DB2 MQ UDFs default service'

MQPubSub

This table defines the Publisher/Subscriber Service Points for the MQ Publish/Subscribe functions.

Table 2. MQPubSub: pre-defined Publisher/Subscriber Service Points
Column name Type Default value Allowable value Sample value
PubSubName varchar(48) not null unique Not applicable Not applicable 'DB2.DEFAULT.SUBSCRIBER'
broker varchar(48) not null Not applicable Not applicable 'AMT.SAMPLE.SUBSCRIBER'
receiver varchar(48) NOT NULL '' Not applicable 'AMT.SAMPLE.SUBSCRIBER.RECEIVER'
type char(1) NOT NULL Not applicable
  • S (Subscriber Service
  • P (Publisher Service)
 'S'
description varchar(400) '' Not applicable 'DB2 MQPublish default Publisher service'
Note:
  • If the type is S, then a value is required in the receiver column.
  • The values in the broker and the receiver columns must refer to an entry in the MQService table.

MQPolicy

The MQPolicy table maintains various policy entries and the associated attributes of the policies.
Table 3. MQPolicy
Column name Type Default value Allowable value Sample value
policyName varchar(48) not null, primary key Not applicable Not applicable 'AMT.SAMPLE.POLICY'
connectionName varchar(48) NOT NULL ''. Not applicable 'defaultConnection'
connectionMode char(1) NOT NULL 'L'
  • R (Real)
  • L (Logical)
 'L'
snd_priority char(1) NOT NULL 'T' (AsTransport)
  • '0'
  • '1'
  • '2'
  • '3'
  • '4'
  • '5'
  • '6'
  • '7'
  • '8'
  • '9'
  • 'T'
 'T'
snd_persistent char(1) NOT NULL 'T' (AsTransport)
  • 'Y'
  • 'N'
  • 'T'
 'T'
snd_expiry integer NOT NULL 0 = unlimited. > = 0 0
snd_retrycount integer NOT NULL 0 > = 0 0
snd_retry_interval integer NOT NULL 1000 milliseconds > = 0 milliseconds 1000 milliseconds
snd_newCorrelID char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
snd_responseCorrelID char(1) NOT NULL 'M'
  • 'M' (MessageID)
  • 'C' (CorrelID)
 'M'
snd_exceptionAction char(1) NOT NULL 'D'
  • 'Q' (DLQ)
  • 'D' (Discard)
 'D'
snd_reportData char(1) NOT NULL 'R'
  • 'R' (Report)
  • 'D' (Report_With_Data)
  • 'F' (Report_With_Full_Data)
 'R'
snd_rtException char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
snd_rtCOA char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
snd_rtCOD char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
snd_rtExpiry char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
rcv_waitInterval integer NOT NULL 30 milliseconds > = -1 milliseconds (-1=unlimited) 30 milliseconds
rcv_convert char(1 NOT NULL 'Y'
  • 'Y'
  • 'N'
 'Y'
rcv_handlePoisonMsg char(1) NOT NULL 'Y'
  • 'Y'
  • 'N'
 'Y'
rcv_rcvTruncatedMsg char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
rcv_openShared char(1) NOT NULL 'Y'
  • 'Y'
  • 'N'
 'Y'
pub_retain char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
pub_othersOnly char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
pub_suppressReg char(1) NOT NULL 'Y'
  • 'Y'
  • 'N'
 'Y'
pub_pubLocal char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
pub_direct char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
pub_anonymous char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
pub_correlasID char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_subLocal char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_NewPubsOnly char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_PubOnReqOnly char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_informIfRet char(1) NOT NULL 'Y'
  • 'Y'
  • 'N'
 'Y'
sub_unsubAll char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_anonymous char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
sub_correlAsID char(1) NOT NULL 'N'
  • 'Y'
  • 'N'
 'N'
Description varchar (400) '' Not applicable ''

MQHost

This table links the connectionName value that is used in the MQPolicy table to the actual queue manager when the connectionMode has a value of L, which means Logic.
Table 4. MQHost with pre-defined values
Column name Type Default value Allowable value Sample value
connectionName varchar(48) not null unique Not applicable Not applicable 'defaultConnection'
queueMgrName varchar(48) not null '' Not applicable 'DB2MQ_DEFAULT_MQM'