| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [Solved] Database coordination problem reason code = 2121 |
« View previous topic :: View next topic » |
| Author |
Message
|
| loris |
 Posted: Sat Dec 14, 2002 7:08 pm Post subject: [Solved] Database coordination problem reason code = 2121 |
 |
|
Novice
Joined: 07 Nov 2002
Posts: 15
|
Hi, All,
I encountered a problem with reason code 2121. I want to connect WebSphere MQ V5.3 to DB2 V7.2 based on MQ Java Base class and my procedure is as below:
1. create database MQBankDB
2. create table MQBankTB(Account INTEGER, Balance INTEGER)
3. crtmqm test.queue.manager
4. strmqm test.queue.manager
5. In WebSphere MQ Services snap-in,
I configure the Resources on the test.queue.manager like this:
Name=MQBankDB
Switch File=
D:\Program Files\IBM\WebSphere MQ\Java\lib\jdbc\jdbcdb2.dll
XAOpenString=MQBankDB, username, password
TreadOfControl=PROCESS
6. When I run the Java program written by MQ Java base class, I got reason code=2121.
Did I miss anything for registing DB2 on the queue manager? How can I run the program successfully?
Thank you very much!
Loris. |
|
| Back to top |
|
 |
| leongor |
| Posted: Sun Dec 15, 2002 7:39 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
It looks ok.
Two things :
1. D:\Program Files\IBM\WebSphere MQ\Java\lib\jdbc\jdbcdb2.dll
Maybe better use path without spaces
2. DB2 7.2 - do you use CSD03 or higher ?
Because lower level is buggy.
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| clindsey |
| Posted: Sun Dec 15, 2002 8:12 am Post subject: |
|
|
Knight
Joined: 12 Jul 2002
Posts: 586
Location: Dallas, Tx
|
Take a look at your mq error logs.
D:\Program Files\IBM\WebSphere MQ\errors\AMQERR01.LOG
and D:\Program Files\IBM\WebSphere MQ\qmgrs\test!queue!manager\errors\AMQERR01.LOG.
Go to the bottom of the files and look for any errors, for example, unable to load swit file.
If the swit file can load, and the user & pw are good, the problem is most likely in db2. Do a find on "db2diag.log" and look at this file to see what db2 is reporting.
Charlie |
|
| Back to top |
|
|
| loris |
| Posted: Mon Dec 16, 2002 7:13 pm Post subject: How to find out whether the DB2 version is DB2 7.2 CSD03? |
|
|
Novice
Joined: 07 Nov 2002
Posts: 15
|
Hi, Leonid and Charlie,
Thank you very much!
How to find out whether the DB2 version is DB2 7.2 CSD03?
Thank you!
Loris. |
|
| Back to top |
|
|
| vennela |
| Posted: Mon Dec 16, 2002 7:27 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I guess you can use "db2level" command at the DOS command prompt.
Version 7.2 is actually 7.1 vith fix pack 3. Version 7.2 csd 03 I guess means 7-1-6.
---
Venny |
|
| 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
|
|
|
|
