| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 Datasource issue while connecting through ODBC in IB9. |
« View previous topic :: View next topic » |
| Author |
Message
|
| Venkat10 |
 Posted: Mon Mar 10, 2014 6:52 am Post subject: DB2 Datasource issue while connecting through ODBC in IB9. |
 |
|
Novice
Joined: 10 Mar 2014
Posts: 19
|
Hello Everyone,
Hope you are doing great.
We are trying to setup an environment for IB9 and having issues with Datasource connection for DB2 version '09.01.0005' using ODBCINI.
mqsicvp command is successful but it's throwing an error while running the message flow.
MQSIVP Command:
BIP8290I: Verification passed for the ODBC environment.
BIP8270I: Connected to Datasource ''XXXX' as user 'userid'. The datasource platform is 'DB2', version '09.01.0005'.
BIP8275I: Verification passed for User Datasource 'XXXX'.
Error in /var/log/messages
Mar 10 10:28:53 SystemName IIB[3664]: IBM Integration Bus v9000 (BROKERNAME.WTX_TEST) [Thread 4066] (Msg 2/4) BIP2230E: Error detected whilst processing a message in node 'TestWTX.Compute'.
Mar 10 10:28:53 SystemName IIB[3664]: IBM Integration Bus v9000 (BROKERNAME.WTX_TEST) [Thread 4066] (Msg 3/4) BIP2393E: Database error: ODBC return code '-1' from data source 'XXXX' using ODBC driver manager '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so'.
Mar 10 10:28:53 SystemName IIB[3664]: IBM Integration Bus v9000 (BROKERNAME.WTX_TEST) [Thread 4066] (Msg 4/4) BIP2322E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[unixODBC][Driver Manager]Data source name not found, and no default driver specified'.
I tried many ways but no luck. Any help is appreciated. Thanks. |
|
| Back to top |
|
 |
| new_to_wmb8 |
| Posted: Mon Mar 10, 2014 10:19 pm Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
|
| Back to top |
|
|
| Venkat10 |
| Posted: Tue Mar 11, 2014 5:35 am Post subject: |
|
|
Novice
Joined: 10 Mar 2014
Posts: 19
|
| Yes, I followed all these steps. I wonder why mqsicvp is working and not flow?? |
|
| Back to top |
|
|
| Tibi |
| Posted: Wed Mar 12, 2014 4:32 am Post subject: |
|
|
Newbie
Joined: 12 Mar 2014
Posts: 1
|
Hi,
I have experienced similar problems and the reason was how the mqsisetdbparms was executed, I mean, at which level the DSN was defined and the credentials set.
Which syntax did you use in the mqsisetdbparms?
I hope it helps |
|
| 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
|
|
|
|
