(WMB) Working with Remote DB

In Message Broker, database can be accessed through predefined database nodes like Database, DatabaseDelete, DatabaseInsert, DatabaseUpdate etc.

Database can also be accessed through Compute and JavaCompute nodes.

Compute nodes are written by using ESQL code. Compute nodes are comparatively faster in performance compared to JavaCompute nodes.

Connecting to DB through compute node :

• A Compute node gets access to a database through System DSN.
• System DSN can be configured through ODBC Data Sources.
• In order to connect to a DB it is mandatory that to have DB specific driver available in the machine.
• We need to give 'DataSourceName' & 'Database Alias'.
• Click on Add next to Database Alias option, a new window opens up, fill the necessary details like database name, hostname, port etc.
• Click Ok.

Story is not over yet, broker still does not know what you have done so far , so the next step would be to update broker configuration by following commands :

mqsistop <<BrokerName>>  {Stop the Broker}

mqsisetdbparms <<BrokerName>> -n <<DataSourceName>> -u <<UserName>> -p <<Password>>

mqsireload <<BrokerName>> -e <<ExecutionGroupName>>

mqsistart <<BrokerName>>  {Start the Broker}