Saif Ahmed, Middleware Blog

Accessing the DB from a compute node in a message flow in WMB 1. Add the datasource name in the oracle ini files 2. Run the mqsetdbparms command >>-mqsisetdbparms-- BrokerName -- -n -- ResourceName ---------------> >-- -u -- UserId -------------------------------------------------> >--+- -p -- Password ------------------------------+--+-----+----><    '- -i -- SSHIdentityFile --+------------------+-' '- -f-'        '- -r -- Passphrase -'     3. Configure the DSN name in the compute node and run the sql query through the compute node

Communication between Queue Managers in MQ 7.5 Creating MQ connection between two queue managers, QMA & QMB 1. Creating queue manager QMA ALTER QMGR + *  ALTDATE(2018-05-19) + *  ALTTIME(15.19.41) +    CCSID(437) +    CLWLUSEQ(LOCAL) + *  COMMANDQ(SYSTEM.ADMIN.COMMAND.QUEUE) + *  CRDATE(2018-05-19) + *  CRTIME(15.19.41) +    DEADQ('QMA.DLQ') +    DEFXMITQ('QMA') + *  PLATFORM(WINDOWSNT) + *  QMID(QMA_2018-05-19_15.19.41) +    SSLCRYP(' ') +    SSLKEYR('C:\Program Files\IBM\WebSphere MQ\qmgrs\QMA\ssl\key') +    SUITEB(NONE) + *  VERSION(07050002) +    FORCE DEFINE LISTENER('LISTENER.TCP') TRPTYPE(TCP) CONTROL(QMGR) +    PORT(1424) + *  ALTDATE(2018-05-19) + *  ALTTIME(15.20.15) +    REPLACE 2. Creating queue manager QMB ALTER QMGR + *  ALTDATE(2018-05-19) + *  ALTTIME(15.21.08) +    CCSID(437) +    CLWLUSEQ(LOCAL) + *  COMMANDQ(SYSTEM.ADMIN.COMMAND.QUEUE) + *  CRDATE(2018-05-19) + *