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 IndexWebSphere Message Broker SupportMB v6 DB connectivity

Post new topicReply to topic
MB v6 DB connectivity View previous topic :: View next topic
Author Message
Inforz
PostPosted: Tue Feb 04, 2020 2:44 am Post subject: MB v6 DB connectivity Reply with quote

Centurion

Joined: 15 Apr 2011
Posts: 131
Location: Chennai, India

Hi,

Am not sure if this was already asked. Whats the method/command used to check the broker to database connectivity in MB v6 for Solaris OS

Currently just taking over on an assignment to me where MB v6 on Solaris is used. I have the db user id and password with me in an excel sheet and wanted to try testing the connectivity from broker to db(Oracle)
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Wed Feb 05, 2020 5:13 am Post subject: Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 349
Location: UK

hi...I think the command to verify odbc connections (mqsicvp) were introduced in v8 only. Can't you identify the list of DSNs configured in the odbc.ini file and test at least one flow per DSN to verify the database connectivity.

PS: It is possible to retrieve the database user id set via mqsisetdbparams by checking the 'UserId' file at the DSN folder but the same won't work for passwords as that is saved as encoded.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportMB v6 DB connectivity
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.