| Author |
Message
|
| narendrach |
 Posted: Sun Aug 13, 2006 10:17 am Post subject: problem with mqsisetdbparms |
 |
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Hi
i am working on MB5.0
Broker on Windows
ConfigMgr on Windows
Broker Database DB2
ConfigMgr DataBase DB2
i trying to Bind a Oracle DataBase to my Broker by using Mqsisetdbparms,and i am facing some problems while starting the broker
i had created a ODBC DSN to my oracle DataBase on Windows
and by using mqsisetdbparms command below i tried to bind my DSN to my Broker
mqsisetdbparms WBRK -n OracleDSN -u testuser -p test
after running this command sucessfull .i tried to start my Broker
it is starting normaly .but in toolkit it is showing it as Broker and Execution are not running. and i am not able to deploy
and again i stoped my broker
and by using
mqsisetdbparms WBRK -n OracleDSN -d
removed the binding of the my DSN with my broker it started normaly
and in toolkit it is not showing any message.and i am able to deploy flows
i tryed giving DSN with another names for same DataBase even though it is not working
i tested the Db Connection it is working fine
_________________
Narendra CH |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sun Aug 13, 2006 12:34 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
And which driver are you using for your DSN?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| shrek |
| Posted: Sun Aug 13, 2006 12:57 pm Post subject: |
|
|
Acolyte
Joined: 19 Feb 2005
Posts: 61
Location: Gudivada,India
|
Couple of things..
1. Is your Connection Test from ODBC settings successful?
2. Have you configured sqlnet.ora/tnsnames.ora ?
On V6, I had success using sqlnet.ora in <Oracle install>\ORA92\network\ADMIN
Thanks.
Pavan |
|
| Back to top |
|
|
| narendrach |
| Posted: Mon Aug 14, 2006 1:51 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
i am using MQSeries DataDirect 4.10 32-BIT Oracle8
i am using MB5.0 version and i have configured tnsnames.ora
Connection Test from ODBC settings was succesfull
_________________
Narendra CH |
|
| Back to top |
|
|
| JT |
| Posted: Mon Aug 14, 2006 5:16 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Did you perform the following tasks (from the v5 Information Center)?
| Quote: |
Oracle
When you define a data source for Oracle, you must choose the driver named MQSeries DataDirect 4.10 32-BIT Oracle.
Complete these steps to configure the driver:- Enter the DSN name, description, and server name (where the server name is the "Service Name" that resolves to a "Connect Descriptor", for example through a mapping in the TSNAMES.ORA file).
- Select the appropriate Oracle client version from the drop-down list.
- Ensure that the Enable SQLDescribeParam box is checked. This parameter is on the Advanced tab of the driver settings.
- Create a new registry subkey for each of your DSNs that reference an Oracle database. Use REGEDIT to navigate to the correct location:
HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBC.INI
- Right-click the DSN, and select New > String Value. Specify WorkArounds for the string, and set the value to 536870912.
|
|
|
| Back to top |
|
|
| narendrach |
| Posted: Tue Aug 15, 2006 2:26 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Hi JT ,
i tried the steps you have given, even though it is not working.
_________________
Narendra CH |
|
| Back to top |
|
|
| wschutz |
| Posted: Tue Aug 15, 2006 3:05 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Since the broker is running on Windows, you should have some messages in the Windows event log with errors.....
_________________
-wayne |
|
| Back to top |
|
|
| narendrach |
| Posted: Tue Aug 15, 2006 3:33 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
i am seeing only this error...
Execution Group default failed to return an internal configuration Start message response within a 120 second time period.
and can we see all the DSN we have set to the broker using mqsisetdbparms . is there any command to see the list of the DSN that are binded to the broker using mqsisetdbparms
_________________
Narendra CH |
|
| Back to top |
|
|
| Debadutta |
| Posted: Tue Aug 15, 2006 10:56 am Post subject: |
|
|
Newbie
Joined: 06 Dec 2002
Posts: 4
|
You should be able to see the corresponding DSN entries under the DSN folder of broker's registry.
Regards,
Debadutta |
|
| Back to top |
|
|
| narendrach |
| Posted: Wed Aug 16, 2006 6:17 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
yes i can able to see them in registry under the broker folder
_________________
Narendra CH |
|
| Back to top |
|
|
| narendrach |
| Posted: Tue Aug 22, 2006 6:42 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Problem solved
it's a CSD problem.i installed it is working
_________________
Narendra CH |
|
| Back to top |
|
|
|
|
