| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Checking Broker DB command |
« View previous topic :: View next topic » |
| Author |
Message
|
| cots |
 Posted: Tue Jan 06, 2004 10:46 am Post subject: Checking Broker DB command |
 |
|
Centurion
Joined: 16 Jun 2003
Posts: 105
|
Hi All,
Please help, Is there anyway or a command line to figureout whether it is using Oracle or DB2 database for the MQSI Broker, my MQSI broker is on AIX box?
Thanks in Advance |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jan 06, 2004 11:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should be able to find out from the broker odbc.ini file(I'm pretty sure that's the file) what the broker database ODBC name is. From that, you can look up where that ODBC datasource points to.
But you should ask questions about WMQI/WBIMB in the WMQI forum.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Jan 06, 2004 1:19 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
The file name is .odbc.ini on UNIX platform. You can run mqsiservice <BrokerName> command to get he Broker DB ODBC name.
Now, in your .odbc.ini file, look for your Broker ODBC DSN. If you are using DB2 database then your entry will look like this,
| Code: |
[MQSIBKDB]
Driver=/u/db2inst1/sqllib/lib/db2.o
Description=MQSIBKDB DB2 ODBC Database
Database=MQSIBKDB
|
Oracle DB entry will look like this,
| Code: |
[ORACLEDB]
Driver=/usr/opt/wmqi/merant/lib/UKor816.so
Description=Oracle8
ServerName=YourServerName
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
WorkArounds2=2
|
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
