ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Howto identify which database drivers is the broker using?

Post new topic  Reply to topic
 Howto identify which database drivers is the broker using? « View previous topic :: View next topic » 
Author Message
naveeng
PostPosted: Wed Jun 01, 2016 1:51 am    Post subject: Howto identify which database drivers is the broker using? Reply with quote

Novice

Joined: 10 Jan 2011
Posts: 16
Is there a way to determine how the broker connects to the Database (i.e. using DB client or JDBC provider…?). My Broker is connecting to DB2.

I am able to see the DB table names using the mqsireportproperties command to list the JDBC providers. Also I can see the similar details in the ODBC.ini file.

I am trying to get the details of the JDBC providers, such as the connection parameters and driver details.
Is there a way to get these information.

I have tried the below steps to identify : -

1) I have used the mqsireportproperties command to find all reportable Entity Names and I find my database(ABC) listed under JDBCProviders.

2) I have tried to explore the ODBC.ini file in-order to see if there is any entry related to the database and found the below : -

[ODBC Data Sources]
ABC=ABC Application Database
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

[ABC]
DRIVER=/opt/ibm/DB2/V9.7/lib64/libdb2o.so
Description=ABC Application Database
Database=ABC

After seeing my database entry in ODBC.ini also existing, I am not able to clearly confirm what drivers is my broker using to connect my database.
Back to top
View user's profile Send private message
maurito
PostPosted: Wed Jun 01, 2016 1:57 am    Post subject: Re: Howto identify which database drivers is the broker usin Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
naveeng wrote:
Is there a way to determine how the broker connects to the Database (i.e. using DB client or JDBC provider…?). My Broker is connecting to DB2.

I am able to see the DB table names using the mqsireportproperties command to list the JDBC providers. Also I can see the similar details in the ODBC.ini file.

I am trying to get the details of the JDBC providers, such as the connection parameters and driver details.
Is there a way to get these information.

I have tried the below steps to identify : -

1) I have used the mqsireportproperties command to find all reportable Entity Names and I find my database(ABC) listed under JDBCProviders.

2) I have tried to explore the ODBC.ini file in-order to see if there is any entry related to the database and found the below : -

[ODBC Data Sources]
ABC=ABC Application Database
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

[ABC]
DRIVER=/opt/ibm/DB2/V9.7/lib64/libdb2o.so
Description=ABC Application Database
Database=ABC

After seeing my database entry in ODBC.ini also existing, I am not able to clearly confirm what drivers is my broker using to connect my database.

The ODBC.ini is for connecting to the database using ODBC, so it is irrelevant for working out what driver you are using for connecting with JDBC.
You need to look at your JDBC set up.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Howto identify which database drivers is the broker using?
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.