| Author |
Message
|
| vijsam |
 Posted: Tue Nov 08, 2011 7:24 am Post subject: Db2 and Oracle configuration |
 |
|
Apprentice
Joined: 01 Jun 2011
Posts: 46
|
Hi all,
I Previously configured my broker with DB2, and now Iam trying to connect to Oracle.For this I have configured using MQSISETDBPARMS and i was able to change the DSN Credentials,But when i gave a command MQSISERVICE I was able to see the DB2 driver name over there,Will MQSISETDBPARMS shift the configuration from DB2 to oracle or do i need to create configmanger and broker again to connect to oracle.
Thanks in advance.... |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Nov 08, 2011 7:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
mqsisetdbparms just sets the credentials used to connect to the database. it doesn't do anything else.
it's not clear how you expect a broker and a configmgr to function on an entirely new database. Have you taken steps to move the contents of the broker and configmgr database from the db2 to the oracle?
Have you taken the necessary steps to adjust the rest of the needed configuration? |
|
| Back to top |
|
|
| vijsam |
| Posted: Tue Nov 08, 2011 7:33 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2011
Posts: 46
|
Thank u jeff for the quick response,Can u please share me the the steps to move the contents of the broker and configmgr database from the db2 to the oracle or else plz provide me the link.....
ThankU |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Nov 08, 2011 7:35 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| If you use the command "mqsicreatebroker" it will solve things. |
|
| Back to top |
|
|
| vijsam |
| Posted: Tue Nov 08, 2011 7:38 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2011
Posts: 46
|
Hi Jeff,
| Quote: |
| do i need to create configmanger and broker again to connect to oracle. |
.Without creating a new broker and configmanager can i alter the database connections...Thanku for ur inputs  |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Nov 08, 2011 7:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I have no idea if you're capable of it or not.
Make a list of the steps you think is necessary to do this. Review these steps against what the documentation says. |
|
| Back to top |
|
|
| vijsam |
| Posted: Tue Nov 08, 2011 7:55 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2011
Posts: 46
|
Hi Jeff,
Iam working on windows v6.1,For the configuration to change from DB2 to oracle what i think is to change the System DSN credentials and then we have to change the odbc.ini file which is created and the login credentials using MQsetdbparms,I hope i can work on it,would you please share me the steps....or atleast ill learn the things with ur inputs ....Thanks for all your inputs.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 08, 2011 8:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| vijsam wrote: |
| what i think is to change the System DSN credentials and then we have to change the odbc.ini file which is created and the login credentials using MQsetdbparms |
And you think (to use your term) that by pointing the DSN at an Oracle database instead of the DB2 one that is currently in use will just work? As my most worthy associate points out if you get this to work the WMB components will be attached to an Oracle database which contains none of the artifacts which they expect to be present. This will cause them to fail almost instantly.
You could almost certainly recreate the needed items. Or you could, as already suggested & as you yourself said, recreate them from scratch in a fraction of the time.
_________________
Honesty is the best policy.
Insanity is the best defence.
Last edited by Vitor on Wed Dec 21, 2011 6:44 am; edited 1 time in total |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Nov 08, 2011 8:02 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Drop the broker and re-create it using the Oracle DB. you could have done it in the time this post has been up.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 08, 2011 8:06 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| smdavies99 wrote: |
| Drop the broker and re-create it using the Oracle DB. you could have done it in the time this post has been up. |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
