Monday, 27 June 2016

UDP(User Defined Properties in Message Broker)


UDP
..............

1.If we specified in the message flow's User defined properties panel some values like dsn,schema then in the flow we need to declare using 'EXTERNAL' keyword & give some null values within single quotes.The values that we mention in the ESQL code are not effected with the values in the Message flow User defined properties panel.

Ex:- DECLARE cDATABASE EXTERNAL CHARACTER '';

2. No need to create UDP in flow but using ESQL coding we can create UDP

Ex:-DECLARE cDATABASE EXTERNAL CHARACTER 'EAI';

How to delete a broker that is creating trouble to delete?


1. C:\ProgramData\IBM\MQSI


       There remove the Broker name in the Common,Config,registry folders

2. Queue Manager Deletion in Win 7
     C:\Program Files (x86)\IBM\WebSphere MQ\Qmgrs

Deleting Brokers path in Windows 7

C:\Program Files (x86)\IBM\WebSphere MQ\Qmgrs
C:\ProgramData\IBM\MQSI\components


Another case is when we change the System Password also,Broker does not start & connect to queue manager.In that case goto Run-->Services.msc & make sure that three of them are in started state or else delete the broker & queue manager using the above steps & create a new broker using Default Configuration wizard.




Now change the password here also to the newly changed password