| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBIMB DB2 ODBC connection test |
« View previous topic :: View next topic » |
| Author |
Message
|
| rohit |
 Posted: Thu Jul 07, 2005 3:29 am Post subject: WBIMB DB2 ODBC connection test |
 |
|
Apprentice
Joined: 05 Jul 2005
Posts: 40
|
Hi,
Environment: AIX 5.2, WBIMB 5 CSD04, DB2 8.1.2
(1) I have created my database in AIX and configured the ODBC.INI file for the same. How can test and confirm my odbc configuration is proper or not? Is there any tool or command available to test this???
(2) I have to perform DB operation in my project for which i have created a message flow with DB SQL statements in COMPUTE node as similar to the one we create in WMQI. My broker is in AIX environment. Even though my deployment was successful, i could only see the request message routed to the COMPUTE node's failure terminal. Am i missing any step?
Do we need to do anything different to establish a DB connection and perform SQL operations using COMPUTE node in WBIMB? How is WBIMB DB operations is different from WMQI??
Appreciate your expedite responses.
rgds,
ROHIT. |
|
| Back to top |
|
 |
| waugh |
| Posted: Thu Jul 07, 2005 4:46 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
Rohit,
try this command,
demoodbc -UID userid -PWD password datasourcename |
|
| Back to top |
|
|
| recallsunny |
| Posted: Thu Jul 07, 2005 5:10 am Post subject: |
|
|
Disciple
Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
|
There is no big difference betweem WMQI and WBIMB as far as DB operations go. The only difference is the Location where you mention the DSN name is different. In WBIMB you would do that in in your Compute node properties tab or the BAR file properties tab.
Also check the Syslog for more details on the error, you could turn on the User trace for more insight.
|
|
| Back to top |
|
|
| waugh |
| Posted: Thu Jul 07, 2005 5:26 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
| does your sql work from normal DB2 SQL prompt? did you try debugging that flow. it will give you exact exception which will be helpful in solving your problem. I think your ODBC is fine as your deployment went successful. |
|
| Back to top |
|
|
| JT |
| Posted: Thu Jul 07, 2005 5:56 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| recallsunny wrote: |
| There is no big difference betweem WMQI and WBIMB as far as DB operations go. |
One big difference is the ability under WBIMB to now declare a unique database id & password, rather than the broker's service id (as was the case under WMQI).
| rohit wrote: |
| Am i missing any step? |
Did you issue the following command:
| Quote: |
| mqsisetdbparms BrokerName -n DataSourceName -u DataSourceUserId -p DataSourcePassword |
|
|
| 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
|
|
|
|
