| Author |
Message
|
| RaviKrG |
 Posted: Fri Mar 20, 2009 9:15 pm Post subject: Database test connection fails |
 |
|
Master
Joined: 07 Sep 2008
Posts: 240
|
Hi I have a flow which inserts data in to tables in db2 database on solaris.
My flow : MQinput -> DataInsert
My env :
Broker : wmb6.1 on solaris
Broker Database : Db2 9.1 on solaris
User Database : Db2 9.1 on solaris
MB toolkit : Windows
I have entered these values in /var/mqsi/odbc/odbc64.ini
[CRICDATA]
DRIVER=/opt/IBM/mqsi/6.1/lib/libdb2Wrapper64.so
Description=CRICDATA DB2 ODBC Database
Database=CRICDATA
then I did mqsisetdbparms with the broker with the user id and password.
Now I am creating the Data Definition file and after entering all the details when I do a test connection it fails.
I get error as
Connection to DB2 for Linux, Unix, and Windows failed.
[ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server .................. with message: Connection refused: connect.
Can anybody tell is there any other setting need to be for this or i have done some wrong |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Mar 20, 2009 11:21 pm Post subject: Re: Database test connection fails |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| RaviKrG wrote: |
Connection to DB2 for Linux, Unix, and Windows failed.
[ibm][db2][jcc][t4][2043][11550] Exception java.net.ConnectException: Error opening socket to server .................. with message: Connection refused: connect. |
Try to telnet to the port. If that fails, ask your network people to open the firewall.
If not, continue as for a 2059.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| RaviKrG |
| Posted: Thu Mar 26, 2009 12:19 am Post subject: |
|
|
Master
Joined: 07 Sep 2008
Posts: 240
|
Finally we have changed the database (user database) to db2 on windows now and we have cataloged the node on solaris and all looks fine as when we work on solaris(db2) but when we try to access the database through the mb flow then I get error and the message goes to backout queue
Database error: ODBC return code '-1'. :BRKR.b284b222-2001-0000-0080-8f749bb9760e: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 327: ImbOdbcHandle::checkRcInner: :
Database error: SQL State '08001'; Native Er
ror Code '-1013'; Error Text '[IBM][CLI Driver] SQL1013N The database alias name or database name "CRICDATA" could not be found. SQLSTATE=42705 '. : BRKR.b284b222-2001-0000-0080-8f749bb9760e: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 456: ImbOdbcHandle::checkRcInner: :
we have changed to
Db2 Database name on windows: CRICDATA
Alias name on solaris : CRICAL
odbc file:
[CRICDATA]
DRIVER=/opt/IBM/mqsi/6.1/lib/libdb2Wrapper64.so
Description=CRICDATA DB2 ODBC Database
Database=CRICAL
then mqsisetdbparms with CRICDATA
is there anything I am missing because of which I am getting this error or i need to follow something else |
|
| Back to top |
|
|
| RaviKrG |
| Posted: Thu Mar 26, 2009 4:29 am Post subject: Database test connection fails - resolved |
|
|
Master
Joined: 07 Sep 2008
Posts: 240
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Mar 26, 2009 4:35 am Post subject: Re: Database test connection fails - resolved |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| RaviKrG wrote: |
| issue resolved |
Please post your solution for the benefit of future sufferers. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| RaviKrG |
| Posted: Sat Mar 28, 2009 8:38 am Post subject: |
|
|
Master
Joined: 07 Sep 2008
Posts: 240
|
| I just uncataloged the database and the node and then re cataloged the node and then after a fresh restart all was fine. |
|
| Back to top |
|
|
|
|
