The "informix".mqiservice table

The "informix".mqiservice table contains the service definitions for service point (sender/receiver) attributes.

The "informix".mqiservice table has the following schema:
CREATE TABLE "informix".mqiservice
    servicename    LVARCHAR(256), 
    queuemanager   VARCHAR(48) NOT NULL,   
    queuename      VARCHAR(48) NOT NULL, 
    defaultformat  VARCHAR(8) default ' ', 
    ccsid          VARCHAR(6) default ' ', 
    mqconnname     lvarchar(264) default '',
    mqchannelname  varchar(20) default 'SYSTEM.DEF.SVRCONN',
    mqxpt          INTEGER DEFAULT 2  CHECK ( mqxpt >= 0 AND mqxpt <= 6 ),
    mqchllib       lvarchar(512) default '',
    mqchltab       lvarchar(512) default '',
    mqserver       lvarchar(512) default '',
    PRIMARY KEY (servicename) );
The attributes are defined as follows:
servicename
The service name used in the MQ functions.
queuemanager
The queue manager service provider.
queuename
The queue name to send the message to or receive the message from.
defaultformat
Defines the default format.
ccsid
The coded character set identifier of the destination application.
mqconnname
The MQ connection name. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqchannelname
The MQ channel name. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqxpt
The MQ transport type attribute. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqchllib
The MQCHLLIB environment variable of WMQ. This value, which is present only when the client-based messaging library is used, specifies the directory path to the file containing the client channel definition table.
mqchltab
The MQCHLTAB environment variable of WMQ. This value, which is present only when the client-based messaging library is used, specifies the name of the file containing the client channel definition table
mqserver
The MQSERVER environment variable of WMQ. This value, which is present only when the client-based messaging library is used, defines a channel and specifies the location of the WebSphere® MQ server and the communication method that is used.

An application can specify the mqchannelname, mqxpt, and mqconnname attributes of a channel at run time. This enables the client application to connect to multiple server queue managers simultaneously. If these values are present, they take precedence over other values. For more information, see information about using the MQCNO structure on an MQCONNX call in the documentation.

Whenever each service is connected to WMQ, the service uses environment variables in the following order:

  1. MQCNO values
  2. Variables in the service
  3. Variables in the instance
  4. WMQ default values