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 Supportstorage after mqsisetdbparms commands

Post new topicReply to topic
storage after mqsisetdbparms commands View previous topic :: View next topic
Author Message
EricL
PostPosted: Fri Jan 05, 2018 1:35 pm Post subject: storage after mqsisetdbparms commands Reply with quote

Voyager

Joined: 10 Oct 2014
Posts: 82

Hi,

As we know, command "mqsisetdbparms" is used in IIB to setup different types of external connections, like ldap, odbc etc, e.g:

mqsisetdbparms <INodeName> -n ldap::ldaptest
mqsisetdbparms <INodeName> -n odbc::USERDB2

...

My question is, after these commands executed, where is the data stored?
How to check all existing settings on the node created by "mqsisetdbparms" issued before?

Thanks in advance !

Eric
Back to top
View user's profile Send private message
mpong
PostPosted: Fri Jan 05, 2018 2:12 pm Post subject: Reply with quote

Centurion

Joined: 22 Jan 2010
Posts: 141

/var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN

or

mqsireportdbparms BROKER_NAME -n dsn::xxxx -p yyyy
Back to top
View user's profile Send private message
EricL
PostPosted: Fri Jan 05, 2018 7:43 pm Post subject: Reply with quote

Voyager

Joined: 10 Oct 2014
Posts: 82

Thanks for your reply....

Think path /var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN is on unix platform, any idea corresponding path on windows?

Further more, any idea how to remove some of the existing settings?
Back to top
View user's profile Send private message
EricL
PostPosted: Sat Jan 06, 2018 6:57 am Post subject: Reply with quote

Voyager

Joined: 10 Oct 2014
Posts: 82

On windows, corresponding path is:

C:\ProgramData\IBM\MQSI\registry\IIBNODE1\CurrentVersion\DSN
Back to top
View user's profile Send private message
gbaddeley
PostPosted: Sun Jan 07, 2018 2:19 pm Post subject: Reply with quote

Padawan

Joined: 25 Mar 2003
Posts: 1883
Location: Melbourne, Australia

Its better to use the 'report' command to retrieve this information. Unless its documented, IBM can move and change the internal storage format at any time without informing you.
_________________
Glenn
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Mon Jan 08, 2018 12:29 am Post subject: Reply with quote

Master

Joined: 17 Jul 2017
Posts: 216
Location: UK

EricL wrote:
Thanks for your reply....

Think path /var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN is on unix platform, any idea corresponding path on windows?

Further more, any idea how to remove some of the existing settings?


Hi, You can delete existing entries using the same command but with the delete flag,

mqsisetdbparms <integrationNodeName> -n <resource> -d [-f]
Back to top
View user's profile Send private message
zpat
PostPosted: Mon Jan 08, 2018 12:45 am Post subject: Reply with quote

Jedi Council

Joined: 19 May 2001
Posts: 5651
Location: UK

gbaddeley wrote:
Its better to use the 'report' command to retrieve this information. Unless its documented, IBM can move and change the internal storage format at any time without informing you.


The report command is relatively new (I think I raised an RFE to have the feature added).
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.
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 Supportstorage after mqsisetdbparms commands
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.