| Author |
Message
|
| dilep |
 Posted: Thu Nov 05, 2009 12:44 am Post subject: MQFTE_Db2 _Audit Error |
 |
|
Apprentice
Joined: 27 Nov 2006
Posts: 40
|
Hi,
I have installed the MQFTE, and I am auditing the log file in database DB2,
When I start the database logger (ftestartDatabaseLogger) I am getting the error
“BFGDB0018E: An MQ problem occurred while the database logger was beginning a new transaction. The reported reason code was MQRC_NO_EXTERNAL_PARTICIPANTS and the reported message text (if any) was: MQJE001: Completion Code '1', Reason '2121' “
I have created the database “FTEAUDIT” and run the sql file and modified the databaselogger.properties file
wmqfte.queue.manager=QMFTE
wmqfte.database.name=FTEAUDIT
wmqfte.database.driver=C:/Program Files/IBM/SQLLIB/java/db2jcc.jar;C:/Program Files/IBM/SQLLIB/java/db2jcc_license_cu.jar;C:/Program Files/IBM/SQLLIB/java/db2jcc_license_cisuz.jar
Thanks |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Thu Nov 05, 2009 1:17 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
MQRC_NO_EXTERNAL_PARTICIPANTS
An MQBEGIN call was issued to start a unit of work coordinated by the queue manager, but no participating resource managers have been registered with the queue manager.
have you made changes in your qm.ini file for XAResourceManager?
_________________
Cheers |
|
| Back to top |
|
|
| exerk |
| Posted: Thu Nov 05, 2009 6:01 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Moving this to the appropriate forum...
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| dilep |
| Posted: Thu Nov 05, 2009 6:56 pm Post subject: |
|
|
Apprentice
Joined: 27 Nov 2006
Posts: 40
|
the os in windows xp , i didn't change the QM.ini file.
please help me where to find the qm.ini file in windows. what are the modifications want to do in qm.ini file |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 05, 2009 7:21 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| dilep wrote: |
| please help me where to find the qm.ini file in windows. what are the modifications want to do in qm.ini file |
There's isn't one in Windows - the values are in the registry. 
The changes you need are in the InfoCenter - the usual warnings about messing about with the Windows registry apply.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| PeteVerdon |
| Posted: Fri Nov 06, 2009 5:43 am Post subject: |
|
|
Apprentice
Joined: 11 Feb 2009
Posts: 33
Location: Hursley, UK
|
|
| Back to top |
|
|
| dilep |
| Posted: Sun Nov 08, 2009 7:18 pm Post subject: |
|
|
Apprentice
Joined: 27 Nov 2006
Posts: 40
|
I have addd in the XA resource mangers,
Name : DB2DB
SwitchFile : jdbcdb2
XAOpenString: FTEAUDIT,userid,password,toc=p,tpm=mq
and i copied the jdbcdb2.dll into <insll.dir>\WebsphereMQ\exits.
and I added the MUSR_MQADMIN in DB2USERS group.
When I am starting the ftestartDatabaseLogger, I am getting the below error:
“The database driver reported to the following details :SQL State [null],Error Code [-99999], Message [Driver not capable] “ |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Nov 09, 2009 8:01 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| dilep wrote: |
| “The database driver reported to the following details :SQL State [null],Error Code [-99999], Message [Driver not capable] “ |
Sounds like your driver isn't XA-compliant 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
