Converting from the AMI-based MQ functions to the MQI-based MQ functions

The MQI-based MQ functions use two tables, SYSIBM.MQSERVICE_TABLE and SYSIBM.MQPOLICY_TABLE, instead of Application Messaging Interface (AMI) configuration files. You need to bind the new functions, create the tables, and convert the contents of the AMI configuration files to rows in the MQ tables.

About this task

Job DSNTIJRT binds the new functions and creates the tables. You need to manually convert the contents of the AMI configuration files.

Procedure

To manually move the AMI configuration file data to the MQ tables:

  1. Map sub-elements and attributes under the <ServicePoint> element to columns in SYSIBM.MQSERVICE_TABLE as indicated in the following table.
    Table 1. How elements and attributes under the <ServicePoint> element map to columns in the SYSIBM.MQSERVICE_TABLE table
    Element Attribute of element Column Example
    <ServicePoint> longDescription DESC_LONG <ServicePoint longDescription="" shortDescription="" ..xmi.label="DB2.DEFAULT.SERVICE">
    shortDescription DESC_SHORT
    xmi.label SERVICENAME
    <ServicePoint _queueName> value INPUTQUEUE <ServicePoint_queueName .. value="DB2MQ_DEFAULT_Q"/>
    <ServicePoint _queueMgrName> value QUEUEMANAGER <ServicePoint_queueMgrName .. value="MQND"/>
  2. Map sub-elements and attributes under the <Policy> element to columns in SYSIBM.MQPOLICY_TABLE as indicated in the following table.
    Table 2. How elements and attributes under the <Policy> element map to columns in the SYSIBM.MQPOLICY_TABLE table
    Element Attribute of element Value of attribute Column Value of column Example
    <Policy> long Description value DESC_LONG value <Policy longDescription="" shortDescription="".. xmi.label= "DB2.DEFAULT.POLICY">
    short Description DESC_SHORT
    xmi.label POLICYNAME
    <GeneralAttributes _syncpoint> value Yes SYNCPOINT Y <GeneralAttributes _syncpoint .. value="Yes"/>
    No N
    <SendAttributes _priority> value AsTransport SEND_PRIORITY -1 <SendAttributes _priority .. value="AsTransport"/>
    <SendAttributes _persistence> value AsTransport SEND _PERSISTENCE Q <SendAttributes _persistence .. value="AsTransport"/>
    Yes Y
    No N
    <SendAttributes _expiry> value Unlimited SEND_EXPIRY -1 <SendAttributes_expiry .. value="Unlimited"/>
    <SendAttributes _retryCount> value n SEND_RETRY _COUNT n <SendAttributes _retryCount .. value="0"/>
    <SendAttributes _retryInterval> value n SEND_RETRY _INTERVAL n <SendAttributes _retryInterval .. value="1000"/>
    <SendAttributes _newCorrelId> value Yes SEND_NEW _CORRELID Y <SendAttributes _newCorrelId .. value="No"/>
    No N
    <SendAttributes _responseCorrelId> value MessageID SEND_RESPONSE _CORRELID C <SendAttributes _responseCorrelId .. value="MessageID"/>
    CorrelID P
    <SendAttributes _exceptionAction> value DLQ SEND_EXCEPTION _ACTION Q <SendAttributes _exceptionAction .. value="DLQ"/>
    Discard D
    <SendAttributes _reportType Exception>, <SendAttributes _reportData> value, value1 No SEND_REPORT _EXCEPTIONDESC _LONG N

    <SendAttributes _reportTypeException .. value="No"/>

    <SendAttributes _reportData .. value="Report"/>
    Yes, Report E
    Yes, Report _With_Data D
    Yes, Report _With_Full_Data F
    <SendAttributes _reportTypeCOA>, <SendAttributes _reportData> value, value1 No SEND_REPORT _COA N

    <SendAttributes _reportTypeCOA .. value="No"/>

    <SendAttributes _reportData .. value="Report"/>
    Yes, Report C
    Yes, Report _With_Data D
    Yes, Report _With_Full_Data F
    <SendAttributes _reportTypeCOD>, <SendAttributes _reportData> value, value1 No SEND_REPORT _COD N

    <SendAttributes _reportTypeCOD .. value="No"/>

    <SendAttributes _reportData .. value="Report"/>
    Yes, Report C
    Yes, Report _With_Data D
    Yes, Report _With_Full_Data F
    <SendAttributes _reportTypeExpiry>, <SendAttributes _reportData> value, value1 No SEND_REPORT _EXPIRY N

    <SendAttributes _reportTypeExpiry .. value="No"/>

    <SendAttributes _reportData .. value="Report"/>
    Yes, Report E
    Yes, Report _With_Data D
    Yes, Report _With_Full_Data F
    <ReceiveAttributes _waitInterval> value n RCV_WAIT _INTERVAL n <ReceiveAttributes _waitInterval .. value="60"/>
    <ReceiveAttributes _convert> value Yes RCV_CONVERT Y <ReceiveAttributes _convert .. value="Yes"/>
    No N
    <ReceiveAttributes _acceptTruncated Messages> value Yes RCV_ACCEPT _TRUNC_MSG Y <ReceiveAttributes _acceptTruncated Messages .. value="Yes"/>
    No N
    <ReceiveAttributes _openShared> value Yes RCV_OPEN _SHARED S <ReceiveAttributes _openShared .. value="Yes"/>
    No E
    Note:

    1. The two values are used in conjunction to determine the column value.