Author |
Message
|
Thripura Sundari |
Posted: Fri Jul 08, 2005 7:29 am Post subject: |
|
|
Acolyte
Joined: 13 Jun 2005 Posts: 57 Location: Bangalore, India
|
Hi all,
I had not given the configuration details in my previous mail. I had installed DB2 8.1 with fix pack 5.
I had also installed fix pack 5 from WBIMB downloads in the url
http://www-1.ibm.com/support/docview.wss?uid=swg24009435. I was able to create comfiguration manager earlier but after the reinstallation, I am not able to create it.
Please help.
Thanks and Regards,
Thripura Sundari |
|
Back to top |
|
 |
ramangoel |
Posted: Wed Jan 24, 2007 11:06 am Post subject: BIP8078E error when running mqsicreateconfigmgr command |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
BIP8078E error when running mqsicreateconfigmgr command
Event Log says:
--------------------
( ConfigMgr ) Unexpected exception in the Configuration Manager DBManager class constructor method; exception text: 'java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver', 'COM.ibm.db2.jdbc.app.DB2Driver'.
While attempting a database operation on the configuration repository, an exception was caught by the Configuration Manager DBManager class constructor method. The database operation did not complete successfully. The exception text is: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver, COM.ibm.db2.jdbc.app.DB2Driver.
The exception text may indicate that the DB2 JDBC Driver could be found; check that the system CLASSPATH variable contains access to the DB2 runtime classes. If the DB2 classes are present in the CLASSPATH or if the exception text indicates a different problem,
--------------------------------------------------------------------
I have checked the Classpath, it has it has an entry "C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip". This zip file does have the DB2Driver.
I have checked all the DB2 Services, all are running.
I could not find any problem.
Does anyone has any idea about this issue?
I would really appreciate your help on this. |
|
Back to top |
|
 |
vennela |
Posted: Wed Jan 24, 2007 12:43 pm Post subject: |
|
|
 Jedi Knight
Joined: 11 Aug 2002 Posts: 4055 Location: Hyderabad, India
|
Where are you running this command from?
MQSI Console?
Have you echoe'd the CLASSPATH in the command console? |
|
Back to top |
|
 |
ramangoel |
Posted: Wed Jan 24, 2007 12:54 pm Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
from normal windows command prompt.
I checked classpath...MyComputer-->Properties-->Environment Variables.
I have created configmngr on other computer by following the same steps I am doing now but this is the first time I got the error. |
|
Back to top |
|
 |
jefflowrey |
Posted: Wed Jan 24, 2007 1:10 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
You should have started a new thread.
What version, please?
What options are you specifying to mqsicreateconfigmgr? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
ramangoel |
Posted: Wed Jan 24, 2007 1:15 pm Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Sorry about that!!
Versions:
-----
DB2 v8.1, FP 6
MQ5.3, FP 8
MB5.0, FP 5
------
command using:
mqsicreateconfigmgr -i user -a passwd -q QmngrName -n DBName |
|
Back to top |
|
 |
ramangoel |
Posted: Wed Jan 24, 2007 3:35 pm Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Can someone pls. help in shedding some light on the resolution of the issue? |
|
Back to top |
|
 |
jefflowrey |
Posted: Wed Jan 24, 2007 3:40 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
Make sure that your db2 drivers are in the front part of your classpath. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
jeevan |
Posted: Wed Jan 24, 2007 6:41 pm Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005 Posts: 1432
|
Raman,
I remember a lot of problem when I did first time. Eventually, i did it using default configuration wizard. That gives you idea where you are making mistakes.
Why dun u give a shot? |
|
Back to top |
|
 |
ramangoel |
Posted: Thu Jan 25, 2007 8:40 am Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Thanks Jeevan,
I tried doing the same first but it started throwing errors after just creating the configmngr DB, at the creation of configmgr.
So I thought it was good idea to do it manually, but even it failed.
I am still trying to change the CLASSPATH, to put all the entries for DB2 in first place, lets see how it goes. |
|
Back to top |
|
 |
ramangoel |
Posted: Thu Jan 25, 2007 8:52 am Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Jeff,
I put all the DB2 Driver Entries in the first place of the CLASSPATH, still same issue persists.
Can it be a problem in installing DB2 or its FP? |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Jan 25, 2007 9:07 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
It could be that there are other things that need to be in the CLASSPATH for the Db2 drivers to work.
It's kinda hard to tell from what you've posted, but it seems like you have things reasonably set up.
You should probably open a PMR. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
ramangoel |
Posted: Thu Jan 25, 2007 9:19 am Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Sorry Jeff, what is PMR?
See if it helps.
CLASSPATH:
BEFORE CHANGE:
---------------------
C:\Program Files\IBM\WebSphere MQ\Java\lib\providerutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\ldap.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jta.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jndi.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\connector.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\fscontext.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar;C:\cnet\bin\classes;.;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cisuz.jar;C:\PROGRA~1\IBM\SQLLIB\java\d;C:\cnet\bin\classes
---------------------------------------------------------------------------------
After Change:
---------------------
C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\providerutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\ldap.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jta.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jndi.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\connector.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\fscontext.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar;C:\cnet\bin\classes;.;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cisuz.jar;C:\PROGRA~1\IBM\SQLLIB\java\d;C:\cnet\bin\classes |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Jan 25, 2007 9:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
PMR means "Program Maintenance Request", I mean call IBM support. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
ramangoel |
Posted: Thu Jan 25, 2007 9:43 am Post subject: |
|
|
Novice
Joined: 24 Jan 2007 Posts: 19
|
Thanks Jeff,
I will try to contact them. |
|
Back to top |
|
 |
|