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 » Database error after applying fix pack 9 to DB2

Post new topic  Reply to topic
 Database error after applying fix pack 9 to DB2 « View previous topic :: View next topic » 
Author Message
basva
PostPosted: Fri Apr 22, 2005 4:40 pm    Post subject: Database error after applying fix pack 9 to DB2 Reply with quote

Apprentice

Joined: 27 Nov 2002
Posts: 39
Hi

Our broker is working fine until our DBA applied the fix pack 9 (DB2 version 7.2). During applying fixpack the broker database was backed up then deleted and recreated and all the contents were restored. We are getting the following error.

Quote:
BIP2322E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '
[DataDirect][ODBC lib] Data source name not found and no default driver specifie
d'.
The error has the following diagnostic information: SQL State 'I
M002' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC
lib] Data source name not found and no default driver specified'
This message may be accompanied by other messages describing the effect on the m
essage broker itself. Use the reason identified in this message with the accomp
anying messages to determine the cause of the error.


Here is the odbc.ini

[BKDB]
Driver=/home/db2admin/sqllib/lib/db2_36.o
Description=Broker Database
Database=BKDB

I also ran mqsi_setupdatabase command.

Also I could connect to this database from db2 command prompt using broker database user ID and password.

Any help is greatly appreciated.

Thanks
Satish
Back to top
View user's profile Send private message
malammik
PostPosted: Sat Apr 23, 2005 7:30 am    Post subject: Reply with quote

Partisan

Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
Satish, what;s going on man? Are u still at ibc? Here are my two cents. Your driver is Driver=/home/db2admin/sqllib/lib/db2_36.o which is an object file needs be linked with the current db libs to become an executable. My guess is that the part of the error message about not finding data source name is a bunch of b. because it cannot load the driver since the libraries it was linked with are no longer valid.

Another important point about linking. I recall that after upgrading a fix pack on db2 one has to run quite a few scripts including those that re-link
your db files, instance files, etc. I would download the readme from support pack and go through it myself very carefully and make sure your dba has executed all the steps.
_________________
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 » Database error after applying fix pack 9 to DB2
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.