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.
MQService
The MQService table maintains various types of service point entries and the associated attributes. There are sample values for most of the attributes.
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.
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' |
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.
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' |
|
'L' |
snd_priority | char(1) NOT NULL | 'T' (AsTransport) |
|
'T' |
snd_persistent | char(1) NOT NULL | 'T' (AsTransport) |
|
'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' |
|
'N' |
snd_responseCorrelID | char(1) NOT NULL | 'M' |
|
'M' |
snd_exceptionAction | char(1) NOT NULL | 'D' |
|
'D' |
snd_reportData | char(1) NOT NULL | 'R' |
|
'R' |
snd_rtException | char(1) NOT NULL | 'N' |
|
'N' |
snd_rtCOA | char(1) NOT NULL | 'N' |
|
'N' |
snd_rtCOD | char(1) NOT NULL | 'N' |
|
'N' |
snd_rtExpiry | char(1) NOT NULL | 'N' |
|
'N' |
rcv_waitInterval | integer NOT NULL | 30 milliseconds | > = -1 milliseconds (-1=unlimited) |
30 milliseconds |
rcv_convert | char(1 NOT NULL | 'Y' |
|
'Y' |
rcv_handlePoisonMsg | char(1) NOT NULL | 'Y' |
|
'Y' |
rcv_rcvTruncatedMsg | char(1) NOT NULL | 'N' |
|
'N' |
rcv_openShared | char(1) NOT NULL | 'Y' |
|
'Y' |
pub_retain | char(1) NOT NULL | 'N' |
|
'N' |
pub_othersOnly | char(1) NOT NULL | 'N' |
|
'N' |
pub_suppressReg | char(1) NOT NULL | 'Y' |
|
'Y' |
pub_pubLocal | char(1) NOT NULL | 'N' |
|
'N' |
pub_direct | char(1) NOT NULL | 'N' |
|
'N' |
pub_anonymous | char(1) NOT NULL | 'N' |
|
'N' |
pub_correlasID | char(1) NOT NULL | 'N' |
|
'N' |
sub_subLocal | char(1) NOT NULL | 'N' |
|
'N' |
sub_NewPubsOnly | char(1) NOT NULL | 'N' |
|
'N' |
sub_PubOnReqOnly | char(1) NOT NULL | 'N' |
|
'N' |
sub_informIfRet | char(1) NOT NULL | 'Y' |
|
'Y' |
sub_unsubAll | char(1) NOT NULL | 'N' |
|
'N' |
sub_anonymous | char(1) NOT NULL | 'N' |
|
'N' |
sub_correlAsID | char(1) NOT NULL | '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.
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' |