| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Question about ODBC Driver for DB2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| caroljx |
 Posted: Tue Apr 06, 2004 9:50 am Post subject: Question about ODBC Driver for DB2 |
 |
|
Newbie
Joined: 06 Apr 2004
Posts: 5
Location: Calgary, AB Canada
|
MQSI 2.0.2, AIX 5.1+ML3, DB2 7.1.0.40
I have a question about db2 ODBC driver for MQSI. In our .odbc.ini file, I found our current configuration is:
Driver=/db2data/db2inst1/sqllib/lib/db2_36.o
But according to IBM's document, it should be:
Driver=/db2data/db2inst1/sqllib/lib/db2.o
I knew we had problem with "Driver=/db2data/db2inst1/sqllib/lib/db2.o", an expert came to changed it to "db2_36.o" to make it worked. Is there anyone know why we had to change this configuration?
------------------------------------------------------------------------------------
We plan to upgrade MQSI 2.0.2 to 2.1 + CSD06. According to MQSI2.1 CSD06's instruction "28704 - Merant Driver Manager update", we should change db2 driver in .odbc.ini as these:
==================================
from: Driver=/db2data/db2inst1/sqllib/lib/db2.o
to: Driver=/db2data/db2inst1/sqllib/lib/libdb2.a
==================================
Since we don't use "db2.o" now, what should I change to after we apply MQSI2.1 CSD06?
_________________
Eager to learn |
|
| Back to top |
|
 |
| JT |
| Posted: Tue Apr 06, 2004 11:45 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| Nick Lethbridge |
| Posted: Wed Apr 07, 2004 1:57 am Post subject: |
|
|
Voyager
Joined: 13 Aug 2001
Posts: 88
Location: Santander, UK
|
JT is correct.
The consultant modified the .odbc.ini file to reference the DB2 ODBC driver library without Unicode support (db2_36.o).
He may also have overwritten the original db2.o file with the db2_36.o file - you will need to check the size + timestamps of the two files.
(Hopefully, he will also have saved a copy of the original db2.o file on the directory.)
To "tidy up and roll back the change", follow the instructions in http://www-306.ibm.com/software/data/db2/udb/ad/db2irfp7/db2ir61.htm (in effect, restore the original db2.o file).
As of WMQI 2.1 with CSD04, a new Merant Driver was delivered that fixed the problem (here is an extract from the ReadMe):
-----------------------------------------------------------------------------------
28704 - Merant Driver Manager update
Support for DB2 UDB Version 7.1 FixPak 2 or later on UNIX.
The DB2 flash 1042663 - "Merant Driver Manager and DB2 UDB V7 ODBC
driver on Unix" described incompatibilities that had been encountered
with Unicode support when the Merant Driver Manager accessed DB2's
ODBC driver on UNIX. The affected versions of DB2 UDB included
Version 7.1 with FixPak 2 or later, and Version 7.2.
The workaround was to use an alternative DB2 ODBC driver library
without Unicode support enabled.
CSD04 includes a new version of the DataDirect (formerly Merant)
Driver Manager which has removed the need for the workaround
documented in the above DB2 flash.
If your DB2 database is running on HP-UX or Solaris you will need to
remove the above workaround to enable this support.
If your DB2 database is running on AIX you will need to remove the
above workaround and also change the DB2 Driver entry in your
.odbc.ini file
from : Driver=/db2data/db2inst1/sqllib/lib/db2.o
to : Driver=/db2data/db2inst1/sqllib/lib/libdb2.a
------------------------------------------------------------------------------------
=> After you have upgraded to WMQI v2.1 with CSD06 your .odbc.ini file should reference libdb2.a.
I noticed that you are running with DB2 7.1 + FixPack 3 (equivalent to DB2 7.2).
I would take the opportunity to upgrade DB2 and install DB2 7.2 FixPack 10a or FixPack 11 - see http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7fphist.d2w/report
The advantage of doing this:
You can then view the database from a DB2 8.1 Control Center and it will make a future migration to WBIMB easier (a pre-requisite for WBIMB is DB2 7.2 with FixPack 9).
Regards,
Nick. |
|
| 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
|
|
|
|
