Cloud Pak for Integration

Cloud Pak for Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  MQ Application data in the queue is in binary message

    Posted Thu January 27, 2022 05:53 AM
    Hi Team,

    I am getting the application data in the queue is a binary message. What settings are need to be changed to make it in text or readable format.

    ------------------------------
    Sneha Bobade
    ------------------------------


  • 2.  RE: MQ Application data in the queue is in binary message

    Posted Thu February 24, 2022 02:30 PM

    Not sure you got my first answer. In MQ the data payload can be of two versions considering 'binary'.

    1 - message is from a system with a different CCSID. This is the Character set of the sending system. Lets say is z/OS US, the CCSID would be 37. You were sending to a Windows US based system, CCSID 819. If you received the message, doing nothing, it would look like binary. MQ has the internal capability to convert between CSID's. You can turn on CONVERSION on the channel or you have the application issue an MQGET with the option to convert set to yes. Now the data will be in the CCSID of the receiving system.

    2 - The data is true binary. In a case like this you have to build a transformation set. This can also be done in MQ and is not normally done. the other way is to use IIB/ACE to transform the message using DFDL into a format of your desire.



    ------------------------------
    Robert (Bobbee) Broderick
    Senior WebSphere Consultant
    IBM
    Madison AL
    917-453-6790
    ------------------------------

    Original Message


  • 3.  RE: MQ Application data in the queue is in binary message

    Posted Mon February 28, 2022 04:47 AM
    Hi Robert (Bobbee) Broderick,

    The information given by you was helpful. How can I turn on the CONVERSION on the channel. 
    If you can provide the steps it will be helpful.

    Note :- The queues & channels are created on MQ CP4I.Attaching  the image for your refrence.


    Thanks & Regards 
    Sneha Bobade
     

    ------------------------------
    Sneha Bobade
    ------------------------------

    Original Message


  • 4.  RE: MQ Application data in the queue is in binary message

    Posted Mon February 28, 2022 06:44 AM
    RUNMQSC command:

    ALTER CHANNEL(BOBBEE.TO.IIB10_QM) CHLTYPE(SDR) CONVERT(YES)

    ------------------------------
    Robert (Bobbee) Broderick
    Senior WebSphere Consultant
    IBM
    Madison AL
    917-453-6790
    ------------------------------

    Original Message