| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBIMB Msgflow using Database statement - Urgent!!! |
« View previous topic :: View next topic » |
| Author |
Message
|
| rohit |
 Posted: Thu Jul 07, 2005 10:39 pm Post subject: WBIMB Msgflow using Database statement - Urgent!!! |
 |
|
Apprentice
Joined: 05 Jul 2005
Posts: 40
|
Hi,
My Environment: WBIMB 5.0.4, WMQ 5.3, ConfigMgr - W2K, Broker - AIX, DB2 8.1.2
I have created and deployed normal transformation msgflows into my broker and it's working fine.
I need to use my application databases in the WBIMB message flow - compute node - to query, insert, update, etc. Have create a sample flow with a SQL query statement. Have deployed the message flow successfully. But the input message is routed to the failure terminal of the compute node. SQL statement should be correct else it willn't allow me to deploy. I doubt whether it would be DB connection part rom WBIMB Broker to Application database.
In my msgflow, i have specified the DSN name in the compute node's property. I have created a appln database and created a remote catalog for the same. Am able to connect to the database using the remote DB alias created.
Can someone brief me the steps starting from message flow, db, catalog and odbc configuration, so that i can cross check and rectify this issue.
Thanks in Advance.
cheers!!
Rohit. |
|
| Back to top |
|
 |
| rkford11 |
| Posted: Fri Jul 08, 2005 5:58 am Post subject: Re: WBIMB Msgflow using Database statement - Urgent!!! |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
| rohit wrote: |
Hi,
My Environment: WBIMB 5.0.4, WMQ 5.3, ConfigMgr - W2K, Broker - AIX, DB2 8.1.2
I have created and deployed normal transformation msgflows into my broker and it's working fine.
I need to use my application databases in the WBIMB message flow - compute node - to query, insert, update, etc. Have create a sample flow with a SQL query statement. Have deployed the message flow successfully. But the input message is routed to the failure terminal of the compute node. SQL statement should be correct else it willn't allow me to deploy. I doubt whether it would be DB connection part rom WBIMB Broker to Application database.
In my msgflow, i have specified the DSN name in the compute node's property. I have created a appln database and created a remote catalog for the same. Am able to connect to the database using the remote DB alias created.
Can someone brief me the steps starting from message flow, db, catalog and odbc configuration, so that i can cross check and rectify this issue.
Thanks in Advance.
cheers!!
Rohit. |
Have you run the command
mqsisetdbparms -n database -u userid -p password
to let the broker access the database. |
|
| Back to top |
|
|
| JT |
| Posted: Fri Jul 08, 2005 6:12 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
