ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » help with JDBC connection from wkbnch to DB2 on AIX

Post new topic  Reply to topic
 help with JDBC connection from wkbnch to DB2 on AIX « View previous topic :: View next topic » 
Author Message
sstubble
PostPosted: Fri May 18, 2007 9:49 am    Post subject: help with JDBC connection from wkbnch to DB2 on AIX Reply with quote

Novice

Joined: 09 Dec 2005
Posts: 20
I've got an open PMR with IBM but no help so far. My environment is WBIMB V5.0.9. The toolkit & config mgr are on windows server 2003 sp1. The broker and all db's are on AIX 5.2. The db is DB2 UDB 8 FP 14. I want to use a DataInsert node to insert into a db table. I want the db name to be a promotable property. I have a working ODBC connection between the windows and aix server. It seems that I need to establish a JDBC connection between the toolkit on the windows server and the database on the aix server. Is this possible? The infocenter doc describes using the IBM DB2 App Driver or the IBM DB2 Net Driver for establishing the JDBC connection. If I'm reading the doc right the App Driver is only for connecting to local db's. I've been able to successfully establish a JDBC connection to a local db using the App Driver. The Net driver seems to indicate that I can connect to a remote db but it must be on the same platform & version. If I try to establish the JDBC connection with the Net driver I get the following error "

IWAS0126E Problems encountered while trying to establish connection PGMRBAD1. Reason: '[IBM][JDBC Driver] CLI0615E Error receiving from socket, server is not responding. SQLSTATE=08S01'

Does this mean that I cannot make a JDBC connection from the toolkit on windows to a DB2 db on an AIX server? One additional bit of info. The db's on AIX are 64-bit (required for the TSM backup). The broker accesses them using a 32-bit client.
Back to top
View user's profile Send private message
Monk
PostPosted: Sat May 19, 2007 11:11 pm    Post subject: Reply with quote

Master

Joined: 21 Apr 2007
Posts: 282
try checking of the db2 port(50000) is open and ur able to connect to it
use netstat to monitor .
once u have a successful connection to DB2 on aix.
try accesssing it from windows, goto data source -> system DSN
and access it from you DSN definition. enter ur user/pass to check connectivity..

then make sure u hv enabled the broker with mqsisetdbparms command to access the database
Just wondering Why do u need JDBC adapter,if you can do with ODBC driver.
I m not sure what you are tring to do...but hopefully the above mentioned steps may help...
_________________
Thimk
Back to top
View user's profile Send private message
sstubble
PostPosted: Tue May 22, 2007 7:18 am    Post subject: Reply with quote

Novice

Joined: 09 Dec 2005
Posts: 20
I need the jdbc adapter because that's what the message broker toolkit (eclipse) uses to make database connections. You have to be able to establish a connection to use any of the mapping features. It turns out that there is a known problem with making jdbc connections from the toolkit to a 64-bit db on AIX. IBM Software Group has published a technote. You can't use the supplied IBM JDBC App or Net driver. You must select 'Other Driver'

Also, make sure you have issued a db2jstrt on the server that hosts the DB2 database you are esbablishing a connection to.

Here's the info I supplied in the connection. "server" in the connection URL should be the hostname of your server and DBNAME should be the database name you want to establish a connection to. 6789 is the default port for jdbc connections.


Database Vendor Type: DB2 Universal Database V8.1
JDBC Driver: Other Driver
JDBC Driver class: COM.ibm.db2.jdbc.net.DB2Driver
Class Location: C:\Program Files\IBM\SQLLIB\java\db2java.zip
Connection URL: jdbc:db2://server:6789/DBNAME
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » help with JDBC connection from wkbnch to DB2 on AIX
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.