| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| xaopenstring |
« View previous topic :: View next topic » |
| Author |
Message
|
| ramires |
 Posted: Fri Nov 11, 2005 7:37 am Post subject: xaopenstring |
 |
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Hello,
In windows registry MQ stores userid and password for access to WF database. The entry is something like:
DB=FMCDF, TPM=MQ, toc=p, UID=ramires, PWD=password
The user and password are in clear text. Hoq can I avoid this? Does the xaopenstring need user and password?
I tried to remove but I'm getting xa errors.
Regards |
|
| Back to top |
|
 |
| ramires |
| Posted: Tue Nov 15, 2005 6:03 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
I guess I solved my problem. If I remove UID and PWD from XAResourceManger stanza (win registry), the entry look like this:
ThreadOfContol THREAD
XAOpenString DB=FMCDB, TPM=MQ, toc=p
I get:
11/15/2005 13:17:16 - Process(1516.9) User(MUSR_MQADMIN) Program(amqzlaa0.exe)
AMQ7605: The XA resource manager DB2 FMCDB has returned an unexpected return
code -6, when called for xa_close.
When change to:
ThreadOfContol PROCESS
XAOpenString DB=FMCDB, TPM=MQ, toc=p
I don't get AMQ7605. It appears the value of "ThreadOfContol" and "toc" must macth, but they don't need to match if I sepcify a "UID" and "PWD" in XAOpenString.
Its really confusing, and the IBM info about this subject is contradictory:
http://www-1.ibm.com/support/docview.wss?uid=swg1IY52270
says to use THREAD
http://www-1.ibm.com/support/docview.wss?uid=swg1IC47778
says to use PROCESS |
|
| Back to top |
|
|
| hos |
| Posted: Thu Nov 17, 2005 5:06 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Have a look at the MQWF readme file. It explains the required setting with respect to your DB version. MQWF configuration does the proper setting and you should not modify it manually! If your setup requires THREAD, you should use THREAD and not switch to PROCESS. If you have a real concern with the password in clear text in your Windows registry you should contact MQ, because this is not an MQWF issue.
B.t.w.: toc and ThreadOfControl must ALWAYS match otherwise you'll run into performance problems. |
|
| Back to top |
|
|
| ramires |
| Posted: Thu Nov 17, 2005 7:48 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
|
| Back to top |
|
|
| hos |
| Posted: Fri Nov 18, 2005 3:29 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
|
| 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
|
|
|
|
