How To Access Database Using Compute Node ESQL in Message Broker

Ok you need to access Database ( DB2 or Oracle or any other ) from your message flow. there are 2 simple steps to configured..

Step 1 : Create a data source name on your machine if you are using windows ,create ODBC data source name for DB, or if you are configuring on unix then create DSN for your database first.

Step 2: Now register your data source name (DSN) with your runtime message broker by using below command 

mqsisetdbparms IB9NODE -n <DSN> -u db2admin -p <password>    ( Remove <> signs >

Step 3:-  Using Compute Node , First you need to configured your compute node by proving datasource name. 

Step 4 : - Use select or insert whatever you are doing statement in ESQL like below 

select from datasourcename.tablename;

Step 5: - Deploy and run your message flow.

Do let me know if you have any doubt in comment box below. 


Post a Comment