MQSeries.net :: View topic - WMB

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB - using database

WMB - using database

« View previous topic :: View next topic »

Author

Message

vijayakumar

Posted: Tue Aug 31, 2010 10:05 pm Post subject: WMB - using database

Centurion

Joined: 01 Aug 2010
Posts: 101

is there any commands available to check wht database the message flow is using for datasource?

smdavies99

Posted: Tue Aug 31, 2010 10:36 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

If you are using V7.0.0.1 then the mqsicvp command might help

You obviously have to know the dataset name.

Where have you searched for this information?

If you are using Windows the ODBC Admin panel will give you all the info you need.
Then on Unix/Linux the file pointed to by $ODBCINI will tell much the same story.
_________________
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.

mqjeff

Posted: Wed Sep 01, 2010 1:52 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

There is no general purpose tool that will tell you exactly what database any specific message flow is using, because it is entirely possible that any given message flow can be using a different database for each message that comes through.

If you know that all of your message flows are using only ODBC, then you can see the whole list of potential databases by looking at the ODBC configuration.

If you know that all of your message flows are using only ODBC and JDBC Type 4 connections, then you can look at your ODBC configuration and your JDBCProviders.

But the BEST way to know what database a particular message flow is using is to look at the SOURCE for the message flow.

Or at least take a usertrace.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB - using database

Jump to:

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

Protected by Anti-Spam ACP