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 » MQSI 2.1/WMI 5.0 broker & 64-bit DB2 databases compatibi

Post new topic  Reply to topic
 MQSI 2.1/WMI 5.0 broker & 64-bit DB2 databases compatibi « View previous topic :: View next topic » 
Author Message
MVO
PostPosted: Mon Aug 23, 2004 11:39 am    Post subject: MQSI 2.1/WMI 5.0 broker & 64-bit DB2 databases compatibi Reply with quote

Centurion

Joined: 09 Sep 2001
Posts: 131

Hi,
I've just upgraded my 64-bit Solaris server to UDB V8. I'd like to migrate all my V7 DB2 databases to 64-bit but am not sure if the broker will still work.

According to http://www-306.ibm.com/software/integration/wbimessagebroker/requirements/
Support for 64-bit databases (DB2 and Oracle) :
The Broker is a 32-bit application and interacts with 32-bit database libraries. In these Broker environments, our statement of support for databases refers to the database client.
The Broker supports connecting to a 32-bit database client which connects to a 64-bit server. The Broker does not support connecting to a 64-bit database client. This restriction is imposed by both the Broker and the DataDirect drivers.

Is it safe to leave the broker database as 32-bit ? Or it's OK to migrate to 64-bit because all DB2 databases used by the broker are local i.e. they are on the same server as the broker.

Thanks
Back to top
View user's profile Send private message
tdolby
PostPosted: Tue Aug 24, 2004 2:46 am    Post subject: MQSI and 64-bit databases Reply with quote

Newbie

Joined: 29 Jun 2004
Posts: 8

You can certainly use a 64-bit database as a broker database, as long as the database client libraries used (libdb2.so and friends) are 32-bit. This can be done by either creating a 32-bit instance and using TCPIP to do the communication, or by using LD_LIBRARY_PATH to point the broker at the lib32 directory of your 64-bit instance.

It is also safe to leave the broker database as 32-bit, if you prefer to do this.

Hope this helps - I've set up various configs using DB2 8 in 64-bit mode, and they work really well. DB2 8 is much nicer than DB2 7, as it allows 32-bit and 64-bit DBMSs to talk to each other . . .
_________________
Trevor Dolby
IIB Development
Back to top
View user's profile Send private message
MVO
PostPosted: Wed May 11, 2005 12:26 pm    Post subject: Reply with quote

Centurion

Joined: 09 Sep 2001
Posts: 131

Anybody knows if WMQI 2.1 (yes, we're still on 2.1 !!!) supports UDB V8.2 ? We have to apply FP9 to fix a bug with UDB 8.1 but want to make sure that 8.2 is supported.

Thanks
Back to top
View user's profile Send private message
malammik
PostPosted: Wed May 11, 2005 4:53 pm    Post subject: Reply with quote

Partisan

Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA

It should work if you connect to your db via tcp however if you are binding connections to db2 your 32 bit shared object might not know how to talk to 64 bit instance.

Most importantly beyond whether it will work or not is whether it will be supported by IBM so open up a PMR and double check.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex
Back to top
View user's profile Send private message Visit poster's website AIM Address
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » MQSI 2.1/WMI 5.0 broker & 64-bit DB2 databases compatibi
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.