Service and policy tables

MQ messaging functions use three service and policy tables.

Most of the MQ messaging functions have an optional policy and service parameter. If the parameter is not passed, the default value is used. The following table lists the default values for these parameters.

Table 1. Default policy and service values
Type	Name	Resources	Status
Service	IDS.DEFAULT.SERVICE	IDS.DEFAULT.QUEUE	created
Service	IDS.DEFAULT.SUBSCRIBER	SYSTEM.BROKER.CONTROL.QUEUE	system default
Service	IDS.DEFAULT.PUBLISHER	SYSTEM.BROKER.DEFAULT.STREAM	system default
Service	IDS.DEFAULT.SUBSCRIBER.RECEIVER	IDS.DEFAULT.SUBSCRIBER.RECEIVER.QUEUE	created
Policy	IDS.DEFAULT.POLICY	connection name :default queuemanager	system default
Publisher	IDS.DEFAULT.PUBLISHER	sender:IDS.DEFAULT.PUBLISHER	system default
Subscriber	IDS.DEFAULT.SUBSCRIBER	sender:IDS.DEFAULT.SUBSCRIBER receiver: IDS.DEFAULT.SUBSCRIBER.RECEIVER	system default

Each service definition includes a queue specification. The service can be mapped any queue. For testing purposes, you can create the following queues using the script idsdefault.tst:

IDS.DEFAULT.QUEUE queue for the IDS.DEFAULT.SERVICE
IDS.DEFAULT.SUBSCRIBER.RECIVER.QUEUE queue for the IDS.DEFAULT.SUBSCRIBER

The script idsdefault.tst is located in the MQBLADE directory. Use the runmqsc utility to execute commands in idsdefault.tst.

If the QueueManager is not a default queue manager, you must update the queuemanager column of the informix.mqiservice table by updating servicename to IDS.DEFAULT.SERVICE, IDS.DEFAULT.PUBLISHER, IDS.DEFAULT.SUBSCRIBER and IDS.DEFAULT.SUBSCRIBER.RECEIVER.

During registration, the following default values are inserted into the "informix".mqi* tables:

 INSERT INTO ""informix"".mqiservice(servicename, queuemanager, queuename)
        VALUES('IDS.DEFAULT.SERVICE', '', 'IDS.DEFAULT.QUEUE');

 INSERT INTO ""informix"".mqiservice(servicename, queuemanager, queuename)
        VALUES('IDS.DEFAULT.PUBLISHER', '', 'SYSTEM.BROKER.DEFAULT.STREAM');

 INSERT INTO ""informix"".mqiservice(servicename, queuemanager, queuename)
        VALUES('IDS.DEFAULT.SUBSCRIBER', '', 'SYSTEM.BROKER.CONTROL.QUEUE');

 INSERT INTO ""informix"".mqiservice(servicename, queuemanager, queuename)
        VALUES('IDS.DEFAULT.SUBSCRIBER.RECEIVER', '',
               'IDS.DEFAULT.SUBSCRIBER.RECEIVER.QUEUE');

 INSERT INTO ""informix"".mqipubsub(pubsubname, servicebroker, receiver,
                                  psstream, pubsubtype)
         VALUES('IDS.DEFAULT.SUBSCRIBER', 'IDS.DEFAULT.SUBSCRIBER',
                'IDS.DEFAULT.SUBSCRIBER.RECEIVER',
                'SYSTEM.BROKER.DEFAULT.STREAM', 'Subscriber');

 INSERT INTO ""informix"".mqipubsub(pubsubname, servicebroker, receiver,
                                  psstream, pubsubtype)
        VALUES('IDS.DEFAULT.PUBLISHER', 'IDS.DEFAULT.PUBLISHER', '', '',
               'Publisher');

 INSERT INTO ""informix"".mqipolicy(policyname)
        VALUES('IDS.DEFAULT.POLICY');

 INSERT INTO ""informix"".mqipolicy(policyname)
        VALUES('IDS.DEFAULT.PUB.SUB.POLICY');